… up all pros and cons. I would add another point: Backup from slave / secondary. With DRBD this is hard / impossible in… lag, 100% sure all transactions are there, no need to backup this database). The main database is configured in Master-Master… (26G buffer pool). So it would not even be a cold stand-by but a frozen one. 
So all the pros…
Comment: MySQL Replication vs DRBD Battles
April 29, 2008 By 12 Comments
Post: Here's a quick way to Foresee if Replication Slave is ever going to catch up and When!
August 29, 2012 By 11 Comments
… fixed, other times new replication slave is built from a backup which is normally hours behind, or, it could be that… restarted the server, or started a new one, caches are cold and there’s a lot of IO happening, Not all… checksum – these are usually very intense and cause slave to backup slightly. I didn’t like my own answer to The…
Comment: Living with backups
November 6, 2008 By 28 Comments
… impression that cold binary backups have to be done with MySQL off in order to get useable data for a backup. I don…
Post: On Benchmarks on SSD
July 14, 2010 By 4 Comments
… but up-down. The database just after start is in “cold state” and you need to make sure you have enough… afterward. The similar issue is when you restore database from backup, run benchmark, and remove files. That it may happen during…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… lose data Caches on failover slave are not cold Online schema changes Low impact backups Automatic failover with replication I already mentioned…
