hi folks,
i'm currently mirroring multiple databases w/ postgresql.
this requires some additional support in the application:
each table has an inode_id (as global object id) and an mtime field.
on each insert, an new inode_id is fetched from an sequence and on
each insert/update the mtime is updated.
after some time (i.e. one minute) all new rows are posted to all
other nodes. (the nodes are listed in an separate table w/ their
last-poll time, so evrything newer than the lastpoll is posted out).
this works quite good for my current applications, but I still have
some latency. (depends on the polling time - i dont want to query all
tables evry second ...)
is there an better way to solve this ?
cu
--
---------------------------------------------------------------------
Enrico Weigelt == metux ITS
Webhosting ab 5 EUR/Monat. UUCP, rawIP und vieles mehr.
phone: +49 36207 519931 www: http://www.metux.de/
fax: +49 36207 519932 email: contact@metux.de
cellphone: +49 174 7066481 smsgate: sms.weigelt@metux.de
---------------------------------------------------------------------
Diese Mail wurde mit UUCP versandt. http://www.metux.de/uucp/