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 |
    -----
      +------+--- ... ---+
      V      V           V
    -----  -----       -----
    | B |  | D |       | Z |
    -----  -----       -----
      |
      V
    -----
    | 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