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
Is it possible to have cluster and replication? (ie clusters at each
location and replication to sync each location)
Alan Williamson wrote:
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
This isn't a constraint, this is a limit, the goal is to have a
bi-directional replication but I've not found solutions to my problem
using mysql. I've a control access system with 9 minitowers which
controls people access via RFID, each minitower is provided with linux
and mysql synchronized
Since MySQL-Cluster is not recommended over a WAN that's not an option. I
soon will be looking for a method to syncronize real-time data between a
active/passive datacenter setup. (One datacenter in Salt Lake City, Utah
and another in Las Vegas, Nevada)
At this time I don't think any 'out of
