[Pdns-users] mysql timeout

[Richard Mayhew]

_________________________________________________________________

Nashua Mobile (PTY) LTD Electronic Mail Notice: Click Here 
or send an email to emailnotice at nashuamobile.com
_________________________________________________________________
I had the same problem with my MySQL replication until I changed the
default timeout settings.
Here is my my.cnf. Note the slave-net-timeout and master-connect-retry
options.


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

slave-net-timeout=30
master-connect-retry=30
     
#Database Replication
log-bin
server-id=2
master-host=xxxxxxxxx
master-user=xxxxxxxxxx
master-password=xxxxxxxxx

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


-----Original Message-----
From: pdns-users-bounces at mailman.powerdns.com
[mailto:pdns-users-bounces at mailman.powerdns.com] On Behalf Of Maik Fuss
Sent: 16 April 2007 08:59 PM
To: pdns-users at mailman.powerdns.com
Subject: Re: [Pdns-users] mysql timeout


> Thank you for verifying, but please remain polite. 
>
> Is your server a very quiet one? 
>
> 	Bert
>
>   
Excuse my impolitely, but... :)

The server is quiet (few domains) for the WAN, but for the VPN he is the
mainserver and so its a slow working with this problem atm.

_______________________________________________
Pdns-users mailing list
Pdns-users at mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users