ntozier Indeed, I've been using MariaDB ever since I started using osTicket (with an unsupported PHP 7.2 *cough* *cough*). It's standard on all Fedora builds, and uses exactly the same commands as 'real' MySQL, so shouldn't have any compatibility issues.

For what it's worth, I'd recommend MariaDB too, but that's primarily because I hate Oracle ?

@RBGE yeah I'm not an Oracle fan either. I've setup both. While I haven't done any hard bench-marking of the two, my general perception is that MariaDB is faster with osTicket. Have you found the same?

ntozier I'm afraid I can't really do a proper comparison, as I've been using MariaDB as default for years in pretty much all Linux servers, and my osTicket DB is still on the small side (only started at 1.10.4). I've never once had any reason to switch to Oracle's offering though, so while I can't attest to speed, I can to compatibility!

Understood. Thanks for the compat testament. ?

Can we get an update on mysql8 compatibility? I need to migrate from 5.5 to a new corp v8 mysql and this is not a viable option for us.

@btshowers

@ntozier blogpost is a really good read on this subject. Basically, osTicket is fine with MySQL 8 (and MariaDB’s equivalent) as long as you set the default character set to utf8 (or specify utf8 when creating the db) and making sure that the default password method is native or ensure the database user has native method.

Cheers.

KevinTheJedi @ntozier yes, I read all of the specifics around setting the default character set on the instance to utf8 and enable native (legacy) password support. The issue is that this runs on a corporate mysql server and they are unwilling to make this instance change for the character set just for a one-off like mine. their take is that you should be able to tell the app to use utf8mb4. There is also support for this in PHP 8. Furthermore when you set this setting on a mysql instance you get this message indicating it's best practice to use utf8mb4: [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. So the real question is when will OSTicket be PHP 8 and MySql 8 (with utf8mb4 support) compatible?