… were publicly announced before. Somewhere in 6.x series proper performance monitoring instrumentation and semi-synchronous replication is promised together with… from MySQL Marketing Materials . There is not much of technical insight otherwise – pretty simple site, master slave replication, plans to use DRBD… dealing with High Performance. Though I’d really like them to see to have some work done outside of MySQL Cluster – for…
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 …don’t get this with shared storage or DRBD, although those provide stronger guarantees against data …! The insert buffer can also cause terrible performance. There are some subtleties about exactly what’…
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… slave means no degraded performance associated with caches warm up. Finally, it is well known that with MySQL, altering a table means…, I’ll present another HA solution build around Heartbeat and DRBD.
Comment: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… MySQL High Availability needs. The reasons are: – Bad memory or MySQL Bugs on Primary can corrupt storage… which will be replicated by DRBD – Long switch time even for Innodb tables – on large system tuned for performance filesystem recovery from journal…. You can shorten it sometimes (not always) but will pay performance. – Pretty much unusable for MyISAM tables which may take infinity…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
… reduce the downtime. I agree that for good performance, data needs to be in memory but… that … 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: Thoughts on MySQL Replication
July 9, 2006 By 18 Comments
Apachez, DRBD is great solution but for a bit different problem. It also does replication f course but unlike with MySQL replication… but not much of extra performance. DRBD however could be used together with MySQL Replication to increase High Availability – MySQL Replicaion is asynchronous so… to the new box. The other way you can apply DRBD is to create network backup of your MySQL server completely live.
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… of choosing the best (performance-wise) solution. I don’t dispute how helpful the built in functions of DRBD are (online device verification, replication event checksums, fast resync after a node has been offline), and I wish that MySQL…
Comment: When would you use SAN with MySQL ?
March 10, 2009 By 18 Comments
Peter, “MySQL also has broken group commit (which we have partial fix … DRBD, don’t we usually advise only to keep the binlog on DRBD to avoid the most significant parts of the performance penalty…
Post: How reliable RAID really is
June 30, 2006 By 13 Comments
… about MySQL Performance or about Performance at all, but I guess it should be interested to many MySQL DBAs and other people involved running MySQL…’re doing. In SCSI BIOS there is an option to perform “Verify Media” which can be used to scan hard drive… with Instant recovery – could be interesting to try to integrate DRBD with LVM so snapshot could be taken and synchronized to…
Comment: Finding your MySQL High-Availability solution – The questions
October 17, 2009 By 36 Comments
… performance in my opinion especially if you talk about putting SSD on the local servers. There are three types of failures: * mysql… and causes the server to lose 99% of it’s performance this is much more difficult to correct automatically. Our downtime… restore times. I have heard of several horror stories with DRBD with the data being corrupted on the master then corrupting…
