3

I am researching MySQL cluster replication. I read a section "We assume that the slave server or cluster is dedicated to replication of the master, and that no other data is being stored on it" in MySQL cluster manual. According to the section, slave cluster should not store any data except data replicated from master cluster.

I want to know for sure because I have an intention to deploy two cluster that a SQL node are both master and slave. Example: I have two clusters with SQL node A belongs to cluster a and SQL node B belongs to cluster b

SQL node A --- master of node B and also slave of node B ---> SQL node B

SQL node B <--- master of node A and also slave of node B ---> SQL node A

I think an bidirectional replication channel help me have two cluster for backup and scale out read/write (It allow web application to be read/write to two SQL nodes)

I am wondering the model is feasible ?

3

I do not see any problem (if you configure it properly: bin_log on, log_slave_updates, row replication, different server ids for all servers, same exact versions on all servers), but only if you use one of the clusters as read-only at any time.

  • When I configure a node as master thus the node accept read/write (not read-only) from web application. If I must use a cluster as read-only, cannot I configure a node for both slave and master of other node ? – Luke Nguyen Aug 5 '14 at 8:39
  • @Luke Nguyen actually you can, as the SUPER user has always write privileges, but I am not suggesting that. Just do not write to both clusters at the same time or replication between clusters may break. – jynus Aug 5 '14 at 8:45
  • I also think about broken replication channel. Increase sql nodes on each cluster and use a backup channel is not bad solution. Writing to both cluster at the same time is potential duplicated data. The problem is possible to solve with load balancing/HA between web application and two clusters. It ensures only write/read request to one sql node at any time. Welcome all your comments. Thank you very much ! – Luke Nguyen Aug 5 '14 at 9:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.