0

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.

Improve this question

1 Answer 1

Reset to default
0

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.

Improve this answer
3
  • Ok, unfortunately some of the tables are MyISAM...
    – rgvcorley
    Commented Aug 8, 2012 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
    Commented Aug 8, 2012 at 11:38
  • Use innobackupex - it will use xtrabackup for innodb and cp (or rsync if you specify option) for myisam
    – Arek B.
    Commented Sep 28, 2015 at 12:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .