admin

MySQL scaling: query snipers

  • Post author:
  • Post category:Mysql

I've been wanting a query sniper for a while for MySQL (some people seem to call them "query killers"). They're basically programs which inspect the MySQL "show processlist" command and decide to kill some processes if they violate specified rules. I have a prototype of one in python, and couldn't find any other implementations until tonight when I came across Querybane, which is what Wikipedia use to do exactly the same thing. Now, I need to think further about if querybane does what I want, especially given I can't find the source code. Perhaps it's hidden in the media wiki code somewhere? The only code for a project named "servmon" (it's parent project) that I can find is four years old and in PHP. (Oh, by the way, the Wikipedia MySQL docs are really interesting, for example this page has some nice practical advice about replication log corruption. I wish I had found this before now for two reasons: it's nice to see how other people do this stuff; and there is some stuff I can totally steal from here.) So, does anyone know where I can find recent querybane code? Alternatively, what do other people use as a query…

Continue ReadingMySQL scaling: query snipers

clusterssh

For reasons which might be fairly obvious, I've been doing a lot of repetitive sshing to machines recently (think executing the same upgrade on four mail servers for instance). I pondered aloud in the cube the possibility of an application which would give me a dialog to type in, and then wack that text into a bunch of xterms all at the same time for me. Andrew did some Debian foo and suddenly cluster ssh is presented as an option. It's pretty cool, and basically does exactly what I wanted. It's not perfect though -- some people have complained that it uses gnome-terminal, and about the fonts of all things. I've noticed some odd behaviour if you try to cut and paste into the gnome-terminal as well (instead of the text entry dialog). Interesting, I think it might be time for me and the cluster ssh code to become acquainted sometime.

Continue Readingclusterssh

End of content

No more pages to load