FusionPBX with Mysql

[Vishal Pai]

Hi

I want to setup fusionpbx with mysql. It was there in older version but v4.x i din't find. Any suggestion will highly appreciated.

 

[DigitalDaz]

I would advise you not to use mysql, the developer has stated, if he has not done it already, that going forward there will be features that are dependent upon postgres.

 

[smn]

I would advise you not to use mysql, the developer has stated, if he has not done it already, that going forward there will be features that are dependent upon postgres.

Are you sure about that? He only said he is not testing MySQL anymore is my understanding. I have it working nicely on MySQL.

Also, the default OS is Debian and Debian 9 now uses MariaDB (MySQL) by default. So there is a bit of a conflict there where the default OS is going in one direction and he is going in another.

 

[DigitalDaz]

He has absolutely mentioned in the past that he may introduce features that are dependent on postgresql.

 

[djzort]

Why would MySQL be preferable to PostgreSQL anyway? FusionPBX will install it all for you - and even take backups of that database? If you want to add some integrations, every language has PostgreSQL (be sure to integrate against custom views, not against the tables directly!)

 

[smn]

Why would MySQL be preferable to PostgreSQL anyway? FusionPBX will install it all for you - and even take backups of that database? If you want to add some integrations, every language has PostgreSQL (be sure to integrate against custom views, not against the tables directly!)

FusionPBX doesn't install it for you. I guess I lot of people use the script. I prefer doing it all myself so that I am more in tune with what is going on. Installing it is not the problem. I just prefer working with MariaDB, and clustering MariaDB 10 is quite easy.

 

[djzort]

apt-get install postgresql... easy

 

[smn]

apt-get install postgresql... easy

I am talking about all the things you have to do after you install it if you don't use the script

 

[djzort]

you create a user then create a database. its literally the same number of steps as mysql.

 

[DigitalDaz]

Creating a BDR cluster is very easy. I'll make a tutorial soon.

 

[phonesimon]

I am talking about all the things you have to do after you install it if you don't use the script

I have limited knowledge of BDR but a decent amount of experience with Galera. As I understand it the same kinds of schema modifications (specifically, primary key requirements) will be necessary whether you use BDR or Galera in order to prevent replication collisions.

 

[smn]

I have limited knowledge of BDR but a decent amount of experience with Galera. As I understand it the same kinds of schema modifications (specifically, primary key requirements) will be necessary whether you use BDR or Galera in order to prevent replication collisions.

It's a mesh. So every node talks to every other node and treats them the same. Galera doesn't really work like that. Galera could probably scale a lot better but not an issue if you are only doing 2 or 3. I don't see anything in the BDR documentation about quorum. Galera needs 3 for proper operation because of quorom. BDR doesn't say and I spent quite a bit of time looking.

I would much prefer to use Galera myself. I think it's a big mistake to not support MariaDB. Debian 9 uses that by default. I think a lot of people are moving to MariaDB. From a development point of view, you will find more people familiar with MariaDB, myself included. That is an often overlooked consideration for open source.

 

[DigitalDaz]

I'm sure every database would be supported if the project had the resources to do it. The current Postgres/BDR method has been in use now in production since at least early 2015 and has served everyone well.

I know postgres brings other things to the table for example, autovacuuming, uuid, json and jsonb datatypes etc.

 

[smn]

I'm sure every database would be supported if the project had the resources to do it. The current Postgres/BDR method has been in use now in production since at least early 2015 and has served everyone well.

I know postgres brings other things to the table for example, autovacuuming, uuid, json and jsonb datatypes etc.

Are you running BDR with only 2 nodes? I am trying to figure out if 2 nodes is considered adequate or if it risks a split brain situation typical of master-master setups. I could not find anything in the documentation about that.

Usually master-master needs at least 3 nodes to avoid the potiential for split brain.

 

[DigitalDaz]

Its sort of not an issue.

I only ever use one GUI to edit things, everything that gets done that isn't in the gui, is fine anyway.

Really the only database stuff that gets done at the PBX level is inserting CDRs and they have a UUID as the primary key.

 

[sokalsondha]

Hello Can someone give me some help to install fusionpbx with MySQL? i dont mind using the old version. as i only need basic pbx feature.
but i am totally lost with postgresql. so if i can use Mysql i will be fine.
which version fusionpbx had the mysql? i heard that initially fusionpbx was with mysql.
if someone has those files can may be give me. so i can install the fusionpbx with mysql
looking for to install it in the debian machine

thanks

 

[ad5ou]

Fusionpbx does not support using Mysql and attempting to use an older version to gain compatibility with Mysql is dangerous. Countless bugs and security issues have been resolved in the latest Fusionpbx code even compared to the last “stable” release. Older versions have even more security problems.

Your best option if you wish to use Fusionpbx in a production environment is to pay for the monthly membership at Fusionpbx.com. The paid membership will give you access to more documentation and most importantly access to the videos from previous admin and advanced training classes.

If paid training is not an option, there is lots free information on the internet for postgresql. If you know MySQL, there isn’t much of a learning curve to understand postgresql

 

[sokalsondha]

thnaks very much for you explain..
i have checked the postgresql database structure for fusionpbx.. but seems to be very hard and too many things in the database..
thanks for your time sir