[opensuse-buildservice] OBS backup
Hello, We are using OBS already for some time but haven't made any backups yet. Is there a way to backup an OBS system, OBS mysql database and filesystems? Thanks in advance. Best regards, Lud -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org
On Tuesday 2012-09-11 14:42, Lud Antonie wrote:
Hello,
We are using OBS already for some time but haven't made any backups yet. Is there a way to backup an OBS system, OBS mysql database and filesystems?
Anything wrong with rsync and mysqldump? -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org
On Tue, Sep 11, 2012 at 12:55 PM, Jan Engelhardt <jengelh@inai.de> wrote:
We are using OBS already for some time but haven't made any backups yet. Is there a way to backup an OBS system, OBS mysql database and filesystems?
Anything wrong with rsync and mysqldump?
Well, usually you don't "rsync" online databases (mysql or svn), as that would result in inconsistencies. You have to snapshot the filesystem, which may not be that easy (depending on the filesystem). So, for mysql it should be mysqldump, and for svn it should be "svnadmin dump". -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org
----- Original Message -----
Anything wrong with rsync and mysqldump?
Well, usually you don't "rsync" online databases (mysql or svn), as that would result in inconsistencies. You have to snapshot the filesystem, which may not be that easy (depending on the filesystem).
I often mysqldump to a file inside the directory I'm backing up before initiating the backup so rsync works fine. The bonus is that when you do incrementals (I use duplicity) you get a nice history of the database data. -- James Oakley jfunk@funktronics.ca -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org
Hello, Which filesystems needs to be dumped to backup the OBS software i.e. in which directories is OBS installed? Thanks in advance. Best regards, Lud -----Original Message----- From: Claudio Freire [mailto:klaussfreire@gmail.com] Sent: Tuesday, September 11, 2012 6:00 PM To: Jan Engelhardt Cc: Lud Antonie; opensuse-buildservice@opensuse.org Subject: Re: [opensuse-buildservice] OBS backup On Tue, Sep 11, 2012 at 12:55 PM, Jan Engelhardt <jengelh@inai.de> wrote:
We are using OBS already for some time but haven't made any backups yet. Is there a way to backup an OBS system, OBS mysql database and filesystems?
Anything wrong with rsync and mysqldump?
Well, usually you don't "rsync" online databases (mysql or svn), as that would result in inconsistencies. You have to snapshot the filesystem, which may not be that easy (depending on the filesystem). So, for mysql it should be mysqldump, and for svn it should be "svnadmin dump". -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org
Am Mittwoch, 12. September 2012, 07:22:02 schrieb Lud Antonie:
Hello,
Which filesystems needs to be dumped to backup the OBS software i.e. in which directories is OBS installed?
The backend data in /srv/obs and the mysql database content.
Thanks in advance.
Best regards, Lud
-----Original Message----- From: Claudio Freire [mailto:klaussfreire@gmail.com] Sent: Tuesday, September 11, 2012 6:00 PM To: Jan Engelhardt Cc: Lud Antonie; opensuse-buildservice@opensuse.org Subject: Re: [opensuse-buildservice] OBS backup
On Tue, Sep 11, 2012 at 12:55 PM, Jan Engelhardt <jengelh@inai.de> wrote:
We are using OBS already for some time but haven't made any backups yet. Is there a way to backup an OBS system, OBS mysql database and filesystems?
Anything wrong with rsync and mysqldump?
Well, usually you don't "rsync" online databases (mysql or svn), as that would result in inconsistencies. You have to snapshot the filesystem, which may not be that easy (depending on the filesystem).
So, for mysql it should be mysqldump, and for svn it should be "svnadmin dump".
-- Adrian Schroeter SUSE Linux Products GmbH email: adrian@suse.de -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org
On Tuesday 2012-09-11 17:59, Claudio Freire wrote:
On Tue, Sep 11, 2012 at 12:55 PM, Jan Engelhardt <jengelh@inai.de> wrote:
We are using OBS already for some time but haven't made any backups yet. Is there a way to backup an OBS system, OBS mysql database and filesystems?
Anything wrong with rsync and mysqldump?
Well, usually you don't "rsync" online databases (mysql or svn)
Well that's why I said mysqldump.
that would result in inconsistencies.
Can't be worse than when the kernel locks up and you need a force reboot.
So, for mysql it should be mysqldump, and for svn it should be "svnadmin dump".
OBS does not use svn, but its own storage methodology (namely, mostly plain files). -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org
On Wed, Sep 12, 2012 at 8:58 AM, Jan Engelhardt <jengelh@inai.de> wrote:
So, for mysql it should be mysqldump, and for svn it should be "svnadmin dump".
OBS does not use svn, but its own storage methodology (namely, mostly plain files).
Curious, because osc feels a lot like svn. Why would it reinvent the wheel? -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org
On Wed, Sep 12, 2012 at 12:21:31PM -0300, Claudio Freire wrote:
On Wed, Sep 12, 2012 at 8:58 AM, Jan Engelhardt <jengelh@inai.de> wrote:
So, for mysql it should be mysqldump, and for svn it should be "svnadmin dump".
OBS does not use svn, but its own storage methodology (namely, mostly plain files).
Curious, because osc feels a lot like svn. Why would it reinvent the wheel?
Historical reasons, mostly. The storage format used in OBS predates OBS by a couple of years. It's actually much more related to git than svn, e.g. it uses a hash to identify file sets. Cheers, Michael. -- Michael Schroeder mls@suse.de SUSE LINUX Products GmbH, GF Jeff Hawn, HRB 16746 AG Nuernberg main(_){while(_=~getchar())putchar(~_-1/(~(_|32)/13*2-11)*13);} -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org
On Wednesday 12 Sep 2012 12:21:31 Claudio Freire wrote:
Curious, because osc feels a lot like svn. Why would it reinvent the wheel?
because perl. -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org
On Wednesday 2012-09-12 17:21, Claudio Freire wrote:
On Wed, Sep 12, 2012 at 8:58 AM, Jan Engelhardt <jengelh@inai.de> wrote:
So, for mysql it should be mysqldump, and for svn it should be "svnadmin dump".
OBS does not use svn, but its own storage methodology (namely, mostly plain files).
Curious, because osc feels a lot like svn. Why would it reinvent the wheel?
Somehow bdb does not feel like the best to handle large blobs. -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org
On Wed, Sep 12, 2012 at 9:47 PM, Jan Engelhardt <jengelh@inai.de> wrote:
OBS does not use svn, but its own storage methodology (namely, mostly plain files).
Curious, because osc feels a lot like svn. Why would it reinvent the wheel?
Somehow bdb does not feel like the best to handle large blobs.
I've used svn with large (several MB) blobs for a long time, and never had any big issues I haven't had with osc. What does happen is that big transactions fail too often because of network issues, but that also happens with osc. Anyway, quite late in the game to start changing stuff so... -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org
participants (7)
-
Adrian Schröter -
Claudio Freire -
Graham Anderson -
James Oakley -
Jan Engelhardt -
Lud Antonie -
Michael Schroeder