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?