| Dzmitry Stremkouski | 585ed4b | 2018-04-22 11:23:54 +0200 | [diff] [blame^] | 1 | linux: |
| 2 | system: |
| 3 | file: |
| 4 | ca: |
| 5 | name: /etc/mysql/ssl/ca.pem |
| 6 | makedirs: true |
| 7 | mode: 644 |
| 8 | contents: | |
| 9 | -----BEGIN CERTIFICATE----- |
| 10 | MIIF0TCCA7mgAwIBAgIJAOkTQnjLz6rEMA0GCSqGSIb3DQEBCwUAMEoxCzAJBgNV |
| 11 | BAYTAmN6MRcwFQYDVQQDDA5TYWx0IE1hc3RlciBDQTEPMA0GA1UEBwwGUHJhZ3Vl |
| 12 | MREwDwYDVQQKDAhNaXJhbnRpczAeFw0xNzA3MjYwOTMxMjdaFw0yNzA3MjQwOTMx |
| 13 | MjdaMEoxCzAJBgNVBAYTAmN6MRcwFQYDVQQDDA5TYWx0IE1hc3RlciBDQTEPMA0G |
| 14 | A1UEBwwGUHJhZ3VlMREwDwYDVQQKDAhNaXJhbnRpczCCAiIwDQYJKoZIhvcNAQEB |
| 15 | BQADggIPADCCAgoCggIBALtNZDt+96ywq2QroY8XriB9QFludQ4JyTYH/ugUvOxO |
| 16 | VuomQEfJZ+oWRH4F+0oXrdEF8jITehG44v0cLv9PpSd6MMrrUFw/Cxd6QZacCeRg |
| 17 | qrOE2VYDJS3qG1LVAfK2d3dBOKQXHz2BG8tXqjkTd8ZqN5NZQm3+czTcXC+f0evl |
| 18 | pXMWHdWRBqR5ssuiCqEogmXFEGy9k8vWVuhSIgbM/0uvQ+gket7i1A7cTaSDSJEn |
| 19 | lsJdt0GicQvklWrgXHE4BhvhmCpA+2VlwRpeokrEu7DHwCkOhQgUiUbpfEHrXEQg |
| 20 | XCraseprwnVMcbggu4InIF2be6yyaD9silhBRxfAEZ34kp76+rff+mw0p5fMPHfK |
| 21 | NwOUsWd6RPu4z6+QoTeJ75MpCTeh6RWUVXpOdDVN6AX0drIyE/+9oSY7uHCXCxm7 |
| 22 | U7ZOLUDdW1y/NNvexany4bhgCFetEiKKrHO4VIUVAK4JXCWeTqo5DFOjMrkK+wEt |
| 23 | aLwLFYgJMb1JkSbtTNG+iM19aKbo9hNzHQBHkL/gozKoTmbCluPQrh+wcz6mP57s |
| 24 | rJe6/njH6TaKB75wychkrhzkXqpQ6iAVBn2xY1zERPgZqdi0zSuN59cEllgm77wG |
| 25 | rmFkAB/DOgmQIlCAJEQGrLb1rHr8TKhYH5Q15yStwg30OiBZrMtwRZT3UxgHEwGx |
| 26 | AgMBAAGjgbkwgbYwDAYDVR0TBAUwAwEB/zALBgNVHQ8EBAMCAQYwHQYDVR0OBBYE |
| 27 | FNeA/Eb/hvDkRo0gMO9kuGjfB4SvMHoGA1UdIwRzMHGAFNeA/Eb/hvDkRo0gMO9k |
| 28 | uGjfB4SvoU6kTDBKMQswCQYDVQQGEwJjejEXMBUGA1UEAwwOU2FsdCBNYXN0ZXIg |
| 29 | Q0ExDzANBgNVBAcMBlByYWd1ZTERMA8GA1UECgwITWlyYW50aXOCCQDpE0J4y8+q |
| 30 | xDANBgkqhkiG9w0BAQsFAAOCAgEAtqc6bkDSXDXCqXcJYvI7s/OHgbD/w3NUQJDF |
| 31 | bwniZnSdBrzG1nGJTxaZQqh/NUX9Czz4IPbezk3J149giHW8KQ3j5HVuJyQKTzHq |
| 32 | TYcnfiqwBOGMhhThQGi75MDk7Rb2MA4faapaBzKLUkTjz7QC7KHcaxZ8LYWygs6o |
| 33 | +zlejWaBZdhNtkSPt0rYMLbBxLG7HWPQPVa5FBL+Hs5lp7d8dVsddZ25wZ3+weho |
| 34 | SJM2W3WXsiDwp/5oDCwnH9FDdSeBz/iXdj0LJJIzUoADLk41ydOa7uwkmTIe9Fi1 |
| 35 | 1srsHxW564MQ5TU3KusyOdkYJ2nYBqZhxQ6u6q1j4h8g0EWc7W02LSyugWEDtELU |
| 36 | ZNytjrpRsfsqWB3t3ZDjt1USHQW/AuCIoXKsLITnRQgNwv5dWAwT8gCnE6C1xNgk |
| 37 | xwVM3yjKO/BZCD2J0onuUQI9YTDAmU1YFrTYkQ2z6foNCgUtkEmBYS/24vyEPo7y |
| 38 | brY4pLAwFwy7iGNFk8XGyue6LhSwRjEUgpVxZ8qBQkYAwZfnJP7idXgLPnyIkM9O |
| 39 | YYJr8IY8Bhd1cgWB4WVFPCoXdP1s7VqZi5T8rsjjDl1Jb6tRhauntmBiRuOeLF4X |
| 40 | RHXc4FoWv9/n8ZcfsqjQCjF3vUUZBB3zdlfLCLJRruB4xxYukc3gFpFLm21+0ih+ |
| 41 | M8IfJ5I= |
| 42 | -----END CERTIFICATE----- |
| 43 | cert: |
| 44 | name: /etc/mysql/ssl/cert.pem |
| 45 | makedirs: true |
| 46 | mode: 644 |
| 47 | contents: | |
| 48 | -----BEGIN CERTIFICATE----- |
| 49 | MIIGHzCCBAegAwIBAgIIF4FaUAd0kCQwDQYJKoZIhvcNAQELBQAwSjELMAkGA1UE |
| 50 | BhMCY3oxFzAVBgNVBAMMDlNhbHQgTWFzdGVyIENBMQ8wDQYDVQQHDAZQcmFndWUx |
| 51 | ETAPBgNVBAoMCE1pcmFudGlzMB4XDTE4MDQxOTEzNDEwMVoXDTE5MDQxOTEzNDEw |
| 52 | MVowSDELMAkGA1UEBhMCY3oxFTATBgNVBAMMDG15c3FsX3NlcnZlcjEPMA0GA1UE |
| 53 | BwwGUHJhZ3VlMREwDwYDVQQKDAhNaXJhbnRpczCCAiIwDQYJKoZIhvcNAQEBBQAD |
| 54 | ggIPADCCAgoCggIBAL4QIC/jDtaUb/KHSYLaUuWkW4n5qjiZ65FdMzbDs2nGsUqZ |
| 55 | f7l3YSacUCRhQ2PF+qFDONGq4OhUQ41koFz1FJ7zwiCuJSkP48NvHVA+esr0Tyzv |
| 56 | 3tJx3xAN56yZ8z6mbsZ/b92ZkxYImePxU8Gqjx/lV6I6EfWdpKzAXuDd/UplPCZb |
| 57 | DhbdamMkF1t20+j8QPD3S/kVG6N40HuAVC+pqKAaYWBk1odn2HnrEG5evXfp0mJw |
| 58 | 4oSxo4JCk/X0JNrDWVNe7ZlPOzW0+9Ro5tHd12rFOyKS+j4tlUxMT+HbYnvaLXV8 |
| 59 | ufvT0rLj+q0YZPShJWTikmYqsfSL/MbDNeA7jiJtZFmnZE/4jwJZjqiTl8PHk6MH |
| 60 | 6IWisW2m2WuRWsgygaT5ZsmPsa1Ykjt3Rmyquxuqj0fYLiGmz3jD2Mb3sDOi98T7 |
| 61 | JvbluMfpbti3bFYTf5sb2+wplejtjXsM8ohOBaIwrl+oY9Mct9jCuC5IaxCuNDu4 |
| 62 | 1sJgqXer3J0n6kmdL9IX7jFvUs7Zqzv8oz6Zybh+VATUHwrnCuw6RPtesDquO2M9 |
| 63 | t0EbUMMajdwzMmtICmfCIfPKnlfzPiS+t3yiptw41OfVfrnPotgzO0DBDGfrQkIs |
| 64 | 1hOELFjrD27cewBDI5OHwpou5eK5T8Cxdaqh5hLeFpMvqLltwjP7GIuqBwapAgMB |
| 65 | AAGjggEJMIIBBTAJBgNVHRMEAjAAMAsGA1UdDwQEAwIF4DAdBgNVHQ4EFgQUb+93 |
| 66 | 8vEI9GmijvajmbGft9586HEwegYDVR0jBHMwcYAU14D8Rv+G8ORGjSAw72S4aN8H |
| 67 | hK+hTqRMMEoxCzAJBgNVBAYTAmN6MRcwFQYDVQQDDA5TYWx0IE1hc3RlciBDQTEP |
| 68 | MA0GA1UEBwwGUHJhZ3VlMREwDwYDVQQKDAhNaXJhbnRpc4IJAOkTQnjLz6rEMFAG |
| 69 | A1UdEQRJMEeHBMCoAjOHBMCoAjKCDDE5Mi4xNjguMi41MYIMMTkyLjE2OC4yLjUw |
| 70 | ggVkYnMwMYIWZGJzMDEubXVsdGlub2RlLWhhLmludDANBgkqhkiG9w0BAQsFAAOC |
| 71 | AgEAOhjwhORG3AhgUvB5NgjnzsGdbg8B+P6B8UZsquLgjaMUwQfZHHYqfi9qHH8P |
| 72 | zTE4Wx9aah8MD1Jskpo70LyID3A/8EaN98HlQeD9NtTdtddulGOSPDhGOWeMBMjj |
| 73 | j5ehXAwlbifPBsB0M5+laTlqS1mIyPioUDKAiLcusFpAVz4tJpkfG/+AywZI5Nj7 |
| 74 | 2bkxm0Hvq5nKoHZ/fiaBQ9RQhoNBYmFszprstMkRG394XO6G17Oq1BVUKN/7e4za |
| 75 | AKZpVCTSl+lDm80Gt8j8VebW6tsAEzIisLgkKmqARO+AXZ6Atwl8sQUUNsy63A7i |
| 76 | 6BfrJb3tdZgXXgrdVU0DJfeq59xF57MYwca3IEhAxphnPavQN8JuouHMuiVsGc1M |
| 77 | FB5xyMrW1XPQYtH8yu5SLcU+0ps+dfr+NWepLXEU8URluX17hTFZIVWyq1TZs7oj |
| 78 | Pq3lPyAmMTc04zIyB3AUwYneKOVT2kEccaoM9a/TQR71Q8mdg//AbXLjTmUhAUSZ |
| 79 | wuQAf7yml+TcAbmzwvzCW/T8QYhH/Cgwc2wTu0MJprX32/VuOw4wgDqe3GbwNSmM |
| 80 | 1jTj6g93pHADOo+kMoMUw4ADRIemW8Tq3ZsaQw3dt3UlUNu+82+vmBI3HW0V/NNA |
| 81 | yuDE4X96Dopl4utK3QoJaBdiZ5uXui2UgJuVO/hkcx54T4E= |
| 82 | -----END CERTIFICATE----- |
| 83 | key: |
| 84 | name: /etc/mysql/ssl/key.pem |
| 85 | makedirs: true |
| 86 | mode: 644 |
| 87 | contents: | |
| 88 | -----BEGIN RSA PRIVATE KEY----- |
| 89 | MIIJKQIBAAKCAgEAvhAgL+MO1pRv8odJgtpS5aRbifmqOJnrkV0zNsOzacaxSpl/ |
| 90 | uXdhJpxQJGFDY8X6oUM40arg6FRDjWSgXPUUnvPCIK4lKQ/jw28dUD56yvRPLO/e |
| 91 | 0nHfEA3nrJnzPqZuxn9v3ZmTFgiZ4/FTwaqPH+VXojoR9Z2krMBe4N39SmU8JlsO |
| 92 | Ft1qYyQXW3bT6PxA8PdL+RUbo3jQe4BUL6mooBphYGTWh2fYeesQbl69d+nSYnDi |
| 93 | hLGjgkKT9fQk2sNZU17tmU87NbT71Gjm0d3XasU7IpL6Pi2VTExP4dtie9otdXy5 |
| 94 | +9PSsuP6rRhk9KElZOKSZiqx9Iv8xsM14DuOIm1kWadkT/iPAlmOqJOXw8eTowfo |
| 95 | haKxbabZa5FayDKBpPlmyY+xrViSO3dGbKq7G6qPR9guIabPeMPYxvewM6L3xPsm |
| 96 | 9uW4x+lu2LdsVhN/mxvb7CmV6O2NewzyiE4FojCuX6hj0xy32MK4LkhrEK40O7jW |
| 97 | wmCpd6vcnSfqSZ0v0hfuMW9SztmrO/yjPpnJuH5UBNQfCucK7DpE+16wOq47Yz23 |
| 98 | QRtQwxqN3DMya0gKZ8Ih88qeV/M+JL63fKKm3DjU59V+uc+i2DM7QMEMZ+tCQizW |
| 99 | E4QsWOsPbtx7AEMjk4fCmi7l4rlPwLF1qqHmEt4Wky+ouW3CM/sYi6oHBqkCAwEA |
| 100 | AQKCAgEAljOIPE/kWg/UqIXhwldnS7Qn41I7A6AgWjCdWJowH1e2pI3KMnf1ft3p |
| 101 | N9bluuOqveax8IBqXTC6cfMkCFJmiXd54vm8xEaaaMhXEiNORzXrnEe0f/sdnUJf |
| 102 | 5DeF0+0TfisX7LiBVNhXRZxh5Js1oK9OIhZiOwjqKtucH3lPwotejbFH4Sn5+X98 |
| 103 | NfwiW+1+JPBKSf40aWwA1pkD7ubVLDGs4tDN+RRIL5Fk2tRkR2+xo7oySUtZPIgB |
| 104 | Bk57Eadv4EMU4iOLV1Y/7g043IHEy8wyf5BH0vuTEUj9mDAYFGjHpCF9mVY9HMKu |
| 105 | SD0PC4SOWLv1lmgHWouGqE19Nkfael2uCCVGLjEr+PdiwWDyeCZwvtEI72SHIwoT |
| 106 | QJbti8mgfJtPvIgKh9PWTyf/I5LBIPvjh+/2x4B9MhqSOFUyx2gJMiJQ9NsvOyhQ |
| 107 | zFJMjIEoefajphTy4OcLGv6MkWvhtAKICW2xWfGLNkaWKEIA3ZAhHJLaiX+dw8/P |
| 108 | NAqvY33jVYHqhYKzKPTRqSWlzRHF6cjvVJw2KPL/kEJx4G1U/Azwl656928xKVj5 |
| 109 | uSoLzcdhMe4Klfdpi46SIOoCls4j68yDIG/lvLNUFX+etoOB26BbRJs+/2dX23uh |
| 110 | sFcKKBNb8UWvr8Fe4rP4YnAWqKJH6PfBA7sIlhkvRNhJrqcFiQECggEBAOWCHEzH |
| 111 | j2idl3k4ynZrACxZ5TF5DIps68Ps1G6927I+9ccVYzltK4FEKzJMbZlQRtXKYhi8 |
| 112 | yAzqnUJg2quF9GBVBNuQSXBoV6JZmUvqvIXySfy1VJadUEiWyziYFdDeOWrVwP4x |
| 113 | fAjSeUaf0mdPfEiV78UcLnpuKD43INPFDBwIbfHWgQdbu4OJAm2guekJ03vT7zkC |
| 114 | AJRmr9Ecswa4Bi7tOJQer4ytDQ8DIznW26Tgx6h25J+uuELl6LqVfhEGJDXqOHy6 |
| 115 | QT2Lp/dCFu/Wtbja6Dys85yfDwiwHxgi5kbSinuPgK7OqLgHu6Sbs8rTb8tflY58 |
| 116 | ls3GtNEVdVmDWcUCggEBANQAa+tEojx1H7p5fe13nPfy7xlh8oDx01asovKeBIHw |
| 117 | kA6/XngU0bm8c8R4jh/d4eUeFkoBzWzzPPrX6ydV1w0XgnV10lTKMvL0uHwSBBew |
| 118 | nPgYIrjjSxdrkLN+06SuaKw98siXX68JUXpLN3WqGBHLUAt/mRGdH0b1bBE43Mvb |
| 119 | IsxUjFtZAUP4ekso3IReKrCaCV6jihRwLntWI1Xi9rjRMEg6gbCakvXHNmKYk5Nt |
| 120 | /QeTJ9UhbtpZvVcThIlFU2mTOzvzJfXkh69CXcP2CVaXQK15Q8crhl4TfQo0M3ak |
| 121 | Xl9404EgJKNF2k1XHRLHm7hFSbq8OTwSH/yfzOtsG5UCggEAJ2oj4A+5kjbWR6w4 |
| 122 | IQQZQISjts5aF//CsaAfj3EtpLvpS6phowAbo5SIcpfrjpPZxmd+V088b/Nu1HJ7 |
| 123 | u09C+7Q+JFLwOczBmBEZIY+LltlYWXzurPsRSZYUCoEb5gX0CGPzQ/RNn9o9l6Jk |
| 124 | 6Pcemfyd89T2KnJ2mNCw442ImdvcvdafzBq15k4GS7t5kgrs9ewcvkaYwOOtuBTc |
| 125 | rf+2mCKHP/DRJzCk+HoKd6ltiTBNOaJJex7vaBXB1SFNSDEs0NGLp+f4wlAUpYMF |
| 126 | G2VdSgTWM21kXPZ4B37vqB5+O5V20OeBKwQ0t34kfI184A1VurCMp66/21EPxoSP |
| 127 | 5bKIHQKCAQBTowLwYzhZ/58P0yRiDeFoVHgNnH2ubzkAJcV3T+3ZUY2Ts93SI+yF |
| 128 | iRpm9WSkn8WhvVfvxHxFskRpdct4zj20FYVLT7s15jtpbDBoCjeBHRUgL21rYYhb |
| 129 | af1BQxS+EGyNHzdr+YQvKs7xH0F28y7hvkMK9kDuGP2g4evLc5Jv/jjhQa3Jz/hW |
| 130 | 121vv2QX+IqA95QguQYdgBBmahowpQTO7wBMToChqqm1uuzywtzdufOsDFsXk0QH |
| 131 | coXnF3UfLrF0ojgpM4jTVGBPPTB+wc73UV6b0Y5ywfIVpTycTPHMqZXttl5Cv+qU |
| 132 | W1d/UZHPud3uOa+XsvAlicUCxgxzCEhtAoIBAQCO1ihZ7zF10Ei04rEgwHrQc42u |
| 133 | E/JostbTzNtVjn+xauB7P8WmcpveBKXV+Hb5lPCQ0uMvZMZdKCuUgDSjQb4Jbh8k |
| 134 | 3OJhxQ40cUzi0z1cNXpfgghAuB9aCzNG8GYjvsYL3LUox8SocuwXJLRnqL/6AV5a |
| 135 | SohaSQOZ+xcBWkeWQ/3oRexT0Y3r8FqVfXRVPP4YBCzksCKh5+0FtsA0vzBPoahe |
| 136 | Z9pyL5KCdkDTk5I/ziiKMXaW747vkqeRF3rkCI6fwOTL0jh+vxzuA8If3HvMLyHN |
| 137 | 6xiZViPc4VayFnhDIC1w1oBqlhyIZ0AG/D7gqvfYiG6mHO32kPtHEN6Qzny8 |
| 138 | -----END RSA PRIVATE KEY----- |
| Petr Michalec | 5ff575c | 2017-11-06 15:37:05 +0100 | [diff] [blame] | 139 | galera: |
| 140 | master: |
| 141 | enabled: true |
| 142 | name: galeracluster |
| 143 | bind: |
| 144 | address: 127.0.0.1 |
| 145 | port: 3306 |
| 146 | maintenance_password: password |
| 147 | admin: |
| 148 | user: root |
| Petr Michalec | 89c8c3f | 2017-05-22 17:19:22 +0200 | [diff] [blame] | 149 | password: password |
| Petr Michalec | 5ff575c | 2017-11-06 15:37:05 +0100 | [diff] [blame] | 150 | members: |
| 151 | - host: 127.0.0.1 |
| 152 | port: 4567 |
| 153 | - host: 127.0.0.1 |
| 154 | port: 4567 |
| 155 | - host: 127.0.0.1 |
| 156 | port: 4567 |
| Dzmitry Stremkouski | 585ed4b | 2018-04-22 11:23:54 +0200 | [diff] [blame^] | 157 | ssl: |
| 158 | enabled: True |
| 159 | key_file: /etc/mysql/ssl/key.pem |
| 160 | cert_file: /etc/mysql/ssl/cert.pem |
| 161 | ca_file: /etc/mysql/ssl/ca.pem |
| Petr Michalec | 5ff575c | 2017-11-06 15:37:05 +0100 | [diff] [blame] | 162 | clustercheck: |
| 163 | enabled: True |
| 164 | user: clustercheck |
| 165 | password: password |
| 166 | available_when_donor: 1 |
| 167 | available_when_readonly: 1 |
| 168 | port: 9200 |
| 169 | max_connections: 20000 |
| 170 | innodb_buffer_pool_size: 3138M |
| 171 | mysql: |
| 172 | server: |
| 173 | enabled: true |
| 174 | bind: |
| 175 | address: 0.0.0.0 |
| 176 | port: 3306 |
| 177 | protocol: tcp |
| 178 | database: |
| 179 | mydb: |
| 180 | encoding: 'utf8' |
| 181 | users: |
| 182 | - name: haproxy |
| 183 | host: localhost |
| 184 | - name: haproxy |
| 185 | host: '%' |
| 186 | - name: haproxy |
| 187 | host: 127.0.0.1 |
| 188 | - name: clustercheck |
| 189 | #host: localhost |
| 190 | password: password |
| 191 | database: '*.*' |
| 192 | grants: PROCESS |
| 193 | - name: inspector |
| 194 | host: 127.0.0.1 |
| 195 | password: password |
| 196 | databases: |
| 197 | - database: mydb |
| 198 | table: mytable |
| 199 | grant_option: True |
| 200 | grants: |
| 201 | - all privileges |