Quote:
Originally Posted by psico
I want to hack my vb 3.6.1 to send only searches to the Slave server, because when someone makes a complex search, the POST table on the slave get locked and all the queries to the POST table are locked until the search finish... That?s why I need to send ONLY searchs to the SLAVE DB...
Anyone know how to do that?
Tnx a lot in advance and sorry for my bad english!
Psico.
|
Hello psico,
Let me see if I understand you question. You want all your searches be sent to your slave DB and not the primary, is that right? If so, its quite simple, I use the following for my NightClubber website
Code:
on your config.php file, add:
if (THIS_SCRIPT == search)
{
**Slave DB details go here**
}
The problem is, that with this code edit, your primary database will replicate into the slave database. Im not quite sure how to replicate only the necesary tables.