MariaDB MariaDB 5.5 to 10 upgrade beta testing

Up until 1.2.3-eva2000.06 stable release the default MariaDB version is MariaDB 5.5 branch. MariaDB 10 branch will not be the default until at least MariaDB 10.0.13 release.

However, for folks impatiently waiting for testing out MariaDB 10 Mysql, 1.2.3-eva2000.07 beta builds already have a new sub menu ready with a placeholder for MariaDB 5.5 to 10 upgrade process with an added option to re-enable the upgrade process.



I've added a switch variable just for testing MariaDB 5.5 to MariaDB 10 upgrade process. So yes default install is MariaDB 5.5 still, but you can test out the MariaDB 10 upgrade process by doing following steps:

1. Ensure to test on test server and NOT live production site/server. Install centmin.sh menu #1 run to install

2. After install, edit .07 beta's inc/mariadb_submenu.inc file and change variable ENABLE_MARIADBTENUPGRADE='n' to ENABLE_MARIADBTENUPGRADE='y'. Save file

3. run centmin.sh again and now select menu option [HASHTAG]#11[/HASHTAG] to open the sub-menu and select sub-menu option #3 to do an upgrade from MariaDB 5.5 to 10. You will get a reminder prompt to backup all MySQL databases before starting. If you have no databases to backup or if it's a test server with data, just hit 'y' when asked if you have done your backups to proceed. Then the process will uninstall previous MariaDB 5.5 and install MariaDB 10 repo.

Notes:

1. The new process no longer installs MariaDB-test rpm package for the test database.
2. On completion, you will be shown output for your MariaDB 10 plugin list etc and your /etc/my.cnf will have a new group [mariadb-10.0] with MariaDB 10 specific relevant mysql settings.
3. MariaDB 10 is installed via official YUM repository so yum update can be used for updates i.e.
   
   Code:

   yum update MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
   

4. Again try this on test server with a copy of your site MySQL data and not live server first. I am still testing and will eventually have MariaDB 10 as default installed version for Centmin Mod.
5. Full MariaDB 10 feature comparison at https://mariadb.com/blog/mariadb-10-vs-mysql-56-feature-comparison-update

---

 

I tested on wable.com test VPS server fine

Code:

mysqladmin ver
mysqladmin  Ver 9.1 Distrib 10.0.11-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.

Server version          10.0.11-MariaDB
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 32 min 26 sec

Threads: 1  Questions: 302  Slow queries: 0  Opens: 20  Flush tables: 1  Open tables: 83  Queries per second avg: 0.155

 

Personally, I would like to see some of the critical, blocker and major bugs prior to 10.0.12/10.0.13 dealt with first https://mariadb.atlassian.net/issues/?filter=16602. Some are performance and scalability related I believe 10.0.12 will take care of a majority of them, but will see what 10.0.12 might introduce bug wise first.

Basically, just me being overly cautious

 

One step closer with MariaDB 10.0.12 released https://community.centminmod.com/threads/mariadb-10-0-12-now-available.487/

 

Not anytime soon.. maybe if I have some more extended free time I eventually will. Proper benchmarks take along time to do.

But MariaDB 10 is faster than MariaDB 5.5 from most tests I've seen depending on how MariaDB settings are tuned.

 

if Singapore is like Australia, it's basically a slow .. very slow MariaDB yum download... sometimes with local Australian testing it can be as slow as 128KB/s from MariaDB yum mirror

just wait it out

see George Liu on Twitter: "@mariadb any chance of faster YUM download mirrors for Aussies ? Australian server takes 300 seconds vs USA servers ~30 seconds to download"

 

ah yes that would work too