Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Here's my mysql cluster setup

All nodes have a database db with following tables

table1 table2 table3

NODE1 gets table2 from NODE2, table3 FROM NODE3

NODE2 gets table1 from NODE1

NODE3 gets table1 from NODE1

Is this possible with mysql replication?

share|improve this question
    
I know that we can exclude or include some tables/databases in mysql replication and also that a master can also be a slave. The only problem is Can a slave have multiple masters? –  Gunjan Mar 4 '11 at 15:57

1 Answer 1

up vote 3 down vote accepted

I think its not possible with a normal master/slave replication. For this you need something like the mysql cluster version.

The main problem is the master / master replication without the cluster. Then you get some trouble with IDs and something else. I have tried this before a lot of time. And when you write on both master and one master is before the other and will write to the other and the primary key exists and you cannot write its very strange.

I have put a link to HowToForge there is an article to set up a master / master replication you can try it.

Perhaps you can look for alternatives like couchedb or mongodb its no mysql but with the nosql databases you can better replicate and scale.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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