1.71.4 Database Configuration

The database environment is described in a configuration file, which is used by server-side applications, e.g. merovingian and mserver5. A default version is created upon system installation in prefix/etc/monetdb5.conf. Below we illustrate its most important components, for the remaining details look at the configuration file itself.

• prefix=/ufs/myhome/monet5/Linux
• exec_prefix=${prefix}
• dbfarm=${prefix}/var/MonetDB5/dbfarm
• monet_mod_path=${exec_prefix}/lib(64)/MonetDB5
• mal_init=${prefix}/lib(64)/MonetDB5/mal_init.mal
• sql_init=${exec_prefix }/lib/MonetDB5/sql_init.sql
• merovingian_log=${prefix}/var/merovingian.log
• mapi_open=false

The header consist of system wide information. The prefix and exec_prefix describe the location where MonetDB has been installed. monet_mod_path tells where to find the libraries. The bootstrap file for the kernel is given by mal_init. These arguments are critical for a proper working server.

The option sql_init is a comma separated list of SQL files to be executed upon system restart. It is primarily used to make SQL library functions known to all users.

The logs are typically stored on a different storage medium to protect the database against accidental hardware loss.

Client connections are limited to those originating from the same machine. To make the database accessible from remote sites the option mapi_open should be set to true.