HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=25)
-   -   MySql Multi server - Flush Hosts (http://www.howtoforge.com/forums/showthread.php?t=59675)

beenfishing 23rd November 2012 17:45

MySql Multi server - Flush Hosts
 
I have a multiserver setup and everything works perfectly. Every now and then I have to flush the mysql hosts on the main server in order for jobs to update on the others. I am having to do this more and more often as the amount of users on the server grows, sometimes 2 or 3 times a week.Is there a permanent solutions to this problem?

Any suggestions would be greatly appreciated.

Thanks

till 23rd November 2012 18:06

Flushing the mysql server on the master should not be nescessary at all, I never had to do this on the clusters that I manage for our customers. Take a look at the mysql logs and error counters on the master and check if enough connectuons are allowed or if you get connection errors.

beenfishing 23rd November 2012 23:07

Thank for your response but for some reason, all the mysql logs on my servers are empty, not sure why.

till 25th November 2012 14:23

You should be able to see the error counters in phpmyadmin. My guess is that one of your slaves uses a wrong password to connect to the master server e.g. in the vlogger configuration file and as mysql diconnects servers with too many failed logins, your slave will get disconnected after some time. If thats the ase, you should be able to see a higher number of false logins in the error counters in phpmyadmin.


All times are GMT +2. The time now is 15:46.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.