 | | | cluster or replication | cluster or replication 2005-09-13 - By Alan Williamson
Back
> I've 10 server in differents locations, I want to make a broadcast, I
> would like to have always datas synchronized between this network, each
> database have the same tables and same structure. Each insert or update
> in database will be executed for each server within this broadcast,
> what's the best choice ?
At the moment, replication is your best option. Replication works very
nicely over wide-area-networks, where the bandwidth between each node
could be dramatically different.
The only constraint you'll have here is that there can only be one MASTER
that has to accept all the INSERT/UPDATE/DELETE (or anything that will
make the data change). All other nodes would be considered SLAVEs and
be READ-ONLY.
Hope this helps.
a
--
Alan Williamson, Technology Evangelist
SpikeSource Inc.
Daily OS News @ http://compiledby.spikesource.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
Earn $52 per hosting referral at Lunarpages.
|
|
|