How Do I Specify the Start Point for DRS Incremental Synchronization?

For a MySQL incremental synchronization task, you need to specify the start point on the Set Synchronization Task page. The source database logs of the task are obtained from the position after the start point (excluding the current start point).

Figure 1 Start Point

If the gtid_mode parameter of the database is set to on, a start point consists of three parts: file name (File), position (Position), and executed Global Transaction Identifiers Set (Executed_Gtid_Set). You can run the show master status command to obtain these values. If the source database version is MySQL 5.5, it is not supported. When setting Executed_Gtid_Set, you need to delete the newline characters.

For example, the start point about MySQL Community Edition is as follows:

Based on the obtained information, set Executed_Gtid_Set to c8cd8ff7-da6f-11ec-a945-00d861ef1161:1-3,f4f9537f-0c8b-11ec-a284-00d861ef116a:1-10820402.

Figure 2 Setting the start point