Proxysql to sphinxsearch

[Max Hike & Bike]

Is there any chance on proxy to sphinxsearch  with Proxysql ?

Now i have only one problem with quering sphinx with proxy:

2018-02-01 16:24:55 MySQL_Session.cpp:1752:handler_again___status_CHANGING_CHARSET(): [ERROR] Detected a broken connection during SET NAMES on sphinx.local , 9306 : 2019, Can't initialize character set (null) (path: compiled_in)

Sphinx do not support comand SET NAMES

[René Cannaò]

ProxySQL tracks charsets and executes SET NAMES on backend only when the charset needs to be changed.

In your case, most probably the character specified by the client (explicitly or during connect) doesn't match with the backend (Sphinx) charset.

If you use the same charset, no SET NAMES will be executed.

Do

--
Sent from my mobile device.
Email: rene....@gmail.com
Time zone: GMT+2

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Max Hike & Bike]

Thanks, in helps

четверг, 1 февраля 2018 г., 16:56:21 UTC+2 пользователь Max Hike & Bike написал:

[Adrian Nuta]

Hi,

you can also check Manticore Search (https://github.com/manticoresoftware/manticoresearch) - it's a fork of Sphinx. In the last release we fixed some issues for improving compatibility with ProxySQL (STATUS_AUTOCOMMIT wasn't sent):

We haven't tested extensively Manticore with ProxySQL, any feedback is welcomed.

[Drew Dixon]

FWIW I am also very interested in eventually utilizing Sphinx (or maybe this fork now, which this email just introduced me to!) with ProxySQL potentially.  Now I'm curious what advantages this Manticore Search fork has over the original Sphinx...  : )

Thank you,

-Drew

[Adrian Nuta]

The fork was started by 2 big users, as Sphinx dev/support went silent more than a year ago. Some new features were added (like percolate queries), but lot of effort was put into the quality of code. The fork is open source (since it's made from a gplv2 source), the new Sphinx (v3) is closed-source (so far). 

Adrian Nuta,

+40745670843

skype: aditirex

https://www.linkedin.com/in/adriannuta

www.adriannuta.com