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:

All Veeam Products Top List
Technology Bloggers on Air