I'm stuck with one specificity of Replication on MySQL servers.

I'm currently working with this configuration :

A <--> B ⊦---> C ---> D

I explain.

I've got a replication Master <--> Master between servers A & B. This replication is working for years now and everything is fine with it.

I also managed to build a replication between server C & D which needs to have GTID activated (necessity of external replication with Google Cloud SQL).

But I cannot activate the replication between server A and C because C has GTID activated and A is currently with GTID disabled.

By the way, I've got differences of version between my servers. A & B are MySQL 5.5 and just some tables are replicated C & D are MySQL 5.6 (and perhaps 5.7 if it is possible).

I cannot actually upgrade A & B from 5.5 to 5.6, neither can I halt and activate GTID on A & B.

Is there a way to ignore the GTID configuration for the Master (A) -> Slave (C) but maintain the GTID configuration for Master (C) -> Slave (D) configuration ?

Thanks for your advices.

migrated from stackoverflow.com Nov 27 at 17:09

This question came from our site for professional and enthusiast programmers.

  • I'd keep 5.7 out of your replication chain as 2 major version differences are unsupported. You've got a lot of constraints the most common being the upgrade of A&B to support gtid. Can you describe the constraints there to see if those are resolvable? – danblack Nov 27 at 22:09

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.