White Paper

Hot backup of MySQL on a Linux VM

Ricky El-Qasem, vExpert and startup warrior

Read now Read now

Register to download

Sign in or register

with your social account to get immediate access to all free products and resources

Hot backup of MySQL on a Linux VM

How helpful is this article: 4 / 5 (49 votes cast)

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!
Read now

About the Author

Register to download

Sign in or register

with your social account to get immediate access to all free products and resources