mysql - 如何在两个不同版本的主数据库之间进行同步(或复制)？

Question

我有一个mysql 5.5 innodb数据库应用程序。我想在 mysql 5.6 版本中安装相同的设置。我会保留两者。

第一个数据库中的每个更改都会在第二个数据库中发生，或者第二个数据库中的更改将在第一个数据库中发生更改。

请让我知道实现此目的的最简单方法。操作系统是Linux。

Answer 1

您可以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.

您当然可以进行多主复制。

有一些注意事项:

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.

我认为你很擅长 5.5 到 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.