I need to set up Sphinx Search attached to MySQL on Amazon EC2. I then need you to test it and make sure it works with the configuration file I made. Correct and improve the configuration file on both my local machine and server and test it. I want you to create a test PHP file for testing purposes.
I will use Sphinx to perform Autocomplete.
I will also use Sphinx to perform keyword searches.
I will use Sphinx to perform prefix searches as well.
I will need advice regarding the configuration and my queries.