Upgrading from MariaDB 5.5 to MariaDB 10.0

What you need to know when upgrading from MariaDB 5.5 and MariaDB 10.0

As there has not been any changes in table or index formats between MariaDB 5.5 and MariaDB 10.0, the upgrade should be painless.

How to upgrade

• Shutdown and uninstall MariaDB 5.5
• Take a backup (this is the perfect time to take a backup of your databases)
• Install MariaDB 10.0.
• run mysql_upgrading (if your package is not doing that for you). This will do two things:
  • Upgrade the permission tables in the mysql database with some new fields.
  • Do a very quick check of all tables and mark them compatible with MariaDB 10.0
• Add new options to my.cnf to enable features.
  • If you changed my.cnf then you need to restart mysqld.

Incompatible changes between 5.5 and 10.0

For most user, upgrading from 5.5 should be painless. Here follows a list of those things that has changed that could affect and upgrade:

Options that has changed default value

Most of the following options has increased a bit in value to give better performance. They should not use notable more memory, but some of them a bit more disk space.

Options that has been removed or renamed

The following options should be removed or renamed if you use them in your config files:

New major features you should consider using in MariaDB 10.0

For master / slave setups

• Global transaction id is enabled by default. This makes it easier to change a slave to a master.
• MariaDB 10.0 supports parallel slaves. You can enable this with slave-parallel-threads=#.
• Multi source replication

See also

• The features in MariaDB 10.0