patches since 2.3.12-p2?

Dave McMurtrie dave64 at andrew.cmu.edu
Mon Jul 21 07:44:01 EDT 2008


Ian G Batten wrote:

> I understand some of the technical, philosophical and historical  
> reasons why this isn't the case, but every now and again I find myself  
> wishing that Cyrus had an SQL backend for the various databases  
> (perhaps not delivery, because losing it isn't the end of the world,  
> but certainly for mailboxes).
> 
> In our case, we have really big Oracle and Postgres systems that could  
> proably handle the load imposed by out mailsystem metadata as well as  
> our mailsystem copes with it itself via skiplist, but we would could  
> then manage those databases with the same tools we use for the  
> production systems (hot backups, replication, etc).
> 
> Losing the mailboxes database can spoil your whole day, and the  
> lengths we go to to keep it safe (snapshots of the filesystem, hourly  
> runs of ctl_mboxlist -d, etc, etc should really be necessary if it  
> were in a production SQL database.
> 
> In my copious spare time, I might take a pass at the cope and see how  
> hard it looks.

So you don't duplicate his effort, I should mention that Ken Murchison 
already wrote a generic SQL backend for Cyrus.

We've done a small amount of testing with sqlite, but there's still some 
work to be done before it's production-ready.

Thanks,

Dave


More information about the Info-cyrus mailing list