Has anyone switched from MySQL to MariaDB?

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

Has anyone switched from MySQL to MariaDB?

Post by weblike »

Hi,
Has anyone switched from MySQL to MariaDB?
Any issues?
Steps to proceed?
Experience so far?
Please share.
thank you
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
customaware
Posts: 2391
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Has anyone switched from MySQL to MariaDB?

Post by customaware »

Yep. So far so good.
Couple of issues in first 8.3 build which are now fine.

I think there was a couple of different reserved words which Vlad has fixed.

Early days but so far pretty happy.

Not sure if it is, but it seems faster and can also do sequences which MySQL cannot do.
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

Re: Has anyone switched from MySQL to MariaDB?

Post by weblike »

Have you switched a production server or build a new one with MariaDB.
1. Update from MySQL to MariaDB?
2. Build new server MariaDB-> export MySQL DB -> import in new server?

Thank you for your reply.
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
customaware
Posts: 2391
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Has anyone switched from MySQL to MariaDB?

Post by customaware »

Option 2 Gheorghe.
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: Has anyone switched from MySQL to MariaDB?

Post by Jaymer »

WHY MariaDB (other than Sequences) ???
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

Re: Has anyone switched from MySQL to MariaDB?

Post by weblike »

There are lot of articles/benchmarks for Mysql&MariaDB

https://www.liquidweb.com/kb/mysql-perf ... s-mariadb/

We are using a few hosting servers with cPanel, PHP&Laravel, and since we switched from MySQL to MariaDB, speed&stabilty are much better.

Cheers,
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
Markfre1
Posts: 221
Joined: Sun Mar 11, 2012 10:15 pm
Location: United States

Re: Has anyone switched from MySQL to MariaDB?

Post by Markfre1 »

You need to read some other comparisons as well. I had read a bunch of comparisons a month ago, and think I concluded the Mysql was the route for me. I'll see if I can dig up some of the info.

Mark F
Post Reply