… Hadoop or Sphinx used to crunch data in parallel or it even could be special wrapper on top of MySQL do do… far MySQL does not have anything which tackles this need, even on the roadmap. Indeed MySQL has MySQL Cluster but it is quite different. MySQL Cluster at this point is a cluster in terms of Storage – only…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…’m especially interested about it is Sphinx which is currently implemented as storage engine for MySQL but this role does not suite… 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: Introducing our Percona Live speakers
May 10, 2011 By 4 Comments
… the things you don’t know about Sphinx’s capabilities. Many people think of Sphinx as a great search engine, but it…, think about using MySQL to find the top N most important rows per group of rows, distributed across a cluster of servers… in MySQL — and that’s just for performing this task on a single server, not to mention a cluster of servers. Well, Sphinx…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… most common ones: – MySQL replication with manual failover – Master-Master with MMM manager – Heartbeat/SAN – Heartbeat/DRBD – NDB Cluster These technologies are… text indexes might be replaced by another search engine like Sphinx in order to remove the restriction. There is no HA… MySQL DBA + strong Sysadmin skills Heartbeat/DRBD High, Good MySQL DBA + strong Sysadmin skills NDB Cluster Very high, Specific NDB knowledge, strom MySQL skills…
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… we included Sphinx chapter in High Performance MySQL book – check out Appendix C. This should be the best printed material about Sphinx out there, though as of now Sphinx…
Post: Using Sphinx as MySQL data retrieval accelerator
October 30, 2006 By 25 Comments
… following thread couple of days ago: Basically someone is using sphinx to perform search simply on attributes (date, group etc) and… we’re building for one of our clients which uses cluster of 3 nodes to handle search. In this case no… databases which may be slower than MySQL. MySQL Make it so one would not need to use sphinx to get great performance for…
Comment: Using Sphinx as MySQL data retrieval accelerator
November 7, 2006 By 25 Comments
… is normally much better than just returning random matching values. Sphinx does not support wildcards at this point. But again it… need relevance I agree with you. Everything has its purpose – sphinx is designed exactly for usages where relevance is very important… each. MySQL has no way to use multiple CPUs for such query. Even with MySQL Cluster sort would be done on MySQL server – single…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… but doing it in simple efficient and innovative way. NDB cluster is yet another example I’d put in here. I… with MySQL, it is not easy to do however as there is no interface. We had the same problem with Sphinx – Sphinx can run sorting and group by operations much faster than MySQL can and it can do…
Post: Percona welcomes Ryan Lowe and Vladimir Fedorkov
January 13, 2009 By 3 Comments
… he scaled an Alexa top 1000 site with a sharded MySQL backend, worked in aerospace, worked in telecom, and lots of… worked together for years in past endeavors. Vladimir can make Sphinx do just about anything, and is an expert systems administrator… point out that our own Ewen Fortune has been a MySQL Cluster Certified DBA for quite a long time now. OK, shameless…
Post: BoardReader - Forum Search Engine
November 29, 2006 By 12 Comments
…To target this problem we also store inbound links clustered by second level domain which allows to get … likely redesign it in the future to use sphinx instead (it can do extremely fast parallel group-… use it to Search MySQL Forums Notice simple link structure – you can replace mysql.com in it with …
