[ale] MySql Replication

[Christopher Fowler]

Excuse the html crap

http://www.ultraviolet.org/mail-archives/mysql.2001/16494.html

This page descibed a fix that actually fixed the problem.  I now
have replication on 2 slaves.


On Tue, Jul 01, 2003 at 01:31:41PM -0400, Christopher Fowler wrote:
> 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
_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale