Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have set up a 3 node percona cluster in amazon ec2. As our client required, i also had to set up an asynchronous slaves in another datacenter as well. Each async slave pointed to single percona cluster node with log-slave-updates and bin-log enabled.

However the async slaves failed to maintain the replication process for long. At least once a week i have to build the slaves from scratch. These async slaves are used only for backup purpose.

Is there any alternative method(best way) of doing this?

Percona Cluster ---> async slaves ?

share|improve this question
That's the correct way to do it. It might be helpful if you mentioned the the specific versions of the servers, and in what way the slaves "failed to maintain the replication process" -- there's more than one way to break replication, after all... and whether different slaves pointed to different nodes as masters failed at the same time, or not... – Michael - sqlbot Aug 4 '13 at 2:31
What is SHOW VARIABLES LIKE 'binlog_format'; on the Slaves ? – RolandoMySQLDBA Aug 4 '13 at 3:10
Binlog_format is "ROW" – adinindu Aug 5 '13 at 16:32

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.