Re: Replication MOP´s
Posted by: Peter Brawley
Date: December 26, 2019 11:20AM

If the versions and OSes are identical and all tables are InnoDB, a cold (physical copy) backup is reliable: Do a error-free server shutdown. Copy all ibdata files and .ibd files, .frm files for InnoDB tables, ib_logfile files, and my.cnf/ini to a safe place.

If you have the Enterprise edition, Hot backup: Use the mysqlbackup tool in MySQL Enterprise Backup.

On Linux systems LVM afteran error-free shutdown:
https://www.lullabot.com/articles/mysql-backups-using-lvm-snapshots
https://dba.stackexchange.com/questions/72946/is-it-safe-to-copy-db-files-directly-from-an-lvm-snapshot

XtraBackup from Percona: http://www.percona.com/doc/percona-xtrabackup/innobackupex/creating_a_backup_ibk.html

Options: ReplyQuote


Subject
Written By
Posted
December 26, 2019 10:35AM
Re: Replication MOP´s
December 26, 2019 11:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.