| Christopher Browne 2006-01-18, 11:24 am |
| Aaron Randall <aaron.randall- LJ+G6BnwIY2akBO8gow8
eQ@public.gmane.org> writes:
> Hi Everyone :)
>
> I have a question similar to one that was raised a little while ago titled - "How do I know when a subscriber has caught up?".
>
> Is there a flag somewhere that confirms that the master and slave
> are connected (regardless of whether they are currently transmitting
> data) to show that Slony is running successfully on both. At the
> moment, the only was I can check is by tailing the Slony logs, but
> ideally I would like to use some kind of database field that could
> confirm/deny the master and slave(s) are connected successfully.
Well, you can get some implicit "all is running well" if you run
select * from _cluster.sl_status;
If it shows all the nodes you expect, and shows that they are only an
event or two behind, then replication should be functioning well.
That's about the best metric I can think of without looking at the
logs.
You could also run the script test_slony_state.pl (or the DBI
version); that checks a number of things about how things are running.
--
let name="cbbrowne" and tld="ca.afilias.info" in String.concat "@" [name;tld];;
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)
|