… another point: Backup from slave / secondary. With DRBD this is hard / impossible in many situations. We use both, replication and DRBD in production…” working sets runs on DRBD (no slave lag, 100% sure all transactions are there, no need to backup this database). The main database is configured in Master-Master replication fashion. We evaluated using DRBD here too but…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… described) or standby server via DRBD or SAN. As you can see we never mentioned recovering from backup so far. It will… ensure you understand the position on the master to which backup corresponds to. This becomes more complex if you have complex… reclone slave from the master, another slave or restore from backup. So this is just question of having decent capacity planning…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…manual failover – Master-Master with MMM manager – Heartbeat/SAN – Heartbeat/DRBD – NDB Cluster These technologies are by far, not a …that includes extensive testing, fire drills, full documentation, monitoring, alerting, backups, migration to production and post migration monitoring. Of course, it…
Comment: Data Corruption, DRBD and story of bug
November 30, 2010 By 6 Comments
… recovery from backup is needed. Some people need to ensure even database/OS/FS bugs causing corruption and replicated by DRBD are not causing downtime – for these guys DRBD alone is not solution, so they… down… one can resort to long recovery by use of backups.
Comment: Thoughts on MySQL Replication
July 9, 2006 By 18 Comments
… gives you high availability but not much of extra performance. DRBD however could be used together with MySQL Replication to increase… transactions could be lost. However if master is replicated by DRBD you can avoid loosing any tranactions. It also greatly simplifies… to the new box. The other way you can apply DRBD is to create network backup of your MySQL server completely live.
Post: How reliable RAID really is
June 30, 2006 By 11 Comments
… backups. Do not trust to any single piece of hardware in HA scenarios. Have backups ready. If you care about your data backups… deal especially for offline drive. Backups with Instant recovery – could be interesting to try to integrate DRBD with LVM so snapshot could be taken and synchronized to network as backup. If quick recovery is…
Post: Why you can't rely on a replica for disaster recovery
July 31, 2010 By 25 Comments
…) get qualified advice and 2) don’t trust the advice; backups and disaster recovery plans must be tested periodically. This case… used. In this case it’s block-level SAN replication. DRBD would behave just the same way. At a higher level… and drop the table off your “backup.” I still see people using a replica as a backup, and I know it’s…
Comment: Living with backups
November 6, 2008 By 28 Comments
My backups are always taken via lvm snapshot on the passive node of my DRBD cluster. I think of it like this… course, I haven’t experienced any node failures during the backup process. But I think everyone shares the risk that a catastrophic activity can occur during a backup. As far as implementation is concerned, I just have a…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… you want SAN like high availability I would highly consider DRBD which can do storage level replication between directly attached volumes… with low overhead allowing to take a backups conveniently. Also if you keep last uncompressed backup on SAN (or last snapshot) you… able to minimize recovery time significantly by switching to that backup – no data copy will be required which can be significant…
Comment: Data Corruption, DRBD and story of bug
November 30, 2010 By 6 Comments
“DRBD can’t be considered fully reliable HA solution if there is risk that application corrupts data by itself.” In other news, DRBD does not replace backup (RAID doesn’t either). And, when is there ever no (I mean zero) risk that an application corrupts data?
