List:Replication« Previous MessageNext Message »
From:Suresh Kuna Date:April 16 2011 12:05pm
Subject:Re: replication is not automatic
View as plain text  
Configure the cacti graphs to get more info.

On Sat, Apr 16, 2011 at 5:26 PM, Tim Dunphy <bluethundr@stripped> wrote:

> >Monitor the statistics of the machine and network i.e memory levels and
> traffic during the slave >disconnects.
>
> so monitor using top, ntop and mtop? I've used the former two but not mtop,
> yet. can you please give me an example of how you would correlate the
> monitoring information with problem I am having? What would I be looking
> for?
>
> Or maybe it's just a simple matter of the matter being too "squeezed" to
> perform well during replication. Am I right in my guess that mtop might be
> useful here in troubleshooting this situation?
>
> tx!
>
> tim
>
> ----- Original Message -----
> From: "Suresh Kuna" <sureshkumarilu@stripped>
> To: "Tim Dunphy" <bluethundr@stripped>
> Cc: replication@stripped, "a smith" <a.smith@stripped>
> Sent: Saturday, April 16, 2011 12:54:15 AM
> Subject: Re: replication is not automatic
>
> Monitor the statistics of the machine and network i.e memory levels and
> traffic during the slave disconnects.
>
>
> On Sat, Apr 16, 2011 at 10:20 AM, Tim Dunphy < bluethundr@stripped >
> wrote:
>
>
>
> both instances are connected to the same 192.168.1.x network. they are both
> tiny 256k istances. could it be just a matter of them not being "tough
> enough" to handle replication? that is to say larger instances with more
> ram?
>
> just a thought...
>
>
> ----- Original Message -----
> From: "Suresh Kuna" < sureshkumarilu@stripped >
>
> To: "Tim Dunphy" < bluethundr@stripped >
>
>
>
> Cc: replication@stripped , "a smith" < a.smith@stripped >
> Sent: Saturday, April 16, 2011 12:44:10 AM
> Subject: Re: replication is not automatic
>
> Master and slave are connected each other through which network ?
>
> On Sat, Apr 16, 2011 at 8:09 AM, Tim Dunphy < bluethundr@stripped >
> wrote:
>
> > Hi Suresh,
> >
> > > Can you paste the master the slave configuration file's here.
> > >Did you check that those two have different server-id's or same ?
> >
> > sure thing!
> >
> > Here's the master server-id : server-id=1
> > And here's the slave server-id: server-id=2
> >
> > They are without different.
> >
> > Here's the entire conf file for the master:
> >
> > [mysqld]
> > server-id=1
> > log-bin=mysqlmaster
> > datadir=/var/lib/mysql
> > socket=/var/lib/mysql/mysql.sock
> > user=mysql
> > # Disabling symbolic-links is recommended to prevent assorted security
> > risks
> > symbolic-links=0
> >
> > # To enable the InnoDB Plugin, uncomment the 2 next lines
> > #ignore-builtin-innodb
> > #plugin-load=innodb=ha_innodb_plugin.so
> >
> > # To enable InnoDB-related INFORMATION_SCHEMA tables
> > # Join the following options to above directive
> > ;innodb_trx=ha_innodb_plugin.so
> > ;innodb_locks=ha_innodb_plugin.so
> > ;innodb_cmp=ha_innodb_plugin.so
> > ;innodb_cmp_reset=ha_innodb_plugin.so
> > ;innodb_cmpmem=ha_innodb_plugin.so
> > ;innodb_cmpmem_reset=ha_innodb_plugin.so
> >
> > [mysqld_safe]
> > log-error=/var/log/mysqld.log
> > pid-file=/var/run/mysqld/mysqld.pid
> >
> > And here's the entire conf file for the slave
> >
> > [root@virtcent10:~] #cat /etc/my.cnf
> > [mysqld]
> > server-id=2
> > datadir=/var/lib/mysql
> > socket=/var/lib/mysql/mysql.sock
> > user=mysql
> > # Disabling symbolic-links is recommended to prevent assorted security
> > risks
> > symbolic-links=0
> >
> > # To enable the InnoDB Plugin, uncomment the 2 next lines
> > #ignore-builtin-innodb
> > #plugin-load=innodb=ha_innodb_plugin.so
> >
> > # To enable InnoDB-related INFORMATION_SCHEMA tables
> > # Join the following options to above directive
> > ;innodb_trx=ha_innodb_plugin.so
> > ;innodb_locks=ha_innodb_plugin.so
> > ;innodb_cmp=ha_innodb_plugin.so
> > ;innodb_cmp_reset=ha_innodb_plugin.so
> > ;innodb_cmpmem=ha_innodb_plugin.so
> > ;innodb_cmpmem_reset=ha_innodb_plugin.so
> >
> > [mysqld_safe]
> > log-error=/var/log/mysqld.log
> > pid-file=/var/run/mysqld/mysqld.pid
> >
> >
> > I hope this helps!! Still a bit stumped here.. :(
> >
> > thanks for your input!
> >
> > tim
> >
> > ----- Original Message -----
> > From: "Suresh Kuna" < sureshkumarilu@stripped >
> > To: "a smith" < a.smith@stripped >
> > Cc: "Tim Dunphy" < bluethundr@stripped >,
> replication@stripped
> > Sent: Friday, April 15, 2011 8:50:02 PM
> > Subject: Re: replication is not automatic
> >
> > Can you paste the master the slave configuration file's here.
> >
> > Did you check that those two have different server-id's or same ?
> >
> > On Fri, Apr 15, 2011 at 9:54 PM, < a.smith@stripped > wrote:
> >
> > > Quoting Tim Dunphy < bluethundr@stripped >:
> > >
> > > 110415 6:40:37 [ERROR] Slave I/O: error connecting to master
> > >
> > >> ' repl@stripped:0 ' - retry-time: 3306 retries:
> > 86400,
> > >> Error_code: 2013
> > >>
> > >
> > > This is on the slave right? ^^
> > > Do you have any firewalls that might be causing network connectivity
> > > issues?
> > >
> > > Also, does "show slave status" still not show any errors?
> > >
> > >
> > > ta Andy.
> > >
> > >
> > >
> > >
> > > --
> > > MySQL Replication Mailing List
> > > For list archives: http://lists.mysql.com/replication
> > > To unsubscribe:
> > > http://lists.mysql.com/replication?unsub=1
> > >
> > >
> >
> >
> > --
> > Thanks
> > Suresh Kuna
> > MySQL DBA
> >
>
>
>
> --
> Thanks
> Suresh Kuna
> MySQL DBA
>
>
>
> --
> Thanks
> Suresh Kuna
> MySQL DBA
>



-- 
Thanks
Suresh Kuna
MySQL DBA

Thread
replication is not automaticTim Dunphy13 Apr
  • Re: replication is not automatica.smith13 Apr
    • Re: replication is not automaticTim Dunphy15 Apr
      • Re: replication is not automatica.smith15 Apr
        • Re: replication is not automaticTim Dunphy15 Apr
          • Re: replication is not automatica.smith19 Apr
          • Re: replication is not automaticars k25 Apr
            • Re: replication is not automaticTim Dunphy4 May
        • Re: replication is not automaticSuresh Kuna16 Apr
          • Re: replication is not automaticTim Dunphy16 Apr
            • Re: replication is not automaticSuresh Kuna16 Apr
              • Re: replication is not automaticTim Dunphy16 Apr
                • Re: replication is not automaticSuresh Kuna16 Apr
                  • Re: replication is not automaticTim Dunphy16 Apr
                    • Re: replication is not automaticSuresh Kuna16 Apr