CODEWITHSUNDEEP
sphinxmysql-proxy
Nick
Nick

Reputation: 10539

Using MySQLProxy with Sphinx

Is there relatively easy way to insert into Sphinx distributed index using MySQL proxy?

E.g. you connect to MySQL proxy and send something like:

insert into my_ft_index values(1000, 'harry potter');

then MySQLProxy somehow calculate the hash of 1000 and decide where to forward this insert?

Upvotes: 1

Views: 89

Answers (1)

barryhunter
barryhunter

Reputation: 21091

See: http://sphinxsearch.com/forum/view.html?id=13632

From what I understand there, mysqlproxy wouldnt work (but havent tried)

Frankly its pretty trival to implemnent in application code. (ie 'picking' which server to send the request) - if was a HA setup, with multiple servers per shard, less so.

Upvotes: 1

Related Questions