summaryrefslogtreecommitdiffstats
path: root/setup/projects
diff options
context:
space:
mode:
Diffstat (limited to 'setup/projects')
-rw-r--r--setup/projects/adei/vars/mysql.yml7
1 files changed, 3 insertions, 4 deletions
diff --git a/setup/projects/adei/vars/mysql.yml b/setup/projects/adei/vars/mysql.yml
index 072d946..dd9aa0e 100644
--- a/setup/projects/adei/vars/mysql.yml
+++ b/setup/projects/adei/vars/mysql.yml
@@ -26,8 +26,8 @@ mysql:
- { name: "MYSQL_MASTER_PASSWORD", value: "secret@adei/service-password" }
- { name: "MYSQL_PMA_PASSWORD", value: "secret@adei/pma-password" }
- { name: "MYSQL_MAX_CONNECTIONS", value: "500" }
- - { name: "MYSQL_INNODB_BUFFER_POOL_SIZE", value: "32G" }
- - { name: "MYSQL_INNODB_BUFFER_POOL_INSTANCES", value: "32" }
+ - { name: "MYSQL_INNODB_BUFFER_POOL_SIZE", value: "16G" }
+ - { name: "MYSQL_INNODB_BUFFER_POOL_INSTANCES", value: "8" }
- { name: "MYSQL_INNODB_LOG_FILE_SIZE", value: "2G" }
- { name: "MYSQL_INNODB_LOG_BUFFER_SIZE", value: "16M" }
- { name: "MYSQL_SYNC_BINLOG", value: "0" }
@@ -36,9 +36,8 @@ mysql:
- { name: "MYSQL_INNODB_FLUSH_LOG_TYPE", value: "2" }
- { name: "MYSQL_INNODB_FLUSH_METHOD", value: "O_DIRECT" }
- { name: "MYSQL_INNODB_FLUSH_LOG_TIMEOUT", value: "300" }
-# - { name: "MYSQL_BINLOG_FORMAT", value: "MIXED" }
- { name: "MYSQL_BINLOG_FORMAT", value: "ROW" }
-# - { name: "MYSQL_BINLOG_FORMAT", value: "STATEMENT" }
+# - { name: "MYSQL_BINLOG_FORMAT", value: "MIXED" }
mappings:
- { name: "adei_master", mount: "/var/lib/mysql/data" }
resources: { request: { cpu: 2000m, mem: 16Gi } }