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.

R1soft's CDP doesn't currently work on MySQL databases inside a Virtuozzo container.

Is there any backup software that offers the same kind of 'continuous data protection'?

An alternative to this would be a host that provided just MySQL hosting with CDP installed, if anyone knows of such a service this would be ideal.

Thanks in advance.

share|improve this question

1 Answer 1

Well you need a modified kernel to perform such kind of things as "volume snapshotting" and it's not possible to modify the kernel when you are in a container. Although it is still possible to perform a hot backup of the MySQL DB if all your tables use InnoDB storage, check Percona's xtrabackup tool, it's exactly for that.

share|improve this answer
    
Ok, unfortunately some of the tables are MyISAM... –  rgvcorley Aug 8 '12 at 11:34
    
If you don't use native MySQL full text search you can convert them to InnoDB easily (and I strongly recommend to do it because MyISAM storage is just not crash safe). Please note that conversion process locks tables so they are effectively offline during conversion phase so it's better to perform the conversion as soon as possible while you don't have much data. –  Alex Aug 8 '12 at 11:38

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.