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 <[EMAIL PROTECTED]> 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
--
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc


_______________________________________________
Pdns-users mailing list
[email protected]
http://mailman.powerdns.com/mailman/listinfo/pdns-users



_______________________________________________
Pdns-users mailing list
[email protected]
http://mailman.powerdns.com/mailman/listinfo/pdns-users

Reply via email to