From derby-user-return-14024-apmail-db-derby-user-archive=db.apache.org@db.apache.org Fri Nov 18 16:40:09 2011 Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 1A30F9F6F for ; Fri, 18 Nov 2011 16:40:09 +0000 (UTC) Received: (qmail 90488 invoked by uid 500); 18 Nov 2011 16:40:08 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 90455 invoked by uid 500); 18 Nov 2011 16:40:08 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 90448 invoked by uid 99); 18 Nov 2011 16:40:08 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Nov 2011 16:40:08 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [85.214.47.106] (HELO h1652951.stratoserver.net) (85.214.47.106) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Nov 2011 16:40:00 +0000 Received: from [192.168.0.3] (host-091-097-140-074.ewe-ip-backbone.de [91.97.140.74]) by h1652951.stratoserver.net (Postfix) with ESMTPA id 9EF2A50218F for ; Fri, 18 Nov 2011 17:39:39 +0100 (CET) Message-ID: <4EC68AEA.2080006@spezifikum.com> Date: Fri, 18 Nov 2011 17:42:18 +0100 From: Spezifikum User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:8.0) Gecko/20111105 Thunderbird/8.0 MIME-Version: 1.0 To: derby-user@db.apache.org Subject: Re: Live backup - best practice? References: <4EC68836.2030005@spezifikum.com> In-Reply-To: <4EC68836.2030005@spezifikum.com> Content-Type: multipart/alternative; boundary="------------050504040303090302070807" This is a multi-part message in MIME format. --------------050504040303090302070807 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 8bit 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 --------------050504040303090302070807 Content-Type: text/html; charset=ISO-8859-15 Content-Transfer-Encoding: 8bit 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
--------------050504040303090302070807--