… that I don’t like DRBD with virtual machines. First is the disk IO performance hit that comes with DRBD. When you run a… set up replication filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate a specific…-based replication, it looks like you’ll need to wait for the next release of MHA. Q: How do you monitor MySQL…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… them. With DRBD you have the choice of killing one of the nodes and re-syncing from another one while with MySQL Replication you can… this with DRBD as this requires logical level of operation to work. This is not to mention other things you can do with MySQL Replication… consistency – MySQL Replication can out of sync – and there is bunch of tips in documentation of how to do it. With DRBD the chance…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… with MySQL is the number of possible HA solutions. From the simplest the most complex let’s list the most common ones: – MySQL replication with manual failover – Master-Master with MMM manager – Heartbeat/SAN – Heartbeat/DRBD – NDB Cluster These technologies are by…
Post: Is DRBD the right choice for me?
July 7, 2009 By 18 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 a manager…
Comment: Is DRBD the right choice for me?
July 7, 2009 By 18 Comments
I think with mk-table-checksum things got a whole deal better – now …’m unaware of any tool implementing it) to use MySQL replication with DRBD used for replication of binary log. In this case in case master… able to catch up the events from the binary log replicated by DRBD before promoting the slave to the master.
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… I would highly consider DRBD which can do storage level replication between directly attached volumes. Now with support for Dolphin Interconnect …use MySQL replication with something as MMM or Flipper. I think this actually works best for most cases (unless async nature of MySQL replication …
Comment: Is DRBD the right choice for me?
July 8, 2009 By 18 Comments
… this comes down to the same argument in my post – “MySQL Replication (with a manager such as MMM) aims to have 100% availability… of DRBD are (online device verification, replication event checksums, fast resync after a node has been offline), and I wish that MySQL Replication had the same features. But it’s fairly easy to emulate most of what you need with tools like…
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… well with all the MySQL storage engines including MyISAM (NDB is a special discussed later) but it suffers from the limitation of MySQL replication…, I’ll present another HA solution build around Heartbeat and DRBD.
Post: Great Talks on Percona Live,NY!, Free Pass opportunity inside
September 7, 2012 By 1 Comment
… for High Availability solutions with MySQL you should consider attending Percona Replication Manager and DRBD for “traditional” Replication and DRBD based approaches to MySQL high availability or… base, developers and DBAs running MySQL in production with extreme performance and availability environments as well as MySQL ecosystem project leaders. You will…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… sharding with requirement to split the data in defined way so cross shard queries become a pain. Dealing with lag in MySQL Replication is… scale MySQL and get some HA out of the box even on the medium level. Seriously – MySQL Cluster, Continuent, Master-Master Replication, DRBD or… and Scalability on the scale of Big Table with Map Reduce. Indeed I think MySQL Replication usage will reduce, but I would not…
