Fri Oct 10 00:22:37 PDT 2008
- Previous message: [Slony1-general] Slony daemon died on master
- Next message: [Slony1-general] 1 BIG SYNC - 9million rows
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Slony daemon died on master
- Next message: [Slony1-general] 1 BIG SYNC - 9million rows
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list