Wednesday, March 25, 2015

Follow up on MySQL 5.6 GTIDs: Evaluation and Online Migration

One year ago, I blogged about Evaluation and Online Migration of MySQL 5.6 GTIDs.  At that time, we setup the following test environment where:
  • A is a production master with GTIDs disabled,
  • D to Z are standard slaves with GTIDs disabled,
  • B is an intermediate master running my recompiled version of MySQL implementing the ANONYMOUS_IN-GTID_OUT mode (see the details my previous post),
  • C is a slave with GTID enabled.

    +---+
    | A |
    +---+
      |
      +------+--- ... ---+
      |      |           |
    +---+  +---+       +---+
    | B |  | D |       | Z |
    +---+  +---+       +---+
      |
    +---+
    | C |
    +---+

Today, doing some cleanup, we dig out the 2 servers running this experiment (B and C):
  • they have an uptime of more than 200 days,
  • their gtid_executed is at more than 1.500.000.000,
  • and they are still replicating.
I find this cool !

No comments:

Post a Comment