Backup of Derby database?
Hi!
The Express-C edition of RTC uses the embedded database Apache Derby to store all data. I've heard about other embedded databases (HSQL) occasionally suffering from data corruption. So what are other backup options with Derby apart from just copying the (possibly corrupted) files someplace else? For instance, in MySQL the default database dump file consists of SQL statements which helps against corruption since the data is there in clear text. Is there a similar option for Derby as well?
Karsten
The Express-C edition of RTC uses the embedded database Apache Derby to store all data. I've heard about other embedded databases (HSQL) occasionally suffering from data corruption. So what are other backup options with Derby apart from just copying the (possibly corrupted) files someplace else? For instance, in MySQL the default database dump file consists of SQL statements which helps against corruption since the data is there in clear text. Is there a similar option for Derby as well?
Karsten
6 answers
The best practice for Derby backup is to regularly take your server
off-line and to zip up the Derby directory. That would be hard to
implement in a production environment where users expect the server to
be available all the time. A better approach is to use a DB system that
allows online backup, such as DB2.
-
Matt Lavin
Jazz Server Team
On Wed, 2008-11-05 at 14:38 +0000, ksilz wrote:
off-line and to zip up the Derby directory. That would be hard to
implement in a production environment where users expect the server to
be available all the time. A better approach is to use a DB system that
allows online backup, such as DB2.
-
Matt Lavin
Jazz Server Team
On Wed, 2008-11-05 at 14:38 +0000, ksilz wrote:
Hi!
The Express-C edition of RTC uses the embedded database Apache Derby
to store all data. I've heard about other embedded databases (HSQL)
occasionally suffering from data corruption. So what are other
backup options with Derby apart from just copying the (possibly
corrupted) files someplace else? For instance, in MySQL the default
database dump file consists of SQL statements which helps against
corruption since the data is there in clear text. Is there a similar
option for Derby as well?
Karsten
hello, i'm wondering if can backup all needed data with common db2 full backup.
I'v recognized that, if i run the repotools export command, more data than those in the db will be stored in the repository.tar. With repo export, it seems like meta data and some folders will be exported to the .tar too.
Does the db2 backup save all the required data?
I'v recognized that, if i run the repotools export command, more data than those in the db will be stored in the repository.tar. With repo export, it seems like meta data and some folders will be exported to the .tar too.
Does the db2 backup save all the required data?
DB2 backs up only your Jazz database.
Repotools -export -> exports the jazz contents, full text index (used for text search work items, plans etc) and metadata used for import.
DB2 online backup would be really fast compared to repotools -export (because Db2 only backs up the data changed).
--- Balaji
Jazz Server Team
Repotools -export -> exports the jazz contents, full text index (used for text search work items, plans etc) and metadata used for import.
DB2 online backup would be really fast compared to repotools -export (because Db2 only backs up the data changed).
--- Balaji
Jazz Server Team
hello, i'm wondering if can backup all needed data with common db2 full backup.
I'v recognized that, if i run the repotools export command, more data than those in the db will be stored in the repository.tar. With repo export, it seems like meta data and some folders will be exported to the .tar too.
Does the db2 backup save all the required data?
rkelkenb wrote:
That's exactly right. Use the DB2 facilities for backing up your data.
There's a good article with some tips for backing up here:
https://jazz.net/learn/LearnItem.jsp?href=content/tech-notes/jazz-team-server-0_6-deployment-guide/index.html
Thanks,
Craig Chaney
Jazz server team
may it be that a db2 full backup would store all necessary data, so i
don't have to backup via repotools.
I've heard before that repotools export was not thought for the use of
backup, just for the case of migration.
That's exactly right. Use the DB2 facilities for backing up your data.
There's a good article with some tips for backing up here:
https://jazz.net/learn/LearnItem.jsp?href=content/tech-notes/jazz-team-server-0_6-deployment-guide/index.html
Thanks,
Craig Chaney
Jazz server team