June 20, 2013

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

upgrade to MySQL 5.6, be sure to upgrade to Percona Toolkit 2.2, too. We also started beta support for Percona XtraDB Cluster in 2.1MySQL (5.0, 5.1, 5.5, and 5.6), plus at least four major forks (Percona Server, MariaDB, Percona XtraDB Cluster, and MariaDB Galera Cluster), upgrades… 2.1.4, released …

Post: Upgrading MySQL

5.0.30 to 5.0.86. The largest amount of potential issues happens when you upgrade to different major version, especially if you skip over one. MySQL 5.0 to 5.1 upgrade is a lot safer upgrade path than 4.1 to 5.1 just because…

Post: The story of one MySQL Upgrade

…_tables to ensure all new privileges are added, which is something I frequently see forgotten Next step is setup MySQL 5.0 to 5.1 replication to see… encounter during upgrade are very different depending on the upgrade version – upgrade from MySQL 4.1 to 5.0 had a lot of different issues than upgrade from MySQL 5.0 to 5.1 Also, Maatkit…

Post: MySQL Upgrade Webinar Questions Followup

… go directly MySQL 5.0 to 5.5 for MyISAM tables? MyISAM have not been getting any significant development since MySQL 4.1, so in-place upgrade of MySQL 5.0 to MySQL 5.5 should be… a you go over normal upgrade checks you should be fine. Q: What are the key concerns upgrading MySQL 4.1 to MySQL 5.5? This is jumping over…

Post: MySQL 4 to MySQL 5 Upgrade performance regressions

upgrading from MySQL 4.0 and 4.1 to MySQL 5.0. By serious I mean several times performance difference not just 5-10% you often see for simple queries due to… easy to fix, But why is not it mentioned in MySQL 4.1 to 5.0 upgrade notes ? ? Furthermore if there were no good ideas how to make XA to

Comment: Upgrading MySQL

… in MySQL 5.0. Upgrade from MySQL 4.1 to 5.0 and repair all MyISAM tables (see Section 2.4.4, “Rebuilding or Repairing Tables or Indexes”). Then upgrade from MySQL 5.0 to 5.1 and check and repair your tables.” http://dev.mysql.com/doc/refman/5.1

Post: Even minor upgrades are not always safe

… in MySQL 5.0 (You never know where to expect problems, ie some people reported JOIN breaking by upgrading to 5.0). Yes this stuff is in upgrade notes… this case during 4.1 upgrade which is old stable version which is not as actively changed as 5.0 I upgraded MySQL 4.1.19 to 4.1.21 couple of…

Post: Solving RPM installation conflicts in CentOS 5 and CentOS 6

mysql-libs packages provided by CentOS/Redhat. So even if the user wants to install PS 5.5 alongside packages that depend on 5.1/5.0upgrade from 5.1 to 5.5 without uninstalling any software that depended on the old version. # rpm -qa | grep ^Percona Percona-Server-client-51-5.1

Post: Percona Server security fix releases

… that there still are many active MySQL 4.0 and MySQL 4.1 installations and we understand how hard it is upgrade 4.0/4.1 to 5.1. With published exploits these installation are now under serious risks. If you are interested in backporting patches to 4.0 / 4.1 or to older 5.0 and 5.1