…needs using MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication Advanced MySQL …help. Full Text Search applications. Need help with implementing Full Text Search solution ? We can help with fine tuning MySQL build in Full Text Search…
Post: BoardReader - Forum Search Engine
November 29, 2006 By 12 Comments
…for Sphinx – Full Text Search Engine which we love to use where large scale search is needed. At… this problem we also store inbound links clustered by second level domain which allows to…Search MySQL Forums Notice simple link structure – you can replace mysql.com in it with any other domain to search…
Post: Using Sphinx as MySQL data retrieval accelerator
October 30, 2006 By 25 Comments
…full text search matching, but it is still extremely fast doing data crunching. I just tested right now performing search …one of our clients which uses cluster of 3 nodes to handle search. In this case no …with other databases which may be slower than MySQL. MySQL Make it so one would not need …
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… engines (something even PostgreSQL does not have) as well as Full Text Search parses but there is very long way to go before… use them same as single MySQL server with improved performance and high availability. Of course there is MySQL Cluster but it does not… not think MySQL Cluster would ever be that thing as it provides too strong guarantees. It is same as with MySQL Replication – the…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…/DRBD yes NDB Cluster yes 3. Does your application use MyISAM only features? There are some features like Full text indexes and GIS… “MySQL replication” and “Master-Master with MMM manager”. Depending on the application, the MyISAM Full text indexes might be replaced by another search engine…
Post: Sphinx 0.9.8 is released just in time for OSCON 2008
July 20, 2008 By 2 Comments
…. It integrates with MySQL and scripting languages very well, it is simple, it performs well and it is easily clustered, allowing you… ranking (similar to what MySQL build in full text search uses) you can get performance another 20-100% better though search result quality will be…
Comment: Using Sphinx as MySQL data retrieval accelerator
November 7, 2006 By 25 Comments
… each. MySQL has no way to use multiple CPUs for such query. Even with MySQL Cluster sort would be done on MySQL server – single… do not want full text search on the contrary they are asking about query to return all result set from full text search keyword matching standpoint…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
…. On the benefits side we usually see clustering by primary key, caching data, higher concurrency,… moving to Innodb are typically Full Text Search and RTREE indexes/GIS with Full Text being much more common. … exercises not so common paths in the MySQL server – in particular Optimizer may have harder…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…and a search almost as efficient as a binary search can be…reserves different extents from the clustered index. Q4: Does Innodb … overtaking buffer pool. Though full table scan is only…Q17: How InnoBD handles blobs/text fields (needs more info) ….cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, …
