CODEWITHSUNDEEP
mysqlmulti-master-replication
itgeek
itgeek

Reputation: 1

mysql replication master-master-master

We currently have MySQL configured to support fail-over : Site1 <----> Site2 . While they are setup as master/master. Only one site is actively being written to by the app servers at a given point in time. We want to setup a new fail-over site. We would then have Site1<--->Site2<--->Site3. A three-way replication. Again, only one of the sites would actively be writing to the db. The other two would just be standbys. Currently Site1 and Site2 are running slightly older 5.5.29 but we'd like to use 5.6.20 on the new Site3. Eventually we'll upgrade to 5.6.20 on the others but we have to run things this way for now.

Is this possible? Any suggestions or gotchas to look out for?

thanks in advance

Upvotes: 0

Views: 288

Answers (1)

Sergio
Sergio

Reputation: 1050

Let's say you have servers "1" and "2" with master-master replication and willing to add server "3". Then you could make a circle of replication: configure your new server "3" to replicate from "1" (so both "2" and "3" replicate from "1"). Then point "2" to replicate from "3" instead of "1".

PS: Also to achieve HA without DNS entries manipulation I'd suggest to use keepalived (if possible in your environment), which will give your same failover and transparency for clients (they would see single virtual IP).

Upvotes: 1

Related Questions