Filed with Developers MariaDB (Optional MySQL Replacement) [Case 50050]

[LampedWeb]

I'm beginning to take a strong dislike to Oracle's handling of their open source projects. I'd like to distance myself from them and I understand Percona and MariaDB provide community driven forks of MySQL.

I'm a part-time server admin, and really don't want to spend my time supporting either of these options myself.

Is cPanel considering, or would consider in the future, supporting either of these forks?

[dibarra]

I too am not happy about Oracle- luckily cPanel gives us Postgres to work with in the meantime. I'd rather wait and see where the community goes before having cPanel jump on a database that might die.

[cPanelDavidG]

Just to clarify, everyone here wants both Percona and MariaDB, preferably in such a way that Perconia and MariaDB integrate with one another, correct? I know from MariaDB enthusiasts that these tools are very often paired together in custom deployments, but I just wanted to clarify this potential ambiguity/misunderstanding.

[VeZoZ]

Just to clarify, everyone here wants both Percona and MariaDB, preferably in such a way that Perconia and MariaDB integrate with one another, correct? I know from MariaDB enthusiasts that these tools are very often paired together in custom deployments, but I just wanted to clarify this potential ambiguity/misunderstanding.

I believe the request is asking for the ability to have cPanel install MariaDB rather than MySQL

You can already run any of these just fine in cPanel. You just remove the cPanel RPM's and install one of these and everything should still work. You then disable cPanel mysql updates and handle the updates yourself. I suppose you could install MySQL any way you want in cPanel as CloudLinux can install one rather than cPanel MySQL as well.

So people are just asking to give the option of what to use. Probably could just do it as a tweak setting of what MySQL you wish to run.

MySQL 5.0, 5.1
MariaDB 5.1, 5.2


Only have the option of one of these obviously. Add new versions as available. It adds an extra element of maintaining multiple variations and custom builds of MySQL. I think before this is even considered PostgreSQL should get the same treatment as MySQL as far as support.

[eva2000]

exactly, we want cpanel by default to switch out mysql.com rpms for mariadb rpms to be installed out of the box, upgraded to etc

• MySQL 5.1.x, 5.5.x
• Maria 5.1.x, 5.2.x

[cPanelDavidG]

Prior posts in this thread have been updated to only reflect MariaDB. Discussions about Percona Server should take place in http://forums.cpanel.net/f145/percon...nt-190482.html

[cPanelDavidG]

It looks like MariaDB is a drop-in replacement down to using the same paths and names and the differences are clearly noted at: MariaDB versus MySQL - Compatibility - AskMonty KnowledgeBase

[eva2000]

I'd vote for Mariadb 5.2.x branch. Been testing both Mariadb and Percona on non-cpanel servers. Mariadb has more core improvements for non-innodb stuff while Percona focuses on innodb.

The good thing is Mariadb includes Percona XtraDB/innodb plugin for innodb and is like only a minor innodb plugin version behind from Percona when you look at MariaDB 5.2.4 vs Percona 5.1.54 rel 12.5 so very close.

Mariadb be one i'd choose for WHM/Cpanel as has everything for both innodb and non-innodb users

[eva2000]

looking at
mariadb 5.2.4 64bit non-cpanel
vs
cpanel 5.1.54 64bit install, what is the /usr/local/cpanel/lib64/libmysqlclient.so.14 for ?

mariadb

locate libmysqlclient
/usr/lib64/libmysqlclient.so
/usr/lib64/libmysqlclient.so.15
/usr/lib64/libmysqlclient.so.15.0.0
/usr/lib64/libmysqlclient.so.16
/usr/lib64/libmysqlclient.so.16.0.0
/usr/lib64/libmysqlclient_r.so
/usr/lib64/libmysqlclient_r.so.15
/usr/lib64/libmysqlclient_r.so.15.0.0
/usr/lib64/libmysqlclient_r.so.16
/usr/lib64/libmysqlclient_r.so.16.0.0
/usr/lib64/mysql/libmysqlclient.a
/usr/lib64/mysql/libmysqlclient.la
/usr/lib64/mysql/libmysqlclient.so
/usr/lib64/mysql/libmysqlclient_r.a
/usr/lib64/mysql/libmysqlclient_r.la

cpanel

locate libmysqlclient
/usr/lib64/libmysqlclient.so
/usr/lib64/libmysqlclient.so.15
/usr/lib64/libmysqlclient.so.16
/usr/lib64/libmysqlclient.so.16.0.0
/usr/lib64/libmysqlclient_r.so
/usr/lib64/libmysqlclient_r.so.16
/usr/lib64/libmysqlclient_r.so.16.0.0
/usr/lib64/mysql/libmysqlclient.a
/usr/lib64/mysql/libmysqlclient.la
/usr/lib64/mysql/libmysqlclient.so
/usr/lib64/mysql/libmysqlclient_r.a
/usr/lib64/mysql/libmysqlclient_r.la
/usr/lib64/mysql/libmysqlclient_r.so
/usr/local/cpanel/lib64/libmysqlclient.so.14

[winlinuxadmins]

Guys wanna shaire another one thats firebird DB cool and easy functions may be wanna check the steup at winlinuxadmins

[eva2000]

Updated manually to MariaDB 5.2.4 without problems

[cPanelDavidG]

After some additional feedback internally and externally, I have submitted this to our developers for review.

[xanubi]

I've successfully replaced mysql with MariaDB on cpanel, with great success. The speed and Performance of MariaDB 5.2.6 have nothing to do with mysql 5.1.56. It's like a light year's difference. I'm very happy with MariaDB.

[Kent Brockman]

I've successfully replaced mysql with MariaDB on cpanel, with great success. The speed and Performance of MariaDB 5.2.6 have nothing to do with mysql 5.1.56. It's like a light year's difference. I'm very happy with MariaDB.

Sounds great. What Linux version are you using? how many free space and total RAM memory has your server? vps or dedicated?

[cPanelDavidG]

I've successfully replaced mysql with MariaDB on cpanel, with great success. The speed and Performance of MariaDB 5.2.6 have nothing to do with mysql 5.1.56. It's like a light year's difference. I'm very happy with MariaDB.

Given the similarities of MariaDB with MySQL, with exception of some nifty engines available for MariaDB, I'm curious if you customized MariaDB to get a performance gain or if this performance gain was realized "out of the box?"