多个mysql数据库之间的双向同步 [英] Bi-directional synchronization between multiple mysql databases

问题描述

伙计们，



是否有可能在mysql中同步4个数据库？我的意思是在不同的位置有4台服务器，服务器上的数据库将处于自动同步模式。如果其中任何一个下降，其中三个会自动同步并且它会自动同步，所有4个都会自动同步。



请回复......！



我尝试过：



使用双向同步数据库尝试了很多事情但运气不好。

Guys,

Is it possible to synch 4 databases in mysql? I mean there are 4 servers on different location and databases on server will be in Auto Synch mode. If any one goes down rest of the three gets sync automatically and it goes UP, all 4 gets synch automatically.

Please reply...!

What I have tried:

Tried with lot of things using Bi-directional synch database but hard luck.

推荐答案

是的，但是为什么不使用单个数据库并实施强大的镜像/备份策略？



无论如何，你都不喜欢这个论坛。你可能最好在一个更相关的论坛上发布这样的问题，例如

设计和架构讨论板 [ ^ ]，数据库讨论区 [ ^ ]或系统管理员讨论区 [ ^ ]注意 - 只选择一个。



建议的研究主题从谷歌 [ ^ ]

Yes it is possible, but why not use a single database and implement a robust mirroring/backup strategy?

In any event you are way off-topic for this forum. You might be better off posting a question like this in a more relevent forum such as
Design and Architecture Discussion Boards[^], Database Discussion Boards[^] OR System Admin Discussion Boards[^] NB - pick one only.

Suggested research topics from Google[^]

这篇关于多个mysql数据库之间的双向同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！