Abstract: Ali Cloud database backup DBS provides continuous data protection and low-cost backup services for databases. It provides strong protection for data in multiple environments, including enterprise data centers, other cloud vendors, and public clouds. Database backup Provides an overall solution for data backup and operation recovery, with real-time incremental backup and data recovery accuracy to the second level. Database backup DBS product wide audience, small to individual webmaster, large to enterprise users, have database backup needs. This article will guide you to fully understand the functions and features of DBS products, as well as how to select specifications for different types of users, how to archive, etc.
Heng Tiegang (Payne), product expert of Alibaba database Business Division, joined Alibaba in 2011. He once served as MySQL DBA of Alibaba Group, and now he is database product manager, focusing on database product design.
Press conference video review, poke here! Press conference PPT link, stamp here!
The following content is based on the video and PPT of the speech.
This article will mainly focus on the following five aspects to introduce ali Cloud database backup DBS: 1. Product Overview 2. Product Advantages 3. Product architecture 4
Overview Database Backup The English name of the product is Database Backup, or DBS for short. It provides continuous data protection and low-cost Backup service for databases. As shown in the overall DBS architecture diagram on the right of the figure below, you can see that the user’s database can be backed up to the OSS object storage on Ali Cloud through ALI Cloud DBS no matter in the data center of the enterprise, other cloud vendors or the public network. If the user’s database has been on the cloud, such as using Ali Cloud RDS or self-built database on ECS, it can also use Ali Cloud VPC or classic network, through DBS can also be backed up to the user’s OSS. All in all, Aliyun DBS can provide strong protection in cloud, cloud and other cloud environments. In terms of functions, we can see that database backup provides data backup and operation recovery and other overall solutions to achieve real-time incremental backup, and can achieve the ability of second level data recovery. 88 ec74920d445a9214d7d46d1032696d11043ad3 everyone can realize ali cloud DBS some of the more remarkable characteristics, one is the second level RPO, when recovery can choose any point in time, In addition, the overall cost of ali Cloud DBS docking object storage is also very low, and Ali Cloud DBS can support a variety of environments.
Next, we will share the advantages of Ali Cloud DBS database backup products. In fact, Ali Cloud DBS database backup products have the following five advantages: flexible and easy to use, no learning threshold; High performance, adapt to different scale requirements; Low cost, reduce the overall TCO; Zero risk, massive user verification; Multi-environment, covering ali Cloud scene. Bcd79bebd901eaa5d94a729dd5add0e63007a6b8 advantage 1: flexible and easy to use, without learning threshold For ali cloud DBS this product, the user from buying to configure to run, basically can complete in only five minutes. As shown below is the whole course of using DBS, first, the user needs to buy a DBS instance, then need to configure your own backup source, the so-called backup source, that is, the user wants to backup which database through DBS, as long as the database connection string and account password is entered, and completes the backup source configuration. In the second step, the customer needs to configure the entire backup target, which is equivalent to backing up the database to OSS via DBS. In the third step, the user needs to configure whether the database needs to back up the entire instance or a single database, and whether to back up a single table or multiple tables. DBS supports the user’s choice of the entire fine-grained backup. In the fourth part, users can set the backup time, because DBS provides full backup and incremental backup. As long as users enable incremental backup, the system will backup in real time. Full backup can be backed up every seven days a week or once a week. The backup frequency and time can be flexibly set based on user requirements. In general, data backups tend to take place during peak business hours, such as between 2am and 5am. The fifth step is to store the backup data to the user’s OSS after the backup is started, so the user needs to store the backup data for how long, when to clean and when to save, Ali Cloud DBS provides global rule Settings. After the user sets these rules, the subsequent operations are automatically completed by DBS. In the whole backup and recovery, Ali Cloud DBS provides a unified Web interface, so that users do not need to switch back and forth between data backup and data recovery work interface. This is the first advantage of DBS, which allows users to be more flexible and easy to use. Users only need simple configuration to run, so the learning cost is low. Ee9916c73d7570154df3d42a39e69e757e1dffc9 advantage 2: high performance, adapt to different size requirements When a user in the first step after configuration is complete copy of plan, the backup began in running state. Aliyun DBS provides full backup and incremental backup, as shown in the left figure below. In full backup, DBS adopts agentless mode, that is, users only need to provide IP address, domain name, account and password for configuration. Throughout the whole amount of backup, backup of DBS provides no lock, its meaning is equivalent to in the process of backup will not affect the user database online business queries above, because everybody knows except the backup database also needs to carry some online business queries, and DBS in the whole process of backup will not affect the online query operations. In addition, Ali Cloud DBS also provides concurrent backup, because when the amount of data in the database is relatively large, concurrent backup can greatly improve the speed of backup. In this process, there are a lot of innovations. For example, Ali Cloud DBS will detect the busy degree of the database, and adjust the size of the fragments when pulling data in full backup, the amount of data to be pulled each time, and the number of concurrent threads. Fe44f797d3810c588182c03e4b7e479b6e09ff2f explained the full amount of the above backup, next to share incremental backup. When DBS performs incremental backup, it captures logs in real time from the database memory. Every time a log is generated, it captures the log and allocates it to the user’s OSS. In this way, real-time incremental backup of data can be realized, and the USER’s RPO can reach the second level or lower. https://yq.aliyun.com/articles/613293?utm_content=m_1000006722