Replication Setup Not Working
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
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.