[ale] MySql Replication

[Christopher Fowler]

So far no good.  I've got the msater up to 16M.  The database is only 3M in
size

On Tue, Jul 01, 2003 at 08:36:46AM -0700, Martha Armour wrote:
> 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
_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale