Also, what OS are you running? We have a Derby database that is about 300GB and the online backup would slow down operation of the system too much and take too long to perform. Fortunately we are using Solaris 10 with the database being on a ZFS pool and what we ended up doing is to do a "freeze" of the database, take a ZFS snapshot of the filesystem, and then "unfreeze" the database. Then we backup the database from the ZFS snapshot at leisure using "tar" and "gzip" and offload that to another server.
Now some of the Linux based systems have ZFS so we will start to be able to support those as well. -----Original Message----- From: kosurusekhar [mailto:kosurusek...@gmail.com] Sent: Tuesday, November 04, 2014 12:54 AM To: derby-user@db.apache.org Subject: Derby online backup with huge database Hi All, We implemented to take the derby online backup when ever our application is launching. It is working fine. But in production the database grows more than 2GB. It is taking more than 7 to 10 minutes to take the backup. Is this behaviour is normal with Derby database? Is there any thing need to configure/implement to speedup the backup process? Please advice me in that. Thanks in advance. Regards Sekhar. -- View this message in context: http://apache-database.10148.n7.nabble.com/Derby-online-backup-with-huge-database-tp143121.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
