Re: cluster or replication

2005-09-13 Thread Lorenzo De Vito
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 w

Re: cluster or replication

2005-09-13 Thread Cory Robin
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 h

RE: cluster or replication

2005-09-13 Thread Alan Williamson
> 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, > wha

RE: cluster or replication

2005-09-12 Thread Cory Robin
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 t