…free space info is corrupt. InnoDB: You may need to dump your InnoDB tables and recreate the …corrupts data by itself Now to bug 55981. It has MySQL version 5.6, but the problem exists in MySQL…it is not DRBD problem, DRBD basically can’t help if there is possibility that application corrupts data by…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… small MySQL installations or managed hosting provider. For large MySQL web MySQL installations … time if Innodb or MyISAM tables are used. There is read-…a glitch causing failure and data corruption (and this is not just a… availability I would highly consider DRBD which can do storage level …
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
…nodes and of course doing alter tables. For alter tables, only replication can reduce the …corruption ones. Looking at the other downtime reasons you are giving, most of them would have covered by Heartbeat/DRBD…SSL between your application servers and your MySQL servers? 2.9 Good point and yes…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… are not yet in the stock MySQL. Yet another way is using DRBD to get a standby MySQL server or at least synchronously… deal with. If you have just one or several small tables corrupted you can reload them. One option is to reload them…) – for example you may have master or relay binary log corruption. Master or Slave running out of space, Slave crashing (and…
Comment: Finding your MySQL High-Availability solution – The questions
October 17, 2009 By 36 Comments
…state. * mysql server crash due to a new bug * mysql server crash due to innodb corruption. …rebuilding your tables occasionally (on the secondary) and also rebuild them after upgrades. Corrupt data …horror stories with DRBD with the data being corrupted on the master then corrupting the secondary. …
Comment: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… most MySQL High Availability needs. The reasons are: – Bad memory or MySQL Bugs on Primary can corrupt storage… which will be replicated by DRBD – Long switch time even for Innodb tables – on large…
Post: Why you can't rely on a replica for disaster recovery
July 31, 2010 By 25 Comments
…MySQL system, and there was a failover that didn’t work; both the primary and fallback machine had identically corrupted…DRBD would behave just the same way. At a higher level, MySQL replication has the same weakness. If you rely on a MySQL… replicate over and drop the table off your “backup.” I still…
Comment: When to use Hardware upgrade instead of Software Optimization
December 7, 2008 By 5 Comments
… can get tables corrupted because of MySQL bugs (or filesystem, hardware etc) – so I would rather keep the slave or DRBD partition on the…
