… support in version 5.6, yes. MySQL is unlikely to be a usable solution for … than some of the big expensive closed-source databases‘ too. Sphinx is a technology to consider for some … targeted towards very different use cases. But there are a lot of misconceptions, such as “Percona Server is…
Post: Using Sphinx as MySQL data retrieval accelerator
October 30, 2006 By 25 Comments
… the following thread couple of days ago: Basically someone is using sphinx to perform search simply on attributes (date, group etc) and…. Sphinx should not be replacement for Database Server but for many data retrieval needs it will work great. Especially as it can be used with other databases which may be slower than MySQL. MySQL Make it so one would not need to use sphinx to…
Post: Sphinx: Going Beyond full text search
July 23, 2007 By 18 Comments
…using Sphinx with MySQL for scalable Full Text Search applications. For example on BoardReader we’re using… all this data as summary tables. Instead we decided to use Sphinx for this kind …. Using Sphinx such non-traditional way required implementing some features more traditional for SQL databases …
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
… commercial databases but until recently this type of software was not available for MySQL. Change Data Capture can be used to: Monitor a database… like Sphinx or Solr only the rows that change. Feed third party replication systems. Provide data to “external triggers” such as Gearman…
Post: Schedule for MySQL Conference 2012 is Published
January 25, 2012 By 3 Comments
… MySQL Community. We’re talking about other database systems only as it comes to migration to MySQL and about NoSQL technologies such as Memcached,Redis,Sphinx which are commonly used to supplement MySQL…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
…MySQL Storage Engines, and pluggable storage engines as MySQL…as core storage engines and are not match of functions which you’d find in Oracle, PostgreSQL and other databases…MySQL, it is not easy to do however as there is no interface. We had the same problem with Sphinx – Sphinx… use of MySQL …
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…Sphinx which is currently implemented as storage engine for MySQL but this role does not suite it well as…mean Solid functionally complete features which work as uses intuitively expect them to work instead …Do not forget about the roots. MySQL has gained its popularity as database for Web but web …
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
… the database which is much faster to extract. Even if data needs to be aggregated from several sources I’d use special… be indexed available for index process. With Sphinx which talks directly to the MySQL database we can get some 10.000 of documents… also already make sure Sphinx can be used efficiently to perform queries going beyond full text search. Such as finding the goods from…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…MySQL replication” and “Master-Master with MMM manager” Don’t use any special MyISAM feature All Can change MyISAM Full text to Sphinx…database server. In term of write capacity here are you choices. Write capacity MySQL…replication” can be as simple as CHANGE MASTER TO, and can take as little as a …
Post: BoardReader - Forum Search Engine
November 29, 2006 By 12 Comments
…work on crawler in this project only on database Backend and full text search engine implementation. …first you can use it to Search MySQL Forums Notice simple link structure – you can replace mysql.com in …tables as we want to count uniques, but it should be fixed once we rewrite it using sphinx. …
