I had configured Mysql in a Master > Slave configuration from a tutorial on here, I have recently moved my backups from the Master to the slave because it was causing issues with the web application when it was backing up the database in the early hours of the morning. What I have realised though when it backs up the slave the amount of data each day is not increasing at all which is obviously not right but it says the replication is working and I can see it on the processlist on the master?
28970723 | replication | db02:34588 | NULL | Binlog Dump | 3067 | Has sent all binlog to slave; waiting for binlog to be updated | NULL
On the slave show slave status shows
show processlist on the slave shows
1004 | system user | | NULL | Connect | 241832 | Waiting for master to send event | NULL |
| 1005 | system user | | NULL | Connect | 3240 | Has read all relay log; waiting for the slave I/O thread to update it | NULL
Just doesn't show the host as DB01 its just blank on the slave