[Pdns-users] MySQL-Reconnecting with MySQL >5.0.3

[Norbert Sendetzky]

Hi Jason

> That's pretty nasty transaction-dumb behavior. Is that because
> PowerDNS treats the MySQL driver as just an abstracted storage engine?
> PDNS if its going to use transaction-safe databases, should create a
> transaction abstraction layer that gets enforced when using an ACID
> environment like InnoDB or Postgres.

The behavior is a design flaw of the MySQL database, which is only OK for 
read-only operations but may totally break when changing records (esp. in a 
transaction). Therefore, they turned it off by default now.

PDNS can't do anything besides enforcing the flag to be turned off because it 
don't get notified if an auto-reconnect happens.


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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20070227/a486ca1f/attachment-0001.sig>