One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though… be a good idea. It also often helps with monopolizing replication thread. For example if I need to delete old data…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… tool, one of the most painful things anyone experiences with MySQL is significantly alleviated. If you’ve ever delayed a project… removes those limitations and makes the tool fully featured and much easier to use. The key is that it is replication-aware and inspects replicas, throttles its operation to avoid causing replication delay, watches for load on…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… 1.6: Percona XtraBackup can now save Galera replication information while performing a backup when given … utilities, which also had a number of other limitations (e.g. could not be used with …of the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, there …
Comment: Is DRBD the right choice for me?
March 14, 2012 By 17 Comments
The issue we’ve experienced with MySQL replication is resyncing a master and slave on a database with … take 20+ minutes on a database of reasonable size — thus limiting or halting all write activity on the master. This essentially…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
… write up about using MySQL replication. The piece I find missing however is good description of warning about limits of this approach as… times if write load growth by only 50%. – Delays in replication MySQL replication is fast which means in average delay is small. Typically… but far from being all what can be said about MySQL Replication.
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
…, which highlighted replication could be the limiting factor for this system quite soon, so I decided to check what is limiting MySQL Replication speed. My first idea was to check it based on slow query log, happily the server was running MySQL with…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
… MySQL Replication goes in single thread it is enough for one statement to get stuck to have all replication stalled. Long Queries – MySQL Replication executes… you’re close to the limit. To manage replication lag and to understand what is loading your replication it is also helpful to…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
… started looking at other ways of achieving higher availability using MySQL replication. One of the weakness of MMM is its communication layer… from a node Pacemaker stonith devices are supported No logical limits in term of number of nodes Easy to add nodes…=”ignore” \ last-lrm-refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin.000090|106″ rsc_defaults $id=”rsc-options…
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… ? Use Query Chopping – this can be running update/delete with LIMIT in the loop, controlling maximum amount of values per batch…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… with MySQL Replication, such as filtered replication or cross storage engine replication, though which are not typically used for HA purposes. Time Delayed replication is… be caused by software and hardware bugs rather than known limitations. You could argue depending on cases you spend most time…
