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

2007-02-28 Thread Norbert Sendetzky
Hi Jason > 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. When your applications notice that the connection is lost, they also know that transactions where rolled back and they can ei

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

2007-02-27 Thread Jason J. W. Williams
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

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

2007-02-27 Thread 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 > environm

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

2007-02-26 Thread Jason J. W. Williams
Hi Norbert, 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 li

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

2007-02-26 Thread Norbert Sendetzky
On Monday 26 February 2007 23:55, Kenneth Marshall wrote: > On Mon, Feb 26, 2007 at 03:37:58PM -0700, Jason J. W. Williams wrote: > > It would be nice to have a config file option to enable/disable it. In > > our environment, there are no zone transfers going on, and its more > > important to recon

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

2007-02-26 Thread Kenneth Marshall
On Mon, Feb 26, 2007 at 03:37:58PM -0700, Jason J. W. Williams wrote: > It would be nice to have a config file option to enable/disable it. In > our environment, there are no zone transfers going on, and its more > important to reconnect to maximize uptime. Also, PowerDNS should > handle rollbacks

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

2007-02-26 Thread Jason J. W. Williams
It would be nice to have a config file option to enable/disable it. In our environment, there are no zone transfers going on, and its more important to reconnect to maximize uptime. Also, PowerDNS should handle rollbacks properly if its going to support InnoDB. In the event of a rollback, either t

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

2007-02-26 Thread Norbert Sendetzky
Hi Christian > starting in MySQL 5.0.3 the reconnect-flag in the mysqlclientlib is set to > 0 by default, which means no auto-reconnecting. > > Any ideas or plans to solve this? We found several "mysql server has gone > away" in the logfile, while the server runs perfectly. After reading http://d

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

2007-02-26 Thread Jason J. W. Williams
Hello all, We've noticed this behavior with PDNS as well...but did not know what to attribute it to. -J On 2/26/07, Christian Kuehn <[EMAIL PROTECTED]> wrote: Hi, starting in MySQL 5.0.3 the reconnect-flag in the mysqlclientlib is set to 0 by default, which means no auto-reconnecting. Any id

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

2007-02-26 Thread Christian Kuehn
Hi, starting in MySQL 5.0.3 the reconnect-flag in the mysqlclientlib is set to 0 by default, which means no auto-reconnecting. Any ideas or plans to solve this? We found several "mysql server has gone away" in the logfile, while the server runs perfectly. Greets Christian -- Christian Kühn (Te