WordPress site for Linux and other computernerds

Tag: upgrade

Upgrade MariaDB 5.5.x to 10.0.x on Slackware 14.1 x64


Update for Slackware x64: latest version of MariaDB 10.0. This package was build on a Slackware 14.1 system. To build this package succesfully on a 14.1 system, you also need to install the jemalloc package.



How to upgrade from MariaDB 5.5.x to MariaDB 10.0.x

1. Start by downloading the 2 packages above.
2. Transfer these packages to the server you want to upgrade.
3. First install the jemalloc package:

installpkg jemalloc-3.6.0-x86_64-1.txz

4. Stop the running mysqld service:

/etc/rc.d/rc.mysqld stop

5. backup ALL your databases (make a copy of the entire /var/lib/mysql directory).

cp -a /var/lib/mysql/ /var/lib/mysql-BACKUP

6. Uninstall the MariaDB 5.5.x package (use removepkg or pkgtool).
7. Install the new MariaDB 10.0.25 package:

installpkg mariadb-10.0.25-x86_64-1.txz

8. Make sure /etc/rc.d/rc.mysqld is updated (overwrite the old rc.mysqld with rc.mysqld.new).
9. Start the mysqld service:

/etc/rc.d/rc.mysqld start

10. Check if mysqld is running now:

ps aux | grep mysql

11. Run mysql_secure_installation. Maybe this is not really necessary, but it doesn’t hurt to start clean. While you’re at it, you can set a new mysql root password here as well.
12. Run mysql_upgrade (MUST DO):

mysql_upgrade -u root -p

10. Restart the mysql service again (just to be sure).

/etc/rc.d/rc.mysqld restart

11. Now go check your DB’s and applications.


Enjoy 🙂
EDIT 27-Oct-2019: The above procedure is also valid when upgrading from say MariaDB 10.0 to 10.2 or later versions.


Server upgrade

I managed to get my greedy hands on more powerfull computing gear, providing the means to upgrade this webserver. After nearly 4 years, the old hardware was still fine, but with the newer parts in place, the machine performs even better, and is somewhat more future proof.


Part Old server New server
CPU Intel Core2 Duo E6320 Intel Core2 Duo E7500
CPU speed 1.86 Ghz 2.93 Ghz
Memory 2.0 GB DDR2 4.0 GB DDR2
Chipset Intel DQ965 Intel Q45

In order to prevent a possible disk crash, the old 250 GB harddisk (already 4 years old) was cloned to a new one. The old disk was still OK, but it’s better to be safe than sorry.