Subject | Re: [firebird-support] gbak speed |
---|---|
Author | Steve Wiser |
Post date | 2013-04-11T13:43:21Z |
We back up a 24 GB Firebird 2.1.5 database nightly on an High CPU Extra
Large EC2 instance with the fdb located on EBS. Takes 39 minutes and we
have an encryption layer on top of the file system. We do not use the
loopback interface, instead we reference the fdb by direct file location
and use the flags of -b -v -t -y (we like to log the results).
I hope that helps!
-steve
--
Steve Wiser
President
Specialized Business Software
6325 Cochran Road, Unit 1
Solon, OH 44139
www.specializedbusinesssoftware.com
www.docunym.com
(440) 542-9145 - fax (440) 542-9143
Toll Free: (866) 328-4936
Large EC2 instance with the fdb located on EBS. Takes 39 minutes and we
have an encryption layer on top of the file system. We do not use the
loopback interface, instead we reference the fdb by direct file location
and use the flags of -b -v -t -y (we like to log the results).
I hope that helps!
-steve
--
Steve Wiser
President
Specialized Business Software
6325 Cochran Road, Unit 1
Solon, OH 44139
www.specializedbusinesssoftware.com
www.docunym.com
(440) 542-9145 - fax (440) 542-9143
Toll Free: (866) 328-4936
On Thu, Apr 11, 2013 at 9:29 AM, Nick Upson <nu@...> wrote:
> incremental backup is not recommended in firebird 2.1.5 under significant
> load, I wish I could
>
>
> On 11 April 2013 14:27, Ricardo Uzcategui <ricardouven@...> wrote:
>
> > **
> >
> >
> > Hi.
> >
> > My experience is using SSD sata III 6BG IO speed with best results (in a
> > mac bookpro with 16 gb ram). and, are you considering to use incremental
> > backup?
> >
> > On Thu, Apr 11, 2013 at 8:14 AM, Norman Dunbar <Norman@...
> > >wrote:
> >
> >
> > > Ahem ...
> > >
> > > On 11/04/13 13:26, Norman Dunbar wrote:
> > >
> > > > I've updated the gbak manual to reflect the use of -g[arbage_collect]
> > > > and -se[rvice] to speed up backups and restores, by adding a couple
> of
> > > > sections explaing their use.
> > >
> > > Obviously, I didn't include -g[arbage_collect] in the restore section!
> > >
> > >
> > > Cheers,
> > > Norm.
> > >
> > > --
> > > Norman Dunbar
> > > Dunbar IT Consultants Ltd
> > >
> > > Registered address:
> > > Thorpe House
> > > 61 Richardshaw Lane
> > > Pudsey
> > > West Yorkshire
> > > United Kingdom
> > > LS28 7EL
> > >
> > > Company Number: 05132767
> > >
> > >
> > > ------------------------------------
> > >
> > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > >
> > > Visit http://www.firebirdsql.org and click the Resources item
> > > on the main (top) menu. Try Knowledgebase and FAQ links !
> > >
> > > Also search the knowledgebases at http://www.ibphoenix.com
> > >
> > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> >
> > --
> > Ricardo...
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
>
> --
> Nick Upson, Telensa Ltd
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
>
> This message and any files transmitted with it may contain information
> that is privileged, confidential, and exempt from disclosure under
> applicable law. They are intended solely for the use of the intended
> recipient. If you are not the intended recipient, distributing, copying,
> disclosing, or reliance on the contents of this communication is strictly
> prohibited. If this has reached you in error, kindly destroy this message
> and notify the sender immediately. Thank you for your assistance.
>
> We attempt to sweep harmful content (e.g. viruses) from e-mail and
> attachments, however we cannot guarantee their safety and can accept no
> liability for any resulting damage. The recipient is responsible to
> verify the safety of this message and any attachments before accepting them.
>
>
[Non-text portions of this message have been removed]