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

For databases less than 1G, use mysqldump

For databases larger than 1G, use xtrabackup

Backup strategy

# mysql backup at 2019-01-09 by dba, backup every day at 2: 00 a.m. #

0 2 * / bin/sh / data/scripts/mysql_backup.sh > / dev/null

# mysql backup at 2019-01-09 by dba, one backup each at 10:00 and 22:00 every night #

0 10 bin/sh 22 * / bin/sh / data/scripts/mysql_backup.sh > / dev/null

# mysql backup at 2019-01-09 by dba, backed up every 4 hours #

0 * / 4 * / bin/sh / data/scripts/mysql_backup.sh > / dev/null

# mysql backup at 2019-01-09 by dba, backup every 6 hours #

0 * / 6 * / bin/sh / data/scripts/mysql_backup.sh > / dev/null

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.