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

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