From 488c875393fa01fb3d9ff37750fcd851ee3ef94d Mon Sep 17 00:00:00 2001 From: "Suren A. Chilingaryan" Date: Mon, 29 Jul 2024 22:31:21 +0200 Subject: Ignore MySQL error 1062 (dublicate entries in unique column) as it breaks replication currently --- setup/projects/adei/vars/mysql.yml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'setup/projects/adei/vars/mysql.yml') diff --git a/setup/projects/adei/vars/mysql.yml b/setup/projects/adei/vars/mysql.yml index bb0b7f2..9b17fd7 100644 --- a/setup/projects/adei/vars/mysql.yml +++ b/setup/projects/adei/vars/mysql.yml @@ -94,7 +94,7 @@ mysql: - { name: "MYSQL_INNODB_FLUSH_LOG_TYPE", value: "2" } - { name: "MYSQL_INNODB_FLUSH_LOG_TIMEOUT", value: "300" } - { 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_SLAVE_SKIP_ERRORS", value: "1007,1008,1050,1051,1054,1060,1061,1062,1068,1094,1146,1304,1359,1476,1537" } - { name: "MYSQL_BINLOG_FORMAT", value: "ROW" } mappings: - { name: "adei_slave", mount: "/var/lib/mysql/data" } -- cgit v1.2.3