Sales Hotline: 1-800-691-1991 8am - 8pm ET
English
White paper

Hot backup of MySQL on a Linux VM

Ricky El-Qasem, vExpert and startup warrior

Hot backup of MySQL on a Linux VM
Please rate how helpful this article was to you:
3.9 out of 5 based on 49 ratings
Thank you for helping us improve!
An error occurred during voting. Please try again later.
Published: February, 2009

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!

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!
Please rate how helpful this article was to you:
3.9 out of 5 based on 49 ratings
Thank you for helping us improve!
An error occurred during voting. Please try again later.
About the Author