List:Replication« Previous MessageNext Message »
From:Database System Date:April 29 2010 6:16pm
Subject:Re: Replication for heavy duty database
View as plain text  
It was same.

--- On Thu, 4/29/10, Tucker, Gabriel <gtucker@stripped> wrote:

> From: Tucker, Gabriel <gtucker@stripped>
> Subject: Re: Replication for heavy duty database
> To: database100@stripped
> Cc: replication@stripped
> Date: Thursday, April 29, 2010, 11:18 AM
> Check your max_allowed_packet
> settings in your CNF and both the master and
> the slave.  They must match.
> 
> On Thu, Apr 29, 2010 at 11:40 AM, Database System
> <database100@stripped>wrote:
> 
> > Hi,
> >
> > Is there anyone does replication on heavy duty
> database? There are a lot of
> > updates on tables. When I replicate that server, I
> found the slave cannot
> > continuely to connect to master, although Slave_I/O
> and SQL_I/O both are
> > "Yes". It had so many times reconnect each second.
> > Here is somehting from error log:
> >
> > 100429  9:03:50 [Note] Slave I/O thread: Failed
> reading log event,
> > reconnecting to retry, log 'binlog.040932' position
> 26904210
> > 100429  9:03:50 [Note] Slave: connected to master
> 'rep_name@host_name',replication
> > resumed in log 'binlog.040932' at position 26904210
> > 100429  9:03:50 [Note] Slave: received end packet
> from server, apparent
> > master shutdown:
> > 100429  9:03:50 [Note] Slave I/O thread: Failed
> reading log event,
> > reconnecting to retry, log 'binlog.040932' position
> 26908777
> >
> > It is still replicating, but has failuer so many times
> per second, fills up
> > error log. There is no network issue can be found.
> ping to master is normal.
> >
> > Anyone had such experience?
> >
> > Thanks advance,
> > Lisa
> >
> >
> >
> >
> > --
> > MySQL Replication Mailing List
> > For list archives: http://lists.mysql.com/replication
> > To unsubscribe:
> > http://lists.mysql.com/replication?unsub=1
> >
> >
> 
> 
> -- 
> Gabe Tucker
> AlertSite - DBA
> P 954.312.0188 / 877.302.5378
> Ext. 214
> www.alertsite.com
> 


      
Thread
Replication for heavy duty databaseDatabase System29 Apr
  • Re: Replication for heavy duty databaseGabriel Tucker29 Apr
    • Re: Replication for heavy duty databaseDatabase System29 Apr
  • Re: Replication for heavy duty databaseTruls Bergskaug30 Apr