Sphinx: Initialize a real-time index

Question

I would like to migrate one of the sphinx indexes in real time. However, the rt index does not take the source, and its initialization is a bit messy. Is there a way to migrate an existing index in real time without a lot of scripting?

Answer 1

There is currently no official way. Only individual solutions. In this interesting document (PDF), there is one way:

mysqldump -uroot blog users > users_dump.sql mysql -P9306 < users_dump.sql 

Sincerely.

Answer 2

I am glad that my presentation was useful, but now Sphinx has a new team that helps move from source to real-time indexes: Attach an index

It's simple:

 ATTACH INDEX diskindex TO RTINDEX rtindex 

By the way, I wrote a blog post that details the attach index .