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

Kenneth Marshall ktm at rice.edu
Mon Feb 26 22:55:25 UTC 2007

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?


More information about the Pdns-users mailing list