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!

Featured Resources:

Related Articles:

Veeam 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.

White Papers

    Amazon AppStream 2.0 Developer Guide

    This is official Amazon Web Services (AWS) documentation for Amazon AppStream 2.0. This documentation is offered for free here as a Kindle book, or you can read it online or in PDF format at https://aws.amazon.com/documentation/appstream/. Amazon AppStream 2.0 is a fully managed, secure application streaming service that allows you to stream desktop applications from AWS […]


      FREE eG Enterprise Logon Simulator for Citrix XenApp and XenDesktop

      Fast, free and incredibly useful. Coming in summer 2017. 14Synthetic logon simulation tool for monitoring, diagnosis, alerting and reporting of Citrix logon performance Quick SaaS deployment – be up and running in minutes Web-based monitoring console Supports logon through StoreFront or NetScaler Gateway Best-suited for Citrix XenApp 6.5, 7.x and XenDesktop 7.x Free forever, no […]

      On-Demand Webinars

        Closing the Visibility Gap | How to Combine Application & Infrastructure Monitoring to Accelerate IT Transformation – On-Demand Webinar

        Citrix Performance Monitoring Solutions What leaves visibility gaps and demands higher levels of time and expertise from IT professionals? Having different consoles for application code visibility vs. IT infrastructure management. The convergence of application and infrastructure monitoring offers significant opportunities to drive IT transformation using IT service management, DevOps and/or a combination of both. Watch […]

        Latest Videos

          Windows Insiders Video | Windows 10 Fall Creators Update Bug Bash

          We are excited to announce Windows 10 Fall Creators Update Bug Bash. Thank you for your help in shaping Windows. Your feedback goes a long way and our developers are actively working on fixing issues based on what we hear from you. We want to welcome both new and returning users in joining us for […]

          Views All IT News on DABCC.com
          Views All IT Videos on DABCC.com
          Win a Tesla P100D

          Visit our Sponsors!