I have Mysql RDS1 and another Mysql RDS2 where the schema is different.I need the any changes on RDS1 to be synced immediately to Mysql RDS2.where the data changes due to create, insert, update and deleteBoth RDS1 and RDS2 is alive and integrated to diff app.I referred: https://aws.amazon.com/blogs/aws/fast-easy-free-sync-rds-to-redshift/but still searching for a proper solution for my problem.Can anybody help?
Thank you marlong, i need sync immediately like pubsub.. even seconds matters. I trying with cron... Seeking for optimal way..
Then did you try sqlyog?
Thank you marklong.. let me try.