June 18, 2013

Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster

May 19, 2010 By 10 Comments

…nodes. If after a major outage, only one of the physical host where the data nodes are located comes up, the cluster will start. The other features…the SQL nodes but given the framework, extending to SQL nodes is trivial. Installing Pacemaker and Heartbeat is very easy on Lucid Lynx, just do the…

Filed Under: Insight for DBAs, MySQL Tagged With: ,

Comment: Announcement of Percona XtraDB Cluster (alpha release)

January 11, 2012 By 30 Comments

…, thanks for the info. To follow up, are there are features provided by mysql cluster that is NOT available in xtradb cluster…, what is the maximum # of data nodes and sql nodes supported by xtradb cluster? The documentation does not mention an upper limit on the # of nodes, whereas ndb is limited…

Filed Under: MySQL, Percona Software

Post: Distributed Set Processing with Shard-Query

May 14, 2011 By 27 Comments

…nodes Distributed set processing (theory) What is SQL? As you probably know, SQL stands for “structured query language”. It isn’t so much the language that is… Set processing is massively parallel . In fact, it is embarassingly parallel. Because Shard-Query works on sets, and features pluggable …

Filed Under: MySQL

Post: Sphinx search performance optimization: multi-threaded search

January 16, 2013 By 10 Comments

…the application as if it was just one server serving the request in the first place. Well, guess what – you can actually utilize this feature…The reason is that while search is done on data nodes (even if local ones) and in parallel, merging of results is done by the…source src1p1 : src1 { sql_query =…

Filed Under: MySQL Tagged With: , , ,

Post: Read/Write Splitting with PHP Webinar Questions Followup

January 23, 2013 By 4 Comments

…nodes, but not executed synchronously.  Because of features…the SQL thread is caught up and the IO thread is waiting. A: Yes, the “seconds behind master” is really “seconds behind the latest binlog entry downloaded from the…

Filed Under: Events and Announcements, Insight for Developers, MySQL Tagged With: , ,

Post: Top 5 Wishes for MySQL

June 29, 2007 By 10 Comments

…nodes nicely even if you do not have much support from MySQL to do so. What is really bad is…features pushing back a lot of features which Web users would like. These features are often small, typically not SQL…

Filed Under: Insight for DBAs Tagged With: