MySql Multi server - Flush Hosts

Discussion in 'General' started by beenfishing, Nov 23, 2012.

  1. beenfishing

    beenfishing New Member

    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.

  2. till

    till Super Moderator

    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.
  3. beenfishing

    beenfishing New Member

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

    till Super Moderator

    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.

Share This Page