Note: "permalinks" may not be as permanent as we would like,
direct links of old sources may well be a few messages off.
Ross S. W. Walker schrieb: > As the subject says I want to know if it is possible to use DRBD and LVM > snapshots to create a point-in-time replica? > > This would allow me to rotate snapshots in a pattern that would provide > the best consistency/coverage for my needs. > Hello ! I do this on a server pair with DRBD 8.0pre6 under XEN. I think you will have to use DRBD 8.X because only later DRBD Versions claim to run without problems on top of LVM Volumes. I snapshot the underlying LVM Volumes readonly and do rsync style rotating Backups with the help of dirvish (http://www.dirvish.org/). To have consistent backups of my MySQL Databases I have a small perl-skript that runs before the backup which commits a "FLUSH TABLES WITH READ LOCK" to the MySQL Database. After the skript has taken the LVM Snapshot via "system" calls I do "UNLOCK TABLES" so the tables are unlocked. Usually this takes about 1-3 seconds and sessions that attempt to write to MySQL wait longer for response so that only a short lock can be detected. Bye -- __________________________________________________ Ralf Schenk fon (02 41) 9 91 21-0 fax (02 41) 9 91 21-59 rs at databay.de Databay AG Hüttenstraße 7 D-52068 Aachen www.databay.de Sitz/Amtsgericht Aachen HRB:8437 USt-IdNr.: DE 210844202 Databay - einfach machen. _________________________________________________ Diese E-Mail und etwa angehängte Dateien enthalten vertrauliche Informationen und sind ausschließlich für den Adressaten bestimmt. Sollten Sie irrtümlich diese E-Mail erhalten haben, bitten wir Sie, uns darüber unter info at databay.de zu informieren und die E-Mail ungelesen an uns zurückzusenden und aus Ihrem System zu löschen. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify info at databay.de. If you are not the named recipient, you should return this message without reading further and delete it from your system.