Shulou(Shulou.com)06/01 Report--

Sort out the data backups encountered in your work

Method 1: use Ali Cloud to back up the database

Aliyun has automatic backup feature, and there is a snapshot feature in the control center, which is used for automatic backup and recovery. Ali Cloud server automatically backs up system disk and data disk every day. If the server is *, you can borrow the snapshot feature to restore every drive letter quickly. The figure below is as follows

In addition, you can create snapshots, a total of 12 snapshots can be created free of charge, without occupying our data disk. If we need to restore the data, we just need to go to the snapshot backup and select the snapshot that needs to be rolled back directly to restore the data.

The overall advantages of snapshot backup are more prominent, but the disadvantages are also more obvious, can not backup and restore part of the data; in addition, the concept of disaster preparedness can not be realized. Therefore, in order to ensure the security of data, we can also use the disaster recovery backup function of multi-backup. To enter the Ali Cloud market, you can use the service of multiple backups in the server accessibility section. As shown below:

In addition, it is possible to back up the data on the CVM locally, and you can download it directly using the FTP tool.

Method 2: link ECS to backup the URL,AWS database of the database in the same way, and use mysqldum for backup

Database backup:

Mysqldump-usports_db-pqwer1234asdf0-hsports.c2tkk4l0ki3z.us-west-2.rds.amazonaws.com sports_sns > / tmp/AA.dmp

Export the table structure of the database:

Mysqldump-uhehe-p-d sports-sns.cd8tn8.rds.cn-north-1.amazonaws.com.cn sports_sns > / tmp/yan_tabledb.sql

Show tables

Database slow log query:

Select count (*) form slow_log

Method 3: full and incremental testing with xtraback,Mysql backup tool xtraback

Xtrabackup is an open source project of percona that can hot back up innodb, XtraDB, and MyISAM (lock tables).

Official website http://www.percona.com/docs/wiki/percona-xtrabackup:start

Xtrabackup is an open source software developed by percona, which can be said to be an open source alternative to ibbackup, a hot backup tool for innodb. The software is made up of two parts: xtrabackup and innobackupex. Xtrabackup is dedicated to innodb engines and xtraDB engines, while innobackupex is dedicated to myisam and innodb engines, as well as mixed-use engines.

Specifically refer to the following Daniel's technical blog: this is not used and have time to study later.

Http://blog.chinaunix.net/uid-25266990-id-3314699.html

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.