aat2703 aat2703 - 1 year ago 145
MySQL Question

MySQL database replication not working - show processlist db is null

The replication between my 2 MySQL databases wont start the replication... I have a problem with the time that is in a different timezone than the other database server could it be the timezone difference?...

They both have different server ID's... I told the slave to look into the masters correct log position file...

I follow this thread: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql

Master DB: The master DB

Show processlist... The db says null?
enter image description here

Slave DB: The Slave DB

Answer Source

Sorry - It is working... I thought it did catch up with the current data in my database.... Of course it is only aware of whats in the log file! It is working!

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download