Vicidial Reports

[Docpluto]

Hello-

We have a 6 server load balancing cluster setup with the following configuration:
2 Webservers, 2.4 Ghz Core 2 Quad Quad Core Dual 256GB SSD Raid1 8GB DDR2 Ram
3 Asterisk Server 3.4 Ghz Xeon E3 Quad-Core w/HT Dual 256GB SSD Raid1 16GB DDR3 Ram
1 Db Server 2.13 Ghz Xeon E5 6-Core w/HT Dual 256GB SSD Raid1 24GB DDR3 Ram
VERSION: 2.12-478a
BUILD: 150307-1914 Vicidial Scratch install on Centos 6.x

I have had some custom reports built that pull many different sources of information. The reports work fine however these reports take over 5 minutes to generate for 1 days activity, more days = more time. I am wondering if there is any way to speed the process of of getting reports from vicidial?

[boybawang]

you can setup a replication server and pull reports from there

[Docpluto]

What do you mean replication server? A server that just does reporting? Please explain in greater detail.

[bobchaos]

He means you need to setup a 2nd MySQL server, slave it to the first one and then tell Vicidial to use it for reporting. under Admin --> System settings. Making a slave server is something you'd better research on MySQL forums but it's a very common thing to do with databases for both redundancy and efficiency purposes, you should have no trouble finding info on it.