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.

We are currently running our database in RDS - just one master (no read slaves), with a Multi-AZ deployment for fail-over durability.

I am contemplating some performance tweaks, one of which is disabling binary logs. I know they're used for master->slave replication, but I am not sure whether Amazon uses the same mechanism to support its Multi-AZ set-up or not.

I don't want to accidentally break the Multi-AZ feature by disabling binary logs.

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

Yes it does uses mysql binary logs for Multi-AZ replication.

Here this FAQ at amazon site confirms this:

Q: Can I directly access the binary logs for my Database Instance to manage my own replication?
A. Amazon RDS does not currently provide access to the binary logs for your Database Instance.

http://aws.amazon.com/rds/faqs/#103

And this one too.

You may find in some cases that your Read Replica(s) aren’t able to receive or apply updates from their source Multi-AZ DB Instance after a Mulit-AZ failover. This is because some MySQL binlog events were not flushed to disk at the time of the failover. After the failover, the Read Replica may ask for binlogs from the source that it doesn’t have. This loss of MySQL binlogs during a crash is described in the MySQL document here.

http://aws.amazon.com/rds/faqs/#107

This simply confirms that it does uses binary logs.

share|improve this answer
add comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.