Welcome to WebmasterWorld Guest from 54.146.217.179

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


Hi,

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.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members