solved MariaDB and Litespeed Server

Hello I had a couple questions concerning server upgrades. Last night I switched fro Apache Server to Litespeed and the difference has been notable-however I am seeing an issue with mp3 files not playing in Chrome and Firefox-my server support has not been able to resolve other than they have identified it as a Litespeed issue and are working with Litespeed to try and understand/fix
My question on this is has anyone else tried running Litespeed in place of Apache?-If so have you seen the issue and resolved it?

My second question is concerning possible issues switching from mysql 5.6.35 to MariaDB 10.1
Are the tables in MariaDB formatted the same as Mysql? Any issues upgrading I should be aware of?
I also have a ecommerece store installed with jamroom in a subfolder and i am trying to find if everything will go off without a hitch if i switch...

Litespeed claimed that their server just snapped in and replaced apache without any issues...which was not 100% correct-I am confident they will get it worked out but was wondering if anyone has had any experience with the above?
updated by @derrickhand300: 10/24/17 01:46:12PM

Docs: "Requirements"
https://www.jamroom.net/the-jamroom-network/documentation/appendix-about-jamroom/774/requirements

MariaDB is one of the Supported Database.

MariaDB works really well - I use it here as my main development platform. I can't comment on Litespeed as it's not something I have actually used.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Thank you

Hello Brian...I just upgraded to mariaDB 10.0 as it was the recommended upgrade in WHM...then running a performance check and I have lost almost 50% of my performance score- is there something I am missing on this upgrade? My scores were consistently around 2100 before the upgrade but now they are 1200-1300....Its going to take a complete server restore to get my old DB back...so i wanted to ask if you had any idea what would cause this? The screenshot shows last 3 tests after upgrading to mariaDB
Wondering if its possible that Performance check is not configured for mariaDB? Sorry just puzzled here
updated by @derrickhand300: 07/25/17 05:17:17AM

Reading on this
https://mariadb.com/kb/en/mariadb/configuring-mariadb-for-optimal-performance/
it sounds like there is quite a bit of tweaking to be done to mariaDB for best results- Brian can you share the settings you use for MariaDB 10.1 here? ( I just updated from 10.0 to 10.1 hoping for a change)
From what i have gathered it sounds like MariaDb took all the personel from Mysql when they kicked off and my personal feeling is that maria is the future- so i would like to be on board now- just hate to ,lose all that performance..
updated by @derrickhand300: 07/25/17 07:50:49AM

Yeah you for sure want to be on 10.1. It sounds like you're probably running a default config file, while MySQL had one that had been configured. How much RAM does your server have?


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Thank you Brian-I will attach server details in a screenshot

Any chance of an update on this? I have to restore my server from backup within a couple hours or lose the backup and I was hoping to test the settings

I'm not in the office today so haven't been online - sorry about that. Here's what we use for a 4 Gig RAM server:


MariaDB 10.1 out performs MySQL 5.5 and 5.6 using that config. Of course your mileage may vary since I have no idea what else is running on your server.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

THANK YOU BRIAN!

Thanks Brian we just updated the settings and still not much difference...just curious do you think i should just stick with maria and accept the performance loss?
My previous mysql installed I was seeing on average just over 2000 performance score- with Maria im seeing an average of around 1300-1400
Just curious its human nature to want the 2000+....but is there really any difference in a 2000 and say a 1400?

I would stick with MariaDB - it typically does better on JOIN's, which the performance check doesn't measure as well - so I think in "real world" it will perform better than MySQL.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Thanks!