I need to migrate an old web application using old PHP and MySQL versions.
I am intending to start by migrating the code that interacts with the database to a new server with the latest versions and allow the old server to use an API in the new server. Ideally I would like to have the data consistent between the database in the new server and the one in the old server.
It seems that replication only works only when the master is only one version behind the slave. In this case the difference is a way more than one version. I also want changes to the database on the new server to reflect on the database on the old server.
Are there any tools/techniques to help with this situation other than ensuring the data consistency programmatically with