[MonetDB-users] MonetDB clustering
Hi and good morning from Germany. My name is Maik Strewe and I want to test the performance of the monetDB in a cluster. My application needs millions of rows but few columns. I have to set up an monetDB cluster on 2 servers at an external server hoster. The single instances on the hosts are installed and running. Then I tried to use the "monetdb discover" command but the servers cant see each other. As far as I know the discovery is based on a UDP broadcast, right? Is it possible to configure the cluster members in a configuration file so that the monetdb instance can discover the cluster member by configuration?
Hi Maik, On 03-05-2012 08:38:38 +0000, Maik Strewe wrote:
The single instances on the hosts are installed and running. Then I tried to use the “monetdb discover” command but the servers cant see each other. As far as I know the discovery is based on a UDP broadcast, right? Is it possible to configure the cluster members in a configuration file so that the monetdb instance can discover the cluster member by configuration?
Currently not. It's a feature I'd like to implement once, but it's not really high on the list. Given the current workload, I don't expect it to appear in the near future. Fabian
Thank you for your fast reply. So, is it right that i can not set up a monetDB cluster if udp broadcasts block in the network? I want to set up a cluster on an external server hoster. The two servers got ips x.x.x.117 and x.x.x.119 and I think the hoster blocking the udp broadcast. -----Ursprüngliche Nachricht----- Von: Fabian Groffen [mailto:Fabian.Groffen@cwi.nl] Gesendet: Donnerstag, 3. Mai 2012 11:19 An: monetdb-users@lists.sourceforge.net Betreff: Re: [MonetDB-users] MonetDB clustering Hi Maik, On 03-05-2012 08:38:38 +0000, Maik Strewe wrote:
The single instances on the hosts are installed and running. Then I tried to use the “monetdb discover” command but the servers cant see each other. As far as I know the discovery is based on a UDP broadcast, right? Is it possible to configure the cluster members in a configuration file so that the monetdb instance can discover the cluster member by configuration?
Currently not. It's a feature I'd like to implement once, but it's not really high on the list. Given the current workload, I don't expect it to appear in the near future. Fabian
On 03-05-2012 11:55:02 +0000, Maik Strewe wrote:
Thank you for your fast reply.
So, is it right that i can not set up a monetDB cluster if udp broadcasts block in the network? I want to set up a cluster on an external server hoster. The two servers got ips x.x.x.117 and x.x.x.119 and I think the hoster blocking the udp broadcast.
monetdbd cannot "do" anything clever when it cannot "see" other databases, so that's where any story ends, unless you do things yourself, of course. Fabian
Hi MonetDB people, greetings from the other side of the street :). Long time no see. I just upgraded my monetdb installation to the April release. I use the Ubuntu repo. my database is running, but when I try to connect with the Python API or mclient I get the error: CREATE AGGREGATE: name 'median' (tinyint(8)) already in use Any suggestion how to figure out how to solve this problem? greetings, -- Gijs Molenaar http://www.astro.uva.nl/people/gijs-molenaar/
On Thu, May 03, 2012 at 02:15:03PM +0200, Gijs Molenaar wrote:
Hi MonetDB people,
greetings from the other side of the street :). Long time no see.
I just upgraded my monetdb installation to the April release. I use the Ubuntu repo. my database is running, but when I try to connect with the Python API or mclient I get the error:
CREATE AGGREGATE: name 'median' (tinyint(8)) already in use
Any suggestion how to figure out how to solve this problem?
greetings,
-- Gijs Molenaar http://www.astro.uva.nl/people/gijs-molenaar/
Gijs Good to hear from you. Come over to this side one day... Did you have a 'median' aggregate (or function) defined in your db? If so the upgrade to april may fail because we introduced one there. Niels
------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
participants (4)
-
Fabian Groffen -
Gijs Molenaar -
Maik Strewe -
Niels Nes