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: 42
Joined: Mon Aug 30, 2021 3:05 pm

Return to Support

Who is online

Users browsing this forum: No registered users and 276 guests