From 21cd800419a07cf6f7738afaf36cc8d1880e0b0d Mon Sep 17 00:00:00 2001 From: "sascha.strassheim" Date: Tue, 8 May 2018 11:26:10 +0200 Subject: [PATCH] piwik --- customer/pixelpark-piwik/production.yaml | 38 ++++++++++++++++++++++++ 1 file changed, 38 insertions(+) create mode 100644 customer/pixelpark-piwik/production.yaml diff --git a/customer/pixelpark-piwik/production.yaml b/customer/pixelpark-piwik/production.yaml new file mode 100644 index 00000000..fc483271 --- /dev/null +++ b/customer/pixelpark-piwik/production.yaml @@ -0,0 +1,38 @@ +--- +infra::additional_classes: + - infra::profile::galera_cluster + - infra::profile::mysql_server + +galera::repo::yum_mariadb_baseurl: "http://repo.pixelpark.com/Linux/yum/mariadb/10.3/centos/%{operatingsystemmajrelease}/%{architecture}/" +galera::vendor_version: '10.3' + +infra::profile::galera_cluster::override_options: + mysqld: + innodb_file_per_table: OFF + wait_timeout: '600' + interactive_timeout: '600' + max_allowed_packet: '128M' + sql-mode: "NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER" + max_connections: 600 + wsrep_retry_autocommit: 4 + + mysql::server::backup::backupdir: /var/lib/backup/mysql + mysql::server::backup::backuprotate: '1' + + +infra::profile::galera_cluster::galera_master: webstats05.pixelpark.net +infra::profile::galera_cluster::galera_servers: + - 93.188.110.195 + - 93.188.110.196 + - 93.188.110.197 + +infra::profile::galera_cluster::root_password: ENC[PKCS7,MIIBeQYJKoZIhvcNAQcDoIIBajCCAWYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAWlNPTdRJbEY9KA1l/7CGilJwxyuivYvt4kfrUV9PQaBNR4iOu315c5647ZLAPWMj3EUqzS3CF/S5X15rYOxM/3PK0J+OVUuY2NvhmGRlN+aKx3nQNfaq4EcLtJ30q9ANcKvkBJF09awwshcGH4EQO/Xe6Pxy9YNKVhe3CT70G9ZPYouBE2p0PR+W9iOWGrMK0pWbtK7wBU2vzX/87rG3POkABXYc/yJ2oWRIkHv6B6/Gj7Nwbi/tgTZyb+CkZvd9+05pZjn75Kl+GpGp36yltKklH91n5Yi0GZwrQO4Mq3jaFe/n6pnZtQ3+haDrynXypgLnCQqJSP5SZpHJiPe7czA8BgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBkff6X5ZmdT+y5l/f7zO2ggBCpo1K4qs/wmalLx75mm+xC] +infra::profile::galera_cluster::status_password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAl/59ISmIt+1ke3jtWJQiCxUAizGZwaW/KDWTabTJy2fe+0H/dcsCGWUrvV7LZg+NG73CS/oIu3CO3ynsStUW1nPk9M+8MfHoNkR3cBJF/19JpbhVExI6Lkkx+cxoHNp1UNMW/BCW3ZyUKrXLUQQ3xH5oSvSSdanFc/uc48Zyr0PmoJTNePxIjFUlwjNEr/4JGYnRL61Qq3/z3aCNPa0h8zewvq754ooiQ67y5bPZEO6bOrRNBaTfrGqaCyF9mxF2J/hD7zNtAGlO/D6DOuZ1meJwG13LUXK994nrAH2L72R5yu5gg3KjSzyw/gQRRdhoCF2VI5fJJhq8wqev5wTXajBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDYHgKzrCdO1JbKomw/B7WkgCCbXzoFXykKU9SSWNOuQXe0y2tUXnAyI4BoFsOs6rBKKA==] + +mysql::server::backup::backuppassword: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAr58l09Nu/HnAESV131Ja5FPbdr2QrCwUVOHnLOEuyvija692uVy1zWjHHkAIsXFWdh0Kt4gpS5ADilL+lDzeN/yxXmszTS8MiVlUpy0OzTQH8c4BCM63ad3RiFMo7jKwkZHlXeS/CEhIXtuDEfIOu537+AFIbpHsFTkgpzl9mwa5lqFzG0kvofXd/FaFddkvpf8vuA9ndDC5EpFJmSjwanRKozgH8pFCOEQa6WJ+8vnKAT2c8aLylGo/ma4lk7NiXXG6QpMmNVOddK7JoiJkCgD1toAyFZHQQJS1qJRJ1WQ+XQGvlw7xuIoIlpWfpFoNdAzAZNPc1qTTw49YuvY3sTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBAAiHmucFcAKztwvEmaYXkDgCBXLMmnx8qz9CxLyVYSzVHtyfZksSlocNyIXoE54QtKLA==] + +infra::profile::mysql_server::databases: + webstats: + user: webstats + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAYJY7J7ketIlU1b6iIzhtMj85z4zIbWnnQedKeRW70XfifBT+DUVoIPXR5E+grJRHitcAUchnPw8FqwRhtgIjoYz8FkDQO4Om+oIFs6cLBGvbip0DU19yp92HkioK7zbXwO30MW6N86sIE3pA51aaFHFFrHGyCu7mtYkpoycktZCvtCtK0wzMzgekncHcW9rf3IZb6VX9n9rlXtLeDa5P6LD/K3/Xk+9zOdltxXkwMIvUT6blGavB9ZzXnQ9dicqEcL46B0pMa/p4XZFIq37dF/snvB1P5mHPhfAUigVrEuVeMjOUbYWYWh5YxmWtGCuxVFYDKpfVuxWRTzBIs5TC+jBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBk/k38J+RaNrzHRXK2P01bgCB1XTPbEQQDn/e4J3WpfKChuOjD3chI3fdAFMQVL2LIoA==] +# host: '192.168.65.0/255.255.255.0' -- 2.39.5