aat2703 aat2703 - 1 month ago 19
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

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!

Comments