Actually, the best way to do it would be each mysql server configured as a dual master/slave.
They would push data around to one another... Each would be set as a slave to all of the other masters, and each of the other masters would be one of it's slaves. The connection map on this thing would look like something from a spirograph....
The more you have, the more bandwidth your going to consume in the traffic obviously, but until you get past 4 or so, I don't think it would be to bad.
Thats pure conjecture though, but once again, pretty minor cofiguration setup change on the part of the sql servers.
__________________
Quitters never win, and winners never quit, but those who never win and never quit are idiots.
|