Glyn Astill glynastill at yahoo.co.uk
Fri Nov 7 05:25:22 PST 2008
--- On Thu, 6/11/08, Anoop Bhat <ABhat at trustwave.com> wrote:

> Hi,
> 
> I learned from cbrowne that I can query sl_status to find
> out the status of the replication.
> 
> Within a minute or so, the origin's sl_status for the
> cluster I created looked like this
> 
>  st_origin | st_received | st_last_event |     
> st_last_event_ts      | st_last_received |   
> st_last_received_ts     | st_last_received_event_ts  |
> st_lag_num_events |   st_lag_time
> -----------+-------------+---------------+----------------------------+------------------+----------------------------+----------------------------+-------------------+-----------------
>          1 |           2 |            35 | 2008-11-06
> 20:02:24.943084 |               35 | 2008-11-06
> 14:07:11.002322 | 2008-11-06 20:02:24.943084 |              
>   0 | 00:00:06.259891
> 
> 
> st_last_event and st_last_received grew.
> 

Are the slons running? And if so looking in the logs is a good start.

> However, I'm not sure what's being replicated and
> if it's going into the right tables in the slave db.
> 
> The db's are called vul and vul_slave. On vul_slave,
> what can I check on to see if it's gotten any data.
> 

Make a change to a replicated table, then go check it on the slave.



      


More information about the Slony1-general mailing list