Username:

Password:

Fargot Password? / Help

sharding

February 6, 20134 years ago

Sphinx Vs Lucile

In the past few weeks I've been researching how to improve db queries for scaling purposes and having in mind the MySQL sharding approach.

So, we are looking for a stand-alone full-text search server with the following properties:
.Must operate as a stand-alone server that can serve search requests from multiple clients 
.Must be able to do "bulk indexing" by indexing the result of an SQL query: say "SELECT id, text_to_index FROM dbtable;" 
.Must be free software and must run on Linux with MySQL as the database 
.Must be fast (rules out MySQL's internal full-text search)

Read more