A question commonly asked is how can you quiesce MySQL databases when running on a Linux VM? Since Linux doesn’t have a VSS mechanism like Windows does, it’s not as straight forward as a Microsoft SQL quiescence. On of Veeam’s Systems Engineers, Ricky El-Qasem, has written a white paper on the subject and it’s available now for download from the Veeam website. The white paper describes 2 different options/methods for running pre and post snapshot scripts using VMware tools installed on the Linux VM.

Here’s a quick preview:

Option 1. Suspend MySQL service

The MySQL service is stopped for a few seconds while the snapshot is created then
started again and is described in Method 1.

Advantage: It's quick and easy and will allow you to take a transaction of
all databases without additional disk usage local to the MySQL server.

Disadvantage: For a brief period of time no databases running on the
MySQL server will be available which may not be suitable for applications
that need 100% uptime.

Option 2. Use Online Dump

An online dump of each database is taken using the mysqldump command which
copies a database to storage accessible from the MySQL server and is described in
Method 2.
Advantage: The dumped databases are in a transaction consistent state
and this is achieved without stopping the MySQL service and allows for
100% uptime.
Disadvantage: Extra storage space is required to maintain a second copy
of the database and process may take a considerable amount of time to
achieve depending on the size of your databases.

GD Star Rating
loading...
Backing up MySQL on a Linux VM, 3.2 out of 5 based on 10 ratings

View posts related to category:

    Veeam Availability Suite — Download free 30-day trial

    Doug Hazelman (VMDoug)
    Author: Doug Hazelman (VMDoug)

    Doug Hazelman is Vice President, Product Strategy, Chief Evangelist. Doug consults with customers, partners and industry analysts on key considerations for implementing virtual server infrastructures. He works with Veeam’s R&D team to enhance and develop new Veeam products to address market needs, and advises customers... 

    Published: November 27, 2009