…replication mainly to be able to fail over if there are problems. Over time application still will be limited by MySQL…how to optimize it another 10-15% may be a great idea. On higher end I’d even look to speak to…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL 5.0 database with MySQL…to minimize downtime it is best to use MySQL Replication for upgrade. Once you have setup slave with new version and made it to…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 1 Comment
… MySQL servers and reports on how…a slave upgraded to your target version and let it replicate until such time you are ready to… to limit the number of queries per fingerprint to …to all objects within the database server and has all privileges to the specified –temp-database from #1. pt-upgrade is a…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
…to a level where we started looking at other ways of achieving higher availability using MySQL replication…a node Pacemaker stonith devices are supported No logical limits in term of number of nodes Easy to add nodes In order to…how Pacemaker defines an asymmetrical resource having a… database…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…databases but until recently this type of software was not available for MySQL. Change Data Capture can be used to: Monitor a database…limited trigger support, some of which is the cause of the aforementioned problems. The biggest problem, at least from standpoint of how…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…point is to think outside the box, even to think of things that seem “less advanced” than using a database. …A day at a time, for example. There are a lot of other ways you can make replication faster. I wrote a… but how much time do you have? And the gains are simply limited by some of MySQL‘…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
…how large the read-to-write ratio is. What are some workarounds? Here are a few I’ve seen: Use DRBD replication instead of MySQL replication…a thread for each database we see in the binary log, and simply pass the replication events to the appropriate thread. A…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…to learn about MySQL Replication or just looking to keep MySQL infrastructure to be as close to one for other databases…limitations. You could argue depending on cases you spend most time working with how…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…limit=# Rate limit statement writes to slow log to only those from every (1/log_slow_rate_limit) session. With high traffic coming to your database…replication thread. Can be changed at run time with both SET SESSION and SET GLOBAL. log_slow_verbosity=name Choose how…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…to a replication…LIMIT 0 to the SELECT part of the query. convert.php This script takes as one argument the default database…how you can combine both types of views together. The complete method examples show how to create a…
