Re: how to setup master, primary slave master and slaves

[Victor Matladi]

Master

*************************** 1. row ***************************
Id: 46
User: prod_replication
Host: 10.42.245.79:40819
db: NULL
Command: Binlog Dump
Time: 3227
State: Has sent all binlog to slave; waiting for binlog to be updated
Info: NULL
*************************** 2. row ***************************
Id: 47
User: root
Host: localhost
db: NULL
Command: Query
Time: 0
State: NULL
Info: show processlist
2 rows in set (0.00 sec)




for Slave

Id: 6
User: system user
Host:
db: NULL
Command: Connect
Time: 51803
State: Waiting for master to send event
Info: NULL
*************************** 2. row ***************************
Id: 7
User: system user
Host:
db: NULL
Command: Connect
Time: 1402
State: Has read all relay log; waiting for the slave I/O thread to update it
Info: NULL
*************************** 3. row ***************************
Id: 9
User: root
Host: localhost
db: mysql
Command: Sleep
Time: 1896
State:
Info: NULL
*************************** 4. row ***************************
Id: 10
User: root
Host: localhost
db: NULL
Command: Query
Time: 0
State: NULL
Info: show processlist
4 rows in set (0.01 sec)