I would like to migrate one of the sphinx index into real time. However, rt index doesn't take a source and its initialization is开发者_开发百科 kinda messy. Is there a way to migrate existing index into real time without a lot of scripting?
I am glad that my presentation was helpful, but now Sphinx has new command which help migrate from original to real-time indexes: attach index
It is simple as:
ATTACH INDEX diskindex TO RTINDEX rtindex
BTW, I have wrote a blog post which describe attach index command in details.
At the moment no official way exists. Only custom solutions. In this interesting document (PDF) there is one of the ways mentioned:
mysqldump -uroot blog users > users_dump.sql
mysql -P9306 < users_dump.sql
Regards.
精彩评论