…/CentOS prior to 6.4, upgrading your distribution to 6.4 may break your cluster. In this post I will explain you how to fix your cluster in case it breaks after a distribution upgrade that implies an update of pacemaker from 1.1.7 to… want to upgrade, you cannot apply any rolling upgrade process. So like for Pacemaker 0.6.x to 1.0.x, you need again to…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
… most typical scenario is when you want to upgrade. You usually upgrade only a few machines to see how it goes before deploying the new… become a major hurdle in the future for people wanting to switch from MySQL 5.6…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… Percona Toolkit supported platforms and versions. When you upgrade to MySQL 5.6, be sure to upgrade to Percona Toolkit 2.2, too. We also… specify –iterations or –run-time to limit how long they run. There are more changes in addition to those highlights. For example, three… full list. If you upgrade from 2.1 to 2.2, be sure to re-read tools’ documentation to see what has changed. As…
Comment: Solving INFORMATION_SCHEMA slowness
May 6, 2013 By 25 Comments
… be possible, however, to backport that fix to 5.1.58, and run a custom build until you can upgrade sometime in the…/01/28/percona-custom-development-services-how-we-can-help/ You may also be able to work around the issue, depending on… developed the database library for Zend Framework, I needed to write a function to discover the structure of a table, its columns…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… MySQL server. With Percona Playback you can measure how a server or database upgrade, change in my.cnf or schema change can… Playback for MySQL now shows error when it’s unable to connect to the MySQL database server. Bug fixed #1070824 (Vlad Lesin… fixed #1080648 (Vlad Lesin). Missing build dependences have been added to the README file. Bug fixed #1072845 (Stewart Smith). Percona Playback…
Post: When is it a time to upgrade memory ?
September 16, 2008 By 11 Comments
…% full, should I be thinking about upgrading memory already?” This is a wrong way to put the question. Unless you have very… all buffer pool busy sooner or later. How to figure out if it is time for upgrade when ? Look at number of misses per second Check number of innodb file reads and writes per second and see how…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 7 Comments
… application to the version you’ve upgraded to. Let’s look at how one Percona Toolkit tool, pt-upgrade can help you identify what to expect and test your upgrades better… when upgrading your servers. pt-upgrade This tool lets you test your SELECT queries against multiple MySQL servers and reports on how each…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… recommend MIXED replication mode if you have something substantial to gain. Q: How would Upgrade work if Old Server has Antelope format and… to your production use. If resources allow I prefer to have upgrade testing done in the environment which is maximally close to production. Q: How safe is it to upgrade from MySQL 5.5 to…
Post: When to use Hardware upgrade instead of Software Optimization
December 5, 2008 By 5 Comments
…. When consultant should suggest hardware upgrade and when it is not in a simple checklist form. How good is hardware ? Sometimes people use so crappy hardware it would be much cheaper for them to upgrade before purchasing much of professional services. Though in some cases people like their system to be optimal and so they want to…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… in MySQL 4.1 to 5.0 upgrade notes ? ? Furthermore if there were no good ideas how to make XA to work with group commit… this problem, so lets see who is affected, how to check you’re affected and how to fix it. Who is affected ? The good… these are probably most obvious and easy to use. How to fix the problem ? Assuming getting back to MySQL 4.1 is not the…
