Use Remote MySQL Server for Asterisk Database


(Jerry Riggin) #1

In order to increase capacity, I would run MySQL on a separate server. NOT just CDR, but the whole server with all FreePBX 14 (asterisk) tables. I’ve googled this but can only find how to use remote CDRs. I have second server on a 10G connection and I want all database activity on the remote server. Is that doable?


(Lorne Gaetz) #2

Should be. Not something I’ve done personally, but the FreePBX mysql details are as defined in /etc/freepbx.conf.


(Itzik) #3

AFAIK, the general config Database isn’t that large. Only CDR is what’s growing continuously.


(Jerry Riggin) #4

We have a CSR GUI for queue agents that is DB intensive and integrated with the FreePBX tables in the asterisk database. Following @lgaetz advice, I modified /etc/freepbx.conf and presto I am using an external SQL server for everything, including CDR with no mods to CDR in advanced settings.

I love when stuff just works without hours of extra work! Thanks, Lorne.


(Dave Burgess) #5

You could post an ‘anonymized’ version of the changes, just to complete the documentation chain.


(system) closed #6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.