Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I am trying to design a MySQL database backup and recovery policy (Linux OS) for my company. I am looking at the LVM snapshot as a full backup solution plus binary logs rotation as an incremental.

My environment is as following:

  • XenServer 5.6 connected to HP SAN using iSCISI interface

  • VMs are running under CentOS or RedHat with LVM installed

What I am wondering is what kind of potential impact should I expect of using LVM snapshots? I have heard that people are using LVM for/as MySQL full backup solution but on the other hand I have heard about some issues such as I/O or CPU overheads.

Any comments will be appreciated, thanks in advance.

share|improve this question

1 Answer 1

LVM snapshots have a huge negative impact on I/O performance. A better way to backup mysql is to replicate to a slave. When you need to perform a backup stop replication, do the backup, and then restart replication.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.