Sphinx Search

[ALanJay]

Originally Posted by Neil Lock

Finally got it to work,

Now I have another question, I want to run this from a slave database ie grab the query data but the sphinx requires the REPLACE INTO which obv cant run on a slave instance so my question is this - is it possible to hook this up to run on the master for the replaces and the slave for the other queries. I intend on going and playing but wondered before hand whether anyone had a solution?

Thanks

Neil

Can I ask why?

searchd can be on any computer and the database it looks into can be on any other one (that it can see). You obvioulsy have to configure the front end to look at searchd on the correct computer and change the localhost references to the IP address of the machine that has searchd running on it.

But the load from indexing the files isn't that great and the way Oban has implemented it with a main index and deltas means that even with a large board with lots of posts and we get from 10,000 to 40,000 a day running the rebuild of the full index once a day at a quite preriod will not put a load on the database (and in our case with a file with nearly 12 million posts it takes under 5 minutes). The creation of the delta file which I run every 5 minutes takes just a few seconds.

Sphinx's overhead when indexing seems very small (as far as I can tell) on the mySQL database so I don't see the need to complicate things.

In my setup:

HTML front ends (x8 - 10.10.10.11 to 10.10.10.18) sphinx.php points to 10.10.10.19

10.10.10.19 - searchd when index created looks at 10.10.10.1

10.10.10.1 - mySQL master database

As I understand it all Sphinx leaves in the database is a marker to say where the line between the main and delta database is.

Good luck Neil