I am not too fussy about FBSD multiuser dump/restore operations on a
production server as dynamic as a DBMail system (does the new (-L) switch
(UFS2) change that - I don't know.).
Simon's point is a good one. One needs to be careful though about
replicating full-circle a hopelessly corrupted or dropped InnoDB. (A recent
tarball is good to have)
To achieve the backup on a replicating slave what I do at a number of
locations is:
* run a shell or perl script from crontab on a replication slave to:
* stop the RDBMS,
* tarball the database namespace
* restart the RDBMS, resume replication,
* rename the tarball with a date
* move the the tarball to NFS backup drive and
* delete tarballs older than xx days
(That way if cron ever tarballs a bad database (which can happen if database
corruption preceeds a catastrophic failure) I can fall back to the
previous.)
This is very inexpensive and seems to cover most if not all
disaster/recovery scenarios.
I have also seen some admins get away with hot mysql dumps on DBs up to
8gigs, but somewhat expensive so schedule for low-service periods.
I have only done hot pg_dump on smaller databases. I prefer a custom format
(-Fc) to a tarball to allow reordering flexibility on a restore / migrate
(pg_dump allows read-writes in-progess so restore sometimes requires a tweak
or two).
best...
Mike
----- Original Message -----
From: "Simon Lange" <[EMAIL PROTECTED]>
To: "'DBMail mailinglist'" <dbmail@dbmail.org>
Sent: Thursday, July 07, 2005 8:08 PM
Subject: RE: [Dbmail] Database backup
what database-server-software are u using?!
ever evaluated realtime database replication?! we do use a circle
replication and we are very succefull that way...
Simon
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf
Of Niblett, David A
Sent: Wednesday, July 06, 2005 3:24 PM
To: 'dbmail@dbmail.org'
Subject: [Dbmail] Database backup
Just curious out there how others do their database maintenance and
backups.
If I understand the docs correctly, it would be best to run
dbmail-util -ar
and then a dump of the database. I'm currently using 'pg_dump -Ft dbmail
|
bzip2 -9 > <filename>'
Anyone have any other suggestions or ideas?
--
David A. Niblett | email: [EMAIL PROTECTED]
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
