…and if one of the servers in the DRBD pair is having issues receiving packets from … that familiar with, I’d suggest reading over the manual’s description of how replication … in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
… the customer today investigating MySQL over DRBD performance issues. His basic question was why there is so much overhead with DRBD in my case… MySQL over DRBD. Your reads are going to be serviced from local hard drive and it is only writes which suffer overhead of DRBD… which is often going to define your MySQL on DRBD Performance. Lets now see how DRBD works so we can analyze how much…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… we’re comparing here – it is mainly DRBD to MySQL Replication based techniques (lets leave MySQL Cluster and Continnuent alone for a while… 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… reads no 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 definitions
October 9, 2009 By 10 Comments
… MySQL. I have done dozen of MySQL HA related engagements while working for Sun/MySQL over the last couple of years using Heartbeat, DRBD… first DRBD based HA solution nearly 10 years ago. There is quite a lot of confusion surrounding HA solutions for MySQL, I… to improve the availability of a computer service, like a MySQL database. High-availability, HA for short, introduces a wealth…
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
… term – doing failover when not needed, flapping and causing all over mess. Some people also say you should not failover when… is a good approach for larger scale systems. Interested in MySQL and High Availability ? Come to Percona Live NYC taking place… art high availability solutions for MySQL such as Clustrix, Tungsten Replicator, PRM, Percona XtraDB Cluster, MySQL and DRBD as well as many great…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… for a growth that will need sharding (splitting the database over multiple servers), then you might need to take a serious…, average MySQL DBA + good Sysadmin skills Heartbeat/SAN (depends on SAN) High, Good MySQL DBA + strong Sysadmin skills Heartbeat/DRBD High, Good MySQL DBA + strong Sysadmin skills NDB Cluster Very high, Specific NDB knowledge, strom MySQL skills…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… master-slave replication except that you can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this… guaranteed). You don’t get this with shared storage or DRBD, although those provide stronger guarantees against data loss if mysqld… have to be the tools I used — it could be MySQL Proxy or a TCP sniffer or anything else. But if…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… what is the most popular HA solution for MySQL, replication. High Availability solution for MySQL: Replication This HA solution is the easiest… failing over to a slave means no degraded performance associated with caches warm up. Finally, it is well known that with MySQL…, I’ll present another HA solution build around Heartbeat and DRBD.
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… is what a lot of people looked for that days. Over last 10 years Web applications are changed and so are… scale MySQL and get some HA out of the box even on the medium level. Seriously – MySQL Cluster, Continuent, Master-Master Replication, DRBD… see as response to these requirements ? From MySQL side we have further development of MySQL Cluster to be more usable for web…
Comment: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
Florian, Thanks for your interest. Generally I have nothing against DRBD – it is great product which I’ve been using since… MySQL High Availability needs. The reasons are: – Bad memory or MySQL Bugs on Primary can corrupt storage… which will be replicated by DRBD… shops you can do good enough with replication based fail over. Hopefully this will get even better with Integration of Google…
