After a sucessful installation of MonetDB software suite, monetdbd and monetdb are ready to be used to create database clusters (a.k.a. farms) and databases, respectively. The program monetdbd is the MonetDB database server daemon. This program is mainly meant to be used as a daemon, but it also allows to setup and change the configuration of a database farm.
The use of monetdbd is either as user-oriented way to configure, start and stop a database farm, or to be started from a startup script, such as from systemd on Linux systems, as part of a system startup.
A monetdbd instance manages one local cluster of databases, which is a directory in the file system, referred to as the dbfarm. The dbfarm location must always be given as argument to monetdbd.
It is strongly advised to check monetdbd manual page for a comprehensive explanation of all available features. Command line manual is also available via man monetdbd.
MonetDB Database Server Daemon is only available for the Unix family of operating systems.
monetdbd create /tmp/my_dbfarm # create a fresh database farm
monetdbd start /tmp/my_dbfarm # start the daemon on a database farm
monetdbd get all /tmp/my_dbfarm # retrieve all properties of the database farm
monetdbd set port=50001 /tmp/my_dbfarm # change a property of the database farm (e.g. change the port)
monetdbd stop /tmp/my_dbfarm # stop the daemon on a database farm
Some configuration settings take effect at runtime while others require a daemon restart.
List of database farm properties:
hostname my_server_hostname
dbfarm /tmp/my_dbfarm
status no monetdbd is serving this dbfarm
mserver unknown (monetdbd not running)
logfile /tmp/my_dbfarm/merovingian.log
pidfile /tmp/my_dbfarm/merovingian.pid
loglevel information
sockdir /tmp
listenaddr localhost
port 50000
exittimeout 60
forward proxy
discovery true
discoveryttl 600
control no
passphrase <unset>
snapshotdir <unset>
snapshotcompression .tar.lz4
keepalive 60
mapisock /tmp/.s.monetdb.50000
controlsock /tmp/.s.merovingian.50000