diff options
| author | Suren A. Chilingaryan <csa@suren.me> | 2018-03-22 04:37:46 +0100 |
|---|---|---|
| committer | Suren A. Chilingaryan <csa@suren.me> | 2018-03-22 04:37:46 +0100 |
| commit | 0b0b9954c2d0602b1e9d0a387d2a195a790f8084 (patch) | |
| tree | f0a3a26edd280b8fd84945944bd153f411b31fea /setup/projects/adei/vars/mysql.yml | |
| parent | e2c7b1305ca8495065dcf40fd2092d7c698dd6ea (diff) | |
| download | ands-0b0b9954c2d0602b1e9d0a387d2a195a790f8084.tar.gz ands-0b0b9954c2d0602b1e9d0a387d2a195a790f8084.tar.bz2 ands-0b0b9954c2d0602b1e9d0a387d2a195a790f8084.tar.xz ands-0b0b9954c2d0602b1e9d0a387d2a195a790f8084.zip | |
Various fixes and provide ADEI admin container...
Diffstat (limited to 'setup/projects/adei/vars/mysql.yml')
| -rw-r--r-- | setup/projects/adei/vars/mysql.yml | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/setup/projects/adei/vars/mysql.yml b/setup/projects/adei/vars/mysql.yml index 3349598..cf72c90 100644 --- a/setup/projects/adei/vars/mysql.yml +++ b/setup/projects/adei/vars/mysql.yml @@ -27,6 +27,8 @@ mysql: - { name: "MYSQL_PMA_PASSWORD", value: "secret@adei/pma-password" } - { name: "MYSQL_MAX_CONNECTIONS", value: "500" } - { name: "MYSQL_SYNC_BINLOG", value: "0" } + - { name: "MYSQL_BINLOG_SYNC_DELAY", value: "25000" } + - { name: "MYSQL_BINLOG_NODELAY_COUNT", value: "32" } - { name: "MYSQL_FLUSH_LOG_TYPE", value: "2" } - { name: "MYSQL_FLUSH_LOG_TIMEOUT", value: "300" } - { name: "MYSQL_BINLOG_FORMAT", value: "MIXED" } @@ -75,10 +77,14 @@ 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_LOG_BIN", value: "1" } - { name: "MYSQL_SYNC_BINLOG", value: "0" } + - { name: "MYSQL_LOG_SLAVE_UPDATES", value: "0" } + - { name: "MYSQL_BINLOG_SYNC_DELAY", value: "25000" } + - { name: "MYSQL_BINLOG_NODELAY_COUNT", value: "32" } - { name: "MYSQL_FLUSH_LOG_TYPE", value: "2" } - { name: "MYSQL_FLUSH_LOG_TIMEOUT", value: "300" } - - { name: "MYSQL_SLAVE_WORKERS", value: "8" } + - { name: "MYSQL_SLAVE_WORKERS", value: "16" } - { name: "MYSQL_SLAVE_SKIP_ERRORS", value: "1007,1008,1050,1051,1054,1060,1061,1068,1094,1146,1304,1359,1476,1537" } - { name: "MYSQL_BINLOG_FORMAT", value: "MIXED" } mappings: |