FreeSWITCH's core.db I/O Bottleneck - to set or not to set to RAM disk

[acpan22]

Hi,

I was reading up ASTPP 4.0.1 and i installed on Debian 9 for trying, and checked the core.db settings on the astpp manual,

from the ASTPP manual it says,

/usr/local/freeswitch/db into an in-memory filesystem.  

On current FreeSWITCH versions you should use the documented "core-db-name" parameter in switch.conf.xml 

(simply restart FreeSwitch to apply the changes): 

<param name="core-db-name" value="/dev/shm/core.db" /> 

Also FreeSwitch manual stated:

Otherwise you may create a dedicated in-memory filesystem, for example by adding the following to the end of /etc/fstab

fstab Example

# # Example of /etc/fstab entry (using default size) # tmpfs /usr/local/freeswitch/db tmpfs defaults 0 0 # # To specify a size for the filesystem use the appropriate mount(1) option: # # tmpfs /usr/local/freeswitch/db tmpfs defaults,size=4g 0 0 #

To use the new filesystem run the following commands (or the equivalent commands for your OS):

mount /usr/local/freeswitch/db

Also stated:

An alternative is to move the core DB into an ODBC database, which will move this processing to a DBMS which is capable of handling large numbers of requests far better and can even move this processing onto another server. Consider using freeswitch.dbh to take advantage of pooling.
==============

I can find the above path, and the last sentence above says  another way is to move the core DB into an ODBC database, my question is;

Is ASTPP using core DB into an ODBC database? or file system or RAM? 

How do we set it to use RAM on Debian 9 ASTPp 4.0.1 if it is not on DB? It's kind of confusing.

Thanks for guiding.

ACP

[Mario Raulino]

Hi, about db into ram read, has to do with ssd and performance https://freeswitch.org/confluence/display/FREESWITCH/Performance+Testing+and+Configurations

ODBC I used to share internal information like: calls, registrations, sessions, etc... with other machines in a cluster. I had problems when I put 5 machines sharing the same db. Today I use an opensips in front of the machines.

I belive you can be free and choose that works best on your system.

--
=====================================================================
Documentation: https://docs.astppbilling.org/display/itplmars/ASTPP
Please contact at sa...@inextrix.com for commercial support.
---
You received this message because you are subscribed to the Google Groups "ASTPP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to astpp+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/astpp/d0538c0d-cbd0-4775-b482-c1d19cb60a01%40googlegroups.com.

--

Atenciosamente;

Mario Felipe Raulino

TOTALVOICE

ro...@totalvoice.com.br

mario....@totalvoice.com.br

(011) 4858-1631

(048) 3181-0323

[Samir Doshi]

ASTPP use default settings of FreeSwitch and that is on RAM. 

Samir Doshi Director iNextrix Technologies Pvt. Ltd. samir...@inextrix.com smrdoshi www.inextrix.com +1-315-898-1139 (USA) | +91-79-29700670 (India)

Services we offer :VoIP Development | Mobile development | AR development | Wearable Development | Web Development | SEO

Our Products: VoIP Billing Solution & More Intelligent Call Center Software Mobile SIP Softphone Windows PC Softphone Live Call Monitor Disclaimer: The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance on the contents of this information is strictly prohibited and may be unlawful. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it.

Sender notified by Mailtrack 10/30/19, 11:41:10 AM

To view this discussion on the web visit https://groups.google.com/d/msgid/astpp/CAKfJ-sCEtjRt7MqnsjrFO%3DrDjospEoOb%2BBpDmjavk5mSxsJ8Bg%40mail.gmail.com.

[acpan22]

Thanks Mario for sharing. I am still at the basic level, but appreciate your tips.

Thanks Samir, it is really good to know RAM is used as a default.

ACP