Replication is something that protects against hardware errors, for example, a hard disk crashed.īackup - protects against software errors, for example, due to the human factor, data has been deleted from a table. Logs that will enable you to recreate the slave in the event of aįinally, you should copy backup files to another physical disk on the same to recover from disk failures or to another physical server to easily recover from complete server failures. Using the rawĭata files option also means that you can back up the binary and relay Inefficient, you can back up the raw data files instead. Details are explained on MySQL documentation.įor larger databases, where mysqldump would be impractical or It is basically a process of copying data and log files from disk. Since your data is big or will get bigger, it is recommended to backup raw data files.
During backup on your replication server, your main master database will be running.
Get mysql enterprise backup install#
If you are looking for a free solution with MySQL community edition, then you can install another replication server and either run mysqldump to take backup or make a raw data backup. It offers the most efficiency and flexibility whenīacking up InnoDB tables, but can also back up MyISAM and other kinds MySQL Enterprise Backup: A licensed product that performs hot backups This is a licensed product sold on Oracle store. The ideal backup solution will be to use MySQL Enterprise Backup.
MySQL backup methods are documented on MySQL documentation.
0 kommentar(er)
