Re: Sqlite3 locking

Angelo Ativo <[email protected]> Wed, 14 Sep 2016 19:31:15 +0000

Newsgroups	gmane.network.dns.powerdns.devel
Message-ID	<[email protected]>

Thank you for the response Justin, it’s much appreciated.

—Angelo


> On Sep 12, 2016, at 1:08 PM, Justin Clift <[email protected]> wrote:
> 
> On 12 Sep 2016, at 20:53, Angelo Ativo <[email protected]> wrote:
> <snip>
>> Wouldn’t the chances of this failure be relatively high if there were say, hundreds of NSUPDATE requests to a PDNS server backed by sqlite3 every second? What happens when two NSUPDATE requests occur at the exact same time?
> 
> Note - I’m not a PDNS developer, so can’t comment on the retry thing (though
> it sounds useful).
> 
> Specifically with the SQLite bit though, it’s not really designed for high
> write rates (with contention).  If someone’s usage is becoming like that,
> it’d be a good idea to migrate the SQL backend to something  with good write
> contention handling. (there are many options, though naturally I’ll point
> at PostgreSQL as being decent :>)
> 
> Regards and best wishes,
> 
> Justin Clift
> 
> --
> "My grandfather once told me that there are two kinds of people: those
> who work and those who take the credit. He told me to try to be in the
> first group; there was less competition there."
> - Indira Gandhi
>

_______________________________________________
Pdns-dev mailing list
[email protected]
https://mailman.powerdns.com/mailman/listinfo/pdns-dev

signature.asc (application/pgp-signature, 842 B)