Best Practices of Database Disaster Recovery in the DT Era

Double 11 The Biggest Deals of the Year. 40% OFF on selected cloud servers with a free 100 GB data transfer! Click here to learn more.

With the arrival of the Data Technology (DT) era, enterprises have become increasingly dependent on data. Data protection has become essential for enterprises, and only those who take preventive measures with sufficient preparations can survive in disasters. In the Best Practices for Enterprise Database Session at The Computing Conference 2018, topics related to disaster recovery attracted much attention. This article introduces the best practices of using Alibaba Cloud database cloud product portfolios to tailor the disaster recovery solutions conforming to the development status of enterprises.

The Value of Data for Enterprises

Data is important resources for production of an enterprise. Once data is lost, the enterprise’s customer information, technical documents, and financial accounts may get lost, which may hold back customer relation, transaction, and production. In general, data loss is classified into three levels:

To cope with economical loss caused by data loss, enterprises must take disaster recovery measures to protect data. The higher the enterprises’ degree of informatization, the more important the disaster recovery measures are.

Enterprise-Class Database Disaster Recovery System

Definition of Disaster Recovery

Disaster recovery involves two elements: disaster tolerance and backup.

Pain Points of Backup

Pain Points of Disaster Tolerance

Deployment Solution

An enterprise-class database disaster recovery system should be selected based on business requirements and full considerations must be given to the following factors: RPO, RTO, costs, and scalability. The system must also meet various requirements of database disaster recovery, including building of the disaster recovery environment, data synchronization, monitoring and alarms, drills, failover, and data verification and repairing.

Core Products for Enterprise-Class Database Disaster Recovery

After multiple rounds of iteration, the outstanding disaster recovery capabilities of Alibaba Cloud products are well proved. The following core products can help enterprises develop the database disaster recovery solutions for different scenarios or to meet different requirements.

In a disaster recovery scenario, we recommend that you integrate other Alibaba Cloud products such as DRDS and OSS. These products have undergone internal and external verifications of Alibaba Cloud and are proved to be highly reliable. You can use these products flexibly in the disaster recovery scenario.

Typical Application Scenarios

Real-Time Backup

If you set high requirements for data backup, for example, continuous real-time backup without affecting business operations, you can buy Database Backup Service to implement hot backup of databases. This service supports real-time incremental backup and data recovery in seconds. The following figure shows the architecture of the solution:

The architecture design is described as follows.

Deployment of key components:

Data recovery:

Architecture characteristics:

Multiple Remote Active Backups

You can find all the following solutions in the enterprise-class database disaster recovery system: on-cloud elastic disaster tolerance, dual or multiple active backups, and three centers in two locations. The following takes multiple remote active backups as an example to describe the solution. This solution supports data-level remote dual active backups and one-click switchover to another data center to realize flexible scale-up or scale-down and future linear expansion.

Deployment architecture

New Product: Database Backup Service

As a database on-cloud backup channel, Database Backup Service is used together with OSS to develop a cloud database backup solution. It takes only five minutes for such a solution to implement real-time backup with a second-level RPO. (The RPO indicates the maximum duration allowed for data loss when the database fails. A smaller RPO is often desired.)

When Database Backup Service is deployed, the entire backup process is unlocked and does not block any service requests on the databases. You can choose to back up the entire instance or a table. Once a misoperation is detected, you can use Database Backup Service to recover data at any time point. Data of the entire instance or the specified table can be recovered to the state one second before the misoperation. Database Backup Service is available in multiple specifications, which meet the backup requirements of the database with a size ranging from hundreds of MBs to hundreds of GBs.

Currently, the backup system time provided by Database Backup Service has been proved by massive users. Database Backup Service not only supports real-time backup and second-level RPO, but also has the table-level recovery capability. It helps users to recover only valuable data and the RTO can decrease to several minutes.

It is worth mentioning that real-time backup has been tested in years of Double 11 shopping festivals. Database Backup Service will further provide the online query function. After a data backup task is completed, you can immediately run SQL statements to query backup data without waiting. You can also export the query results into Excel or Word files for further analysis, or generate Insert and Replace statements to correct data.

Reference:https://www.alibabacloud.com/blog/best-practices-of-database-disaster-recovery-in-the-dt-era_594169?spm=a2c41.12293876.0.0

Follow me to keep abreast with the latest technology news, industry insights, and developer trends.