Advertisement
Guest User

Untitled

a guest
Oct 4th, 2016
156
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. Backup myisam db:
  2. 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
  3.  
  4. Backup innodb db:
  5. innobackupex --user=root--password=<passwd> --host=127.0.0.1 --parallel=4 /data/backup
  6.  
  7. Backup galera:
  8. innobackupex --user=root--password=<passwd> --host=127.0.0.1 --galera-info --parallel=4 /data/backup
  9.  
  10. Restore:
  11. service mysql stop && rm -rf /var/lib/mysql/*
  12. innobackupex --apply-log /data/backup/<backup-data> --use-memory=4G
  13. innobackupex --copy-back /data/backup/<backup-data> --parallel=4
  14. chown -R mysql:mysql /var/lib/mysql/ && service mysql start
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement