MySQL Master-Master Replication…

Have you tried Master-Master replication (bi-directional slave-master replication) for MySQL? I am finding myself in a position where I need to have this replication to support the load on my blogs and sites.

I would very much appreciate if you can share your experience & suggestions with master-master replication of MySQL database.

I don’t want to go for traditional master-slave as it will require changes in plugin and specifically require additional development for our spam protection initiative. My objective is to truly balance the load using round-robin DNS and provide transparent fail-over support.