2

I have a database on an RDS Instance (master) that needs to be synchronized to another RDS instance (slave). I created a read-replica for the first one, but that is created as read_only so I cannot do any operations on it.

Basically, I'll need to create a few other databases on the slave instance as well so that needs to be non-read-only. I'll also need to setup sync to happen once daily.

I am using MySQL 5.6+.

Improve this question

1 Answer 1

Reset to default
2

DISCLAIMER : I haven't tried this myself

What you asking for is somewhat rare. Nevertheless, it is possible.

Here is a link to Looker.com to explain how.

Basically, you do the following:

  • Create a read replica
  • Create a Custom DB Parameter group
  • Tweak the read_only setting in the Custom DB Parameter Group
  • When replica has been created, ...
    • you modify the instance
    • set Parameter Group to the Custom DB Parameter Group

Once you have the accessibility, you can create the DBs directly in the Slave.

I would normally say "Give it a Try !!!" but I never did this before. So, try it out and tell us all if it worked.

Improve this answer
4
  • Thanks for your quick response. The 'read_only' flag was one of the first things I tried. In the parameters group I couldn't find this parameter and I couldn't change it. Amazon's official documentation says that this flag can be changed too, but I couldn't see it in the parameter group.
    – Kanuj Bhatnagar
    Jul 9, 2015 at 14:10
  • Please look at Steps 6-10 in looker.com/docs/admin/database-config/mysql-rds and try to see if you can duplicate those steps. Perhaps Amazon made it harder or impossible to do this, or maybe the link is older than Amazon's current policies. Try it out and tell us ...
    – RolandoMySQLDBA
    Jul 9, 2015 at 14:14
  • I don't know why it didn't show up before. Anyway, that worked.. thanks!
    – Kanuj Bhatnagar
    Jul 9, 2015 at 14:21
  • Actually, thank you. I learned today that you can bypass read_only on an RDS Slave and I have your question and your acceptance as proof. You get a +1 for your question. I will mark your question as one of my favorites.
    – RolandoMySQLDBA
    Jul 9, 2015 at 14:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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