1

We have found concerns with GTID on MariaDB related to our multi-tenant MyISAM databases. It sounds like there are problems with temporary table replication so we'd like to revert away from GTID. How do I do this?

1

On each slave, run this. It'll do it without downtime and very little replication delay.

stop slave; change master to master_use_gtid=no; start slave;

You can watch show slave status \G, specifically "Using_Gtid, "Master_Log_File" and "Read_Master_Log_Pos". Assure the first is "No" and the other two are climbing after this command.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.