MariaDB versus MySQL

Joined
Aug 13, 2016
Messages
58
Best answers
0
Ratings
1
Points
8
#1
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

Global Mod
Staff Member
Joined
May 3, 2016
Messages
1,515
Best answers
4
Ratings
392 12
Points
83
#2
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.
 
Joined
Aug 13, 2016
Messages
58
Best answers
0
Ratings
1
Points
8
#3
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?
 
Joined
Aug 13, 2016
Messages
58
Best answers
0
Ratings
1
Points
8
#6
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?
 

fwh

Administrator
Staff Member
Joined
Dec 8, 2012
Messages
702
Best answers
0
Ratings
267 1
Points
63
#8
@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
Joined
Nov 26, 2016
Messages
348
Best answers
0
Ratings
22
Points
18
#9
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.
 
Joined
Feb 28, 2017
Messages
23
Best answers
0
Ratings
2
Points
0
#10
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]
 
Joined
Feb 28, 2017
Messages
23
Best answers
0
Ratings
2
Points
0
#12
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.
 
Joined
Jan 16, 2017
Messages
53
Best answers
0
Ratings
7
Points
0
#13
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.
 
Joined
Aug 13, 2016
Messages
58
Best answers
0
Ratings
1
Points
8
#14
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?
 
Joined
Feb 28, 2017
Messages
23
Best answers
0
Ratings
2
Points
0
#15
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
Joined
Mar 4, 2017
Messages
65
Best answers
0
Ratings
2
Points
0
#16
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 Threads
Replies
0
Views
4
Replies
3
Views
7
Replies
1
Views
7
Recommended Threads
Replies
4
Views
326
Replies
7
Views
1,151

Latest postsNew threads

Latest Hosting OffersNew Reviews

Sponsors

Latest Blog ArticlesMost Viewed Threads

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