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.

My application uses a mechanism of SQL patches as part of the upgrade to a new version.

Before running an upgrade, I need to try to run the SQL patches on a copy of the database to ensure they complete without error, before running them on the actual db.

I can do it on RDS, by creating a temporary DB, running the patches on it, and dropping it thereafter.

But ideally, I'd want to do so without having the temporary database written to the binlog for backup and replication.

Is it possible to mark a specific database as non-replicated in an RDS instance?

My other option is to create a temporary RDS instance just for testing the upgrade, but that's a bit overkill and takes extra time to complete.

share|improve this question

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.