From 428249adb4394a31210c8fb4999c19f8e0f04a06 Mon Sep 17 00:00:00 2001 From: Thomas Dalichow Date: Thu, 6 Sep 2018 15:12:35 +0200 Subject: [PATCH] fbb-api - move mysql config to individual cluster nodes to disable this setup for nodes 04-06 --- customer/fbb-db/test.yaml | 63 ----------------- .../fbb-db/tst-db01-fbb.pixelpark.net.yaml | 68 +++++++++++++++++++ .../fbb-db/tst-db02-fbb.pixelpark.net.yaml | 68 +++++++++++++++++++ .../fbb-db/tst-db03-fbb.pixelpark.net.yaml | 68 +++++++++++++++++++ 4 files changed, 204 insertions(+), 63 deletions(-) diff --git a/customer/fbb-db/test.yaml b/customer/fbb-db/test.yaml index c96a3b5d..70754435 100644 --- a/customer/fbb-db/test.yaml +++ b/customer/fbb-db/test.yaml @@ -1,8 +1,6 @@ --- infra::role: base infra::additional_classes: - - infra::profile::galera_cluster - - infra::profile::mysql_server - infra::profile::postfix - logstash @@ -31,64 +29,3 @@ accounts::users: sudo: false infra::profile::postfix::transport_maps_source: 'maps/transport-fbb-tst' - -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' - # temporaer FBBUBPP-33 - sql-mode: "NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER" - -mysql::server::backup::backupdir: /var/backup/mysql -mysql::server::backup::backuprotate: '1' - -infra::profile::galera_cluster::galera_servers: - - 192.168.66.31 - - 192.168.66.32 - - 192.168.66.33 - -infra::profile::galera_cluster::galera_master: tst-db01-fbb.pixelpark.net -infra::profile::galera_cluster::root_password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEArSuOn0m5W0X2lSiWybmcBhOlFLyJ1lmZnhq07PQGuX0isng1F+z5dDLmFjKZeI/PuKyn79vlA6P1Cg+NFNe3ewXwL1n+ASiBZ926IiG21FeivEpA3WJhboysXBnvc+qytf3swwdd0tvODxRCaH4M2cyn/BaLtApz6UrIlnMo1MwU2IqiGwt4Q/TRuB1/EYp1IjRpk2SWGYJ82/Zl64CdgKWswz+iXgZkhmpPSJiJ4UuExU8jr9xGyEPHYLkeRPvDAXgi0HivYwTPdDr60cAAyUyQLFaZkq/sxZZLwkd9TJx09Lq9xnmRvY2LZ8niBdl8XpgO2nCmVnoHJQVWUrRG7TBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDXx4cRyLH/fizFtFbDoiMzgCBF59zBH/qyt+saFxXG+TzjKxBHI49d/jGEx3DLbhf3Ng==] -infra::profile::galera_cluster::status_password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAUnhs4oqdEAgyQ+EGhK7gLioajacceFK7GhP/dmYdQ/YVaGAgm6CQ1B8Q9+sAarrjPbsqG1VAoDBTzcu7saSFs/7+qmcavn7n2SyFGVZln63v81SaNm7mao9zCCmUeEstxeN96MpkGVCs2WUz7cRDIa5woGFuJ4XsgQcpzW4XPEdCvNY3jFMlWUZDsmMxN7ikuPIJCYVaK7qWZFj2LLEyKmHuNRvi0Qymn93kFStYwxbIMMVZp3CR6lWRmPRf7aWbUeZn1ImkwNhiRWh2ND0o3w618/KgZghfcPqqgZCxNLQWrqPvDIchjozoq4X276fy7MqkUAmGWD1Sm0lzmRMBvDBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBCk7fUfT2CE0J6kMvQvCYM4gCBTUUsNSqlDkS4iBxeJK2xPkl2xdkXz8zEC/6HzdWuqXA==] - -mysql::server::backup::backuppassword: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAicTfq6ywtRQqkwQ5wgqoFxtG3s4ubcbK4F9uWpgXKbVpfNRlLxtmYatfxCkh3TOaC07MLOUrNLM1LVdnWwbyNIF0xgY1kdquU4QWXtIF6i2fIFH6qpPHAMh5X8Mfbkkc27E9963WojzDxoWBWT/joaepcx4Me5cCD8ubj8D7sL43SUwGHbhB+AMyGsi8g/sF9g4iGbUA6gkTPchLWZGvLjZdZlXL980GwNE+AHavheaewanIrs0x+BjAZIB0bk9ZUc6NRxUuMefLmwZhsNjydDVcMNdQ6D06FIgRKMCwKo8AfXdpF1c1rLmES7CAJ/wT4t478i1jg7yK3uLxdi+X7zBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBC9rr36T/rN42x4ShgGHETmgCBwtEPnG6ak/2kA7HwPrRY6NEQc03RxQ54qoIZKSRwZsA==] - -infra::profile::mysql_server::databases: - mobile_apps_backend: - user: mobile_apps - password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAUZCx/fePcj1jELbFchK5nWhgG9tfTfc76EUhkDyKY9xFQUSJ0AHkYveRH+pHU8z3nkGA6HnHbeMiBw6L4z535AIEQsatxXn5UAqbqgS4hU0LlMUX74HY/PLBkhzOiniVHHsUioy0hPU6+4yqF7jMZsFkFp6U3G7szc33kTZQB42OP+VlulcptruhFca0cZKM6ZiWGaKAUaKRujYIa6T4xEQBZ0ZUfbvDpauFCO8jlpkYUPVQEQA3sxhiC3sEQ9u0moHUHJsTRwDUX6R62x27ZSK7iKdoVMP/hVTPFgVy3KvZuTPuAZbl/lzJxsOxIuIQjsmocE8BisA4bhpSlv6VpzBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDb/dcFuQTqyjYtHozvk5GSgCA7XEtOieto+X7cq4kZAf0creYXR3Y1P4fG/xNlH2J/wQ==] - host: '192.168.66.0/255.255.255.0' - mobile_cdm_backend: - user: mobile_cdm - password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAQujOC4G0UB4VWlqJGgG+dabMtNLtv3qXcOUIRifBTMollvB0PmEmsiF9GMDkyGtvcSFvH7H16+bltOTDQOP/AwbDkLFoptQ+oGOxB1UGFqdGQvHXKGkrOWQAt1y8GKMefj7G0RafERbVRIPvmaK0hzP6aaqqFfUFl+HxM125mVQjAUnBDsWuBYfNWTACyIqBM1FyigOqbKg6gCpVtX1w3pbngZEYZewFe4T5asCgE94liorZTVXiuYnopTaBeharRg4fP4i6xD8MpxKebYy2HFcA83PaupDlAUXu3D1JxhJ+e6LFcW69yHDf6xBPxStnk3lR9mP55hlV7Slg7HL3eTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBgNi+uh6YTA9Q7Tuo1mDbOgCA4u1M+COKi+0NCMSx3gKBSM0CI07DWWzG6H3h+7VQ2QQ==] - host: '192.168.66.0/255.255.255.0' - entgelte: - user: entgelte - password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAeP+eyQOwJC0jZbj1+68rbyDLncugWXVQT2EAy5zH31sc4ebcbgQFhx1nnM9+UkoHnA6tj3l1IJsUeZx8s2Dh5QyHaD261AZpDgJnGVu/VjZ9EmC24aCweSWBpHAJiKCyzLgUHpq/1Hm7FU9P/V+SCrmnrFLn8Lgu3iYGZwtgRS6oL6CMjXpGUrJietjRnlgLsLNwMmZdWwKEyZQ4UUCVgR5pyDeHYj5Nxa+TkGicdCGa22xMfO335shK4DZiGl1pq/T9KFpiddjELkFYt8bBDE1zinvwYkj1J9r1HCKQM6lmX/IP9t76p+ErqPQvUkwzmep6YySQLC/yD6k2IOwMNTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDXd2fINrxw8yLW3Rg7p8x8gCDJRVXFM/sCfjffsn3W54gHz4GMwO+GTaynt8dJwLH+WQ==] - host: '192.168.66.0/255.255.255.0' - flugplan_alt: - user: flugplan_alt - password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAc810/TEt7ZV1sp/cPSG0Ujwwxd/Hs27/r3CcybZMKXUyTKxrFXZ52tFAJRYzoVzkJlJ805LUAkAVdyS1oAAbrLHVkqSmHdVXhOlW3k3K/DBzk6dwvx/66YYrDq/RiI0dYup/ymQiiNyrUzsuFN4FKdXlVesM22OG7i8AXGgNDO2GS4icDQSsNBdtSmsg6iKbfKuMa961af/hhZgHBPXlUAxJob2ofwL4IJeGcP9mcig58FKs26EJrBaJkhyyYkZWWBE9ZslMILBGnpAptQg4WPphzCsf0E5H71Sg2Wd/qpvt0Vlbs6IIAsfEbO8awC8Id2+gEMXXIf8gMhz+LGtKMjBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDlvMZi2s5gtKvXBIEcLYUwgCA0b/ENpeqm79Gb0Qg2XsZ7KWSjG5AVQyJkU/buEwik+g==] - host: '192.168.66.0/255.255.255.0' - website: - user: website - password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAE0bqu3jJivdYTnZaDf/MTx8njoiX2gFw1MHVhgPVZB9ZtFO6yJ95QcWXGq1SkSxfJ8ucaA7rpxs5cmpjckrn/G4TSb0oEbFOK08C9WCpjWthqbuBSLf/CGk5q+tF8pQPDBx5pt8HMXUmjHvLGQwHowYSy2/snPpcvXbBXJaZoXzYVFeWzmzBStDGWYQ04H9iBLxafGlJYMAKW2Emo/oNlS9I0fxT+C8blAHp5Ypw2X+xL3kPMuKkZhisCBGX/PVaHr5RTVcYq42H5avwC8YYcDJPcOS1q3uWo68zSfxdoH6lz5ysCzdXFMZwI8ZwGSZY9qcnywk7+peB/jGIvi+qAjBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBC/VkMEHQajWH+RGYSctE2KgCC40mNT/biomgZztlQpEtzbnfb2m0gksRYGJcTuFDVk6A==] - host: '192.168.66.0/255.255.255.0' - # Should be the darksite DB - api: - user: api - password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAdrvmrh51Y6RvUQXRnRcWTGF/tq+sQXJiDcR+AzBwqlXfyw8KuRO8VnRHO+BizxlPZUaGgQ17LtdelEeFu2ElT3BVsDhZh8nKuwxtfyaf9W/SkiGIDaKYl5CLYQ2qzuGJXwiN2jyvGSYnD/yIwTGO/BPMq7WQU+YNlMWYABRoGAOVa68jRGHo0uvA7z0kPL3M45l3R/ccpjPMRgeo3q0k/Mey5vsHJPuluSEXmOH9sRycjna91mSr+RywiCzYGuygfldpWovJbeqhPQTQQ6P1jCo8hyF8gvFYiWQqDw7/acOvZxBKzaOqfUeBPZ6n57gITkp3NoM66hatNg/Xs18Y1DBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDLJhbfaPIR3a9FrY//3CzygCBzNbugIUDByCHBFLup/AHDUrezVikK5ACz+ofJWKcU5w==] - host: '192.168.66.0/255.255.255.0' - poi: - user: poi - password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAMBqoSFKIJMPBsH+VH5SjXEjLt7S8if1eb2Mv4PRSbTFPZTZHvCe/qrWly8mu4VmCw6tBGyaIOmKCjrjUV6EV4QZTemWCM4LwD6VwaxA7YMnw/rHb5/kgKuZMNcXnKNE59b0fM5l3Z0ohj+OjDJjrBY3iGn7yu5D2vWLM3tYVxRA5J3Yeuu5yBby/8IEcY/VADoktH4cOATkSKJa3jzTVqIGn7SL0IDQIHHXxj5Zg2WAb4w78+Q2bNrTKWOWaszOHyi+bN7gAvSOjlwe3eOTLvotZeXwRt8U2kqAhrfR5f0Knf66ioWyfXbzqRH1qm6Iw7hMK/AvgHFzaIzdsW4Z/9zBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBA75+ZhkUW61vCRnlq716mdgCDPIhT1XN+QWsemKGGxh2kj48hIuasWd8u9BnWETt7ANw==] - host: '192.168.66.0/255.255.255.0' - psm_apps: - user: psm_apps - 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' diff --git a/customer/fbb-db/tst-db01-fbb.pixelpark.net.yaml b/customer/fbb-db/tst-db01-fbb.pixelpark.net.yaml index a923b64a..c359b652 100644 --- a/customer/fbb-db/tst-db01-fbb.pixelpark.net.yaml +++ b/customer/fbb-db/tst-db01-fbb.pixelpark.net.yaml @@ -2,3 +2,71 @@ mysql::server::backup::time: - '10' - '5' + +### MYSQL-Konfiguration - Temporaer, bis der Kram wieder nach test.yaml kann +### muss gemacht werden, weil aktuell 6 Kisten in 'test' sind, aber nur auf 3 MySQL ausgerollt werden soll + +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' + # temporaer FBBUBPP-33 + sql-mode: "NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER" + +mysql::server::backup::backupdir: /var/backup/mysql +mysql::server::backup::backuprotate: '1' + +infra::profile::galera_cluster::galera_servers: + - 192.168.66.31 + - 192.168.66.32 + - 192.168.66.33 + +infra::profile::galera_cluster::galera_master: tst-db01-fbb.pixelpark.net +infra::profile::galera_cluster::root_password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEArSuOn0m5W0X2lSiWybmcBhOlFLyJ1lmZnhq07PQGuX0isng1F+z5dDLmFjKZeI/PuKyn79vlA6P1Cg+NFNe3ewXwL1n+ASiBZ926IiG21FeivEpA3WJhboysXBnvc+qytf3swwdd0tvODxRCaH4M2cyn/BaLtApz6UrIlnMo1MwU2IqiGwt4Q/TRuB1/EYp1IjRpk2SWGYJ82/Zl64CdgKWswz+iXgZkhmpPSJiJ4UuExU8jr9xGyEPHYLkeRPvDAXgi0HivYwTPdDr60cAAyUyQLFaZkq/sxZZLwkd9TJx09Lq9xnmRvY2LZ8niBdl8XpgO2nCmVnoHJQVWUrRG7TBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDXx4cRyLH/fizFtFbDoiMzgCBF59zBH/qyt+saFxXG+TzjKxBHI49d/jGEx3DLbhf3Ng==] +infra::profile::galera_cluster::status_password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAUnhs4oqdEAgyQ+EGhK7gLioajacceFK7GhP/dmYdQ/YVaGAgm6CQ1B8Q9+sAarrjPbsqG1VAoDBTzcu7saSFs/7+qmcavn7n2SyFGVZln63v81SaNm7mao9zCCmUeEstxeN96MpkGVCs2WUz7cRDIa5woGFuJ4XsgQcpzW4XPEdCvNY3jFMlWUZDsmMxN7ikuPIJCYVaK7qWZFj2LLEyKmHuNRvi0Qymn93kFStYwxbIMMVZp3CR6lWRmPRf7aWbUeZn1ImkwNhiRWh2ND0o3w618/KgZghfcPqqgZCxNLQWrqPvDIchjozoq4X276fy7MqkUAmGWD1Sm0lzmRMBvDBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBCk7fUfT2CE0J6kMvQvCYM4gCBTUUsNSqlDkS4iBxeJK2xPkl2xdkXz8zEC/6HzdWuqXA==] + +mysql::server::backup::backuppassword: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAicTfq6ywtRQqkwQ5wgqoFxtG3s4ubcbK4F9uWpgXKbVpfNRlLxtmYatfxCkh3TOaC07MLOUrNLM1LVdnWwbyNIF0xgY1kdquU4QWXtIF6i2fIFH6qpPHAMh5X8Mfbkkc27E9963WojzDxoWBWT/joaepcx4Me5cCD8ubj8D7sL43SUwGHbhB+AMyGsi8g/sF9g4iGbUA6gkTPchLWZGvLjZdZlXL980GwNE+AHavheaewanIrs0x+BjAZIB0bk9ZUc6NRxUuMefLmwZhsNjydDVcMNdQ6D06FIgRKMCwKo8AfXdpF1c1rLmES7CAJ/wT4t478i1jg7yK3uLxdi+X7zBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBC9rr36T/rN42x4ShgGHETmgCBwtEPnG6ak/2kA7HwPrRY6NEQc03RxQ54qoIZKSRwZsA==] + +infra::profile::mysql_server::databases: + mobile_apps_backend: + user: mobile_apps + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAUZCx/fePcj1jELbFchK5nWhgG9tfTfc76EUhkDyKY9xFQUSJ0AHkYveRH+pHU8z3nkGA6HnHbeMiBw6L4z535AIEQsatxXn5UAqbqgS4hU0LlMUX74HY/PLBkhzOiniVHHsUioy0hPU6+4yqF7jMZsFkFp6U3G7szc33kTZQB42OP+VlulcptruhFca0cZKM6ZiWGaKAUaKRujYIa6T4xEQBZ0ZUfbvDpauFCO8jlpkYUPVQEQA3sxhiC3sEQ9u0moHUHJsTRwDUX6R62x27ZSK7iKdoVMP/hVTPFgVy3KvZuTPuAZbl/lzJxsOxIuIQjsmocE8BisA4bhpSlv6VpzBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDb/dcFuQTqyjYtHozvk5GSgCA7XEtOieto+X7cq4kZAf0creYXR3Y1P4fG/xNlH2J/wQ==] + host: '192.168.66.0/255.255.255.0' + mobile_cdm_backend: + user: mobile_cdm + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAQujOC4G0UB4VWlqJGgG+dabMtNLtv3qXcOUIRifBTMollvB0PmEmsiF9GMDkyGtvcSFvH7H16+bltOTDQOP/AwbDkLFoptQ+oGOxB1UGFqdGQvHXKGkrOWQAt1y8GKMefj7G0RafERbVRIPvmaK0hzP6aaqqFfUFl+HxM125mVQjAUnBDsWuBYfNWTACyIqBM1FyigOqbKg6gCpVtX1w3pbngZEYZewFe4T5asCgE94liorZTVXiuYnopTaBeharRg4fP4i6xD8MpxKebYy2HFcA83PaupDlAUXu3D1JxhJ+e6LFcW69yHDf6xBPxStnk3lR9mP55hlV7Slg7HL3eTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBgNi+uh6YTA9Q7Tuo1mDbOgCA4u1M+COKi+0NCMSx3gKBSM0CI07DWWzG6H3h+7VQ2QQ==] + host: '192.168.66.0/255.255.255.0' + entgelte: + user: entgelte + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAeP+eyQOwJC0jZbj1+68rbyDLncugWXVQT2EAy5zH31sc4ebcbgQFhx1nnM9+UkoHnA6tj3l1IJsUeZx8s2Dh5QyHaD261AZpDgJnGVu/VjZ9EmC24aCweSWBpHAJiKCyzLgUHpq/1Hm7FU9P/V+SCrmnrFLn8Lgu3iYGZwtgRS6oL6CMjXpGUrJietjRnlgLsLNwMmZdWwKEyZQ4UUCVgR5pyDeHYj5Nxa+TkGicdCGa22xMfO335shK4DZiGl1pq/T9KFpiddjELkFYt8bBDE1zinvwYkj1J9r1HCKQM6lmX/IP9t76p+ErqPQvUkwzmep6YySQLC/yD6k2IOwMNTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDXd2fINrxw8yLW3Rg7p8x8gCDJRVXFM/sCfjffsn3W54gHz4GMwO+GTaynt8dJwLH+WQ==] + host: '192.168.66.0/255.255.255.0' + flugplan_alt: + user: flugplan_alt + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAc810/TEt7ZV1sp/cPSG0Ujwwxd/Hs27/r3CcybZMKXUyTKxrFXZ52tFAJRYzoVzkJlJ805LUAkAVdyS1oAAbrLHVkqSmHdVXhOlW3k3K/DBzk6dwvx/66YYrDq/RiI0dYup/ymQiiNyrUzsuFN4FKdXlVesM22OG7i8AXGgNDO2GS4icDQSsNBdtSmsg6iKbfKuMa961af/hhZgHBPXlUAxJob2ofwL4IJeGcP9mcig58FKs26EJrBaJkhyyYkZWWBE9ZslMILBGnpAptQg4WPphzCsf0E5H71Sg2Wd/qpvt0Vlbs6IIAsfEbO8awC8Id2+gEMXXIf8gMhz+LGtKMjBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDlvMZi2s5gtKvXBIEcLYUwgCA0b/ENpeqm79Gb0Qg2XsZ7KWSjG5AVQyJkU/buEwik+g==] + host: '192.168.66.0/255.255.255.0' + website: + user: website + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAE0bqu3jJivdYTnZaDf/MTx8njoiX2gFw1MHVhgPVZB9ZtFO6yJ95QcWXGq1SkSxfJ8ucaA7rpxs5cmpjckrn/G4TSb0oEbFOK08C9WCpjWthqbuBSLf/CGk5q+tF8pQPDBx5pt8HMXUmjHvLGQwHowYSy2/snPpcvXbBXJaZoXzYVFeWzmzBStDGWYQ04H9iBLxafGlJYMAKW2Emo/oNlS9I0fxT+C8blAHp5Ypw2X+xL3kPMuKkZhisCBGX/PVaHr5RTVcYq42H5avwC8YYcDJPcOS1q3uWo68zSfxdoH6lz5ysCzdXFMZwI8ZwGSZY9qcnywk7+peB/jGIvi+qAjBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBC/VkMEHQajWH+RGYSctE2KgCC40mNT/biomgZztlQpEtzbnfb2m0gksRYGJcTuFDVk6A==] + host: '192.168.66.0/255.255.255.0' + # Should be the darksite DB + api: + user: api + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAdrvmrh51Y6RvUQXRnRcWTGF/tq+sQXJiDcR+AzBwqlXfyw8KuRO8VnRHO+BizxlPZUaGgQ17LtdelEeFu2ElT3BVsDhZh8nKuwxtfyaf9W/SkiGIDaKYl5CLYQ2qzuGJXwiN2jyvGSYnD/yIwTGO/BPMq7WQU+YNlMWYABRoGAOVa68jRGHo0uvA7z0kPL3M45l3R/ccpjPMRgeo3q0k/Mey5vsHJPuluSEXmOH9sRycjna91mSr+RywiCzYGuygfldpWovJbeqhPQTQQ6P1jCo8hyF8gvFYiWQqDw7/acOvZxBKzaOqfUeBPZ6n57gITkp3NoM66hatNg/Xs18Y1DBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDLJhbfaPIR3a9FrY//3CzygCBzNbugIUDByCHBFLup/AHDUrezVikK5ACz+ofJWKcU5w==] + host: '192.168.66.0/255.255.255.0' + poi: + user: poi + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAMBqoSFKIJMPBsH+VH5SjXEjLt7S8if1eb2Mv4PRSbTFPZTZHvCe/qrWly8mu4VmCw6tBGyaIOmKCjrjUV6EV4QZTemWCM4LwD6VwaxA7YMnw/rHb5/kgKuZMNcXnKNE59b0fM5l3Z0ohj+OjDJjrBY3iGn7yu5D2vWLM3tYVxRA5J3Yeuu5yBby/8IEcY/VADoktH4cOATkSKJa3jzTVqIGn7SL0IDQIHHXxj5Zg2WAb4w78+Q2bNrTKWOWaszOHyi+bN7gAvSOjlwe3eOTLvotZeXwRt8U2kqAhrfR5f0Knf66ioWyfXbzqRH1qm6Iw7hMK/AvgHFzaIzdsW4Z/9zBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBA75+ZhkUW61vCRnlq716mdgCDPIhT1XN+QWsemKGGxh2kj48hIuasWd8u9BnWETt7ANw==] + host: '192.168.66.0/255.255.255.0' + psm_apps: + user: psm_apps + 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' diff --git a/customer/fbb-db/tst-db02-fbb.pixelpark.net.yaml b/customer/fbb-db/tst-db02-fbb.pixelpark.net.yaml index efb8a753..f990fef4 100644 --- a/customer/fbb-db/tst-db02-fbb.pixelpark.net.yaml +++ b/customer/fbb-db/tst-db02-fbb.pixelpark.net.yaml @@ -2,3 +2,71 @@ mysql::server::backup::time: - '11' - '5' + +### MYSQL-Konfiguration - Temporaer, bis der Kram wieder nach test.yaml kann +### muss gemacht werden, weil aktuell 6 Kisten in 'test' sind, aber nur auf 3 MySQL ausgerollt werden soll + +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' + # temporaer FBBUBPP-33 + sql-mode: "NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER" + +mysql::server::backup::backupdir: /var/backup/mysql +mysql::server::backup::backuprotate: '1' + +infra::profile::galera_cluster::galera_servers: + - 192.168.66.31 + - 192.168.66.32 + - 192.168.66.33 + +infra::profile::galera_cluster::galera_master: tst-db01-fbb.pixelpark.net +infra::profile::galera_cluster::root_password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEArSuOn0m5W0X2lSiWybmcBhOlFLyJ1lmZnhq07PQGuX0isng1F+z5dDLmFjKZeI/PuKyn79vlA6P1Cg+NFNe3ewXwL1n+ASiBZ926IiG21FeivEpA3WJhboysXBnvc+qytf3swwdd0tvODxRCaH4M2cyn/BaLtApz6UrIlnMo1MwU2IqiGwt4Q/TRuB1/EYp1IjRpk2SWGYJ82/Zl64CdgKWswz+iXgZkhmpPSJiJ4UuExU8jr9xGyEPHYLkeRPvDAXgi0HivYwTPdDr60cAAyUyQLFaZkq/sxZZLwkd9TJx09Lq9xnmRvY2LZ8niBdl8XpgO2nCmVnoHJQVWUrRG7TBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDXx4cRyLH/fizFtFbDoiMzgCBF59zBH/qyt+saFxXG+TzjKxBHI49d/jGEx3DLbhf3Ng==] +infra::profile::galera_cluster::status_password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAUnhs4oqdEAgyQ+EGhK7gLioajacceFK7GhP/dmYdQ/YVaGAgm6CQ1B8Q9+sAarrjPbsqG1VAoDBTzcu7saSFs/7+qmcavn7n2SyFGVZln63v81SaNm7mao9zCCmUeEstxeN96MpkGVCs2WUz7cRDIa5woGFuJ4XsgQcpzW4XPEdCvNY3jFMlWUZDsmMxN7ikuPIJCYVaK7qWZFj2LLEyKmHuNRvi0Qymn93kFStYwxbIMMVZp3CR6lWRmPRf7aWbUeZn1ImkwNhiRWh2ND0o3w618/KgZghfcPqqgZCxNLQWrqPvDIchjozoq4X276fy7MqkUAmGWD1Sm0lzmRMBvDBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBCk7fUfT2CE0J6kMvQvCYM4gCBTUUsNSqlDkS4iBxeJK2xPkl2xdkXz8zEC/6HzdWuqXA==] + +mysql::server::backup::backuppassword: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAicTfq6ywtRQqkwQ5wgqoFxtG3s4ubcbK4F9uWpgXKbVpfNRlLxtmYatfxCkh3TOaC07MLOUrNLM1LVdnWwbyNIF0xgY1kdquU4QWXtIF6i2fIFH6qpPHAMh5X8Mfbkkc27E9963WojzDxoWBWT/joaepcx4Me5cCD8ubj8D7sL43SUwGHbhB+AMyGsi8g/sF9g4iGbUA6gkTPchLWZGvLjZdZlXL980GwNE+AHavheaewanIrs0x+BjAZIB0bk9ZUc6NRxUuMefLmwZhsNjydDVcMNdQ6D06FIgRKMCwKo8AfXdpF1c1rLmES7CAJ/wT4t478i1jg7yK3uLxdi+X7zBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBC9rr36T/rN42x4ShgGHETmgCBwtEPnG6ak/2kA7HwPrRY6NEQc03RxQ54qoIZKSRwZsA==] + +infra::profile::mysql_server::databases: + mobile_apps_backend: + user: mobile_apps + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAUZCx/fePcj1jELbFchK5nWhgG9tfTfc76EUhkDyKY9xFQUSJ0AHkYveRH+pHU8z3nkGA6HnHbeMiBw6L4z535AIEQsatxXn5UAqbqgS4hU0LlMUX74HY/PLBkhzOiniVHHsUioy0hPU6+4yqF7jMZsFkFp6U3G7szc33kTZQB42OP+VlulcptruhFca0cZKM6ZiWGaKAUaKRujYIa6T4xEQBZ0ZUfbvDpauFCO8jlpkYUPVQEQA3sxhiC3sEQ9u0moHUHJsTRwDUX6R62x27ZSK7iKdoVMP/hVTPFgVy3KvZuTPuAZbl/lzJxsOxIuIQjsmocE8BisA4bhpSlv6VpzBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDb/dcFuQTqyjYtHozvk5GSgCA7XEtOieto+X7cq4kZAf0creYXR3Y1P4fG/xNlH2J/wQ==] + host: '192.168.66.0/255.255.255.0' + mobile_cdm_backend: + user: mobile_cdm + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAQujOC4G0UB4VWlqJGgG+dabMtNLtv3qXcOUIRifBTMollvB0PmEmsiF9GMDkyGtvcSFvH7H16+bltOTDQOP/AwbDkLFoptQ+oGOxB1UGFqdGQvHXKGkrOWQAt1y8GKMefj7G0RafERbVRIPvmaK0hzP6aaqqFfUFl+HxM125mVQjAUnBDsWuBYfNWTACyIqBM1FyigOqbKg6gCpVtX1w3pbngZEYZewFe4T5asCgE94liorZTVXiuYnopTaBeharRg4fP4i6xD8MpxKebYy2HFcA83PaupDlAUXu3D1JxhJ+e6LFcW69yHDf6xBPxStnk3lR9mP55hlV7Slg7HL3eTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBgNi+uh6YTA9Q7Tuo1mDbOgCA4u1M+COKi+0NCMSx3gKBSM0CI07DWWzG6H3h+7VQ2QQ==] + host: '192.168.66.0/255.255.255.0' + entgelte: + user: entgelte + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAeP+eyQOwJC0jZbj1+68rbyDLncugWXVQT2EAy5zH31sc4ebcbgQFhx1nnM9+UkoHnA6tj3l1IJsUeZx8s2Dh5QyHaD261AZpDgJnGVu/VjZ9EmC24aCweSWBpHAJiKCyzLgUHpq/1Hm7FU9P/V+SCrmnrFLn8Lgu3iYGZwtgRS6oL6CMjXpGUrJietjRnlgLsLNwMmZdWwKEyZQ4UUCVgR5pyDeHYj5Nxa+TkGicdCGa22xMfO335shK4DZiGl1pq/T9KFpiddjELkFYt8bBDE1zinvwYkj1J9r1HCKQM6lmX/IP9t76p+ErqPQvUkwzmep6YySQLC/yD6k2IOwMNTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDXd2fINrxw8yLW3Rg7p8x8gCDJRVXFM/sCfjffsn3W54gHz4GMwO+GTaynt8dJwLH+WQ==] + host: '192.168.66.0/255.255.255.0' + flugplan_alt: + user: flugplan_alt + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAc810/TEt7ZV1sp/cPSG0Ujwwxd/Hs27/r3CcybZMKXUyTKxrFXZ52tFAJRYzoVzkJlJ805LUAkAVdyS1oAAbrLHVkqSmHdVXhOlW3k3K/DBzk6dwvx/66YYrDq/RiI0dYup/ymQiiNyrUzsuFN4FKdXlVesM22OG7i8AXGgNDO2GS4icDQSsNBdtSmsg6iKbfKuMa961af/hhZgHBPXlUAxJob2ofwL4IJeGcP9mcig58FKs26EJrBaJkhyyYkZWWBE9ZslMILBGnpAptQg4WPphzCsf0E5H71Sg2Wd/qpvt0Vlbs6IIAsfEbO8awC8Id2+gEMXXIf8gMhz+LGtKMjBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDlvMZi2s5gtKvXBIEcLYUwgCA0b/ENpeqm79Gb0Qg2XsZ7KWSjG5AVQyJkU/buEwik+g==] + host: '192.168.66.0/255.255.255.0' + website: + user: website + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAE0bqu3jJivdYTnZaDf/MTx8njoiX2gFw1MHVhgPVZB9ZtFO6yJ95QcWXGq1SkSxfJ8ucaA7rpxs5cmpjckrn/G4TSb0oEbFOK08C9WCpjWthqbuBSLf/CGk5q+tF8pQPDBx5pt8HMXUmjHvLGQwHowYSy2/snPpcvXbBXJaZoXzYVFeWzmzBStDGWYQ04H9iBLxafGlJYMAKW2Emo/oNlS9I0fxT+C8blAHp5Ypw2X+xL3kPMuKkZhisCBGX/PVaHr5RTVcYq42H5avwC8YYcDJPcOS1q3uWo68zSfxdoH6lz5ysCzdXFMZwI8ZwGSZY9qcnywk7+peB/jGIvi+qAjBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBC/VkMEHQajWH+RGYSctE2KgCC40mNT/biomgZztlQpEtzbnfb2m0gksRYGJcTuFDVk6A==] + host: '192.168.66.0/255.255.255.0' + # Should be the darksite DB + api: + user: api + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAdrvmrh51Y6RvUQXRnRcWTGF/tq+sQXJiDcR+AzBwqlXfyw8KuRO8VnRHO+BizxlPZUaGgQ17LtdelEeFu2ElT3BVsDhZh8nKuwxtfyaf9W/SkiGIDaKYl5CLYQ2qzuGJXwiN2jyvGSYnD/yIwTGO/BPMq7WQU+YNlMWYABRoGAOVa68jRGHo0uvA7z0kPL3M45l3R/ccpjPMRgeo3q0k/Mey5vsHJPuluSEXmOH9sRycjna91mSr+RywiCzYGuygfldpWovJbeqhPQTQQ6P1jCo8hyF8gvFYiWQqDw7/acOvZxBKzaOqfUeBPZ6n57gITkp3NoM66hatNg/Xs18Y1DBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDLJhbfaPIR3a9FrY//3CzygCBzNbugIUDByCHBFLup/AHDUrezVikK5ACz+ofJWKcU5w==] + host: '192.168.66.0/255.255.255.0' + poi: + user: poi + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAMBqoSFKIJMPBsH+VH5SjXEjLt7S8if1eb2Mv4PRSbTFPZTZHvCe/qrWly8mu4VmCw6tBGyaIOmKCjrjUV6EV4QZTemWCM4LwD6VwaxA7YMnw/rHb5/kgKuZMNcXnKNE59b0fM5l3Z0ohj+OjDJjrBY3iGn7yu5D2vWLM3tYVxRA5J3Yeuu5yBby/8IEcY/VADoktH4cOATkSKJa3jzTVqIGn7SL0IDQIHHXxj5Zg2WAb4w78+Q2bNrTKWOWaszOHyi+bN7gAvSOjlwe3eOTLvotZeXwRt8U2kqAhrfR5f0Knf66ioWyfXbzqRH1qm6Iw7hMK/AvgHFzaIzdsW4Z/9zBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBA75+ZhkUW61vCRnlq716mdgCDPIhT1XN+QWsemKGGxh2kj48hIuasWd8u9BnWETt7ANw==] + host: '192.168.66.0/255.255.255.0' + psm_apps: + user: psm_apps + 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' diff --git a/customer/fbb-db/tst-db03-fbb.pixelpark.net.yaml b/customer/fbb-db/tst-db03-fbb.pixelpark.net.yaml index d4095fe0..ad1caa90 100644 --- a/customer/fbb-db/tst-db03-fbb.pixelpark.net.yaml +++ b/customer/fbb-db/tst-db03-fbb.pixelpark.net.yaml @@ -2,3 +2,71 @@ mysql::server::backup::time: - '12' - '5' + +### MYSQL-Konfiguration - Temporaer, bis der Kram wieder nach test.yaml kann +### muss gemacht werden, weil aktuell 6 Kisten in 'test' sind, aber nur auf 3 MySQL ausgerollt werden soll + +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' + # temporaer FBBUBPP-33 + sql-mode: "NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER" + +mysql::server::backup::backupdir: /var/backup/mysql +mysql::server::backup::backuprotate: '1' + +infra::profile::galera_cluster::galera_servers: + - 192.168.66.31 + - 192.168.66.32 + - 192.168.66.33 + +infra::profile::galera_cluster::galera_master: tst-db01-fbb.pixelpark.net +infra::profile::galera_cluster::root_password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEArSuOn0m5W0X2lSiWybmcBhOlFLyJ1lmZnhq07PQGuX0isng1F+z5dDLmFjKZeI/PuKyn79vlA6P1Cg+NFNe3ewXwL1n+ASiBZ926IiG21FeivEpA3WJhboysXBnvc+qytf3swwdd0tvODxRCaH4M2cyn/BaLtApz6UrIlnMo1MwU2IqiGwt4Q/TRuB1/EYp1IjRpk2SWGYJ82/Zl64CdgKWswz+iXgZkhmpPSJiJ4UuExU8jr9xGyEPHYLkeRPvDAXgi0HivYwTPdDr60cAAyUyQLFaZkq/sxZZLwkd9TJx09Lq9xnmRvY2LZ8niBdl8XpgO2nCmVnoHJQVWUrRG7TBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDXx4cRyLH/fizFtFbDoiMzgCBF59zBH/qyt+saFxXG+TzjKxBHI49d/jGEx3DLbhf3Ng==] +infra::profile::galera_cluster::status_password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAUnhs4oqdEAgyQ+EGhK7gLioajacceFK7GhP/dmYdQ/YVaGAgm6CQ1B8Q9+sAarrjPbsqG1VAoDBTzcu7saSFs/7+qmcavn7n2SyFGVZln63v81SaNm7mao9zCCmUeEstxeN96MpkGVCs2WUz7cRDIa5woGFuJ4XsgQcpzW4XPEdCvNY3jFMlWUZDsmMxN7ikuPIJCYVaK7qWZFj2LLEyKmHuNRvi0Qymn93kFStYwxbIMMVZp3CR6lWRmPRf7aWbUeZn1ImkwNhiRWh2ND0o3w618/KgZghfcPqqgZCxNLQWrqPvDIchjozoq4X276fy7MqkUAmGWD1Sm0lzmRMBvDBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBCk7fUfT2CE0J6kMvQvCYM4gCBTUUsNSqlDkS4iBxeJK2xPkl2xdkXz8zEC/6HzdWuqXA==] + +mysql::server::backup::backuppassword: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAicTfq6ywtRQqkwQ5wgqoFxtG3s4ubcbK4F9uWpgXKbVpfNRlLxtmYatfxCkh3TOaC07MLOUrNLM1LVdnWwbyNIF0xgY1kdquU4QWXtIF6i2fIFH6qpPHAMh5X8Mfbkkc27E9963WojzDxoWBWT/joaepcx4Me5cCD8ubj8D7sL43SUwGHbhB+AMyGsi8g/sF9g4iGbUA6gkTPchLWZGvLjZdZlXL980GwNE+AHavheaewanIrs0x+BjAZIB0bk9ZUc6NRxUuMefLmwZhsNjydDVcMNdQ6D06FIgRKMCwKo8AfXdpF1c1rLmES7CAJ/wT4t478i1jg7yK3uLxdi+X7zBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBC9rr36T/rN42x4ShgGHETmgCBwtEPnG6ak/2kA7HwPrRY6NEQc03RxQ54qoIZKSRwZsA==] + +infra::profile::mysql_server::databases: + mobile_apps_backend: + user: mobile_apps + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAUZCx/fePcj1jELbFchK5nWhgG9tfTfc76EUhkDyKY9xFQUSJ0AHkYveRH+pHU8z3nkGA6HnHbeMiBw6L4z535AIEQsatxXn5UAqbqgS4hU0LlMUX74HY/PLBkhzOiniVHHsUioy0hPU6+4yqF7jMZsFkFp6U3G7szc33kTZQB42OP+VlulcptruhFca0cZKM6ZiWGaKAUaKRujYIa6T4xEQBZ0ZUfbvDpauFCO8jlpkYUPVQEQA3sxhiC3sEQ9u0moHUHJsTRwDUX6R62x27ZSK7iKdoVMP/hVTPFgVy3KvZuTPuAZbl/lzJxsOxIuIQjsmocE8BisA4bhpSlv6VpzBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDb/dcFuQTqyjYtHozvk5GSgCA7XEtOieto+X7cq4kZAf0creYXR3Y1P4fG/xNlH2J/wQ==] + host: '192.168.66.0/255.255.255.0' + mobile_cdm_backend: + user: mobile_cdm + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAQujOC4G0UB4VWlqJGgG+dabMtNLtv3qXcOUIRifBTMollvB0PmEmsiF9GMDkyGtvcSFvH7H16+bltOTDQOP/AwbDkLFoptQ+oGOxB1UGFqdGQvHXKGkrOWQAt1y8GKMefj7G0RafERbVRIPvmaK0hzP6aaqqFfUFl+HxM125mVQjAUnBDsWuBYfNWTACyIqBM1FyigOqbKg6gCpVtX1w3pbngZEYZewFe4T5asCgE94liorZTVXiuYnopTaBeharRg4fP4i6xD8MpxKebYy2HFcA83PaupDlAUXu3D1JxhJ+e6LFcW69yHDf6xBPxStnk3lR9mP55hlV7Slg7HL3eTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBgNi+uh6YTA9Q7Tuo1mDbOgCA4u1M+COKi+0NCMSx3gKBSM0CI07DWWzG6H3h+7VQ2QQ==] + host: '192.168.66.0/255.255.255.0' + entgelte: + user: entgelte + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAeP+eyQOwJC0jZbj1+68rbyDLncugWXVQT2EAy5zH31sc4ebcbgQFhx1nnM9+UkoHnA6tj3l1IJsUeZx8s2Dh5QyHaD261AZpDgJnGVu/VjZ9EmC24aCweSWBpHAJiKCyzLgUHpq/1Hm7FU9P/V+SCrmnrFLn8Lgu3iYGZwtgRS6oL6CMjXpGUrJietjRnlgLsLNwMmZdWwKEyZQ4UUCVgR5pyDeHYj5Nxa+TkGicdCGa22xMfO335shK4DZiGl1pq/T9KFpiddjELkFYt8bBDE1zinvwYkj1J9r1HCKQM6lmX/IP9t76p+ErqPQvUkwzmep6YySQLC/yD6k2IOwMNTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDXd2fINrxw8yLW3Rg7p8x8gCDJRVXFM/sCfjffsn3W54gHz4GMwO+GTaynt8dJwLH+WQ==] + host: '192.168.66.0/255.255.255.0' + flugplan_alt: + user: flugplan_alt + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAc810/TEt7ZV1sp/cPSG0Ujwwxd/Hs27/r3CcybZMKXUyTKxrFXZ52tFAJRYzoVzkJlJ805LUAkAVdyS1oAAbrLHVkqSmHdVXhOlW3k3K/DBzk6dwvx/66YYrDq/RiI0dYup/ymQiiNyrUzsuFN4FKdXlVesM22OG7i8AXGgNDO2GS4icDQSsNBdtSmsg6iKbfKuMa961af/hhZgHBPXlUAxJob2ofwL4IJeGcP9mcig58FKs26EJrBaJkhyyYkZWWBE9ZslMILBGnpAptQg4WPphzCsf0E5H71Sg2Wd/qpvt0Vlbs6IIAsfEbO8awC8Id2+gEMXXIf8gMhz+LGtKMjBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDlvMZi2s5gtKvXBIEcLYUwgCA0b/ENpeqm79Gb0Qg2XsZ7KWSjG5AVQyJkU/buEwik+g==] + host: '192.168.66.0/255.255.255.0' + website: + user: website + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAE0bqu3jJivdYTnZaDf/MTx8njoiX2gFw1MHVhgPVZB9ZtFO6yJ95QcWXGq1SkSxfJ8ucaA7rpxs5cmpjckrn/G4TSb0oEbFOK08C9WCpjWthqbuBSLf/CGk5q+tF8pQPDBx5pt8HMXUmjHvLGQwHowYSy2/snPpcvXbBXJaZoXzYVFeWzmzBStDGWYQ04H9iBLxafGlJYMAKW2Emo/oNlS9I0fxT+C8blAHp5Ypw2X+xL3kPMuKkZhisCBGX/PVaHr5RTVcYq42H5avwC8YYcDJPcOS1q3uWo68zSfxdoH6lz5ysCzdXFMZwI8ZwGSZY9qcnywk7+peB/jGIvi+qAjBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBC/VkMEHQajWH+RGYSctE2KgCC40mNT/biomgZztlQpEtzbnfb2m0gksRYGJcTuFDVk6A==] + host: '192.168.66.0/255.255.255.0' + # Should be the darksite DB + api: + user: api + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAdrvmrh51Y6RvUQXRnRcWTGF/tq+sQXJiDcR+AzBwqlXfyw8KuRO8VnRHO+BizxlPZUaGgQ17LtdelEeFu2ElT3BVsDhZh8nKuwxtfyaf9W/SkiGIDaKYl5CLYQ2qzuGJXwiN2jyvGSYnD/yIwTGO/BPMq7WQU+YNlMWYABRoGAOVa68jRGHo0uvA7z0kPL3M45l3R/ccpjPMRgeo3q0k/Mey5vsHJPuluSEXmOH9sRycjna91mSr+RywiCzYGuygfldpWovJbeqhPQTQQ6P1jCo8hyF8gvFYiWQqDw7/acOvZxBKzaOqfUeBPZ6n57gITkp3NoM66hatNg/Xs18Y1DBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDLJhbfaPIR3a9FrY//3CzygCBzNbugIUDByCHBFLup/AHDUrezVikK5ACz+ofJWKcU5w==] + host: '192.168.66.0/255.255.255.0' + poi: + user: poi + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAMBqoSFKIJMPBsH+VH5SjXEjLt7S8if1eb2Mv4PRSbTFPZTZHvCe/qrWly8mu4VmCw6tBGyaIOmKCjrjUV6EV4QZTemWCM4LwD6VwaxA7YMnw/rHb5/kgKuZMNcXnKNE59b0fM5l3Z0ohj+OjDJjrBY3iGn7yu5D2vWLM3tYVxRA5J3Yeuu5yBby/8IEcY/VADoktH4cOATkSKJa3jzTVqIGn7SL0IDQIHHXxj5Zg2WAb4w78+Q2bNrTKWOWaszOHyi+bN7gAvSOjlwe3eOTLvotZeXwRt8U2kqAhrfR5f0Knf66ioWyfXbzqRH1qm6Iw7hMK/AvgHFzaIzdsW4Z/9zBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBA75+ZhkUW61vCRnlq716mdgCDPIhT1XN+QWsemKGGxh2kj48hIuasWd8u9BnWETt7ANw==] + host: '192.168.66.0/255.255.255.0' + psm_apps: + user: psm_apps + 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' -- 2.39.5