Hi, We are using sql with --with-mysql on Cyrus 3.4 and are on plan to upgrade to version 3.12. We are setting up Mysql shared database for mboxlist_db and annotation_db (due to our use of nfs for managing cyrus instances failover)
Indeed, we have low write throughput on these tables. We have made many fixes and improvements in the code and would be happy to share upstream if anybody else is interested Regards, Sébastien MICHEL https://worldline.com Le lun. 8 déc. 2025 à 10:00, Bron Gondwana via Info <[email protected]> a écrit : > An obvious one is something like the "user_deny" database being in a > central sql database. > > But I do think that the 'sql' backend isn't fit to be used as a > high-write-volume database engine right now. Obviously the one true best > database is twom right now! > > Bron. > > On Mon, Dec 8, 2025, at 17:55, Marco Moock wrote: > > On 08.12.2025 10:50 "ellie timoney" <[email protected]> wrote: > > > We recently discovered that our unit tests haven't been exercising > > the "sql" cyrusdb backend. I set it up so that it would be tested, > > and found a lot of test failures. This makes me wonder if anyone's > > even using it. > > What are the advantages oft that compared to the database files on disk? > > -- > kind regards > Marco > > Send spam to [email protected] > > -- > Bron Gondwana, CEO, Fastmail Pty Ltd / Fastmail US LLC > [email protected] > > *Cyrus <https://cyrus.topicbox.com/latest>* / Info / see discussions > <https://cyrus.topicbox.com/groups/info> + participants > <https://cyrus.topicbox.com/groups/info/members> + delivery options > <https://cyrus.topicbox.com/groups/info/subscription> Permalink > <https://cyrus.topicbox.com/groups/info/Tf5784813a5ff184f-Mbc4e1e37fc74034b3fd9ad6f> ------------------------------------------ Cyrus: Info Permalink: https://cyrus.topicbox.com/groups/info/Tf5784813a5ff184f-Md349d2c90d6a961cb479677f Delivery options: https://cyrus.topicbox.com/groups/info/subscription
