Quote:
Originally Posted by Raun
If I am installing this on a vbulletin installation that is setup as follows what box would it go on?
1load balancer
4 web servers
1 master DB
1 slave DB
|
It depends on the load on the two db servers. My guess would be that the least loaded in this configuration will be the master db server. Both master and slave are handling the same number of write (INSERT/UPDATE/DELETE) queries but the slave will be handling a load of reads too.
With a bit of scripting wrapping index copying (rsync probably) and restarting searchd you could generate the indexes on one machine and then copy them out to another one. This might be handy if you want to build some kind of redundancy into your setup or be able to balance sphinx traffic.
10-21-2009, 07:22 AM
Hybrid Mode
