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.

See also

Veeam Community Forums: Best Practice for Backing Up Linux VMs

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

View posts related to category:

All Veeam Products Top List
Technology Bloggers on Air