May 26, 2012

Post: Percona Server 5.5.21-25.1 released!

Percona is glad to announce the release of Percona Server 5.5.21-25.1 on March 30, 2012 (Downloads … Software Repositories). Based on MySQL 5.5.21, including all the bug fixes in it, Percona Server 5.5.21-25.1…. Bug fixed #962940 (Laurynas Biveinis). Fixed MySQL upstream bug #64160 that was causing issues on upgrade to 5.5.20 and 5…

Comment: Percona Toolkit 2.1 with New Online Schema Change Tool

…) with a Percona type version of MySQL – ie one of Percona’s “improved” versions of MySQL (that is what Percona does, isn… a previous version, to “upgrade“? 3. Thirdly, thanks for your help and information. I just made the MySQL, apache2 and php updates… what is happening on the server. Any ideas on what is happening here? It seems as if MySQL 5.5 has been…

Comment: Percona Server 5.5.21-25.1 released!

… idea which upcoming version of Percona Server will incorporate this important bugfix: http://bugs.mysql.com/bug.php?id=61209 We’ve… be fixed for almost a year now so we can upgrade to 5.5. As Peter says, for us this is…

Post: Upgrading MySQL

Upgrading MySQL Server is a very interesting task as you can approach it … MySQL version upgrade can have both of these issues. It gets larger as you have a larger leap in minor version – Upgrade of MySQL… you upgrade to different major version, especially if you skip over one. MySQL 5.0 to 5.1 upgrade is a lot safer upgrade

Post: MySQL Server Upgrade

Today I’ve upgraded MySQL Server on the host running MySQL Performance Blog. MySQL 4.1.12 was running here for well over a … chance of problems on MySQL 5.0 than on 4.1 This is upgrade strategy I follow for this server which has mix of various third party PHP/MySQL applications. In different situations upgrade strategies…

Post: Troubleshooting MySQL Upgrade Performance Regressions

… do ? First if you followed MySQL upgrade best practices such as testing your workload with pt-upgrade the chances of this happening are… “test server” where you can analyze it without side load. Setting up 2 MySQL Servers side by side (for example with MySQL Sandbox) can… to Percona Server bug tracking system check whenever the bug is in Percona Server indeed by running the same test on MySQL server of…

Post: Which Linux distribution for a MySQL database server? A specific point of view.

… database server during its lifetime comes down to this rather boring process – install, configure, tune, start/stop MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL… start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL version might just be the most critical operations you ever do once server is moved into…

Post: How To Test Your Upgrades - pt-upgrade

… your upgrades better which is one important step when upgrading your servers. pt-upgrade This tool lets you test your SELECT queries against multiple MySQL servers and reports on how each type of query performs from every server you let it test…

Post: The story of one MySQL Upgrade

… worked on upgrading MySQL from one of very early MySQL 5.0 versions to Percona Server 5.1. This was a classical upgrade scenario which can cause surprises. Master and few slaves need to be upgraded. It… 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…

Post: MySQL Installation and upgrade scripts.

MySQL Server upgrade process but rather about my experience with RPM scripts used during install and upgrade. These are obviously not part of automated mysql… the problems Upgrade Script fails to shut down MySQL Server. Obviously nothing can work without this one. Upgrade Script Removes /var/lib/mysql symlink I…