I have several different production databases running MariaBD 5.5. I'd like to setup a new machine, with MariaDB 10.0 in order replicate all of those databases to a single MariaDB instance using multi-source replication.
I know that multi-source was only introduced in MariaDB 10.0, but does it require that both master and slave are running the same version, or will it be sufficient for only the slave to be on MariaDB 10?
Updating all of the production databases to v10.0 isn't really an option at this stage unfortunately.
Best Answer
From what I can find on MariaDB's website, multi-source replication from MariaDB 5.5 to MariaDB 10.0 looks like it should not be an issue.
https://mariadb.com/kb/en/mariadb/upgrading-from-mariadb-55-to-mariadb-100/
"There are no changes in table or index formats between MariaDB 5.5 and MariaDB 10.0, so on most servers the upgrade should be painless."
They even mention considering Multi source replication on this same page (above).
This link provides incompatibilities with MariaDB 5.5 that you should watch out for: https://mariadb.com/kb/en/mariadb/multi-source-replication/
Incompatibilities with MariaDB/MySQL 5.5