Version: , by psico
Developer Last Online: Aug 2013
Version: Unknown
Rating:
Released: 10-19-2006
Last Update: Never
Installs: 0
No support by the author.
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.
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
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.
Some hosts auto prefixes the database made with the username. So say, I have 2 domains (on two different boxes). Then I make a masterdatabase called forum at domain1, but that's called domain1_forum, I can call the slavedatabase on the other domain (different serverbox) forum too. But as it's on domain2, it's automatically called domain2_forum.
What to do in such cases?
(Talking about shared and partially dedicated hosting).
Some hosts auto prefixes the database made with the username. So say, I have 2 domains (on two different boxes). Then I make a masterdatabase called forum at domain1, but that's called domain1_forum, I can call the slavedatabase on the other domain (different serverbox) forum too. But as it's on domain2, it's automatically called domain2_forum.
What to do in such cases?
(Talking about shared and partially dedicated hosting).
AS far as vB is coded, there is no way to do what you ask because both databases need the same table prefix.
BUT, if you own the 2 boxes, you can always log in as root and set up a new database without a prefix. Or, better the case, add a new prefix matching your box1's prefix.
If you really cant make the slave database name mirror the name of the master DB, you should submit a ticket to vBulletin Support Staff, but actually they will tell you the same thing I did. Maybe you should contact a vB coder and ask for this edit.
In search.php, I modify the search queries to point to the slave database server. You only need to replicate user, forum, post and thread on the slave search database.
In search.php, I modify the search queries to point to the slave database server. You only need to replicate user, forum, post and thread on the slave search database.
but when you fill in the slave DB server details into the config.php, doesnt vB automatically replicate the whole DB into the slave? I thought it was like this.
In search.php, I modify the search queries to point to the slave database server. You only need to replicate user, forum, post and thread on the slave search database.
Erwin, could you go into a little more detail on how you did this? Or better yet make a hack?
but when you fill in the slave DB server details into the config.php, doesnt vB automatically replicate the whole DB into the slave? I thought it was like this.
thanks for the tips Erwin
vBulletin does NOT replicate any of your data for you. If you don't already have a replicating pair setup, you shouldn't fill in the slave server details.
Slave Server --> Search ONLY Details »»
About Developer
Visit Web Site
No support by the author.
10-25-2006, 04:35 PM
