Search page in live site(CDS) showing results from "web" db not from our "prod_live" db
We have two databases in Live server(CDS), one is "web" db and "prod_live" db. We need to get the result from "prod_live"db not from web db for search pages. I would like to know which config we need to change to achieve this.
Kindly suggest on this.
Thanks in advance!
Have you looked at the Coveo for Sitecore scaling documentation? It covers this exact use case: pub DB instead of web DB on the content delivery (CD) instances.
Since you have CD instances and are having this web vs prod_live DB problem, I suggest you read and apply the whole guide from the very beginning. There are probably other things that should be configured in your setup.
v4 and 4.1: https://docs.coveo.com/en/661/coveo-for-sitecore-v4/coveo-for-sitecore-scaling-guide