On 09-07-2011 06:37:55 +0200, Martin Kersten wrote:
2) About clustering, my understanding about clustering is to allow one client to launch a sql query on a database through merovingian (if i understood). The query is analysed by all nodes of the cluster and then it return the answer. However, it seems it is not the case, if I follow the documentation on the website about clustering, it seems that I will be connected through a round robin fashion to one of the node. Once connected my query will be executed only on that node. That depends on how you have partitioned the database. In the normal sharded case, the query is executed at all nodes and the result sets glued together.
They are not, this is only in a special case that is not documented on the website, yet.