I have 2 MySQL databases running on a server called X and Y, which both have identical content. In this, I had a series of updates and after that, it compares the content of X with the content of Y in order to discover new rows, updated row data, etc.
I'm investigating the migration of these databases to Amazon RDS. What's the most efficient way to accomplish the process outlined above?