VoIP Mailing List Archives

[abaci64 at gmail.com]

I was wondering if anyone is working on implementing in freeswitch support for dqlite https://github.com/canonical/dqlite to support a distributed freeswitch system for core database.

[abalashov at evaristes...]

Wouldn’t you just use a different RDBM backend at that point? 😂 Like, one that is designed for network connectivity and already has advanced replication?

—Sent from mobile, with due apologies for brevity and errors.

[krice at freeswitch.org]

Why? thats what things like PostgreSQL and MySQL are for

Sent from my iPhone

[abaci64 at gmail.com]

The reason I would consider this over PostgreSQL or MySQL is the simplicity of setting it up, compared to setting up a proper replicated system with those databases. not that they don't have their uses but for setting up something like the core db of freeswitch I think something like dqlite makes sense.


On Sun, Nov 1, 2020 at 10:12 PM Ken Rice <krice@freeswitch.org (krice@freeswitch.org)> wrote:

[brian at freeswitch.com]

Simplicity will bite you if not careful.

On Mon, Nov 2, 2020 at 1:45 PM Abaci B <abaci64@gmail.com (abaci64@gmail.com)> wrote:

[abaci64 at gmail.com]

I totally understand that others may have different opinions about this, I just wanted to know if someone was already working on this as I was considering working on implementing it, based on the reactions it seems that even if I would implement dqlite, I would have a hard time getting it accepted by the core developers.


On Mon, Nov 2, 2020 at 4:45 PM Brian West <brian@freeswitch.com (brian@freeswitch.com)> wrote:

[krice at freeswitch.org]

If its just distributed sqlite the question becomes “just why”?  theres other scaling issues in sqlite like locking that even on a largely idle system cause DB select retries regularly. This isnt a FreeSWITCH Problem but  is a problem down deep in the sqlite code. This is why it is recommended that you go to an external DB where possible.

K

From: FreeSWITCH-users <freeswitch-users-bounces@lists.freeswitch.org> On Behalf Of Abaci B
Sent: Monday, November 2, 2020 5:12 PM
To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>
Subject: Re: [Freeswitch-users] distributed sqlite


I totally understand that others may have different opinions about this, I just wanted to know if someone was already working on this as I was considering working on implementing it, based on the reactions it seems that even if I would implement dqlite, I would have a hard time getting it accepted by the core developers.


On Mon, Nov 2, 2020 at 4:45 PM Brian West <brian@freeswitch.com (brian@freeswitch.com)> wrote: