Database Migration

The easiest method to move a MonetDB to a new location, or to create a copy for back-up purposes, runs as follows. First stop the database server by calling the monetdb management tool

shell> monetdb lock demo

When the server is stopped, you can still connect as a database administrator to ensure that all (update) queries have ceased execution (see system monitor). Once satisfied that the activity has ceased, you can either follow the safe route to dump/restore a database, or perform a file-level RSYNC or RCP to copy the complete dbfarm directory to another dbfarm location. The MonetDB daemon process attached to the remote dbfarm will pick it up and makes it visible for connections. Finally, perform the following operation to continue processing user requests at the orginal server.

shell> monetdb release demo