师父的小问题从MySQL [英] small problem with Master & Slave in Mysql

问题描述

亲爱的所有人

现在我有两个Mysql服务器(Master + Slave)，现在slave总是更新，并且与master相同，但是现在我发现master服务器发生故障，客户端开始对slave服务器进行读/写操作，是否存在自动方法使主服务器从从属服务器再次更新


换句话说(例如，服务器A是主服务器，而B是从属服务器)

在正常B中是从属，并从A获得更新
万一A失败了，然后说几天后又回来了，我想通过脱机时存储在B中的数据来重新更新

谢谢大家
bye

Dear All

now i have two Mysql servers ( Master + Slave ) , now the slave is always updated and it is identical to the master but now i case the master server was failed and clients begin to read/write to the slave server , does there is an automatic method makes the master server updated again from the slave server


in other words ( say Server A is Master & B is slave)

in normal B is slave and get updates from A
in case A is failed then say after days it returned back , i wanted to re-updated by the data which stored in B while it was offline

thanks all
bye

推荐答案

这不是主/从工作方式.您是一个高可用性和可伸缩性的MySql群集 [

That is not how it works with master/slave. You what a MySql Cluster for High Availability and Scalability[^].

Master/slave is what it says. Master updates the slaves. Not the other way around.

这篇关于师父的小问题从MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！