Well, ,the reason we dont have it update from the logins is because the login servers only have read access to the tables & columns they need (We do this for security). Each login has a different database login with the same rights, except for the login server that writes to the stats table.
I have noticed that if the logins do get disconnected from the mysql server for any reason (it be network congestion or whatever), they wont turn back into write mode (a good example of this is when the stats login gets disconnected from the main mysql server for any reason. It wont update stats until it is bounced).
Would you guys rather have it done in an automated way? (it might cause us to have to restart logins more than they get restarted now, which means server lists out of sync for a few moments sometimes).
|
Threaded Mode
