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… also often helps with monopolizing replication thread. For example if I need to delete old data instead of DELETE FROM TBL WHERE…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… the GA release of version 2.1 of Percona Toolkit. Percona Toolkit is the essential suite of administrative tools for MySQL. With this release… removes those limitations and makes the tool fully featured and much easier to use. The key is that it is replication-aware… parts of the toolkit: A 3-hour tutorial about the toolkit on Tuesday Daniel will talk about using it to verify replication…
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 …compression utilities, which also had a number of other limitations (e.g. could not be used with … XtraBackup will be part of the topics at the upcoming Percona Live MySQL Conference and Expo (…
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 … mysqldump can take 20+ minutes on a database of reasonable size — thus limiting or halting all write activity on the master. This essentially places the master ‘out of service’ which is not…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… the MySQL storage engines including MyISAM (NDB is a special discussed later) but it suffers from the limitation of MySQL replication. The main limitation, in term of HA, is the asynchronous design of MySQL replication which does not allow the master…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
The problem of MySQL Replication unable to catch up is quite common in MySQL world and in fact I already wrote about it. There… couple of query design mistakes which result in low hanging fruit troubleshooting MySQL Replication Lag First fact you absolutely need to remember is MySQL Replication… a lot of rows ? Use Query Chopping – this can be running update/delete with LIMIT in the loop, controlling maximum amount of values…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
There are interesting posts these day about future of MySQL Replication by Brian Frank and Arjen. I think it very interesting … level. Seriously – MySQL Cluster, Continuent, Master-Master Replication, DRBD or SAN based HA architectures all have their limits which makes neither of them used…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
… good write up about using MySQL replication. The piece I find missing however is good description of warning about limits of this approach as well… times if write load growth by only 50%. – Delays in replication MySQL replication is fast which means in average delay is small. Typically…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
…” limitations Postgres has overcome for specific use cases. I decided to write a series of blog posts on MySQL‘s unsolved severe limitations. I mean limitations that really hobble it for major… workarounds? Here are a few I’ve seen: Use DRBD replication instead of MySQL replication. Problem: you end up with an idle standby server…
Post: Implementing Parallel Replication in MySQL
November 8, 2010 By 3 Comments
… implementing a limited form of parallel replication. Single-threaded replication is one of the most severe limitations in the MySQL server. We have a brief outline of the… you are interested in hiring us to implement this limited form of parallel replication for your own use, please contact us to discuss…
