From 544c3fee1453fdbe6a99ef30f17a71e9736ba531 Mon Sep 17 00:00:00 2001 From: Philipp Dallig Date: Wed, 14 Jun 2017 14:46:04 +0200 Subject: [PATCH] fbb-db - install galera cluster on prod --- customer/fbb-db/production.yaml | 54 +++++++++++++++++++++++++++++++++ customer/fbb-db/test.yaml | 2 +- 2 files changed, 55 insertions(+), 1 deletion(-) diff --git a/customer/fbb-db/production.yaml b/customer/fbb-db/production.yaml index 3b0442d3..63c11dec 100644 --- a/customer/fbb-db/production.yaml +++ b/customer/fbb-db/production.yaml @@ -1,2 +1,56 @@ --- infra::role: base +infra::additional_classes: + - infra::profile::galera_cluster + - infra::profile::mysql_server + +galera::repo::yum_mariadb_baseurl: "http://repo.pixelpark.com/Linux/yum/mariadb/10.2/centos/%{operatingsystemmajrelease}/%{architecture}/" +galera::vendor_version: '10.2' + +infra::profile::galera_cluster::override_options: + mysqld: + innodb_file_per_table: ON + wait_timeout: '600' + interactive_timeout: '600' + max_allowed_packet: '128M' + +mysql::server::backup::backupdir: /var/backup/mysql +mysql::server::backup::backuprotate: '1' + +infra::profile::galera_cluster::galera_servers: + - 192.168.65.31 + - 192.168.65.32 + - 192.168.65.33 + +infra::profile::galera_cluster::galera_master: prd-db01-fbb.pixelpark.net +infra::profile::galera_cluster::root_password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEALYD7S4xGLg+/MiC+RFIHfdVK1gT15G/Vky0JUTozNOEHHjTZIU23Q+t0Gl44RWiLfIkhyyRHKFESCsxWAcJH4eqtgvCVxtS2KJmARB+3kQ65j2w+GkauH00wf89DzjviOEZ+gCaTHvHbAPe41p5yMePxnuGEO+KRytsuYyW07KGRB44aAk2N3R/5b+NrZH8hpPz15x3ERQ/QMO6kA8XeusromjuMFJJgwIC4b+Ha3JWNP9k6DU+jN0U1QBb2rA/78dTeCRrS+Atuk2O218BnaTPzRfA/myvacSk/PJTcD0kTW/iFGPXwD03YvogUWxLw8XEZBEJaKN/SO2lLgli5+TBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBC3hH6QyGxhjZMtiWl/w/wrgCBAPOzJWJ0wbkDI1KOv+lslZFjo4EOr8viqn+XIngX/Vw==] +infra::profile::galera_cluster::status_password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEATnARg/KGyuxwrcjp3TRdciqxWaB+0YB2mTbnebNNkxuQAO7UCCh2pGNQz2Kmb4ThwlZpFtwcMRS9qnH/X07Y4eTQUynTEk5+r7273jMw+hEpt5Cmi42SDk/H9m9mbi2IGTxZzsz6cy2c43+K9yl5om75QzJnQdxUJkXz+xg7dobGEp9SpKJVKmjB0/3QO5gwqSZoip0xJVyGrt9J8pWYycmU1ba6FhU1nsXbcqU+XgioStgWz+3DW32Qzxx5+oEvfL8PH+zx+H+VFx6j4CpYpxRwvcD5eiFz5+/XsfgYR09bVN20RW/PY0UX4zRxSaTeeVlKIW7nY6Z8d5cOagdF7DBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBCQMFM1WrzAhsvhIn+tQZLJgCCBaB70N2lrzBnZu85A0hmOysdYcOrkf1ddU/vpcjXSbQ==] + +mysql::server::backup::backuppassword: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAWsID3wAfomE9xQLgidatctNQHtrgOwS2GIs1XouXXezXNcbbtbZlLgawdvpqgIjujD88ySkR8qu8xX5cYZtmYWt91HBgg5CCrEo0W3KSA62XMUB2BaZAvQTpXHdz+uPFGWJXXoTFna7dXgZLXREypX1gh35nsGJZbTfCgLqzF7lvU19LhAmKCkPkwd3Lf5VXKr5NoYxKO20pvkf9AxUONpi1G5MyVyT0MiMdXSuEYzp0fFUg3MXkACKQDE3PNWqQCLKCqQdROdlPiJg6xxHCkPQ5QqIlOqfumXNBdjTF44gCBOR4vx6tUFIAS0NW5ebJMz5LUYEyikZShFBRAZ1ghDBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBxWy6LLti8VZ4IX6aLA4oWgCBn3m5XPU22Wmz/vCllmnqGupfMbcw/i/puuqgFAirh7Q==] + +infra::profile::mysql_server::databases: + mobile_apps_backend: + user: mobile_apps + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEANYQ9nxOiI4uMNfaEtF8iUn76ImMrhi31gCtcoXSA2+3FDIjcZsrVJh7ZPUy8umByQQRsddA0Q5fLBBHxRXEevXJCtzLUo4zoPy09y+VNhbtANy5fi8VcQgw1tbEp+Q1Br5e9IAEDrAASXX7eNnholxKwrk4eazIGnVh/OiTu9SJX2iPCdgIAGZD06TXg7T8yaAziY7yGIl/6vx+2sWe1XqSHWgYZUZPKBLU8pbkjF3gM7S06D5GRPrPpmW+pCSsco8L7BCZQwmVnrfps8WwZOGvim9Icsd3EQ6TYwhHJ9+cAWIvJTdfzw+99NJCBb8roJrHcvJ1DJkFHMvn2cNvS7DBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBCLfuWnoFPs0HoOGLsalBPUgCC3htHocxqyAO08bSS76NxMsQ9+Nv8RWgyVwIdnArAldg==] + host: '192.168.66.0/255.255.255.0' + mobile_cdm_backend: + user: mobile_cdm + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAEPeXe4LoR2C94o+TW8CZ/TAiOfPRF4UvG3NshV1e3Yvg9WljDuYPWDQTzz2uxrtb5IZUUtpWIrqq4rbL3KkDWxQ4a3cLiTwv9Tuw3+KFiyTN40infYR1eRvV0B1iDJB8bF0bU/YH1vJtRJDNNMfpfYBir8PAeMKHlXPDEAeY5CX070pGMZVO4HIp1wOzkacR1NMRSzCFqFXbanuPV2q8X69Yli6XRNprnC/cj80pwJ2JxBjRfxAdlA9t5zYSnnfB8u82D0qXmyCpnGLwS/WBwFJATnNt4z/i2MXNqpTRs8J7/GS4MzEE680OwURzumKjfJeDnn9ZzIcoovaTjpnwJTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBI7BqgZ0ffy550TPLNu7ywgCAeBVtaq5lc0IvzmPPB4kdEUghd/7bAtDD9p+6H/6KCsg==] + host: '192.168.66.0/255.255.255.0' + entgelte: + user: entgelte + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAPeqEfXOdcZN/l4iWys792iJ/RC6nK50cWP3JKwcAvY38XdpFct5+7TkAOjrEhtl0EQBwx7cwiSvPYOEAdC9RqrYRdPp3ZgLhsDkSjf/SKJxi1ajdQFbxKKX7OOWIrCVJZcvhWhENdGpvrZBSu1zamPKuZQ0D6sZho3PMl+I11ZDha636CwNpr45WpVd1OKOeyBp/4N6TuZiDlB6uRdjO+JLJvX9LA7WL5k7IS8kqcffvsWMCcXaFu3w0Os5BDu504qsB2Fj9S35IXVHf6F0llGVvUZSy3Ds8vRiG9HhgbdqrnmmkANsXftb5Z8BgteDIvfXmIV2jZNwsqgU/QN0gTzBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBAq/FvRNlEU7s1mgeh/NzjogCAwm8tDmFvKHzLHTZBtu8TCIhHSPcvQJY47gm/dw2t2Zw==] + host: '192.168.66.0/255.255.255.0' + flugplan_alt: + user: flugplan_alt + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAZNqDYCbo2ufaECOp5uOQwjso4j36LUAwyLRMRRnSLPrPMKo+jC4bmn4J2c+0qomgKuRFETeBQOd6QCH9xuT8HKwe12/UQ4RJOOTV8rlwyeXFjKymMVijERdsN3A1eub3Xdn8cGvaoKDs32QrP2IVbDa3ahVTl7OsLLa+Ya7ptswKmxXkll1m35a172mSh6gYWMDcWT3bEa7cQnTIxbp1QTo8OTXbDeVkfvQFWmHtPJije+LWzzL2FKhqtl9PMMnhPCF8KG7g9VOsmFhzeXyJtc9VC5WYXSDaKRW+m9fQQ8ZTSErLv5Fm1wKBiie5mG8kKGv67fCX8OwqUaiyLDkBYjBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBEAYmDEvD7P4L1A6qfmVqBgCC9gf810UA0S87R3Fbq+/2X7yBmc/HvKuXj8ragDli7kw==] + host: '192.168.66.0/255.255.255.0' + website: + user: website + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAIY+kAScW5npIjaWHvcEYvMlEIPRDgeglo3c8Sz1RYN96/N0ibzzg+wWEkIcb+7Y7QRuRVoGlwkXIgw/qhAlAcZzZ8u0QvaKa9A0ZBkU6V8gV2zEDe1ANMYknZEAWJZSq5V8QYaI8uXU9Riu2cmX1fKcP07qAvCBNeO2a00jA5nenwPqZo2g65zQlN5GqkJzjFhFcz1yWW2AUbibUAJ/XeicX0PMqUQNgYUAsMrxx5O60+rV1koGyFoid7+stiNriiAc1Nmg1+DVxlkR87NIR57bsyn2Ynhjq8VedeRiRyuzaIaG83R6TrF+cbBbjFfIlsBu2ufn+6NC/1aHd7JLO7zBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBB4JW9LXIxGuMBnv0j4LWntgCCB+YpDrzQk5LxVlUg6bTLxamvApyLmgP//dRXlDoxspg==] + host: '192.168.66.0/255.255.255.0' + # Should be the darksite DB + psm_apps: + user: psm_apps + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAEBciFEShUWvN7Bqyqdfbpero2aBMGRX1DdlMOapLdkynFFwJBoxfZXlh9HjAegkb7Gf6OID8AHAeeMzPrlRdP5nqpOcIwiE/Lzg/1S/YaMfn3woZ3huF/GDyeeCuYpBRvsUNh3Yeys/lYeIpSIZfsQOEY+qg9lDcBxHFVeuiXYqmjn6gP7jfaZX1zZj6GyBDQgxqzRKxaiVvLuphcS4B+oqUzDdSMS/Y/wjvcYPqT4bjE11Z7G1hF/ry5B8tw8Z2BcxZyDmvdKRcb42M5U6IHzfl6Hs+HrhETj6JoDDCRYWL2YsLsDPziKTw0Cj27qN8p7RAPuyOeJxVpWDU198cqDBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDRLs1hZJnQrOI8ADEvMQl9gCBaG/0Cj4mWU8qRoHrfyL0ncmlozcbEzJESxIRnIvjaYQ==] + host: '192.168.66.0/255.255.255.0' \ No newline at end of file diff --git a/customer/fbb-db/test.yaml b/customer/fbb-db/test.yaml index 1f6a9814..93934d17 100644 --- a/customer/fbb-db/test.yaml +++ b/customer/fbb-db/test.yaml @@ -52,5 +52,5 @@ infra::profile::mysql_server::databases: # Should be the darksite DB psm_apps: user: psm_apps - password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAu8AH8WKa6vjatTMHOlu4Snyu3uqOu3fhAUkV/njJ+ERUaJh2mYazd1MzObRz0MRpe2DepM0ORq6hytXvwH9di5sRDKjNgYREyrZOO/vS+5/3aER1jquzEG5jwmyAFhTnztZnSl+42w5Y4ILNPJRdaJGsV9HTRlPOUsmSmiR9MwpAXwLqWOPXJTFWpVZMEUFbpujDW+UK60cdCnezzxcOsBH5cGqgOA2fr6L8KrcMAwbdDcOI1/dmGexAJM6aqbNc3XNDVtrHVDkk7YXg9uM4GcRBuicq/h0Pgo9nmBiCPadxqkHz82nMFXZnDK1A9IW1wgGaV9WI77UR+Muf/jMq8DBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBCFiA17BwqfUVFwtTLEAxu9gCCbj/wCqFiGud6AMUiuPPctnHajsumSinU5A8PAhgSHBw==] + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAu8AH8WKa6vjatTMHOlu4Snyu3uqOu3fhAUkV/njJ+ERUaJh2mYazd1MzObRz0MRpe2DepM0ORq6hytXvwH9di5sRDKjNgYREyrZOO/vS+5/3aER1jquzEG5jwmyAFhTnztZnSl+42w5Y4ILNPJRdaJGsV9HTRlPOUsmSmiR9MwpAXwLqWOPXJTFWpVZMEUFbpujDW+UK60cdCnezzxcOsBH5cGqgOA2fr6L8KrcMAwbdDcOI1/dmGexAJM6aqbNc3XNDVtrHVDkk7YXg9uM4GcRBuicq/h0Pgo9nmBiCPadxqkHz82nMFXZnDK1A9IW1wgGaV9WI77UR+Muf/jMq8DBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBCFiA17BwqfUVFwtTLEAxu9gCCbj/wCqFiGud6AMUiuPPctnHajsumSinU5A8PAhgSHBw==] host: '192.168.66.0/255.255.255.0' \ No newline at end of file -- 2.39.5