Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Backup myisam db:
- innobackupex --user=root--password=<passwd> --host=127.0.0.1 --parallel=4 --lock-wait-timeout=180 --lock-wait-threshold=20 --lock-wait-query-type=all --kill-long-queries-timeout=20 --kill-long-query-type=all /data/backup
- Backup innodb db:
- innobackupex --user=root--password=<passwd> --host=127.0.0.1 --parallel=4 /data/backup
- Backup galera:
- innobackupex --user=root--password=<passwd> --host=127.0.0.1 --galera-info --parallel=4 /data/backup
- Restore:
- service mysql stop && rm -rf /var/lib/mysql/*
- innobackupex --apply-log /data/backup/<backup-data> --use-memory=4G
- innobackupex --copy-back /data/backup/<backup-data> --parallel=4
- chown -R mysql:mysql /var/lib/mysql/ && service mysql start
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement