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.
-J On 2/27/07, Norbert Sendetzky <[EMAIL PROTECTED]> 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
_______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
