On my quest to find the best search solution I have come across Sphinx which comes highly recommended.
My question is about the setup structure on the following server setup:
2 x webservers load balanced
1 x master (2gb mem, 2 cores)
1 x slave (3gb mem, 4 cores)
I have mysql replication across master and slave and now I want to introduce Sphinx.
Ideally I'd want to seed the index on the master and have the sphinx-queries sent to the slave via the php api.
Has anyone got any experience doing this? Is the index r-synced across to the slave to keep it in sync? Do I just install sphinx on the master? What about the web-servers and the php-api, do they both need sphinx installed too?
Any help getting me started is much appreciated!