Hello all, I followed the tutorial on https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/ClusterManagement but I still can't get it to work. I followed all instructions, but *monetdb discover *only returns instance(s) running on the same machine, but not others on the network. I am using three machines running debian, with monetdb installed and configured according to the link above. What am I missing? Your assistance is highly appreciated.
Hi Ali, On 25-08-2014 17:22:47 -0400, Ali Salem wrote:
Hello all,
I followed the tutorial on
[1]https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/ClusterManagement
but I still can't get it to work. I followed all instructions, but monetdb discover only returns instance(s) running on the same machine, but not others on the network.
I am using three machines running debian, with monetdb installed and configured according to the link above. What am I missing?
Make sure they are all in the same network, and that UDP broadcasting is allowed by your firewall configuration. Fabian
Hello fabian,
Thank you for your reply.
To make it clearer, I am using three virtual machines from Google Compute.
I found this on their site:
*Note:* Google Compute Engine networks only supports point to point IPv4
traffic. Broadcast and Multicast are not supported. (source:
https://developers.google.com/compute/docs/networking).
Does this mean there is no other alternative to achieve MonetDB Clustering?
Like creating a configuration file.
Your help is appreciated.
Ali
On Tue, Aug 26, 2014 at 2:21 AM, Fabian Groffen
Hi Ali,
On 25-08-2014 17:22:47 -0400, Ali Salem wrote:
Hello all,
I followed the tutorial on
[1] https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/ClusterManagement
but I still can't get it to work. I followed all instructions, but monetdb discover only returns instance(s) running on the same machine, but not others on the network.
I am using three machines running debian, with monetdb installed and configured according to the link above. What am I missing?
Make sure they are all in the same network, and that UDP broadcasting is allowed by your firewall configuration.
Fabian _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Hi Ali, Unfortunately, with the current software stack, there is no way you can get cluster functionality without UDP broadcasts. What you would need is something like https://www.monetdb.org/bugzilla/show_bug.cgi?id=2498. Fabian On 28-08-2014 10:20:59 -0400, Ali Salem wrote:
Hello fabian,
Thank you for your reply.
To make it clearer, I am using three virtual machines from Google Compute. I found this on their site:
Note: Google Compute Engine networks only supports point to point IPv4 traffic. Broadcast and Multicast are not supported. (source: [1]https://developers.google.com/compute/docs/networking).
Does this mean there is no other alternative to achieve MonetDB Clustering? Like creating a configuration file.
Your help is appreciated.
Ali
On Tue, Aug 26, 2014 at 2:21 AM, Fabian Groffen <[2]fabian@monetdb.org> wrote:
Hi Ali,
On 25-08-2014 17:22:47 -0400, Ali Salem wrote:
Hello all,
I followed the tutorial on
[1][3]https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/ClusterManagement
but I still can't get it to work. I followed all instructions, but
monetdb
discover only returns instance(s) running on the same machine, but not others on the network.
I am using three machines running debian, with monetdb installed and configured according to the link above. What am I missing?
Make sure they are all in the same network, and that UDP broadcasting is allowed by your firewall configuration.
Fabian _______________________________________________ users-list mailing list [4]users-list@monetdb.org [5]https://www.monetdb.org/mailman/listinfo/users-list
References: 1. https://developers.google.com/compute/docs/networking 2. mailto:fabian@monetdb.org 3. https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/ClusterManagement 4. mailto:users-list@monetdb.org 5. https://www.monetdb.org/mailman/listinfo/users-list
read_char: errno==EILSEQ; invalid byte sequence for UTF-8: _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Fabian Groffen fabian@monetdb.org column-store pioneer http://www.monetdb.org/Home
Hello Fabian and thank you for replying to my question.
Given I am no C developer, would it be possible to hack the source code
somewhere and hard-code the IPs of the servers instead of using UDP
discovery? Shouldn't MonetDB store information about the servers somewhere?
Thank you.
On Thu, Aug 28, 2014 at 10:49 AM, Fabian Groffen
Hi Ali,
Unfortunately, with the current software stack, there is no way you can get cluster functionality without UDP broadcasts. What you would need is something like https://www.monetdb.org/bugzilla/show_bug.cgi?id=2498.
Fabian
On 28-08-2014 10:20:59 -0400, Ali Salem wrote:
Hello fabian,
Thank you for your reply.
To make it clearer, I am using three virtual machines from Google Compute. I found this on their site:
Note: Google Compute Engine networks only supports point to point IPv4 traffic. Broadcast and Multicast are not supported. (source: [1]https://developers.google.com/compute/docs/networking).
Does this mean there is no other alternative to achieve MonetDB Clustering? Like creating a configuration file.
Your help is appreciated.
Ali
On Tue, Aug 26, 2014 at 2:21 AM, Fabian Groffen <[2]fabian@monetdb.org> wrote:
Hi Ali,
On 25-08-2014 17:22:47 -0400, Ali Salem wrote:
Hello all,
I followed the tutorial on
[1][3] https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/ClusterManagement
but I still can't get it to work. I followed all instructions, but
monetdb
discover only returns instance(s) running on the same machine, but not others on the network.
I am using three machines running debian, with monetdb installed and configured according to the link above. What am I missing?
Make sure they are all in the same network, and that UDP broadcasting is allowed by your firewall configuration.
Fabian _______________________________________________ users-list mailing list [4]users-list@monetdb.org [5]https://www.monetdb.org/mailman/listinfo/users-list
References: 1. https://developers.google.com/compute/docs/networking 2. mailto:fabian@monetdb.org 3. https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/ClusterManagement 4. mailto:users-list@monetdb.org 5. https://www.monetdb.org/mailman/listinfo/users-list
read_char: errno==EILSEQ; invalid byte sequence for UTF-8: _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Fabian Groffen fabian@monetdb.org column-store pioneer http://www.monetdb.org/Home _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Ali Salem -
Fabian Groffen