Not the answer you need?
Register and ask your own question!

Moving from gtid on_permissive to on

ianwinterianwinter EntrantCurrent User Role Beginner

I'm trying to move from 5.6 to 5.7. As part of that I want to have GTID fully on once I get to 5.7.

Right now I've got the following working setup:

master1 (5.6.19, gtid off)
- slave1m1 (5.6.19, gtid off, master = master1)
- newmaster1 (5.7.13 gtid on_permissive, master = master1)
- newslave1m1 (5.7.13 gtid on_permissive, master = newmaster1)

Now I've got more slaves to add which is fine but my question is I know I need on_permissve to get it replicating from a gtid off server but what steps should I follow to get the slaves of the newmaster1 fully gtid = on and then the newmaster1 gtid = on.

A full outage will need to occur at some point so that's OK if needed.

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.