Re: how to setup master, primary slave master and slaves
M- status
mysql> show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000010 | 550 | | |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
R-slave status
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.0.0.0.2
Master_User: prod_replication
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000010
Read_Master_Log_Pos: 550
Relay_Log_File: kccpreodb02-relay-bin.000008
Relay_Log_Pos: 235
Relay_Master_Log_File: mysql-bin.000010
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: 550
Relay_Log_Space: 235
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
1 row in set (0.00 sec)
R-master status
mysql> show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000026 | 29973484 | | |
+------------------+----------+--------------+------------------+
S- slave status
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.0.0.0.3
Master_User: prod_replication
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000026
Read_Master_Log_Pos: 29973484
Relay_Log_File: kcc_delllap-relay-bin.000005
Relay_Log_Pos: 235
Relay_Master_Log_File: mysql-bin.000026
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: 29973484
Relay_Log_Space: 235
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
1 row in set (0.00 sec)
Subject
Views
Written By
Posted
3877
September 10, 2010 03:36AM
1501
September 12, 2010 12:45PM
988
September 13, 2010 01:22AM
1337
September 13, 2010 10:44AM
1363
September 14, 2010 02:15AM
1056
September 14, 2010 07:51AM
Re: how to setup master, primary slave master and slaves
1181
September 14, 2010 08:47AM
1019
September 14, 2010 08:16PM
1014
September 15, 2010 12:53AM
1045
September 15, 2010 06:03AM
851
September 15, 2010 07:48AM
987
September 15, 2010 08:40AM
1094
September 15, 2010 08:56AM
957
September 15, 2010 09:25PM
978
September 16, 2010 02:15AM
1017
September 16, 2010 02:45PM
1213
September 16, 2010 09:07PM
956
September 18, 2010 08:27PM
1148
September 18, 2010 09:53PM
1066
September 22, 2010 06:15AM
943
September 22, 2010 07:38PM
892
September 27, 2010 07:38AM
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.