homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

MySQL production setup site
mysql replication production site

5+ Year Member

Msg#: 4319435 posted 1:21 am on May 30, 2011 (gmt 0)


I am setting up 6 server running MySQL 5.1x for a production site. Each server will only have 1 database that is expected to grow about 1 GB per year. This server need to have an uptime close to 100% and I need to replicate data between them.

Each server will run apache with a single PHP script that will collect, validate and post the data to the database. In the minute 1 I will send the post to server 1, then in the minute 10 I will send the post to server 2 and so on until server 6 and then it will start again from server 1.

I have been reading a lot about MySQL master to master circular replication with a combination of federate and event table to check on the master status. I have even read that this NOT a good setup for a production site, but I couldn't find why.

Can anyone tell me about the right setup of MySQL for a production site that need replication and can't afford down time?

Thank you.


Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved