Last updated: 2020-02-25 16:09:46PDF
TencentDB for SQL Server consists of a master database and a mirror database that are deployed in different racks. Each database corresponds to a group of monitoring agents which monitor the database in real time based on the heartbeat. The cluster management scheduling center consists of two sets of independently deployed decision-making clusters and configuration clusters and is mainly used to manage the normal operations of the database node group, access gateway cluster and HDFS. The Hadoop distributed file system (HDFS) makes available data disaster recovery service with cold backup. The gateway cluster is accessed to provide a unique IP, and if the data node is switched, the IP won't change.
Currently, the cloud database SQL Server adopts the database Image (Database Mirroring) solution (highly available replication scheme) by default, which provides the reliability of automatic switching in seconds and "zero" data loss.
Automatic Node Recovery
TencentDB for SQL Server supports automatic rebuilding of database nodes, so if a node fails, it will be automatically restored/reconstructed. The node switchover is imperceptible to the business, and the database access IP does not change.