[Pdns-users] SQLite3 problem during stress

[Norbert Sendetzky]

Hi Christian

> After combating some weird incompatibility with Debian Lenny 5.0 where
> PDNSs gsqlite3 refused to write anything to the database it begun to crash
> when we did the initial transfer (notify of several hundred domains).
> I have tried with the OpenDBX backend which seems to work much better
> regarding the sqlite3 incompatibility but also crashes during heavy
> transfer load.

SQLite is only useful for small installations and a few domains because it 
uses table locks when it writes the changes to the database. As each zone 
transfer is a transaction that wants to write to the same table, no two 
transfers can happen in parallel. Better use a different database for the 
slave dns servers in your case. MySQL is the one with the highest read 
performance but you can use whatever fits your needs.


Norbert
-- 
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part.
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20090719/f895dff4/attachment-0001.sig>