Alexandru Toth wrote:
Hello,
I'm the developer of Cubulus OLAP (http://sourceforge.net/projects/cubulus/ ) .
Hello Alexandru Welcome to the MonetDB user community.
On the roadmap there is a hint about replication, coming in SQL 2.2 (February 2008) release. Is it implemented ? If not, is it possible to use
We have been experimenting with replication techniques. Some of the hooks have been included in the distribution. However, we are not yet satisfied and with the result. It remains on our R&D list to come up with a novel and efficient solution.
some existing software ex: http://dbreplicator.org/
Middleware solutions could potentially provide a short term solution. However, we don't know if they are powerful enough or require functionality currently not available in our JDBC driver.
Or, is it possible to load data into "master", stop it, sync the dbfarm to several slaves (into new directories), and re-start the slaves with the new dbfarm path ? Of course, slaves are used as read-only copies.
ofcourse, provided you don't forget to copy the sql_logs as well. You can even instruct the server that the database is readonly. See the documentation : http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/Storage-Modes.html
regards, Martin
-Alex