About Databases and other wondrous things (MariaDB)

[AusPhotography]

For some time now MariaDB (https://en.wikipedia.org/wiki/MariaDB) has been taking over from MySQL (https://en.wikipedia.org/wiki/MySQL) as the preferred open source database.

The reasons are well covered here: https://blog.openshift.com/why-mariadb-matters-the-openshift-interview-with-monty/

WHM/cPanel have been their usual slow (cautious) approach have made MariaDB the future replacing MySQL.

We upgraded this morning. MariaDB is faster and has a smaller memory foot print.
Initially I'm seeing up to ~20% surprisingly faster database; but this won't make a huge difference to your site experience as the database component of any page hit is only 10-15%.
I.e. maybe 2% of the overall transaction.

Why upgrade?


MariaDB is faster
MariaDB has some better features in regards being resilient to crashes
MariaDB has less bugs/issues than MySQL
Very large sites (eg. Wikipedia) have changed to MariaDB
MariaDB also has more than 10,000,000 users now (lots of people with experience and bugs reports etc.)
It is now the default database on some major Linux distributions (again well supported)
It is plug compatible with MySQL - it is easy for us to change
MariaDB is the future and we are protected from the whims of Oracle (https://en.wikipedia.org/wiki/Oracle_Corporation) who now control MySQL
The MariaDB core team is ex MySQL because the did not like Oracle's approach

[puertoblack2003]

Is it free to use? I've heard that they charge for running it.

[Dave]

MariaDB is free to use.
I've been using it for like 1.5 year now and I'm very satisfied with MariaDB.

[Replicant]

9. The MariaDB core team is ex MySQL because the did not like Oracle's approach


Seems to be a trend with software.

[AusPhotography]

Is it free to use? I've heard that they charge for running it.

Free as it is fully FOSS.

[puertoblack2003]

Free as it is fully FOSS.

I gave it a go. Installed it next to mysql.I ran into some issues with database table corruption.But it was fixed via commands. Going to play around with it and compare it.

regards

[AusPhotography]

I've got all MySQL tables converted to Aria and the XtraDB default, which replaces InnoDB in place - runs sweet as !

Found a bug... (due to MariaDB versions being '10.0.16-MariaDB')
In ../admincp/index.php line 55 make the following change (vB4.2.2)
//if ($mysqlversion['version'] >= '3.23')
if (version_compare($mysqlversion['version'],'3.23', '>='))


also in ../admincp/diagnostic.php line 340 make the following change (vB4.2.2)
//if ($mysqlversion['version'] < '3.23')
if (version_compare($mysqlversion['version'],'3.23', '<'))

and line 719
//if ($mysqlversion['version'] < '3.23')
if (version_compare($mysqlversion['version'],'3.23', '<'))

--------------- Added 1424090842 at 1424090842 ---------------

Found a bug... (due to MariaDB versions being '10.0.16-MariaDB')
In ../admincp/index.php line 55 make the following change (vB4.2.2)
//if ($mysqlversion['version'] >= '3.23')
if (version_compare($mysqlversion['version'],'3.23', '>='))

[squidsk]

Have you reported that on the bug tracker? It's a small enough bug that it should be able to be fixed.

[puertoblack2003]

I've got all MySQL tables converted to Aria and the XtraDB default, which replaces InnoDB in place - runs sweet as !


can you point me out to how you complish that.I searched around there's little information about mariadb proper configurations etc etc,

thanks

[AusPhotography]

can you point me out to how you complish that.I searched around there's little information about mariadb proper configurations etc etc,

thanks

InnoDB -> XtraDB is default for MariaDB > 10.0.8
Aria conversion is easy using phpMyAdmin, just change the table type
or
ALTER TABLE xxxx ENGINE=Aria;

--------------- Added 1424132633 at 1424132633 ---------------

Tracker http://tracker.vbulletin.com/browse/VBIV-16069

[puertoblack2003]

InnoDB -> XtraDB is default for MariaDB > 10.0.8
Aria conversion is easy using phpMyAdmin, just change the table type
or
ALTER TABLE xxxx ENGINE=Aria;

--------------- Added 1424132633 at 1424132633 ---------------

Tracker http://tracker.vbulletin.com/browse/VBIV-16069

I'm using 5.5.40 version. do i apply same setting conversion?

[squidsk]

The sql syntax should be the same and as long as the destination engine for the query is installed and enabled (which it should be if that 5.5.40 is mariadb 5.5.40) then yes that sql query should do the trick.

[AusPhotography]

MariaDB did not implement MySQL 5.6 completely due to instability/quality issues.
Hence they started a new numbering system 10.x.x.x

[AusPhotography]

Have you reported that on the bug tracker? It's a small enough bug that it should be able to be fixed.

It's in 4.2.3beta 4

[markoroots]

Guys after done this, how to fix the right syntax of the sql queries to the database??

[Dave]

You don't have to. MariaDB is based on MySQL and therefore the syntax is exactly the same.

[Paul M]

As Dave says, there should not be any syntax to change, its a like for like replacement.