From 5b7c688ebef75c6085f24b24076687ad225ea00e Mon Sep 17 00:00:00 2001 From: "sascha.strassheim" Date: Mon, 7 May 2018 14:24:03 +0200 Subject: [PATCH] deactivate innodb_file_per_table on webstats05-7 --- .../webstats05.pixelpark.net.yaml | 2 +- .../webstats06.pixelpark.net.yaml | 20 +++++++++---------- .../webstats07.pixelpark.net.yaml | 20 +++++++++---------- 3 files changed, 21 insertions(+), 21 deletions(-) diff --git a/customer/pixelpark-piwik/webstats05.pixelpark.net.yaml b/customer/pixelpark-piwik/webstats05.pixelpark.net.yaml index 6e0d423a..78f6aa90 100644 --- a/customer/pixelpark-piwik/webstats05.pixelpark.net.yaml +++ b/customer/pixelpark-piwik/webstats05.pixelpark.net.yaml @@ -86,7 +86,7 @@ infra::profile::apache::pp_vhosts: ssl_key: '/etc/pki/tls/private/wildcard.pixelpark.net-key.pem' ssl_chain: '/etc/pki/tls/certs/wildcard.pixelpark.net-cert.pem' docroot_owner: apache - docroot_group: pixel + docroot_group: apache docroot_mode: '2775' directories: - directory_root: diff --git a/customer/pixelpark-piwik/webstats06.pixelpark.net.yaml b/customer/pixelpark-piwik/webstats06.pixelpark.net.yaml index a01d5642..50e90e68 100644 --- a/customer/pixelpark-piwik/webstats06.pixelpark.net.yaml +++ b/customer/pixelpark-piwik/webstats06.pixelpark.net.yaml @@ -22,15 +22,15 @@ infra::profile::galera_cluster::galera_servers: infra::profile::galera_cluster::root_password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAJLJ0bGyZieBRhKYzBjdXz5UA5awdSstt/RL2BchQrkxeCurNxyh6VFZcBoVpQGcLqx9i3p3PQPBJnZ1SWZq/JCN0eBvD3rAwUvDzmmkpujnbjPvhrH9qAvYD3Zdx2FJNOdVxOIrzGhRES8tQ00lmsEkRiYI2vWYdJdv1PaSQzdapvgQdkZdRsCDoV/3X76hlv4/y1uXz8yIeKdpX1MRCPpJaFlhdSfCO8ho7X3oNTJuphTewSs36t08A6sMR7655xnkIgk0psedPjRnUlpzv4W17HlE+oT/6+oiNt5GjdI5cwJRc3tVEElv8Hx1txSLTIhxQmleQU9yUISEIp1O+2zBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBNZ+aGF2Shl8vePVg4eiXhgCCFilZO9ZswBiXuJdhTS/KRkyOLfCkD2D+YMXhyC3xlFQ==] 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==] -infra::profile::galera_cluster::override_options: - mysqld: - innodb_file_per_table: ON - 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 +#infra::profile::galera_cluster::override_options: +# mysqld: +# innodb_file_per_table: ON +# 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 @@ -86,7 +86,7 @@ infra::profile::apache::pp_vhosts: ssl_key: '/etc/pki/tls/private/wildcard.pixelpark.net-key.pem' ssl_chain: '/etc/pki/tls/certs/wildcard.pixelpark.net-cert.pem' docroot_owner: apache - docroot_group: pixel + docroot_group: apache docroot_mode: '2775' directories: - directory_root: diff --git a/customer/pixelpark-piwik/webstats07.pixelpark.net.yaml b/customer/pixelpark-piwik/webstats07.pixelpark.net.yaml index b203e2dc..e1bff013 100644 --- a/customer/pixelpark-piwik/webstats07.pixelpark.net.yaml +++ b/customer/pixelpark-piwik/webstats07.pixelpark.net.yaml @@ -22,15 +22,15 @@ infra::profile::galera_cluster::galera_servers: infra::profile::galera_cluster::root_password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAJLJ0bGyZieBRhKYzBjdXz5UA5awdSstt/RL2BchQrkxeCurNxyh6VFZcBoVpQGcLqx9i3p3PQPBJnZ1SWZq/JCN0eBvD3rAwUvDzmmkpujnbjPvhrH9qAvYD3Zdx2FJNOdVxOIrzGhRES8tQ00lmsEkRiYI2vWYdJdv1PaSQzdapvgQdkZdRsCDoV/3X76hlv4/y1uXz8yIeKdpX1MRCPpJaFlhdSfCO8ho7X3oNTJuphTewSs36t08A6sMR7655xnkIgk0psedPjRnUlpzv4W17HlE+oT/6+oiNt5GjdI5cwJRc3tVEElv8Hx1txSLTIhxQmleQU9yUISEIp1O+2zBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBNZ+aGF2Shl8vePVg4eiXhgCCFilZO9ZswBiXuJdhTS/KRkyOLfCkD2D+YMXhyC3xlFQ==] 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==] -infra::profile::galera_cluster::override_options: - mysqld: - innodb_file_per_table: ON - 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 +#infra::profile::galera_cluster::override_options: +# mysqld: +# innodb_file_per_table: ON +# 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 @@ -86,7 +86,7 @@ infra::profile::apache::pp_vhosts: ssl_key: '/etc/pki/tls/private/wildcard.pixelpark.net-key.pem' ssl_chain: '/etc/pki/tls/certs/wildcard.pixelpark.net-cert.pem' docroot_owner: apache - docroot_group: pixel + docroot_group: apache docroot_mode: '2775' directories: - directory_root: -- 2.39.5