…why I’m especially interested about it is Sphinx which is currently implemented as storage engine… Distributed One of the most common buzzwords used together with MySQL is Scale Out, but to… your data to the multiple databases and handle data merging on application together with high availability and…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…multiple terms, can you get Sphinx to report which matched? The SHOW META command in Sphinx … asked: Q: With respect to Solr and Sphinx, do indexes stay up to date with changes (inserts…database or else periodically batch-insert data that has changed since last time you updated the index. You can use…
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
… to be indexed available for index process. With Sphinx which talks directly to the MySQL database we can get some 10.000 of… with database instead of with web documents has another benefit – you instantly get the structure and efficient object identifiers which you can use for… of users with not trivial full text search needs. We’ve recently added support for multiple value attributes which can be used for…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… “Master-Master with MMM manager” Don’t use any special MyISAM feature All Can change MyISAM Full text to Sphinx All 4. What… of a database server. In term of write capacity here are you choices. Write capacity MySQL replication Fair Master-Master with MMM… planning for a growth that will need sharding (splitting the database over multiple servers), then you might need to take a serious…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…getting in too much trouble with backups etc – because Sphinx is doing all …need enough concurrency to utilize multiple hard drives and with 50 drives you … makes it very easy to use LVM for backups while assuming … lot of pieces – filesystem, disk scheduling, database buffer management can be rather …
