MySQL Replication Pros/Cons

[countdrak]

I am a MYsql noob and have been reading up on MySql replication techniques and trying to decide what would be most efficient way of setting up replication.

I have one master and probably will only have one slave. Can someone point me to an article that weighs out the pros & cons of using PEER to PEER Replication Vs a simple master slave setup?

I can't decide what would be much better.

Thanks.

 

[lgarner]

Master-Master allows updates to be made to both hosts. Master-Slave requires all updates to be made to the desigated master.

Master-Master is just slightly more complex to set up, but more resilient.