Hello all, Using MySQL, I have the following replication setup:
A -> B and C where A is the master DB and both B and C are slaves of A. By design, B is rarely more than a couple of seconds behind A, but C is always about 5 minutes behind A. If A crashes, B would be promoted to being a master. But could C become a slave of B my merely adjusting the replication coordinates? Or would it have to be rebuilt using a full dump from B? I am using MySQL 5.5, so GTIDs are not (yet) an option[1]. [1] https://blogs.oracle.com/MySQL/entry/mysql_replication_self_healing_recovery Regards, - Robert -- -- Central West End Linux Users Group (via Google Groups) Main page: http://www.cwelug.org To post: [email protected] To subscribe: [email protected] To unsubscribe: [email protected] More options: http://groups.google.com/group/cwelug --- You received this message because you are subscribed to the Google Groups "Central West End Linux Users Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
