I hava a database application in mysql 5.5 innodb. I want to install the same setup in mysql 5.6 version. I will keep the both.
Every changes in first database will happen in the second one or changes in second will make changes in first database.
Please let me know the simplest way to achieve this. OS is linux.
Best How To :
You can replicate between 5.5 and 5.6:
MySQL supports replication from one major version to the next higher major version. For example, you can replicate from a master running MySQL 4.1 to a slave running MySQL 5.0, from a master running MySQL 5.0 to a slave running MySQL 5.1, and so on.
You certainly can have multi-master replication.
There are a couple caveats:
The use of more than 2 MySQL Server versions is not supported in replication setups involving multiple masters, regardless of the number of master or slave MySQL servers.
I think you're good on the next one between 5.5 and 5.6:
You cannot replicate from a newer master to an older slave using statement-based replication if the statements to be replicated use SQL features available on the master but not on the slave.