I am looking for some solution for automatic resyncing / replicating one table from one mysql server to many others.
我正在寻找一些解决方案,从一个mysql服务器自动重新同步/复制一个表到许多其他服务器。
I don't need master / slave solution, because the servers are not connected in this way, but there are some tables, where only on one server this table is changed and the other servers need the actual table as well.
我不需要主/从解决方案,因为服务器没有以这种方式连接,但有一些表,只有一个服务器上这个表被更改,其他服务器也需要实际的表。
Some ideas how to make this? Is there maybe some deamon what is watching for changes in background and synchronizing the tables if there are changes.
一些想法如何做到这一点?是否有一些deamon正在观察背景的变化,如果有变化,同步表。
Of course I can programm my own tool for synchronizing the tables, but as first I want to ask if there is some better solution?
当然我可以编程自己的同步表的工具,但首先我想问一下是否有更好的解决方案?
1 个解决方案
#1
0
tungsten replicator does a lot of replication special cases. It can probably help you.
钨复制器做了很多复制特殊情况。它可能会帮助你。
Configure all MySQL servers that change the table as masters, and then create a ring or fan out these changes to the others.
配置将表更改为主服务器的所有MySQL服务器,然后创建一个环或将这些更改扇出到其他服务器。
#1
0
tungsten replicator does a lot of replication special cases. It can probably help you.
钨复制器做了很多复制特殊情况。它可能会帮助你。
Configure all MySQL servers that change the table as masters, and then create a ring or fan out these changes to the others.
配置将表更改为主服务器的所有MySQL服务器,然后创建一个环或将这些更改扇出到其他服务器。