[ale] MySql Replication

[Christopher Fowler]

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?






On Tue, Jul 01, 2003 at 07:57:56AM -0700, Martha Armour wrote:
> I have a fail-over setup where two machines running
> MySQL are slave/masters to each other; however,
> the reserve machine does not do any updating of
> the database and will only do so if it becomes
> active.  To expand upon what Attriel said,
> the auto increment tables will mess you up.  If
> you try to insert a key that is already in an
> auto incremented table, replication will break.
> 
> So for my setup, this is fine, but it won't work
> correctly with two masters updating at the same
> time.
> 
> - Martha
> 
> --- attriel <attriel at d20boards.net> wrote:
> > > ------------------------
> > > | Master In Alpharetta |
> > > ------------------------
> > >           |
> > >           |
> > >           |
> > >   Slaves  |
> > >   ----------------------
> > >   |                    |
> > >   Alpharetta        Buford
> > >
> > >
> > > Is it possible to modify data in the slaves and
> > > that data be modified in the master?  I
> > > think I remeber that you had to allways
> > > modify the master
> > 
> > AFAIR, no.  You have to modify the master, the
> > slaves basically allow you
> > to distribute querying (so, if you get a LOT of
> > requests, but no so many
> > updates) ...
> > 
> > For some of the stuff I'm trying to do, multi-master
> > systems would be
> > useful, and I remember talking to someone last year
> > who said it was
> > possible IF you add a new field for all tables
> > "serverid" that is
> > auto-filled by each server with it's own ID, then
> > the uniqueness of
> > whatever column is extended to include the serverid
> > as well (b/c the
> > auto-inc fields won't be unique anymore, since two
> > servers might be
> > serving at the same time)
> > 
> > Then there was some other problem with that scheme
> > that I didn't follow
> > (being why I haven't set this up yet :/)
> > 
> > If you get any more tips, let us know :)
> > 
> > --attriel
> 
> 
> __________________________________
> 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