- 论坛徽章:
- 0
|
如何实现mysql主从同步,我需要在两天更新一次
show master status
是空的
show slave status如下:
| 192.168.1.224 | root | 3306 | 60 |
4 | asustemp-relay-bin.018 | 4 |
| No | Yes | backup |
| 0 | | 0 | 0 | 0
slave机子上show processlist
--------------------+------------------+
| 10007 | root | 127.0.0.1:2255 | backup | Killed | 3681 |
| NULL |
| 19918 | root | 127.0.0.1:4258 | backup | Sleep | 3587 |
| NULL |
| 19919 | root | 127.0.0.1:4259 | backup | Sleep | 3587 |
| NULL |
| 20010 | root | 127.0.0.1:4350 | backup | Sleep | 3586 |
| NULL |
| 20015 | system user | | NULL | Connect | 2125 | Slave: waiting for binlog update | NULL |
| 20020 | root | 127.0.0.1:4614 | NULL | Query | 0 | NULL
| show processlist |
master机子上show processlist
'15','root','ASUSTEMP:3064','backup','Sleep','787','',[NULL]
'17','root','127.0.0.1:2654',[NULL],'Sleep','3006','',[NULL]
'24','root','ASUSTEMP:4637',[NULL],'Query','0',[NULL],'show processlist' |
|