Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 220107

Summary: RHNSat5: speed up database backups?
Product: Red Hat Satellite 5 Reporter: Matt Domsch <matt_domsch>
Component: ServerAssignee: Jesus M. Rodriguez <jesusr>
Status: CLOSED WONTFIX QA Contact: Brandon Perkins <bperkins>
Severity: low Docs Contact:
Priority: low    
Version: 500CC: h.van_schelve, ltroan, sbenjamin, wwlinuxengineering
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2008-10-29 14:22:00 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Satellite backup and sync script using rsync and lvm none

Description Matt Domsch 2006-12-18 22:19:36 UTC 
Description of problem:
Backing up the database (6GB) can take 20-25 minutes, during which time the 
whole satellite needs to be shut down (service rhn-satellite stop; db-control 
backup; service rhn-satellite start).  Can anything be done to speed this up, 
or to not require that the whole service be taken down for such a long period 
of time?

Version-Release number of selected component (if applicable):
rhn-satellite-4.9.0-14-redhat-linux-as-i386-4-embedded-oracle.iso

How reproducible:
always

Steps to Reproduce:
1. stop services
2. db-control backup 
3. start services

Actual results:
downtime of 20-25 minutes

Expected results:
downtime significantly shorter
Comment 1 Hans-Gerd van Schelve 2007-03-30 15:07:57 UTC 
Created attachment 151282 [details]
Satellite backup and sync script using rsync and lvm
Comment 2 Hans-Gerd van Schelve 2007-03-30 15:11:34 UTC 
Hi Matt.

You can try the satbackup.sh script which is written by me and is attached to
this bug. I use it in our production Environment (Satellite 4.2, with about
10.000 Clients). It uses lvm snapshot mechanism for /rhnsat. The idea is:
stopping satelllite
create snapshot
starting satellite
create backup of the snap
remove snapshot
So the effective downtime of our satellite takes about 30 seconds :-)

Test it an feel free to give me a feedback.

Regards, Hans-Gerd van Schelve
Comment 3 Red Hat Bugzilla 2007-04-12 02:09:43 UTC 
User bnackash's account has been closed
Comment 4 Matt Domsch 2008-10-29 14:22:00 UTC 
These have been open for years with no investigation or resolution.  Since then the code base has moved on significantly, such that many of these no longer would apply to the current spacewalk code.  I'm closing these requests in the hope they're no longer necessary, or if they are, they'll get discovered anew.