MySQL requires a specific approach to transaction-consistent database backup, especially in a non-Microsoft operating system like Linux. If you are administering virtualized Linux VMs and looking for guidelines to protect your critical data, this white paper will provide you with scripting examples and best practices.
This white paper describes how to back up a Linux VM using activated scripts local to the MySQL database. In the VMware environments, scripts can perform some actions before and after the VM snapshot creation, thus enabling hot backups of running VMs. To achieve database consistency, you can chose whether to suspend the MySQL service or use an online dump of each MySQL database.
This guide discusses advantages and disadvantages of both options and gives detailed instructions on how to use each method. You will get scripting examples for VMware tools installation on your Ubuntu server and learn to create pre-freeze and post-thaw scripts.
Read this FREE step-by-step guide and learn how to:
- Prepare your infrastructure for backup
- Create scripts for hot backup with Linux and MySQL command-line
- And much more!