Comments - Row-based Replication With No Primary Key
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
MariaDB has all the same replication formats as MySQL: statement, mixed, row.
So then is it possible to have a Master that is Mysql Replicate to a Maria slave? Or do both Master and Slave have to be Maria in order for replication to work properly.
Also we currently are not enforcing foreign key constraints between tables , these relationships are being handled on the application level. We are replicating Innodb (Master) to MyISAM (slaves).
Would i be able to do the same with Maria in place on the slave side?
If you are currently replicating between MySQL 5.5 servers, it should work exactly the same way with MariaDB 5.5 server as a slave.
If you are currently replicating between MySQL 5.6 servers, after replacing the slave with MariaDB 5.5 server you might encounter the same problems as you would have by using MySQL 5.5 as a slave, since replicating from a newer master to an older slave has its limitations.