Lead search not honoring slave DB?

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Lead search not honoring slave DB?

Postby RBecker » Fri Sep 29, 2023 4:12 pm

Hey all,
Was looking into some slow queries on our system and noticed some lead search queries in the log that were occurring on our primary DB server. In the System Settings I have the slave DB enabled and the "Search Leads Logs" report (among many others) selected as a report to use the slave DB. I looked at the /vicidial/admin_search_lead.php file and it appears that these queries are being forced back to the main DB whenever it's returned to use the slave DB. Just wondering if there is any legitimate reason for this and why it's included in the first place.

Version 2.14b0.5, build 230421-1739, SVN 3719
Managed & Dedicated ViciDial Hosting | VoIP Trunking and Termination | https://www.dial-fusion.com/
Main Cluster: 21 Agent Servers | Dedicated DB and Separate Reports Server | 2 Web Servers | HAProxy Load Balancing | Dedicated Archive Server
RBecker
 
Posts: 43
Joined: Mon Aug 30, 2021 3:05 pm

Re: Lead search not honoring slave DB?

Postby williamconley » Fri Jul 26, 2024 10:00 am

Have you confirmed that these are "Search for a Lead" and not other processes? Such as viewing lists and/or campaigns with lists and lead counts? Most normal admin web pages appear to pull only from the Master.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20253
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Support

Who is online

Users browsing this forum: No registered users and 96 guests