MariaDB vs Mysql

spark92

Looking at trying to decide on MariaDB vs Mysql
I have used OSTIcket with a previous employment with MySQL
Is there any advantages or disadvantages between the two?

RBGE

spark92 Other than "it's not Oracle", MariaDB is designed to be exactly the same as MySQL, just with a fully open-source licence. I've been using it with osTicket since 1.10 (and other applications for well over a decade) without any issues.
Generally you'd want to go with whatever is easiest to update, usually the one that's present in your system's repository. As I use a Fedora server, it's MariaDB on my system.

spark92

RBGE
I'm on the fence which to go with as we don't use either one
thank you for your opinion. Appreciated

ntozier

I've used both. I ran MySQL starting with osTicket 1.6ST to i think 1.12.
When we setup a new web server [and migrated] I switched to MariaDB.
I honestly haven't noticed a difference in performance between the two.
I switched to MariaDB because I heard that is what the Devs are actively developing with.

atilav

By the way, anyone here using it with a galera cluster?!
I just installed 1.15.2 and we are starting to put it in production; (our last server had more than 190K tickets)
So, I am considering if there are any advantages to use a galera cluster as DB backend.

Any insights or advises here?

ntozier

Sorry, I've never heard of it.

KevinTheJedi

@atilav

Galera Clusters are really good and useful (if setup properly). You can even use ProxySQL to load balance the database traffic.

Cheers.