Hey all, got a question for you about MySQL. Before I get started I will just point out I am rather new to the whole linux deal so please bear with me.

My question is this:

I need to have 1 database which stores patient records. (Currently running on a MS SQL server, but will be transferred to MySQL soon.) This database needs to run on 2 servers in the one city and have them replicate the records between themselves. This will have to be a 2 way replication since new updates will be added to each site daily, but it is not necessary to have them 100% current, a 3,6,12 hour window would be sufficient.

So does anyone have a few pointers of where I want to start looking to set this up so it is very reliable (in the event that a record had been changed at 2 sites before replicating and 1 overwriting the other)? Is there a way I can set up a cluster between the 2 sites to keep them current?

Anyway, hope that is good enough info, if anyone has an idea that would help please give me a shout.


thanx