Subject | Re: [firebird-support] nbackup in high load environments |
---|---|
Author | Kjell Rilbe |
Post date | 2011-07-14T07:48:17Z |
Den 2011-07-14 08:49 skrev Thomas Steinmaurer såhär:
size with two tables containing onver 150 million records each (and
several other tables). The load is low - only an internal web app with
about five concurrent users.
During devel I tried using nbackup, but when running a batch job against
this database during nbackup lock state, I received some kind of error
about transaction commit. Don't remember the details now unfortunately,
but I still have the need to du file based backup during operation, so I
will investigate it closer sooner or later. I'll let you know if I get
the error again and find any reason, workaround, or reproducible test case.
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
> is anybody using nbackup in high load environments successfully? I haveI have FB 2.1.x (not sure which) and the database is about 55 Gbyte in
> a report of a guy, which has ~ 400 clients on Classic (although not all
> connected at the same time) and nbackup seems to be culprit for database
> corruption, especially corrupting medium-sized active tables at the time
> of nbackup is doing it's job. He went the 2.1 route up to 2.1.3,
> although he had no chance to upgrade to 2.1.4 yet.
size with two tables containing onver 150 million records each (and
several other tables). The load is low - only an internal web app with
about five concurrent users.
During devel I tried using nbackup, but when running a batch job against
this database during nbackup lock state, I received some kind of error
about transaction commit. Don't remember the details now unfortunately,
but I still have the need to du file based backup during operation, so I
will investigate it closer sooner or later. I'll let you know if I get
the error again and find any reason, workaround, or reproducible test case.
> I know that nbackup wasn't that reliable from the beginning and improvedKjell
> over each release. Basically I wanted to get some user feedback, if
> nbackup is reliable in rather high load environments.
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64