MySQL specific database replication (Master - Master)

view story

http://serverfault.com – We have a mySQL server at one location, replicating to another in a Master->Slave configuration. There are about 5-7 different databases on this server. We are wanting to do this... We have a second site that we are wanting to move all our web servers to for HA, that are mySQL driven. Unfortunately we cannot move these all at once and are wanting to setup replication over our WAN link from one mySQL server to the other. Since we will be slowly transitioning web servers over to this second site, I need to slowly break off databases from the existing environment to the second site for producti (HowTos)