[ale] MySql Replication

[Martha Armour]

Christopher,

In /etc/my.cnf (or other location of your MySQL
config file, there is a line):

set-variable    = max_allowed_packet=1M

My setup works fine with the 1 Meg default.  It
appears
that you need to increase this size.  I hope this
helps!

- Martha 


--- Christopher Fowler <cfowler at outpostsentinel.com>
wrote:
> That is what I assumed.  
> 
> I setup the Alpharetta slave this morning as another
> fail-over
> mechanism in case Buford became disconnected for
> periods of
> time.  
> 
> Here is the setup:
> 
> Master:
> MySQL: mysql-server-3.23.54a-3.72
> OS: RH 7.2
> 
> Alpharetta Slave
> MySql: mysql-server-3.23.56-1.9
> OS: RH 9
> 
> Buford Slave:
> MySQL: 3.23.55
> OS: FreeBSD 5.0
> 
> 
> The error message I'm not getting on the new
> Alpharetta
> slave is as follows:
> 
> 030701 11:03:51  Slave: reconnected to master
> 'repl at 192.168.2.5:3306',replication resumed in log
> 'moses-bin.001' at position 840
> 030701 11:03:51  Error reading packet from server:
> log event entry exceeded max_allowed_packet -
> increase max_allowed_packet on master
> (server_errno=65535)
> 030701 11:04:51  Slave: Failed reading log event,
> reconnecting to retry, log 'moses-bin.001' position
> 840
> 030701 11:04:51  Slave: reconnected to master
> 'repl at 192.168.2.5:3306',replication resumed in log
> 'moses-bin.001' at position 840
> 030701 11:04:51  Error reading packet from server:
> log event entry exceeded max_allowed_packet -
> increase max_allowed_packet on master
> (server_errno=65535)
> 
> Is there something I need to tweak?


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale