Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm wondering if it is possible to have a set of SQLdb servers to which data is written and have them replicate, avoiding conflicting information.

I imagine that a Master/Slave structure would be mandatory, I would like to know if a system where servers have no hierarchy could support replication.

Currently I'm using MySQL, but I would be happy to move to another database if needed.


Any ideas? :)

share|improve this question
    
Related question: serverfault.com/questions/130961/… –  Jonas Apr 14 '10 at 7:37
add comment

2 Answers

up vote 1 down vote accepted

You could have a multi-master setup / cluster.

See http://en.wikipedia.org/wiki/Multi-master_replication

Postgresql has similar features to Mysql but it considered more enterprise class, yet is also OSS. It is easy to get excellent support for it via #postgresql on irc.freenode.net

I'm not sure if there would be some affects on ACID though.

share|improve this answer
    
What would you say makes Postgres more "enterprise class"? –  Warner Apr 14 '10 at 4:23
    
Postgres has been historically more of an enterprise class database because: Better adherence to SQL Superior ACID compliance. A richer feature set It did not install a risky storage engine by default (MyIsam) Full support for foreign keys Full transactions support Please see en.wikipedia.org/wiki/… & troels.arvin.dk/db/rdbms for more details –  Brennan Apr 14 '10 at 7:04
add comment

Multi master setup is the only one setup whith no hierarchy to comes to my mind right know. By the way, there's the DRDB option for replicating data that might fit your needs using DRDB and Heartbeat for failover.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.