Category Archives: MySQL
MySQL load balancing with mylbhelper
A customer of ours was in this particular situation. They had a very decent hardware load balancer for their webservers with capacity to spare. So they ended up load balancing the mysql instances through the same device and using a piece of software I’ve written called mylbhelper.
Continue reading
Tool tip: mysqlsniffer
mysqlsniff is a tool that I find very useful and utilise a lot, but it doesn’t seem to be so widely known as it deserves to be. It’s pretty much general_log light without a restart! Continue reading
Wet dream finally coming through?
My major beef with it is that it’s not self-healing. Sure, you can monitor, script and re-jig things to a certain extent. But this is why I was thrilled when read the MySQL Forge suggestions for Google Summer of Code. One of the suggestions is to enable self-healing replication using components, or at least concepts, from maatkit and Google’s MMRM. Continue reading
paramy – import dumps in a flash
Basically it’s a multithreaded client. Most servers these days have, or certainly should have, multiple disks and multiple CPU cores and reasonably fast storage. So using a single threaded client to insert those hundreds of thousands or millions of records doesn’t make that much sense today. There’s quite a lot of time to save. I’ve ran some tests on MySQL 5.1.24 and compared the results with those from the stock mysql client.
InnoDB plugin compression with benchmarks
InnoDB Plugin compression levels and their performance examined. Continue reading