… our MySQL Support customers ask is Replication Lag. The story is typically along the lines everything is same as before and for some unknown reason the slave is started to lag…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
… result in low hanging fruit troubleshooting MySQL Replication Lag First fact you absolutely need to remember is MySQL Replication is single threaded, which means if… is best to avoid INSERT … SELECT going through replication in 5.0 for many reasons (locking, long query time, waste of execution on…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
… multiple reasons why application falls behind and why we see those lag spikes: Slave Server Load – MySQL Replication goes in…lag spike. For example MyISAM slaves used for long reporting queries can have queries running for hours which stalls replication progress for this time. As MySQL Replication…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…for 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…MySQL replication link between the servers. Replication often break for various reasons and while replication… lagging …
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…Replication flow: [1] When you setup MySQL replication, you define the global variable server_id, this value must be unique for… for example the case if you re using MMM with slaves. But if for one reason that…You can see the CPU usage and the replication lag… once again cacti is very helpful ! How…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…. Among other things, you’ll make replication lag badly. More about this later. Another …reason denormalization is important is that nested-loop joins on large data sets are very expensive. If MySQL…. Store the ranges of values for various attributes, for example; or the presence or absence …
Post: MySQL Partitioning - can save you or kill you
December 11, 2010 By 14 Comments
…for a while to write about using MySQL Partitioning for Performance Optimization and I just got a …than buffer pool size. The first problem was replication lag, which are mainly due to modifying the uu…and there seems to be a reasonable number which would allow replication to perform better when it is…
Post: MySQL Full Text Search in Action
February 7, 2008 By 9 Comments
… to 3-4 hours for items to become visible in search results. I’m wondering if that is replication lag or issues with… index for performance or search quality reasons you better analyze word frequencies and build stop word list which matches your application. For example… we’re often using with MySQL – Sphinx Search we still tend to use stop word list for performance reasons, but it is normally…
Post: Percona Toolkit 2.0.1 and 1.0.2 released
January 3, 2012 By 5 Comments
… our plans to create excellent free tools for MySQL administrators. There is one really big thing …Nagios so you don’t get alerts about replication lagging and restart the tool because you killed …for any reason, it’s graceful about that, and then it’s easy to resume. Many thanks to Daniel Nichter for…
Comment: Is DRBD the right choice for me?
July 8, 2009 By 17 Comments
… MMM allows much more here – ALTER TABLEs, MySQL Upgrades, Storage Engine changes etc. 2) Anders…it is possible for master to remain in tact after failure. It would be reasonable to run…replication lag may be allowed to appear. 5) Yves: Yes… Replication is a risk here. The monitoring for replication…
