While we look forward to the availability of a new real-time replication strategy for MonetDB, we were wondering if it would be plausible to configure two instances of MonetDB, on different machines, to point to the same dbfarm.

Only one instance would be used at a time; one instance would be the primary instance and the second instance would only be used if the first failed to respond (at which time we would stop sending requests to the primary instance and raise an alert for the system adminsitrator)

We can provide for the replication of the database data at the file system layer (ZFS) but are still susceptible to a failure of MonetDB or the machine it is running on.

Thanks