Hot Standby shell script file mysql1 # cat mysqlbackup. sh #! /Usr/local/bin/fish # The backup policy is daily full backup # set the backup path variable set backupdir/usr/db/backup # generate the backup Directory mkdir-p $ backupdir # Delete the backup time backup for more than one month find $ backupdir/-mtime + 30-type d-delete # Start backup innobackupex -- user = root -- password = 'yue5bkgof $ '-- parallel = 12 $ backupdir/ mysql1 # cd/usr/db/backup/mysql1 # mysql1 # lltotal 442drwxr-xr-x 8 root wheel 512 Mar 1 Mar 8 root wheel 512 Mar 1 Mar 1 Mar 8 root wheel 512 Mar 1 Mar 1 8 root wheel 512 Mar 1 Mar 8 root wheel 512 Mar 1 Mar drwxr-xr-x 8 root wheel 512 Mar 1 Mar 8 root wheel 512 Mar 1 Mar 1 Mar 8 root wheel 512 Mar 2 Mar 8 root wheel 512 Mar 2 Mar 8 root wheel 512 Mar 2 Mar 8 root wheel 512 Mar 2 Mar 8 root wheel 512 Mar 2 am 8 root wheel Mar 2 Mar 2 2013-03-02_12-01-191-19drwxr-xr-x 8 root wheel 512 Mar 2 Mar 8 root wheel 512 Mar 2 Mar 2013-03-02_18-01-13drwxr-xr-x 8 root wheel 512 Mar 2 Mar 8 root wheel 512 Mar 3 Mar 3 8 root wheel 512 Mar 3 Mar 8 root wheel 512 Mar 3 Mar 3 Mar 8 root wheel 512 Mar 3 Mar 8 root wheel 512 Mar 3 am 2013-03-03_15-01-19drwxr-xr-x 8 root wheel 512 Mar 3 Mar 3 AM 8 root wheel 512 Mar 3 2013-03-03_21-01-23drwxr-xr-x 8 root wheel 512 Mar 4 Mar 8 root wheel 512 Mar 4 Mar 8 root wheel 512 Mar 8 root wheel 512 Mar 4 Mar 8 root wheel Mar 4 Mar 4 AM 8 root wheel 512 Mar 4 2013-03-04_12-01-12drwxr-xr-x 8 root wheel 512 Mar 4 Mar 8 root wheel 512 Mar 4 Mar 8 root wheel 512 Mar 5 Mar 4 Mar 8 root wheel 512 Mar 5 Mar 8 root wheel 512 Mar 5 Mar 8 root wheel 512 Mar 5 Mar 8 root wheel 512 Mar 5 am 8 root wheel 512 Mar 5 am _ drwxr-xr-x 8 root wheel Mar 5 Mar 8 root wheel 512 Mar 5 Mar 8 root wheel 512 Mar 5 Mar 2013-03-05_21-01-22drwxr-xr-x 8 root wheel 512 Mar 6 Mar 8 root wheel 512 Mar 6 Mar 6 AM 8 root wheel 512 Mar 6 2013-03-06_09-01-23drwxr-xr-x 8 root wheel 512 Mar 6 2013-03-06_12-01-24 ........................ ...................................