Re: [Sqlgrey-users] postgery to sqlgrey

[Farkas L. <lf...@bp...>]

reply to my own mail:-(

Farkas Levente wrote:
> imho the greylist database is not so complicated. it's easy to recognize 
> which records should have to replicate. only old/expired record have to 
> delete and always the last updated one is the latest and all record has 
> timestemp (because that's the main purpose the database) so it's easy to 
> know which is the last updated.

just another tip, may be there are better ideas;
one solution to create a connetion to all (both if there is only two) 
sql server. when you lookup for one triplet you can do it on all sql 
server and use the latest ie. the one with the smallest value. update 
only one sql server (probably the first in this case everybody update 
the same server most case). in the cleanup step (or in another scheduled 
time eg. hourly) you can merge/replicate the sql server before delete 
(update to the latest triplet value on all sql server). so you don't 
need mysql replication you can do the whole thing in the sqlgrey server.

-- 
   Levente                               "Si vis pacem para bellum!"