Project

General

Profile

Separate server for database and its effects on performance

Added by SPAMMED SAM about 7 years ago

Currently I am running GoAutoDial 3.3 for a call center with roughly 100 agents.

Recently we have been having server load issues where:

1. Agent call quality has suffered
2. Agents have been experiencing frequent time sync errors
3. RAM is almost fully cached

From what we have observed MySQL is responsible for the RAM becoming fully cached resulting in various errors, making the dialer unresponsive. We have already increased the amount of physical memory substantially to no avail, MySQL slowly caches memory to the point of system instability.

Whenever the issue occurs we run the following command to clear the cache, which resolves the problem until the memory is full again:

echo 2 > /proc/sys/vm/drop_caches

I want to try setting up the MySQL database on a separate server where it has its own resources that it can use without unduly impacting other components of the dialer, such as asterisk or httpd.

I know that you can point the dialer to a db on another server in the astguiclient.conf file but still have a few questions:

1. Is that the only config that needs to be done, or are there other settings that need to changed as well in the filesystem?
2. Does having MySQL on a separate separate server increase the dialers proneness to certain issues?
3. Has anyone ever tried it out and what were their experience?

Thanks in advance


Replies (1)

RE: Separate server for database and its effects on performance - Added by Ankit Aparajey about 7 years ago

it can be achieved by clustering and pruning, but needed to know few more things in order to help you out properly. it is better to contact us directly on mail : or skype : incorpus.support for faster assistance.

    (1-1/1)
    Go to top