Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 23rd November 2012, 17:45
beenfishing beenfishing is offline
Member
 
Join Date: Jan 2010
Posts: 33
Thanks: 0
Thanked 2 Times in 2 Posts
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 23rd November 2012, 18:06
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,427
Thanks: 812
Thanked 5,206 Times in 4,082 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 23rd November 2012, 23:07
beenfishing beenfishing is offline
Member
 
Join Date: Jan 2010
Posts: 33
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Thank for your response but for some reason, all the mysql logs on my servers are empty, not sure why.
Reply With Quote
  #4  
Old 25th November 2012, 14:23
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,427
Thanks: 812
Thanked 5,206 Times in 4,082 Posts
 
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
amavisd not running fbnewtz General 1 16th November 2012 08:12
Sending mail ISPConfig 3 but not receivind catza Installation/Configuration 20 19th May 2010 12:47
MySQL problem satimis Server Operation 5 25th June 2008 15:41
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
Problem with keeping Apache alive bobeq Server Operation 3 29th November 2007 16:11


All times are GMT +2. The time now is 09:34.


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