Group items tagged

Both MySQL Cluster and MultiMaster replication give you constant access to your data on more nodes . For lots of shops, those not needing to scale, those that can live with a limited downtime, DRBD and MySQL is a good match, But if you want to achieve real high availability as compared to less downtime. or if you are looking to scale your MySQL and want to benefit from HA while you are at it , then MultiMaster is probably the preferred alternative as opposed to DRBD

The side question about it is of course the fact you have to be picky about storage engines you’re using - DRBD does not work with MyISAM (check required) so you need to have processes to ensure your application does not uses this storage engine which may be hard to guaranty in many environments when development has too much autonomy

The state of High Availability Solutions for MySQL these days is - you can’t have it all. There is no OpenSource solution out where which would offer you full redundancy use of both nodes at least for reads no transaction loss and automated fail over. Whenever you’re using MySQL Cluster, DRBD or MySQL Replication you have to have some compromises.

Testing InnoDB and MySQL 5.1 performance in real workload conditions