FreePBX 16 with MariaDB against MySQL 5.7

FreePBX Installation / Upgrade
#1

Hi All!
I installed FreePBX 16 + Asterisk 19 + MariaDB 10.3 on Ubuntu 20.04 server
From wiki Installing FreePBX 16 on Debian 10.9 - FreePBX OpenSource Project - Documentation
it’s recommended to install MariaDB as RDBMS.
So, my question is:

  1. What is reason of choosing MariaDB to be used with FreePBX 16 installation?
  2. Can I install MySQL and will it work properly? If it willn’t - why?

First I installed MySQL 5.7.33 but ran into problem with restoring from backup as well as installing modules. The issue was lower_case_table_names=1 in mysqld.cnf (I figured it out later).
So I decided to install fresh MariaDB.

But in our company usually MySQL 5.7.33 used for RDBMS purposes.
So I need clear explanation why it is (strong?) recommended to use MariaDB RDBMS.

Thx for answer!

#2

https://www.google.com/search?q=maria+vs+mysql&oq=maria+vs+mysql&aqs=chrome..69i57j0l6.3732j0j1&sourceid=chrome&ie=UTF-8

#3

But what about second question?
I couldn’t found DB compatibility list regarding to FreePBX 16 installation

#4

The compatible db is Maria. You’re headed down a path that (with enough knowledge) you could probably make work, but the level of effort to do it and maintain it (so much is tied to the db and it could all break, leaving you to run down ghosts). Even if all that was not enough, you are creating a scenario where potentially no one (even paid support) will be able to help you if you have problems down the line. It is not a good idea.

Alternatives? Install vanilla Asterisk and use MySQL.