H2 Database Backup

[Tim Stevens]

Hello, I am new to GoCD and want to take a backup of our rather large H2 database +4 gigs.  Has anyone done this before and remember about how long the backup took?  I want to schedule downtime for this, but want a ball park figure of how long to plan on.

Thanks in advance!

[Chad Wilson]

Hi Tim

Not sure if you are aware, but you can schedule GoCD's backup which will prevent interactions temporarily while it takes a database backup, so not sure you need to "schedule downtime" as much as schedule the backups in the middle of the morning and set user expectations if the server is otherwise expected to be up 24/7.

For a rough rule of thumb, the build.gocd.org database is ~5GB and anecdotally I think takes a minute or so to complete, zipping to a 1GB DB file. This will likely vary depending on the resources your GoCD server has (as the H2 BACKUP operation is done in memory) and the file system speed for where your DB is stored and your output "artifacts" dir.

-Chad

On Tue, May 24, 2022 at 9:58 PM Tim Stevens <timi...@gmail.com> wrote:

Hello, I am new to GoCD and want to take a backup of our rather large H2 database +4 gigs.  Has anyone done this before and remember about how long the backup took?  I want to schedule downtime for this, but want a ball park figure of how long to plan on.

Thanks in advance!

--
You received this message because you are subscribed to the Google Groups "go-cd" group.
To unsubscribe from this group and stop receiving emails from it, send an email to go-cd+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/go-cd/7e492020-871d-41e7-aea6-18fd31da5127n%40googlegroups.com.

[Aravind SV]

There’s also the maintenance mode, which helps make sure that nothing is running and no one is able to run anything new. I don’t remmeber if you can run a backup during that time, but it could be used to wind everything down in preparation.

I second everything Chad said regarding the file system speed etc.

Cheers,
Aravind

To view this discussion on the web visit https://groups.google.com/d/msgid/go-cd/CAA1RwH_JnmbSRLXtZomyoTYLiXGKUp4bvL0e2WHdnTmhJu1Mug%40mail.gmail.com.

[Tim Stevens]

Thanks Chad/Aravind, this helps!

[Tim Stevens]

From what tool do I perform the backup?  I don't see anything in Perforce to do this.  I am assuming it is performed through the GoCD user interface on the server?

On Thursday, May 26, 2022 at 2:43:21 AM UTC-7 Aravind SV wrote:

[Aravind SV]

Searching for “backup” in GoCD’s documentation should provide you all the information regarding it. 

https://docs.gocd.org

To view this discussion on the web visit https://groups.google.com/d/msgid/go-cd/96c0bc20-7c41-4b82-8d21-9e2c9924821fn%40googlegroups.com.

[Tim Stevens]

Thanks Aravind, I found what I was looking for.