…and if one of the servers in the DRBD pair is having issues receiving packets from…other two NIC ports should be bonded with active-backup or LACP (depending on your switching …in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db …
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this…’t get this with shared storage or DRBD, although those provide stronger guarantees against data… the traffic on the active master: mk-query-digest –processlist h=active \ –filter ‘$event->{arg} =~ m/^SELECT…
Page: Consulting for MySQL
July 31, 2006 By
…. MySQL High Availability design and implementation Design of High Availability architecture which matches your application needs using MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication Advanced MySQL Replication consulting including chained…
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… Marketing side perhaps the speaker kept quoting benefits of MySQL Enterprise from MySQL Marketing Materials . There is not much of technical insight otherwise – pretty simple site, master slave replication, plans to use DRBD… Brian Aker which normally takes part in all Storage Related activities. There were some Q&A about various storage engines – mostly…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… growths load changes or you happen to have failure during activity of certain kind you might have it taking much longer… DRBD do not spread too wide. So when I would recommend to use DRBD with MySQL ? There some good reasons to use DRBD with MySQL… are got use to SAN based high availability solutions with active-passive management software. Quite often these guys would have be…
Post: Data Corruption, DRBD and story of bug
November 29, 2010 By 6 Comments
… use DRBD for HA purposes ( as is in the case I worked with), you screwed, as DRBD mirroring physical data, and MySQL keeping crashing on both instances – active and passive. So DRBD can’t be considered…. It has MySQL version 5.6, but the problem exists in MySQL 5.1.50 or below and in MySQL 5.5, and…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… managing a lot of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding or replication IO… to using SAN based active-passive clusters for availability purposes and they look to do the same with MySQL. This works though… you want SAN like high availability I would highly consider DRBD which can do storage level replication between directly attached volumes…
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 will have to care about background random IO coming from buffer flush activity – which… which is often going to define your MySQL on DRBD Performance. Lets now see how DRBD works so we can analyze how much…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
… that about the same with InnoDB, at least the active dataset needs to be in the Buffer Pool. … different ways of replicating data, from my experience, DRBD is more reliable than replication. It is also …you use SSL between your application servers and your MySQL servers? 2.9 Good point and yes, this …
Comment: Living with backups
November 6, 2008 By 28 Comments
…via lvm snapshot on the passive node of my DRBD cluster. I think of it like this – The … I think everyone shares the risk that a catastrophic activity can occur during a backup. As far as …have a wrapper around mylvmbackup that looks for the mysql socket and exits gracefully if the socket exists. …
