OpenStack DBaaS (Trove)

  1. Bug #1563541
  2. Comment #2

Comment 2 for bug 1563541

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to trove (master)

Reviewed: https://review.openstack.org/300253
Committed: https://git.openstack.org/cgit/openstack/trove/commit/?id=9b03fec1e174d95b7a6047ba4a15eec3f801cf98
Submitter: Jenkins
Branch: master

commit 9b03fec1e174d95b7a6047ba4a15eec3f801cf98
Author: Doug Shelley <email address hidden>
Date: Thu Mar 31 23:18:38 2016 +0000

    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