Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.