Welcome to Server Circle. It's a friendly site and all levels of experience are welcome. Be aware that we use cookies for your login.
Server Circle - Ask questions about Servers and get answers from experts.
Beta (0.59 sec)
Only writing to one node in MYSQL - is this critically important ?

I've just read this:

http://enginesmith.wordpr ...

I think I want two master databases for safety and load balancing but should I definitely only use ONE node for writing ?

Any experiences must be well received and welcome.
Asked by:
bondanidjika ...
176 points
 Report Abuse
 Share Page - Category: Linux Servers - Tags: Only writing to one node in MYSQL - is this critically important ?
 Enter your response
Please use Pastie.org to paste lengthy code or to fix formatting issues with code
  • Responses in reverse (2)

This is the way round it by all accounts:

http://mysql-mmm.org/mmm2:guide

Not sure if it's still essential for a busy master-master site though.

Response by:
BonoEstente
1464 points
I may be completely wrong but I thought that the auto-increment stuff in MYSQL 5 prevented Primary Key corruption. That was the problem with running two masters at once - you'd get two rows written at the same time in different databases with the same key and replication would fail altogether.

Am I right ? Any experts care to elaborate ?

Response by:
Trinity
2782 points


  • Related Questions

by Keith (432 points) in Linux Servers - 0 replies

by jesny (50 points) in Linux Servers - 0 replies

by tmtt (440 points) in Linux Servers - 2 replies


About Us : Contact Us : Etiquette : Terms : CDN Failover : ShorterURL : CDN Fallback : © 2013 Server Circle