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+.
Best Answer
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:
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.