Ow Mun Heng Ow.Mun.Heng at wdc.com
Fri Oct 10 00:22:37 PDT 2008
Hi,

My Slony Master daemon died and for some reason, the slave died along
with it and that was over 4 days ago.

I read back the archives and found that it really _isn't_ a problem (if
my hardware can handle it) [which I know it can't really]

select * from _hmxmms_my_cluster.sl_event order by ev_timestamp asc
limit 2;
-[ RECORD
1 ]+------------------------------------------------------------------------------------------------------------------------------------
ev_origin    | 1
ev_seqno     | 2463502
ev_timestamp | 2008-10-06 00:23:59.276714
ev_minxid    | 73888983
ev_maxxid    | 73906072
ev_xip       |
'73891993','73891292','73888983','73897065','73892567','73895703','73893260','73895669','73891049','73891575','73891928','73892147'
ev_type      | SYNC
-[ RECORD
2 ]+------------------------------------------------------------------------------------------------------------------------------------
ev_origin    | 1
ev_seqno     | 2463503
ev_timestamp | 2008-10-10 10:32:21.038801
ev_minxid    | 74959838
ev_maxxid    | 74959839
ev_xip       |
ev_type      | SYNC


So, the question now is, is there anything I can do to break up the sync
into a few more, more manageable qty? I'm not sure if it can sync up
9million rows in 1 BIG SYNC.

Is there any way I can eg: sync it manually? meaning, remove the
triggers from the slave and then copy the data over and then restart
slony?

Thanks


More information about the Slony1-general mailing list