MariaDB versus MySQL

Emily Routledge · Sep 22, 2016

I asked my hosting providers and they said I am using MySQL for my web databases, I read posts on the forum and MariaDB is getting more good feedback. Can I use MariaDB for my website and how to switch from Mysql to MariaDB?

Thanks in advance.
Emily

VirtuBox · Sep 22, 2016

Hello Emily, if you are using a shared hosting, it's your hosting provider choice to use MySQL or Mariadb. It require to have a root access to a VPS or a dedicated server.

VirtuBox · Sep 22, 2016

On a VPS you can replace MySQL by Mariadb, but does you have a control panel installed ?

Emily Routledge · Sep 23, 2016

VirtuBox said:
On a VPS you can replace MySQL by Mariadb, but does you have a control panel installed ?

LJSHost said:
Hi Emily

As Virtubox said we need to know exactly what operating system(Linux version) and control panel (if you have one) your VPS is running before we can provide exact instructions.

I bought a directadmin license from postpayhost $12/ month and using cPanel hosting from mygethosted $18/month for a cpanel license.
How can I change mysql to mariadb?

LJSHost · Sep 23, 2016

If you want to do this on your cPanel VPS the process is fully documented here.

fwh · Sep 23, 2016

@Emily, if you are using Directadmin and using Mysql 5.5.x then using custombuild to change your Mysql to Mariadb

Code:

cd /usr/local/directadmin/custombuild/
./build set mysql_inst mariadb
./build set mariadb 10.0
./build update
./build mysql

Hope it helps!

Dr. McKay · Feb 28, 2017

I heard good features and feedback about MariaDB but I have not tried it.
Still sticking with Mysql and I don't have any reasons to move to a new one.

rshosting · Feb 28, 2017

I noticed OP was interested in knowing the difference in terms of performance for MySQL and Mariadb, which does not seem to be mentioned yet. Mariadb offers following features which are better than Mysql:

[FONT=&quot]Improved performance and speed.
[/FONT][FONT=&quot]New query optimizer.
[/FONT][FONT=&quot]Faster joins.
[/FONT][FONT=&quot]More storage engines.
[/FONT][FONT=&quot]PAM support.

Upgrading from Mysql to Mariadb is a non-revertible process (unless you have database dump generated prior to upgrade which will need to be restored on clean mysql instance). Hence the upgrade should be planned carefully after determining the end result scenario.

[/FONT]

rshosting · Feb 28, 2017

MariaDB comes with support for additional storage engines such as XtradB, Aria including the other storage engines such as Innodb and MyISAM. You will find more details here : https://mariadb.com/kb/en/mariadb/choosing-the-right-storage-engine/

PAM is an authentication plugin supported by MariaDB. [FONT=&quot]PAM is short for [/FONT]Pluggable Authentication Modules[FONT=&quot] and is an authentication framework used by Linux, FreeBSD, Solaris, and other operating systems. It is not supported on Windows servers.

[/FONT]PAM makes it possible to implement various authentication scenarios of different complexity. For example,

authentication using passwords from /etc/shadow (indeed, this is what PAM usually does for a normal shell logins, for pop3, imap, and many other services)
authentication using LDAP
authentication using ssh passphrases
authentication using one-time passwords (even with SMS confirmation!)
combining different authentication modules, where either one or all of them are required to succeed
password expiration
user name mapping
limiting access by time, date, day of the week, etc.
logging every login attempt
and so on, the list is in no way exhaustive.

Which version of Mysql are you using?

Databases on Mysql 5.6 are compatible with MariaDB and can be safely upgraded. But as I mentioned earlier, it is a non-reversible process, so make sure to take a full backup of all your mysql databases prior to upgrade.

HostingWaves · Mar 1, 2017

If you are using cpanel want to use MariaDB, just login to WHM and go to mysql upgrade and from there you can easily move to MariaDB, but ensure your databases are compatible with this higher version.

Emily Routledge · Mar 15, 2017

rshosting said:
Which version of Mysql are you using?

Databases on Mysql 5.6 are compatible with MariaDB and can be safely upgraded. But as I mentioned earlier, it is a non-reversible process, so make sure to take a full backup of all your mysql databases prior to upgrade.

I checked and the output is returned

mysql Ver 14.14 Distrib 5.6.33, for Linux (x86_64) using EditLine wrapper

Is is Mysql 5.6? and quite compatible with mariadb?

In other words, Do I need to check my CMS (codes, plugins,addons) if it worked with Mysql then it will be the same for maridb?

rshosting · Mar 16, 2017

Upgrading from Mysql5.6 to Mariadb should be a seamless process if you using WHM cPanel. However, it is always recommended to take a backup prior to upgrade.

HostaPolis · Mar 18, 2017

There really is no reason not to use MariaDB over MySQL. It is a dropin replacement, meaning there is nothing
MySQL supports that MariaDB does not, it just works. Performance is better with MariaDB, too.

MariaDB versus MySQL

Active member

Well-known member

Well-known member

Active member

Well-known member

Administrator

Well-known member

Member

Member

Member

Active member

Member

Active member

Sponsors

Tag Cloud