db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Spezifikum <i...@spezifikum.com>
Subject Re: Live backup - best practice?
Date Fri, 18 Nov 2011 16:42:18 GMT
Am 18.11.2011 17:30, schrieb Spezifikum:
> Hi,
> i am quite sure that this question was already asked more than once, 
> but i can't find valuable information.
> I have a servlet using Apache Derby embedded as a DB backend and have 
> to make daily backups. I can not shut down the entire DB or servlet, 
> so my plan would be to lock the tables and do something like "select 
> into outfile" if possible.
> Is that a good idea?
> I expect the database to grow by 50MB per Year, possibly less, but no 
> more than 100MB. It is running on quite powerfull hardware (quad-core, 
> 4GB RAM) and i have a several hours time to do a backup (from 2 to 5 o 
> clock). So performance is not the problem but consistency.
>
> Thanks a lot for any comments in advance
> M. Müller
Sorry. I just found the relevant parts quite well documented in the 
administration guide. The best solution would be to build something 
around "SYSCS_UTIL.SYSCS_BACKUP_DATABASE".

Thanks
M. Müller

Mime
View raw message