… was if the filesystem on top of DRBD was fried beforehand. Let us again compare MySQL Replication to DRBD in this case – in… from running two databases on two servers on two DRBD devices laid out in a “criss-cross†fashion, converging on one node in… maintenance on cold standby database.” But you can do anything you want with a database that you run off a DRBD LVM snapshot. Works on…
Comment: Living with backups
November 6, 2008 By 28 Comments
… always taken via lvm snapshot on the passive node of my DRBD cluster. I think of it like this – The I/O on both nodes… passive node I don’t interfere with any application reads on the active node. I also know that I don’t… I’m copying the backup off – the outward facing NIC on the passive node isn’t used by anything else. Of…
Comment: MySQL Replication vs DRBD Battles
April 29, 2008 By 12 Comments
… an lvm snapshot of the DRBD secondary node. Surely you can. If DRBD sits on top of LVM, then you snapshot the LVM and you get a snapshot of the blocks on the drbd device. Whether DRBD is in…
Comment: MySQL Replication vs DRBD Battles
April 29, 2008 By 12 Comments
…. I would add another point: Backup from slave / secondary. With DRBD this is hard / impossible in many situations. We use both, replication and DRBD in production. One database which is doing nothing but “spooling” working sets runs on DRBD (no slave lag… using DRBD here too but did not do it because we’d loose the ability to do “online schema change” or LVM snapshot…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…to the slave (as described) or standby server via DRBD or SAN. As you can see we never …recover master you need to recover slaves to matching snapshot – either it has to be same state (which is…LVM setup if you want to avoid shutting off slave or master to clone the data and making sure the logs on…
Post: How reliable RAID really is
June 30, 2006 By 13 Comments
… failure in RAID. It is good to run consistency checks on regular basics anyway but this final run would not hurt… more reason to scale out and keep managable size storage on each node. At least multiple smaller RAID volumes could be… to integrate DRBD with LVM so snapshot could be taken and synchronized to network as backup. If quick recovery is needed snapshot could be…
Comment: When to use Hardware upgrade instead of Software Optimization
December 7, 2008 By 5 Comments
… are helpful for some workloads but bad for others. Regarding snapshotting LVM works pretty well if it is setup properly. You have… server… I prefer to design systems there is never dependency on single copy of data. You can get tables corrupted because… etc) – so I would rather keep the slave or DRBD partition on the other node which can be used for failover. Though…
