heh it is :P There are a few issues though. Mysql doesnt support multiple masters, so if you want to create a very large server with 3 or more hosts, you will need to do one of the following:
1. Set it up in a series (kinda like some Christmas tree lights). Problem with this is that, just like some Christmas tree lights, if you remove a bulb, or a server in this case, the replication will stop on the distant servers.
2. Trick mysql into using multiple masters by running multiple instances of it. This will create other problems. The mysql dev team has been promising to add fail-safe replication (if the master fails, it will try another master) since version 4.0, then 4.1, then 5.1. Until they implement that, its going to be a challenge to setup replication for more than 2 servers if the servers could go down at any time.
__________________
Lethal Encounter
|