For applications with high requirements for service continuity, data reliability, and compliance, TencentDB for MySQL provides cross-region disaster recovery instances to help enhance your capability to deliver continued services at low costs and improve data reliability.
If GTID is not enabled, you can enable on the instance details page in the console. The operation takes a long time, and the instance will be disconnected for several seconds. You are recommended to do so during off-hours and add a reconnection mechanism in the programs that access the database.
Log in to the TencentDB for MySQL Console. In the instance list, click an instance name or Manage in the "Operation" column to enter the details page.
Make sure that the GTID feature is enabled by viewing the basic information of the instance on the instance details page. Click Add DR Instance in the instance architecture diagram to enter the disaster recovery instance purchase page.
On the purchase page, set basic information of the disaster recovery instance such as Billing Mode, Region, and Sync Policy.
- The time it takes to complete the creation is subject to the data volume, during which no operations can be performed on the master instance in the console. Please do so at an appropriate time.
- Currently, data sync is supported only for the entire instance. Please make sure that the disk capacity is sufficient.
- Make sure that the master instance is in the running status and not running any tasks; otherwise, the sync task may fail.
After confirming that everything is correct, click Buy Now and wait for disaster recovery instance delivery.
If the "sync policy" you selected during instance purchase is "Sync After Creation", you need to configure a disaster recovery sync link after the instance is created successfully. By doing so, you can implement remote disaster recovery.
On the instance details page of the master instance, you can view the sync status of the disaster recovery instance. Click Create Sync Task to create a private network sync linkage with the master instance for the disaster recovery instance.
Enter the task name, confirm the source and target database information, and click Save and Next.
Select the object to be synced. Sync of the entire instance or certain tables is supported. The sync type cannot be customized currently.
Click Save and Check to check the task. After the check succeeds, click Start Task. Then, you can view the task details on the "disaster recovery sync" page in the TencentDB for MySQL Console.
View a disaster recovery instance
A disaster recovery instance can be viewed from the regions where it resides. You can use the instance list to filter out all instances in a specific region.
View slave-master relationship
Click the icon on the right of a disaster recovery instance or master instance to view the slave-master relationship.
View sync delay
View the sync delay between the master instance and the disaster recovery instance at the top of the instance details page of the disaster recovery instance.
Disaster recovery instance features
A disaster recovery instance has various features, such as instance details viewing, instance monitoring, backup management, and slow query logging.
The disconnected sync link cannot be reconnected. Please proceed with caution.