- Edited
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?
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?
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.
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.
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?
Sorry, I've never heard of it.
Galera Clusters are really good and useful (if setup properly). You can even use ProxySQL to load balance the database traffic.
Cheers.