Preparing MySQL databases for migration
If you want to perform online MySQL migrations, prepare your source and target databases for replication as follows:
-
Source database requirements:
Depending on your source server configuration, following modes are supported:
-
Single server: To enable binary logging, see The Binary Log.
-
Multiple replica servers: To setup replication using GTIDs, see Setting Up Replication Using GTIDs.
-
Note: The above steps are applicable only when you perform an online migration.
- Target database requirements:
Note: For online migrations, if you define a different replication user, then ensure that it has the privileges defined here. However, if you do not define the user, ensure that the main user for the connection has these privileges.
Related Topics