I am trying to use Sphinx full-text search capability for my MySQL server. I have setup a local Sphinx service based on the installation manual and able to do text search.
I can connect to
mysql.exe --host=127.0.0.1 port=9306
Where the port 9306 is the port configured in sphinx.conf:
searchd {
...
listen = 9306:mysql41
...
}
And do SphinxQL queries. I am using the default Sphinx example database shipped with the release package.
However I want to integrate Sphinx with my MySQL server, such that all the clients connecting to my sql server can do SphinxQL and I want to try it out with the MySQL sample database sakila
- What are the steps to achieve that?
- Do I need to convert the database engine from InnoDB to Sphinx?
- Also, from what it seems, Sphinx can only index one (1) database table per configuration, how can I make sure that all tables in the MySQL database gets indexed?