MySQL Forums
Forum List  »  Replication

Master Slave replication
Posted by: Prasanna Ravi
Date: July 14, 2011 12:12PM

Hi,
I am a Oracle DBA but new to MySQL and trying to set up a master slave replication in our staging environment. I have followed all the steps per the document but I still get the below error when checking for slave status. In master, the status shows empty. Mysql v 5.0.77 (open source version). Any help on this is much appreciated.

ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO


Master:

my.cnf

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-bin = /var/lib/pci_stg/pci_stg-bin.log
binlog-do-db=pci_stg
server-id=1
==

mysql> GRANT REPLICATION SLAVE ON *.* to 'ftpci'@'%' ;
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT RELOAD ON *.* TO 'ftpci'@'%';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT SUPER ON *.* TO 'ftpci'@'%';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> use pci_stg
Database changed
mysql> FLUSH TABLES WITH READ LOCK;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW MASTER STATUS;
Empty set (0.00 sec)

===

Slave:

my.cnf
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

server-id=2
master-host = 'sol11.mes1'
master-user = 'ftpci'
master-password = 'pubRet3Eh88t'
master-port = '3306'
master-connect-retry=60
replicate-do-db=mysql

mysql> SLAVE START;
ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO

Thanks,
Prasanna

Options: ReplyQuote


Subject
Views
Written By
Posted
Master Slave replication
11800
July 14, 2011 12:12PM
2410
July 17, 2011 01:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.