MariaDB versus MySQL

Emily Routledge

Member
Registered
Joined
Aug 13, 2016
Messages
61
Points
8
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

Well-known member
Registered
Joined
May 3, 2016
Messages
1,622
Points
83
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.
 

Emily Routledge

Member
Registered
Joined
Aug 13, 2016
Messages
61
Points
8
Emily Routledge
Yes beside a shared hosting package I have a small VPS 2GB of RAM and my VPS provider sent it to me. How can change from MySQL or Mariadb?
If moving to Mariadb, do I need to reconfigure some things on my sites or does it affect my sites?
 

LJSHost

Well-known member
Hosting Provider
Registered
Joined
Jul 5, 2016
Messages
1,031
Points
63
LJSHost
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.
 

Emily Routledge

Member
Registered
Joined
Aug 13, 2016
Messages
61
Points
8
On a VPS you can replace MySQL by Mariadb, but does you have a control panel installed ?
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

Well-known member
Hosting Provider
Registered
Joined
Jul 5, 2016
Messages
1,031
Points
63
If you want to do this on your cPanel VPS the process is fully documented here.
 

fwh

Administrator
Staff Member
Joined
Dec 8, 2012
Messages
773
Points
63
@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

Well-known member
Registered
Joined
Nov 26, 2016
Messages
565
Points
28
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

Member
Registered
Joined
Feb 28, 2017
Messages
23
Points
0
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

Member
Registered
Joined
Feb 28, 2017
Messages
23
Points
0
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

Member
Registered
Joined
Jan 16, 2017
Messages
53
Points
0
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

Member
Registered
Joined
Aug 13, 2016
Messages
61
Points
8
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

Member
Registered
Joined
Feb 28, 2017
Messages
23
Points
0
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

Active member
Registered
Joined
Mar 4, 2017
Messages
65
Points
0
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.
 
Newer Threads

Latest Hosting OffersNew Reviews

Sponsors

Tag Cloud

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top