Ever-increasing amount of diverse text content stored in MySQL databases makes full text search through that content important to the point of being crucial.
Sphinx improves MySQL full-text capabilities in several different areas: speed, relevancy, scalability, compatibility with storage engines other than MyISAM.
This talk will cover Sphinx features from basic searching to advanced capabilities such as efficient filtering, grouping, distributed searching, geo-distance support, and many others.
We will also talk about different special Sphinx uses in conjunction with MySQL: using Sphinx Storage Engine; moving certain non-fulltext queries to Sphinx clusters to offload MySQL; etc.
Andrew is the author of Sphinx, an open-source full-text search engine designed especially for indexing databases.
Peter co-founded Percona in 2006, assuming the role of CEO. Percona is the only company that delivers enterprise-class solutions for both MySQLⓇ and MongoDBⓇ across traditional and cloud-based platforms. Percona has been on the Inc. 5000 list of fastest growing companies since 2013. Back in 2000s Peter was an early employee at MySQL AB, eventually leading the company’s High Performance Group. A serial entrepreneur, Peter co-founded his first startup while attending Moscow State University where he majored in Computer Science.
As CEO of Percona, Peter enjoys mixing business leadership with hands on technical expertise. Peter is co-author of High Performance MySQL published by O’Reilly, one of the most popular books on MySQL performance. Peter blogs regularly on Percona Performance Blog and speaks frequently at conferences all over the world. Peter lives in North Carolina with his wife and two children. In his spare time, Peter enjoys travel and spending time outdoors.
View a complete list of MySQL contacts.