Anoop Bhat ABhat at trustwave.com
Thu Nov 6 12:13:05 PST 2008
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.

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.

I used the slony docs this time to set it up just to make sure it was done right.

I noticed this by the way on http://www.slony.info/documentation/firstdb.html

# subscribe set to second node (1= set ID, 2= node ID)
$ slonik_subscribe_set  2 | slonik

Is that command missing an option?

Thanks

Anoop



More information about the Slony1-general mailing list