Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

MySQL production setup site

mysql replication production site

1:21 am on May 30, 2011 (gmt 0)

Junior Member

5+ Year Member

joined:Dec 29, 2008
posts: 65
votes: 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.