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

[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 properly if its going to support InnoDB. In the event
> of a rollback, either the entire transfer should be re-applied or
> dropped depending on your point of view.
> 
> -J
> 
> On 2/26/07, Norbert Sendetzky <norbert at linuxnetworks.de> wrote:
> >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://dev.mysql.com/doc/refman/5.0/en/auto-reconnect.html I
> >consider disabling auto-reconnect a good thing, even if you are annoyed of
> >the log file entries :-)
> >
> >Auto-reconnect is very dangerous while doing an AXFR transfer because it 
> >rolls
> >back the transaction and reenables auto-commit mode. This may leave your 
> >zone
> >in a state where the first half of the records are missing (when a slave
> >updates it's zone).
> >
> >
> >Norbert

I thought that the zone AXFR's occur is a transaction. In that case, when
a rollback occurs the DB is in the state that it was before the AXFR was
attempted, including the serial number. Why would half of the records be
suddenly missing?

Ken