FusionPBX with Mysql

Status
Not open for further replies.

Vishal Pai

Member
May 2, 2017
35
1
8
34
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

Administrator
Staff member
Sep 29, 2016
3,038
556
113
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.
 
  • Like
Reactions: yukon

smn

Member
Jul 18, 2017
201
20
18
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.
 
Last edited:

DigitalDaz

Administrator
Staff member
Sep 29, 2016
3,038
556
113
He has absolutely mentioned in the past that he may introduce features that are dependent on postgresql.
 

djzort

Member
Feb 28, 2018
76
5
8
41
Sydney, Australia
bytefoundry.com.au
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

Member
Jul 18, 2017
201
20
18
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.
 

phonesimon

Member
Apr 21, 2017
87
15
8
43
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

Member
Jul 18, 2017
201
20
18
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.
 
Last edited:

DigitalDaz

Administrator
Staff member
Sep 29, 2016
3,038
556
113
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

Member
Jul 18, 2017
201
20
18
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

Administrator
Staff member
Sep 29, 2016
3,038
556
113
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

Member
Nov 6, 2019
37
1
8
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

Active Member
Jun 12, 2018
884
195
43
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

Member
Nov 6, 2019
37
1
8
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
 
Status
Not open for further replies.