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

Jason J. W. Williams jasonjwwilliams at gmail.com
Tue Feb 27 22:26:43 UTC 2007

Hi Norbert,

Why are you assigning this as a MySQL design flaw? We've designed
quite a few InnoDB apps that handle just this situation very well in
event of a rollback.


On 2/27/07, Norbert Sendetzky <norbert at linuxnetworks.de> wrote:
> 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

More information about the Pdns-users mailing list