cPanel & WHM Version 82 has been released, and brings a slew of great updates. Take a look at what is included, and then upgrade today!
 
This object is in archive! 

MariaDB support

Feature Importer shared this idea 7 years ago
Completed

As a Server Administrator, I want MariaDB support, so that I can accomodate both innodb and non-innodb users.


Perhaps work with Percona.


This is a feature that has been migrated over from the cPanel Forums. All previous comments and discussions concerning this feature can be located at:

http://forums.cpanel.net/f145/mariadb-optional-mysql-replacement-case-50050-a-190492.html?highlight=Mariadb

Best Answer
photo

This is now available in 11.48+

The work needed to make cPanel compatible with the official MariaDB RPMS is nearing completion. As part of the update, we will also be updating the MySQL 5.0 and MySQL 5.1 compatibility libraries to ensure they work with MariaDB & the version of EasyApache that is currently installed on each respective cPanel server.


Attached are some early screenshots of the implementation of the integration with the MySQL Upgrade Tool in WHM. Please note that these screenshots are an older version of the implementation, and they have not been reviewed by our Documentation team.


The screenshots have been updated with last night's development build.


UPDATE 10/31: Development of this feature is near or at completion and this functionality is in the final stages of QA. This feature is targeted at 11.48.


UPDATE 10/31: This feature has been merged into 11.48.

Comments (40)

photo
5

We're currently testing mariadb on a server without control pannel and are very satisfied with performance compared to normal mysql.

photo
3

I second that. MariaDB is great, specially for systems with memory constraints.

photo
3

MariaDB 5.5 is upon us :)


Also Wiredtree already has support for MariaDB for their WHM servers http://www.prweb.com/releases/dedicated-server/hosting/prweb10172071.htm

photo
1

I think there are more than a few people who see using MySQL as being potentially problematic. Already, I regularly receive emails from Oracle trying to sell me the enterprise edition and/or their services, which is, of course, the main reason Oracle has kept a community edition at all. If they don't make enough money from it, they'll undoubtedly kill the community edition. After all, they own it, they can do what they want.


While I think cPanel is great, and much better than the alternatives, the more I learn about administering my servers from the CLI, the less I use it. Unfortunately, most of my clients don't use it at all, or when they've tried, can't get things to work. cPanel needs to add support so we can "drop in" MariaDB in place of MySQL.

photo
4

Interesting that a blog post for getting mariadb running with cpanel was posted a few days ago. The search term "cpanel mariadb" seems to be getting more and more volume.


Is there any offical statement about getting mariadb supported by cpanel in the near future?

photo
4

We also manually implemented MariaDB on our cPanel and we can definitely see considerable improvements over our customers websites/databases. Thumb Up for this feature to be native supported.

photo
1

not high priority

photo
1

I like MariaDB+XtraDB, much better. Hopefully cPanel will provide official support in the near future, I am sure more and more hosts will be happy wot ditch MySQL.

photo
11

As a hosting company, one great concern is that we will be left with a dead-end on MySQL soon and cPanel should provide a transition while it's on the table with MariaDB. cPanel will have a HUGE mistake on their hands if they let this slip by stranding thousands of hosting accounts stuck on MySQL which Oracle is slowing killing off.

photo
3

This should definitely be a high priority in my opinion coming up! Considering it's easy drop-in replacement for MySQL it shouldn't be too hard to implement. Especially with what Oracle has been doing to this product.


Bring it on!!

photo
1

Please CPanel team your users want mariaDB even Red Hat has switched over making MariaDB the default in their installations, I would really hate to be stranded using mysql

photo
3

Red Hat 7 is dropping MySQL in favor of MariaDB. This may be something that needs to be planned on.


http://www.youtube.com/watch?v=kkAeahvm_rA&t=27m12s

photo
2

I'd prefer to see Percona instead of MariaDB. Either way, if you can make MariaDB an option, adding Percona as an option won't be a problem.

photo
4

As a web hosting provider, we have also switch all our cPanel servers to use MariaDB instead of MySQL 5.5.


Transition was smooth without any downtime or hiccup.We have seen lower usage for CPU and Memory since the switch. Customers also reported seeing website loading faster.


So if cPanel can give us an SQL choice in the WHM > Service Configuration > SQL Server Selection that would be nice.


Regards,

Jean Boudreau

System Administrator

www.ssdbay.com

photo
1

So after 2 years of initial suggestion, this feature request made to Planned stage and does not seem to move anywhere soon.


Since the Great moderator InfoPro closed my thread on forum i am copying some of the questions here. (They belong more in the Optimization thread where they have been though).


Long story short i am launching new servers and think replacing Mysql with MariaDB in them, any feedback would be welcome.


There is a guide in a cpanel blog about migration: How to replace MySQL with MariaDB in 11.36 | cPanel Blog


And more comprehensive in another forum: How to replace MySQL with MariaDB - AYKsolutions Forum


The main problems seems to be:


  • You may need to manually recompile PHP to see Mysql (and everytime you update via EasyApache)
  • MariaDB updates are not automated, some even require to do clean install.
  • Not clear if future Cpanel updates won't mess up mariaDB installation.

Could anybody comment on this?


Have you switched already?


What are the problems?


Thanks.

photo
1

I use MariaDB on few my dedicated servers and I'm more than happy with it. When this options will be available in Cpanel I will switch to Maria immediately. Please push it in production

photo
1

Google has made a switch already, probably not without a reason. When we could expect this implemented?


Is it safe to do it manually now, and expect compatibility when this feature will be released?

photo
2

simonas wrote:

Google has made a switch already, probably not without a reason. When we could expect this implemented?


Is it safe to do it manually now, and expect compatibility when this feature will be released?

Google probably switched to stay out of Oracle's legalities. But the fact that they use it means it is surely top quality or good enough for the rest of us. I think.

photo
1

it is not so important to do right now

photo
2

I switched to MariaDB 5.5 and was very happy with the performance.

Until I needed some support. Support wouldn't help me until I switched back to mysql.


Please make it official and supported.


Thanks.

photo
2

As a sysadmin, web host provider and long time booster of both cPanel and MySQL, I'd like to throw in my vote for MariaDB


Given the performance improvements, NoSQL support (using new database engines), and the very active support of Monty Widenius (original mysql creator), MariaDB is obviously the database server to beat going forward. To not have it as the default on cPanel is a serious oversight at this point, especially given that Google, Facebook, Yahoo, et. al. are all switching to MariaDB.


Given that Oracle is showing no real interest in developing MySQL going forward, there's no reason to hold on to MySQL any longer - especially since MariahDB is a drop-in replacement for MySQL.


I've replaced it on my own personal cPanel box, but would really like to see official cPanel support for it before Q4 2014.

photo
1

I would really love to see an update on this soon. cPanel has always been slow at making new feautre requests happen. And I understand that it's because they make a stable product.


But still - it would be great if you could tell us anything about when it's planned for.Like maybe release number or something - or just something about what's causing problems or something.


I know it's a lot to hope for, but here goes my wish.

photo
4

Kristoffer Rath Hansen wrote:

I would really love to see an update on this soon. cPanel has always been slow at making new feautre requests happen. And I understand that it's because they make a stable product.


But still - it would be great if you could tell us anything about when it's planned for.Like maybe release number or something - or just something about what's causing problems or something.


I know it's a lot to hope for, but here goes my wish.


Now that version 10 has reached GA status, we are evaluating it for inclusion later this year. Our tentative plan is to offer MariaDB 10 (possibly with cPanel & WHM version 11.48 but that's speculative at this point) initially along side MySQL 5.5/5.6.


Sometime after the initial inclusion we would phase out support for MySQL. We're looking a year or more out on that part though.

photo
1

What do you mean by that, Kenneth? And when? :)

"...we would phase out support for MySQL"

photo
4

Henri wrote:

What do you mean by that, Kenneth? And when? :)

"...we would phase out support for MySQL"

Here's a hypothetical scenario to illustrate what I mean:


1. We introduce MariaDB 10 with cPanel & WHM version 11.50

2. In version 11.50 both MariaDB and MySQL are provided, and wholly supported, by cPanel

3. With version 11.52 we announce that MySQL is considered deprecated, and will be removed in version 11.54

4. With version 11.54 we no longer provide the MySQL RPMs. People may continue using their own MySQL RPMs, or those provided by the Operating System. We no longer provide them. MySQL compatibility with future versions of cPanel & WHM are not guaranteed.


Right now everything we do that touches MySQL requires testing against both 5.5 and 5.6. Adding MariaDB adds even more overhead to our processes. Reducing this overhead makes it easier for us to move quickly, and provide more features in a timely way.

photo
1

Henri, since MariaDB is anyway a compatible drop-in replacement for MySQL, I doubt dropping support for it should cause any problem.

And based on Kenneth's reply, it's actually a blessed move.

photo
1

That's nice to hear that. When I first looked that statement I got a bit scared, I must say. However, I honestly agree with leaving DBs RMPs alone since cPanel make WHM compatible with OS's RMPs, if you can understand what I'm trying to me (sorry, English is not my native language - That's Portuguese).

I'm not sure why WHM would not be compatible with the RPMs we can find around there. If it is not, I hope it could become compatible if it does not introduce you more work.

---

"Reducing this overhead makes it easier for us to move quickly, and provide more features in a timely way."

Yes, completely agreed with this, and I hope you can achieve this point as soon as possible!

---

As I'm new to Linux, DBs, WHM and server stuff, I'll surelly need to learn more about all these things. Hopefully I'll be a bit more literate soon as I'm currently studying it almost 15h a day :)

Strangely, I've been paying for a cPanel license for a bit more than 12 years, and have never really played with it myself.

Thanks for clarifying that,

photo
1

Kenneth Power wrote:

Now that version 10 has reached GA status, we are evaluating it for inclusion later this year. Our tentative plan is to offer MariaDB 10 (possibly with cPanel & WHM version 11.48 but that's speculative at this point) initially along side MySQL 5.5/5.6.


Sometime after the initial inclusion we would phase out support for MySQL. We're looking a year or more out on that part though.

Thanks a lot for that! It looks good in my eyes.

photo
1

oasisfleeting wrote:

It's already in your cpanel now. Just implement it along side mysql.

/usr/local/cpanel/3rdparty/lib64/

I followed these steps http://blog.cpanel.net/mysql-mariadb/ and it worked fine (except I used version 10), is there a newer way of switching to MariaDB?

photo
1

This is now available in 11.48+

The work needed to make cPanel compatible with the official MariaDB RPMS is nearing completion. As part of the update, we will also be updating the MySQL 5.0 and MySQL 5.1 compatibility libraries to ensure they work with MariaDB & the version of EasyApache that is currently installed on each respective cPanel server.


Attached are some early screenshots of the implementation of the integration with the MySQL Upgrade Tool in WHM. Please note that these screenshots are an older version of the implementation, and they have not been reviewed by our Documentation team.


The screenshots have been updated with last night's development build.


UPDATE 10/31: Development of this feature is near or at completion and this functionality is in the final stages of QA. This feature is targeted at 11.48.


UPDATE 10/31: This feature has been merged into 11.48.

photo
1

Months are passing by .... :(

photo
1

double_t wrote:

Months are passing by .... :(
cPanelNick updated this topic 2 weeks ago. You can read his update in the Official Answer box under the topic description.

photo
1

I spent the last week trying to install mariadb with cpanel....it installed fine but my sites kept saying required mysql extension...and apparently when I use easyapache to recompile it, it breaks. Can't wait till an official mariadb option is available!

photo
1

Will we be able to downgrade MariaDB to MySQL?

photo
2

I've entirely removed the MySQL from my systems and installed MariaDB. All done via CLI/SSH access. There is enough information in the links below for anyone to do it safely:


http://blog.cpanel.net/mysql-mariadb/

http://forums.ayksolutions.com/showthread.php?p=1069


No data from the DB was lost, even in my unusual installation (which is hugely customized in many aspects). If it worked for me, it will unquestionably work for a more traditional CentOs/WHM/CPanel installation. :)


I was running WHM 11.41.1 (Build 19) when I did the full switch, and no problems were found whatsoever. Even better! As I was writing this response I had another window opened upgrading the WHM to version 11.46.0 (build 12), and everything went flawlessly.


I've just finished a thru check & review after the upgrade as complete and no problems were found. So, I strongly suggest anyone to do the switch!


I will be very happy when the WHM/CPanel add official support to MariaDB. MySQL is done! It was doomed at the very moment when it was acquired by Oracle. So, now that we have MariaDB available, there is no reason to keep MySQL alive. Simply drop it ASAP and be happy while realizing that XTRADB Engine is amazingly faster and superior than InnoDb Engine (and more).


The switch process is straightforward, and the tasks should be a breeze even for beginners!


Good luck! ;)

Julio Marchi

photo
2

Julio Marchi wrote:

I've entirely removed the MySQL from my systems and installed MariaDB. All ...
Hi Julio, you'll likely seem some minor problems and you may fine yourself locked out of MariaDB if you do an account transfer due to incompatibilities between MySQL and Maria's storage of max user connections ( MySQL uses an unsigned int, MariaDB uses a signed one ). We backported most of the MariaDB compatibility fixes from 11.48 in case 126129: MariaDB Upgrade compatibility support. These fixes are already available in EDGE, and they should reach 11.46.x in the near future (see http://documentation.cpanel.net/display/ALD/11.46+Change+Log)

photo
1

i can't install mongo db

photo
1


As noted at the top of the article:


This document describes an unsupported workaround that is not guaranteed to work in the future.


An existing MariaDB installation might need manual intervention to work with 11.48. Then again everything might work out-of-the-box with no effort on your part. I recommend backing up your configuration and databases prior to upgrading to 11.48. A standard recommendation is to test your configuration before rolling 11.48 out to all your servers.

Comments have been locked on this page!