June 20, 2013

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

… Toolkit supported platforms and versions. When you upgrade to MySQL 5.6, be sure to upgrade to Percona Toolkit 2.2, too. We… (Percona Server, MariaDB, Percona XtraDB Cluster, and MariaDB Galera Cluster), upgrades are fashionable, so to speak. Problem is: “original” pt-upgrade was too…

Comment: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver

hello, currently using 2.2.2 and mysql Ver 14.14 Distrib 5.5.30, for Linux (x86_… this since the upgrade of percona this week: pt-heartbeat -F/etc/my.cnf -Dpt_heartbeat –check The –master-server-id option… table `pt_heartbeat`.`heartbeat` uses the server_id column for –update or –check but the server‘s master could not be automatically…

Comment: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

… very anxcious to try out the new pt-upgradeUpgrade to Percona Server anyone ? Maybe to MySQL 5.6 then? Anyway, congradulations with the…

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: How Can Percona MySQL Server Development Services Help ?

…. Percona MySQL Server Development Services can often Backport Bug Fixes in the version you’re running hence helping you to reduce upgrade costs… most performance from your MySQL server via our Percona MySQL Consulting, Percona MySQL Support, and Percona MySQL Remote DBA services. With our MySQL Server Development Services we…

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…

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: 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: Distro Packages, Pre-built Binaries or Compile Your Own MySQL

… be as easy as stopping MySQL, updating symlinks or your my.cnf basedir, starting MySQL and running mysql_upgrade. Unlike package managers, you do… your MySQL server from pre-built binaries does not prevent you from installing other MySQL packages on the server for other dependencies i.e. mysql