List:Replication« Previous MessageNext Message »
From:Suresh Kuna Date:April 16 2011 4:54am
Subject:Re: replication is not automatic
View as plain text  
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

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