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
Advantage: The dumped databases are in a transaction consistent state
and this is achieved without stopping the MySQL service and allows for
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 RatingBacking up MySQL on a Linux VM,