docker-mysql-master-slave icon indicating copy to clipboard operation
docker-mysql-master-slave copied to clipboard

Published 20 hours ago • verified publisher icon vbabak

mysql5.7

Open andyge2014 opened this issue 2 years ago • 1 comments

Hi, I had a situation. Printf Error logs when run build.sh.

Creating mysql_master ... done Creating mysql_slave ... done ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Waiting for mysql_master database connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Thanks for your help.

andyge2014 avatar Sep 16 '22 09:09 andyge2014

Hi, @andyge2014. Just wanted to know if you waited for a while, as it takes some time for the master node to start and the slave node to connect to the master node.

While the master is starting it could be possible the slave node has started and tries connecting to the master node, printing the above error.

I strongly suggest you wait for a while as it may take some time for the containers to get started based on the system configuration. As from the below screenshot, it took me around 1-2 min for the service to start on an Intel I5 - 5th Gen with HDD. Screenshot from 2022-09-18 11-02-24

I have added a health check in PR #7 for the master node and updated the slave to start only after the master node is healthy, which would eliminate the above error.

sarbesh avatar Sep 18 '22 05:09 sarbesh