I am currently running MariaDB on a Linux server.

In this post, @Marc commented that MySQL is what IPS supports.

https://invisioncommunity.com/forums/topic/481462-maria-db-for-ic-5/#findComment-2989786

I contacted my host, and they said I could remove MariaDB, and import my data into MySQL; however, they felt that MariaDB performed better than MySQL in a Linus environment. They also suggested MySQL would be better in a Windows environment.

Am I better off staying with MariaDB on Linux, or moving to MySQL on Windows?

I am not a server guy, just someone who runs a few forums.

Thanks

In my opinion MariaDB is better. They are both RDBMS (Rational Database Systems) that share the common origin. MySQL is owned by Oracle, whereas MariaDB came from the original creator of MySQL (I think I read that somewhere). MySQL has proprietary (yes thank you spell check, I suck)... items that require a commercial license. Although MariaDB does not have the proprietary stuff in it.

MariaDB offers multiple storage engines like Aria, TokuDB, XtraDB, and ColumnStore and Thread Pooling, Parallel Replication, and Query Optimization at no cost, whereas MySQL only InnoDB as the default storage area. I think others can be used as well as Thread Pooling for a cost.

I can go on and on, but overall, I choose MariaDB.

I forgot to mention the security side of it... (Thank god my boss can't see this post!)

Security

• MySQL is native SSL/TLS, and Native Data-at-Rest Encryption (at a cost)

• MariaDB includes Data-at-Rest (no cost), RBAC (Role Based), and User Account Locking and Dynamic Privileges for granular control.
  
  

Edited February 7Feb 7 by Code Name Jessica

We can only really tell you that we optimise for MySQL 8. This isnt to say you may not see better performance personally based on your own experience (or your hosts). However similarly, we can state only from our own tests and what we optimise for.

What we have see, as mentioned there, is there are people who have been running mariadb for quite a while who have seen improvements in speed after moving to mysql

Thank you both.

It's a lot easier to stay where I am than move to a Windows server. I have several other programs running on this VPS.

Its worth noting, we do not at all recommend moving to a windows server. MySQL 8 on linux, not windows

☝ DO NOT MOVE TO WINDOWS, I BEGGITH OF YOU. WINDOWS BAD (I am a Linux Admin, so I get to poke at the bear, you know like the _______ ok, I was going to say some sports team here, but I can only think of steelers, but I don't know anything about them.

Edited February 7Feb 7 by Code Name Jessica

Be sure your server is using Nginx @Square Wheels.

Provided your server has enough RAM for your site's demands, and the server is properly set up, you should be fine.