Re: [Gnumed-devel] Server replication

[Karsten Hilbert]

On Wed, Jul 04, 2012 at 10:43:19PM +0000, Jim Busser wrote:

> >> I have a mirrored slave server that is replicating in real time On Site 
> >> using R-sync.
> >> I also have a back-up offsite storage that receives a copy of the entire 
> >> database nightly.
> >> 
> >> I have Sentinel programs in place to make sure each of these back-ups are 
> >> operational.
> >> 
> >> A script running on the "Slave" server that executes once an hour, and 
> >> checks the master/slave replication status. It's actually fairly smart, it 
> >> connects to the master DB (from the slave server), asks for the master 
> >> status, which gives it the binary logfile name and the logfile position.
> >> 
> >> It then does a "show slave status" on the slave, and compares. If the 
> >> numbers don't match, it sends an email to me.
> >> 
> >> I also receive a daily email form my remote back-up server indicating the 
> >> size of yesterday's back up file as well as the size of today's back up 
> >> file.
> 
> For some of the above, would 'check_postgres' be suitable?
> 
>       http://bucardo.org/check_postgres/check_postgres.pl.html#description

Yes. Monitoring services is always a good idea.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346