I have a Database using MySql, however i want to migrate to azure MySql which i know is possible, I am new to Azure.
My question if i make changes to the local database, is it possible to automatically update the tables in azure with same changes?
I want to link both Database together and any changes effected on any will affect the other.
This functionality is available and is called Data-In replication. Please see: How to configure Azure Database for MySQL Data-in Replication for instructions on how to configure this functionality. Please see the Limitations and Considerations but the following are the requirements:
mysql.az_replication_change_master
stored procedure. Refer to the following examples and the master_ssl_ca
parameter.