MySQL Forums
Forum List  »  Replication

Replication Setup Not Working
Posted by: Kevin Waterson
Date: February 24, 2014 10:26PM

I am trying to set up some replication. the story so far..
GRANT REPLICATION SLAVE ON *.* TO 'replicator'@'%' IDENTIFIED BY 'eV4ng311C4L';
Query OK, 0 rows affected (0.00 sec)

FLUSH TABLES WITH READ LOCK;

SHOW MASTER STATUS;

and on slave...
STOP SLAVE;
CHANGE MASTER TO MASTER_HOST = '10.0.2.38', MASTER_USER = 'replicator', MASTER_PASSWORD = 'my_password', MASTER_LOG_FILE = 'mysql-bin.000004', MASTER_LOG_POS =1782;

Back to master and...
UNLOCK TABLES;
Query OK, 0 rows affected (0.00 sec)

And on slave

START SLAVE;

SHOW FULL PROCESSLIST;

+-----+-------------+-----------+------+---------+------+-----------------------------------------------------------------------------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+-------------+-----------+------+---------+------+-----------------------------------------------------------------------------+-----------------------+
| 234 | root | localhost | NULL | Query | 0 | NULL | SHOW FULL PROCESSLIST |
| 243 | system user | | NULL | Connect | 84 | Waiting for master to send event | NULL |
| 244 | system user | | NULL | Connect | 84 | Slave has read all relay log; waiting for the slave I/O thread to update it | NULL |
+-----+-------------+-----------+------+---------+------+-----------------------------------------------------------------------------+-----------------------+

> SHOW SLAVE STATUS\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.0.2.38
Master_User: replicator
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000004
Read_Master_Log_Pos: 1782
Relay_Log_File: mysqld-relay-bin.000002
Relay_Log_Pos: 253
Relay_Master_Log_File: mysql-bin.000004
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 1782
Relay_Log_Space: 410
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
1 row in set (0.00 sec)


How many things am I doing wrong here?

Kind regards
Kevin

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication Setup Not Working
2306
February 24, 2014 10:26PM
743
March 05, 2014 11:09PM


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.