From 2f1d952ef3a3e5917cc46a7983e704e39e887603 Mon Sep 17 00:00:00 2001 From: "sascha.strassheim" Date: Wed, 18 Apr 2018 14:49:26 +0200 Subject: [PATCH] webstats galera cluster --- .../pixelpark-piwik/webstats05.pixelpark.net.yaml | 13 +++++++++++++ .../pixelpark-piwik/webstats06.pixelpark.net.yaml | 12 ++++++++++++ .../pixelpark-piwik/webstats07.pixelpark.net.yaml | 12 ++++++++++++ 3 files changed, 37 insertions(+) diff --git a/customer/pixelpark-piwik/webstats05.pixelpark.net.yaml b/customer/pixelpark-piwik/webstats05.pixelpark.net.yaml index 1dc510a5..4d0214ff 100644 --- a/customer/pixelpark-piwik/webstats05.pixelpark.net.yaml +++ b/customer/pixelpark-piwik/webstats05.pixelpark.net.yaml @@ -27,6 +27,19 @@ infra::profile::mysql_server::databases: mysql::server::backup::backupdir: /var/lib/backup/mysql +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" + # temporaerer Hotfix + max_connections: 600 + wsrep_retry_autocommit: 4 + +infra::profile::galera_cluster::galera_master: webstats05.pixelpark.net infra::profile::galera_cluster::galera_servers: - 93.188.110.195 - 93.188.110.196 diff --git a/customer/pixelpark-piwik/webstats06.pixelpark.net.yaml b/customer/pixelpark-piwik/webstats06.pixelpark.net.yaml index 820e84f0..ec5accb0 100644 --- a/customer/pixelpark-piwik/webstats06.pixelpark.net.yaml +++ b/customer/pixelpark-piwik/webstats06.pixelpark.net.yaml @@ -27,6 +27,18 @@ infra::profile::mysql_server::databases: mysql::server::backup::backupdir: /var/lib/backup/mysql +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" + # temporaerer Hotfix + max_connections: 600 + wsrep_retry_autocommit: 4 + infra::profile::galera_cluster::galera_master: webstats05.pixelpark.net infra::profile::galera_cluster::galera_servers: - 93.188.110.195 diff --git a/customer/pixelpark-piwik/webstats07.pixelpark.net.yaml b/customer/pixelpark-piwik/webstats07.pixelpark.net.yaml index 13b86551..2093cbcf 100644 --- a/customer/pixelpark-piwik/webstats07.pixelpark.net.yaml +++ b/customer/pixelpark-piwik/webstats07.pixelpark.net.yaml @@ -27,6 +27,18 @@ infra::profile::mysql_server::databases: mysql::server::backup::backupdir: /var/lib/backup/mysql +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" + # temporaerer Hotfix + max_connections: 600 + wsrep_retry_autocommit: 4 + infra::profile::galera_cluster::galera_master: webstats05.pixelpark.net infra::profile::galera_cluster::galera_servers: - 93.188.110.195 -- 2.39.5