My friends at Sphinx Technologies have finally released new beta of Sphinx – Sphinx 2.0.2. It includes about 6 months of development and includes over 30 new features and tons of bug fixes. I’m happy to see how Sphinx 2.0 is shaping up a lot of rough corners are being polished and I’m hopeful we will see very solid Stable Sphinx 2.0 within next 3 to 6 months. In fact Sphinx 2.0.3-rc is promised within 1 month.
What MySQL Users will find interesting in this release is a lot of work on SphinxQL the Sphinx’s language similar to SQL. Now it support number of functions such as SET NAMES which make it possible to connect to Sphinx as if it were MySQL Server with more advanced connectors which issue such commands when they set up connection.
Sphinx Team also announced Sphinx Users Conference in St. Petersburg, Russia on December 4th. This is going to be free Russian Speaking event.
This is the second Sphinx event in Russia and I really wish there would be and International Sphinx Conference somewhere in US or Western Europe. I hope we’ll see something like it in 2012.
Another thought – with Innodb Full Text Search coming up in MySQL 5.6 and Claimed to be faster than MyISAM’s I really would like to see some benchmarks comparing it to Sphinx, especially to its Real Time indexes. Some easy to understand feature comparison table would also be helpful as in many cases people use Sphinx not because it is faster – speed might not be the main thing on smaller collections but its various full text search features.
About the Author
Peter ZaitsevPeter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master's Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling.
Any news on compiling sphinx with MySQL 5.5? Still a no go to the best of my understanding.
Shlomi… I second that request for news. Would be sweet if sphinxse would compile… have been looking at tons of forums for a solution but never found a proper solution to the compile issues…
//Steve
Shlomi Noach: we successfully compiled SphinxSE plugin using Percona Server 5.5.16.
However, we encountered a bug when the mysql option skip-name-resolve was used. Fortunately, there’s a workaround.
Right now we are rolling 5.5 with sphinx plugin to production.
The bugreport: http://sphinxsearch.com/bugs/view.php?id=983
@Vojtech:
Great to hear! how? Can you point me to the patch? Or is that the mysql_ha file attached in your bug report?
Thanks
Schlomi, the bug was fixed today in r3020, no patches needed. Vojtech
@Vojtech,
Cool! Thanks for the info!