2

I've been a MySQL user/administrator for many years and I've been considering a switch to MariaDB. We have a statement-replicated setup with a MySQL slave and I've been thinking that one way to ease-into a MariaDB environment might be to swap the slave out for MariaDB until we're comfortable, then switch the master to MariaDB.

Is that something that is possible? I suspect it is, since the replication interface is fairly simple, especially for a statement-replicated setup.

Is that something that makes any sense?

UPDATE I happen to be using MySQL 5.5 as the master and MySQL 5.6 as the replicated slave in my current environment, just in case that has any bearing on anything. But I'm curious if different versions might be better or worse for a mixed-vendor setup.

3
  • Older version on Master + newer version of Slave is strongly recommended. MariaDB on slave to a Master running Oracle's MySQL is more likely to work than the opposite.
    – Rick James
    Dec 26, 2017 at 2:25
  • Any solution for mariadb master, mysql slave?
    – hpaknia
    Jul 27, 2019 at 18:11
  • You should ask your question separately to get a better answer. The short answer is that MariaDB has a nice compatibility-matrix of versions where it should be clear. Jul 28, 2019 at 4:53

1 Answer 1

2

Yes, this is possible, and probably makes sense. See e.g. Replicating from MySQL Master to MariaDB Slave. So with MySQL 5.5 as the master, you can use MariaDB 5.5 or later as the slave.

3
  • Yes You can, but you can't use GTID repliction. Because mariadb and mysql have different GTID method
    – HamoonDBA
    Dec 25, 2017 at 15:55
  • MySQL 5.5 doesn't have GTID replication so it's a non-issue :)
    – dbdemon
    Dec 25, 2017 at 16:00
  • FWIW, I ended up running MySQL 5.5 master and MariaDB 10.1 slave for quite a while and all was well. GTID wasn't an issue, since MySQL 5.5 hadn't yet diverged. MySQL 5.5 isn't on the list here, but it is indeed compatible as a master database for MariaDB replication slaves. Jan 8, 2019 at 14:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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