diff options
author | Doug Shelley <doug@parelastic.com> | 2016-03-31 23:18:38 +0000 |
---|---|---|
committer | Doug Shelley <doug@parelastic.com> | 2016-04-19 13:07:09 +0000 |
commit | 9b03fec1e174d95b7a6047ba4a15eec3f801cf98 (patch) | |
tree | 4eac0b654e083ad155fc91f0dac59804e885d9d3 /trove/templates | |
parent | 9f877e5ba74ca436d78552add1631b8598946854 (diff) | |
download | trove-9b03fec1e174d95b7a6047ba4a15eec3f801cf98.tar.gz |
Mysql replicas need to set binlog_format
For GTID replication we set the replica source (i.e. master)
to have a binlog_format of MIXED. We aren't setting this on
the replicas so they default to STATEMENT. This causes a problem
with certain "non-deterministic" functions (e.g. RAND()). This
changes replica config templates for Mysql and Percona to use
MIXED mode.
A new scenario test was introduced to validate that the
replicas have this set.
MariaDB doesn't appear to have this issue so it wasn't changed.
Scenario tests for Mysql, Percona and MariaDB were run to
validate this change.
Change-Id: I936cd9bc53a812af19653e9b5b472103fab2b6c1
Closes-bug: 1563541
Diffstat (limited to 'trove/templates')
-rw-r--r-- | trove/templates/mysql/replica.config.template | 1 | ||||
-rw-r--r-- | trove/templates/percona/replica.config.template | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/trove/templates/mysql/replica.config.template b/trove/templates/mysql/replica.config.template index fe8871c0..548fc491 100644 --- a/trove/templates/mysql/replica.config.template +++ b/trove/templates/mysql/replica.config.template @@ -1,5 +1,6 @@ [mysqld] log_bin = /var/lib/mysql/data/mysql-bin.log +binlog_format = MIXED relay_log = /var/lib/mysql/data/mysql-relay-bin.log relay_log_info_repository = TABLE relay_log_recovery = 1 diff --git a/trove/templates/percona/replica.config.template b/trove/templates/percona/replica.config.template index 0326a62e..1d8d197e 100644 --- a/trove/templates/percona/replica.config.template +++ b/trove/templates/percona/replica.config.template @@ -1,5 +1,6 @@ [mysqld] log_bin = /var/lib/mysql/data/mysql-bin.log +binlog_format = MIXED relay_log = /var/lib/mysql/data/mysql-relay-bin.log relay_log_info_repository = TABLE relay_log_recovery = 1 |