Hello Ravikumar, I have run a quick experiment on the cluster setup in EC2. On 08/20/2013 10:57 AM, Ravikumar Balasubramaniam wrote:

I have followed http://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/ClusterManagement page to setup 3 node(in amazon EC2) cluster. I have considered the server from where I control remote databases as leader and others as remote servers. The 'monetdb discover' in the leader is not showing any other database(except self dbs). I have enabled discovery and control properties in the remote servers. What other configurations are needed for successful discovery in EC2 environment?

The control daemon "monetdbd" uses TCP broadcast sockets to find remote nodes. Unfortunately, broadcasts are not allowed in EC2. You might nevertheless be able to use VPN tools to connect your nodes with broadcast support, but this will require further setup.

MonetDB cluster enables mclient to combine all the (select)query results from remote servers and itself. The application should take care of shared write into nodes. Is this fair understanding? Yes, SELECT results are concatenated.

Best, Hannes [1] http://www.monetdb.org/Documentation/monetdb-man-page