I am having a production MySQL server with set of 20 databases in on-premises server. Now I require to migrate few databases from production server to AWS RDS without disturbing other databases in one-by-one.
We can perform this activity using AWS DMS. Instead, I am looking at tranditional MySQL replication for setting up replication between existing production server to AWS RDS.
In RDS, as we are not having access to my.cnf, I am not able to set replicate-do-db configuration. Is there any other workaround to setup replication from on-premises to RDS for few databases.