Database disaster recovery level
In the era of informationization, data security and business continuity of enterprises have become crucial, and disaster recovery and backup has attracted much attention as an important measure to ensure that data is not lost and business is not interrupted.
We usually categorize disaster recovery backups into four levels, from the most basic local backups to complex off-site multi-live systems, each with different characteristics and applicable scenarios.
Let's take a closer look at these four levels of disaster recovery and backup solutions.
Disaster Tolerance Backup Disaster Tolerance Level
1. Tier 0: no backup data center
This level of disaster recovery backup has virtually no disaster recovery capability; it only backs up data locally, and the backed up data is only kept locally and not sent offsite.
Description：General new business, the business is about to be shelved, the edge of the business will use this level, so the database selection requirements are not high, the general stand-alone MySQL, SQL Server, etc. can support.
2. Level 1: local tape backup, off-site storage
Critical data is backed up locally and sent off-site for storage. When a disaster is sent, restore it according to a predetermined data recovery procedure. This program is low cost and easy to configure. However, when the amount of data increases, there is the problem that the storage media is difficult to manage;
And when a disaster occurs, there is the problem of a large amount of data being difficult to recover in a timely manner. To solve these problems, when a disaster occurs, critical data can be recovered first, followed by non-critical data.
Description: When a new business reaches a certain size, it will consider using this level to store database backups using more cost-effective storage media, such as tape libraries, and the backups are retained for a fairly long period of time, requiring the storage media to be stored offsite for preservation, either manually or via the network at regular intervals.
3. Tier 2: hot backup site backups
A hot backup site is established at an offsite location to back up data over the network. That is, the data from the primary site is backed up to the backup site in a synchronous or asynchronous manner over the network. The backup site generally only backs up data and does not undertake operations.
In the event of a disaster, the backup site takes over operations from the primary site, thus maintaining continuity of business operations.
Description: This level is generally the business into a stable period, need to consider the level of disaster recovery to upgrade a grade, this time the database selection, generally need to have cross-computer room data synchronization capabilities, for example, SQL Server's AlwaysOn, MySQL's MGR, PostgreSQL streaming replication and so on can meet;
If you are using a public cloud, then multiple availability zones for RDS databases will suffice.
4. Level 3: Active Backup Center
Two data centers are set up in distant locations, both of which are in working condition and back up each other's data. In the event of a disaster in one data center, the other data center takes over the workload.
This level of backup can be categorized into two types depending on the actual requirements and the amount of money invested:
(1) Mutual backup of critical data only between two data centers
(2) Mirroring between two data centers, i.e. zero data loss
Zero data loss is currently the highest requirements of a disaster recovery and backup program, which requires that no matter what disaster occurs, the system can ensure data security. So it needs to configure complex management software and specialized hardware equipment, relatively speaking, the investment is the highest, but the recovery speed is the fastest.
Description: General financial services and other high data security requirements need to achieve this level, that is, we often say, off-site dual-activation, off-site multi-activation, database selection generally need to have a distributed multi-node data synchronization capabilities, for example, a Base, a SQL and so on can meet.
Disaster recovery capabilities for different disaster recovery backups
Comparison of construction costs and disaster recovery target times
summarize
This article describes four levels of database disaster recovery backup, from local backup (level 0) to complex off-site dual-activity systems (level 3), with each level applicable to different business scenarios.
The article focuses on analyzing the features and applications of backup solutions at all levels to help enterprises choose the right solution based on RTO, RPO and other requirements to ensure data security and business continuity.
In fact, from level 0 to level 3, it is essentially to meet the higher requirements of RTO and RPO, and to meet the more demanding SLA, so it is important to combine the practicality of both database selection and solution selection, and to select the most suitable solution.
reference article
/
/cn/industries/commercial-market/active-active-data-center-solution
/374/
/hjx020/article/details/106588133/
This article is copyrighted and may not be reproduced without the author's permission.