Running two databases with forward set to redirect (monetdbd)
We have an environment that does not support Unix domain sockets well.
We thus configured monetdbd with forward=redirect, as we note from the monetdbd man page that "for local databases, the proxy method uses a UNIX domain socket feature"
We can create two database, but trying to connect (on the default 50000 port) to them only the first-started database is available.
If we try to connect to the second we get the error "request for database 'dev_sb2', but this is database 'dev_sb', did you mean to connect to monetdbd instead?".
With some experimentation we have found that starting the databases directly using mserver5 and specifying different ports (--set mapi_port=50001 etc) we can connect to both databases, but this does complicate things and we would prefer to use the monetdb command for starting, stopping, creating etc.
How can we configure monetdbd (or perhaps individual databases?) so that we can connect to two local databases through monetdbd and manage them using monetdb?
Thanks Steve
Hi Steve,
Thank you for your observation.
On 07/04/2020 16:57, stephenb wrote:
We have an environment that does not support Unix domain sockets well.
What environment are you refering too?
We thus configured monetdbd with forward=redirect, as we note from the monetdbd man page that "for local databases, the proxy method uses a UNIX domain socket feature"
We can create two database, but trying to connect (on the default 50000 port) to them only the first-started database is available.
If we try to connect to the second we get the error "request for database 'dev_sb2', but this is database 'dev_sb', did you mean to connect to monetdbd instead?".
With some experimentation we have found that starting the databases directly using mserver5 and specifying different ports (--set mapi_port=50001 etc) we can connect to both databases, but this does complicate things and we would prefer to use the monetdb command for starting, stopping, creating etc.
In case this issue is business critical I would like to refer you to MonetDB Solutions to have a chat on how they may be of help https://www.monetdbsolutions.com/services
regards, Martin Kersten
How can we configure monetdbd (or perhaps individual databases?) so that we can connect to two local databases through monetdbd and manage them using monetdb?
Thanks Steve
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Hi Martin
Thanks for that feedback. We are actually trying to get it running on WSL - with one database it work just fine - but we couldn't get it working with the Unix domain sockets approach, hence trying forward=redirect.
Regards Steve
On Tue, Apr 7, 2020 at 4:57 PM Martin Kersten martin.kersten@cwi.nl wrote:
Hi Steve,
Thank you for your observation.
On 07/04/2020 16:57, stephenb wrote:
We have an environment that does not support Unix domain sockets well.
What environment are you refering too?
We thus configured monetdbd with forward=redirect, as we note from the
monetdbd man page that "for local databases, the proxy method uses a UNIX domain socket feature"
We can create two database, but trying to connect (on the default 50000
port) to them only the first-started database is available.
If we try to connect to the second we get the error "request for
database 'dev_sb2', but this is database 'dev_sb', did you mean to connect to monetdbd instead?".
With some experimentation we have found that starting the databases
directly using mserver5 and specifying different ports (--set mapi_port=50001 etc) we can connect to both databases, but this does complicate things and we would prefer to use the monetdb
command for starting, stopping, creating etc.
In case this issue is business critical I would like to refer you to MonetDB Solutions to have a chat on how they may be of help https://www.monetdbsolutions.com/services
regards, Martin Kersten
How can we configure monetdbd (or perhaps individual databases?) so that
we can connect to two local databases through monetdbd and manage them using monetdb?
Thanks Steve
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Martin Kersten -
stephenb