search

pat / thinking-sphinx

Sphinx/Manticore plugin for ActiveRecord/Rails
http://freelancing-gods.com/thinking-sphinx
MIT License
1.63k stars 469 forks source link

Latest mysql version compatible with thinking sphinx #1246

Closed atomical closed 1 year ago

atomical commented 1 year ago

Hi Pat,

What is the latest mysql version that is compatible with thinking sphinx / sphinx?

pat commented 1 year ago

Hi Adam,

My current understanding is that if you're using Sphinx 2, then you must also use MySQL libraries for 5.x. Sphinx 3.3 onwards should definitely support MySQL 8, I suspect it's the same for earlier 3.x releases, but I'm not 100% sure.

pat commented 1 year ago

Granted, there have been issues with delta indices on the Sphinx 3.x releases (when the database is PostgreSQL), but should be fine if you're using real-time indices instead of SQL-backed ones.

atomical commented 1 year ago

Thanks! That's very helpful.