Home Applications Hot Backup of MySQL on a Linux VM From a Linux Guest Virtual Machine

Hot Backup of MySQL on a Linux VM From a Linux Guest Virtual Machine

Hot Backup of MySQL on a Linux VM From a Linux Guest Virtual Machine

As more organizations move to virtualization to facilitate core infrastructure, they look to the eco-system vendors to provide necessary core services, such as backup. Who better to help them meet those requirements than the virtualization vendors themselves? This document describes the process required to take a consistent backup of MySQL running in a Linux virtual machine guest.

VMware enhanced the ability to take offline snapshots for the backup of virtual machines with the advent of VCB (VMware Consolidated Backup) and more recently the vStorage API for data protection. These tools allow third-party vendors to make use of API calls to produce LAN-free consistent snapshots of virtual machines. This is achieved by providing a block list to the backup proxy allowing for access of the virtual machine’s disk subsystem. The block list is presented across a Storage Area Network (SAN)/ Network Attached Storage (NAS), Fibre channel, ISCSI or NAS, allowing backup I/O to occur away from the production LAN orientated traffic. The result of these API calls is an Agentless live image-level copy of the virtual disks, or an Agentless file-level mount of the virtual disks. With Microsoft database centric applications like Active directory, SQL and Exchange a transaction consistent backup of these applications is possible with the use of Microsoft Volume Shadow copy Services aka VSS. During backup and at the point the snapshot is created, backup vendors are able to interface with VSS to place these applications in a temporary consistent state just for the period of the snapshot creation. Unfortunately MySQL is not VSS aware especially in a non-Microsoft operating system like Linux so a new approach has to be taken to produce a transaction consistent backup of MySQL databases.

Written by:
Ricky El-Qasem
Senior Systems Engineer
Veeam Software

Download White Paper NOW!


Veeam Software, a VMware Technology Alliance Premier partner, helps organizations safeguard their investment in virtual infrastructure by providing innovative systems management software designed to reduce costs, increase productivity and mitigate risk. Veeam is an international company with U.S. headquarters in Columbus, Ohio and European headquarters in London, UK. The company was founded in 2006 by the team previously behind Aelita Software, well known for its award-winning Windows Server management solutions. In 2008, Veeam acquired nworks, adding enterprise management connectors that bridge the gap between VMware virtual infrastructure and enterprise systems management tools from Hewlett-Packard and Microsoft. Veeam is rapidly expanding its presence and its partner network around the world, and will continue to offer innovative and practical solutions to help IT professionals better manage their virtual infrastructure. Today the company focuses on managing VMware servers, but as customer requirements grow, Veeam will support other virtual environments. With its drive for innovation, strong investment in R&D, and extensive product line, Veeam is well positioned for continued success.

Share your view, leave a comment below:

Featured Resources:

Related Articles:


White Papers


      On-Demand Webinars

        Latest Videos

          Views All IT News on DABCC.com
          Views All IT Videos on DABCC.com
          Register Today for Disrupt End User Computing Forum 2018

          Visit Our Sponsors