… is not lagging. Unfortunately, that’s often not sufficient for failover during peak traffic. The standby server does not process query… have recently accessed pages. When it starts handling queries after failover, the lower cache hit rates can lead to outages. Specifically… or insert statements that have duplicate key errors may be faster than an actual database write. The slow logs were split…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… is probably the best general-purpose way to get fast failover and a bunch of other benefits (non-blocking ALTER TABLE… have to handle if there’s a planned or unplanned failover. This isn’t a big problem on small systems, but… TCP sniffer or anything else. But if you need fast failover, you need some way to at least partially emulate a…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… have some databases that don’t need scale-out or failover capability. For example tables used for logging less critical information… modes on successive queries. Q: Is RBR faster replicating vs SBR replication? RBR is faster than statement based, correct? A: Often that’s true, Row-Based Replication (RBR) can be faster than Statement-Based Replication (SBR). But there are exception cases…
Post: Finding your MySQL High-Availability solution - The definitions
October 9, 2009 By 10 Comments
… of your solution and the higher its cost. Recovery/failover Recovery (or failover) is the process by how a HA setup recovers… human intervention. Once again, although they are some exceptions, faster and automatic recovery usually means higher costs. Cluster A bunch…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…Concurrent Innodb data file extension – Non-Recursive Deadlock Detection – Faster Locking Primitives – Improved Innodb Thread Concurrency – Multiple …Improved Logging for Row based Replication – Replication Utilities for Failover and Admin Transparency – Many new INFORMATION_SCHEMA Tables – …
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
Few months ago, I wrote about a faster way to do certain table modifications online. It works well … a failover. There are two ways to do it: 6. Allow replication to catch up This can be slower or faster method…
Comment: Thoughts on MySQL Replication
July 9, 2006 By 18 Comments
… it. It seems that it can only be used for failover though. Note that the IO for DRDB happens BEFORE the… (on MyISAM) will use locks longer but this can be faster than doing smaller transactions. Bulk inserting records with mulitiple values…
Comment: Making the impossible: 3 nodes intercontinental replication
August 30, 2012 By 29 Comments
…) I guess in WAN case you could use DNS-based failover, which is analogous to VIP moving. However in your case… regular MySQL slave. Except that it can do it much faster thanks to parallel applying.
Post: Percona is hiring performance experts
February 13, 2009 By 2 Comments
… my application and tell me how to make it run faster. You are responsible for day-to-day operations of my… my IT team at your disposal. Please set up redundant failover and good backups! We all work remotely, from our homes…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… TABLE — a typical reason to think about master-master with failover and failback for maintenance. As with anything, it’s a… are a lot of other ways you can make replication faster. I wrote a lot about this in our book…
