… we’re comparing here – it is mainly DRBD to MySQL Replication based techniques (lets leave MySQL Cluster and Continnuent alone for a while as… transaction loss and automated fail over. Whenever you’re using MySQL Cluster, DRBD or MySQL Replication you have to have some compromises.
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… the most common ones: – MySQL replication with manual failover – Master-Master with MMM manager – Heartbeat/SAN – Heartbeat/DRBD – NDB Cluster These technologies are… choices. Write capacity MySQL replication Fair Master-Master with MMM manager Fair Heartbeat/SAN (depends on SAN) Excellent Heartbeat/DRBD Good NDB Cluster…
Post: Is DRBD the right choice for me?
July 7, 2009 By 17 Comments
… to find customers install DRBD for the wrong reasons. There are many pros/cons to compare DRBD to replication, but I’ve managed to cut down my spiel I give to customers to these two points: DRBD‘s aim (assuming replication mode C) is to provide 100% consistency, and then as much uptime as possible. MySQL Replication (with…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… MySQL, replication. High Availability solution for MySQL: Replication This HA solution is the easiest to implement and to manage. You basically need to setup MySQL replication…, I’ll present another HA solution build around Heartbeat and DRBD.
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
… to its potential. The first glaring problem is single-threaded replication. It is severe and getting much worse as servers get… workarounds? Here are a few I’ve seen: Use DRBD replication instead of MySQL replication. Problem: you end up with an idle standby server…, and is generally not something I personally want to administer (replication is fragile enough… imagine recovering after a crash when you…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… cross shard queries become a pain. Dealing with lag in MySQL Replication is another issue which complicates application development. All of it… scale MySQL and get some HA out of the box even on the medium level. Seriously – MySQL Cluster, Continuent, Master-Master Replication, DRBD or…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… SAN like high availability I would highly consider DRBD which can do storage level replication between directly attached volumes. Now with support… use MySQL replication with something as MMM or Flipper. I think this actually works best for most cases (unless async nature of MySQL replication…
Page: Consulting for MySQL
July 31, 2006 By
… MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication Advanced MySQL Replication consulting including chained and circular replication, bi-directional replication, troubleshooting MySQL Replication performance problems. MySQL…
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
…is new in MySQL, the MySQL roadmap for the future, and bread-and-butter talks about topics such as how replication works, new… and submit those session and tutorial proposals on DRBD, partitioning, community toolkits, security, using MySQL with NoSQL, geospatial functionality, cloud computing, …
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
… writes which suffer overhead of DRBD. If you’re using MySQL with Innodb (and running MyISAM with DRBD makes little sense anyway) you… what DRBD users often prefer as if you can avoid transaction loss why bother with DRBD at all and not use MySQL replication instead… which is often going to define your MySQL on DRBD Performance. Lets now see how DRBD works so we can analyze how much…
