Open Query blog

See the OurDelta blog for details of this release. RHEL/CentOS packages also coming.

Filed under: Software and tools | by arjen Social tagging: mariadb > mysql > Open Query > ourdelta > pbxt > xtradb
No Comments »

This Thursday (October 22nd, 13:00 UTC), Walter Heck (of Open Query) will present Dual Master Setups With MMM. MMM (Multi-Master Replication Manager for MySQL) is a set of flexible scripts to perform monitoring/failover and management of MySQL master-master replication configurations (with only one node writable at any time). Session slides (PDF).
The toolset also has the [...]

Filed under: Software and tools | by walter Social tagging: dual master > failover > loadbalancing > mmm > multi-master > mysql > MySQL University > Open Query > replication > Walter Heck
No Comments »

rsnapshot is a filesystem snapshot utility for making backups of local and remote systems, based on rsync. Rather than just doing a complete copy every time, it uses hardlinks to create incrementals (which are from a local perspective a full backup also). You can specify how long to keep old backups, and all the other [...]

Filed under: Software and tools | by arjen Social tagging: backup > InnoDB > mysql > open query > recovery > restore > rsnapshot > rsync > xtrabackup
3 Comments »

We often need many tabs open in a browser, and horizontal tabs become unmanageable. Tab Kit allows you to have them vertically on the left, with various additional configuration choices.
I opted for the tree structure, so when I open a tab from another one it’ll show up as a child to the original. I can [...]

Filed under: Software and tools | by arjen Social tagging: add-on > extension > firefox > mysql > open query > tabkit
No Comments »

Only the other day I was talking with someone who does a lot of work on the shell command line, but hadn’t used the GNU screen tool, so I’d better scribble a post about it as I regard it as an absolute must-have for any remote work, for multiple reasons.
First of all, what screen does. You [...]

Filed under: Software and tools | by arjen Social tagging: dba > mysql > Open Query > remote > screen > ssh > tools
4 Comments »

I was actually exploring inotify-tools for something else, but they can also be handy for seeing what goes on below a mysqld process. inotify hooks into the filesystem handlers, and sees which files are accessed. You can then set triggers, or just display a tally over a certain period.
It has been a standard Linux kernel [...]

Filed under: Software and tools | by arjen Social tagging: analysis > inotify > inotify-tools > linux > monitoring > mysql > mysql server > mysqld > open query > tools
1 Comment »

While doing some work for the MySQL MMM project, I got distracted and browsed around for a bit. I started searching for MySQL on google code, and then expanded that search into launchpad, sourceforge and of course forge.mysql.com.
I found that there are literally thousands of FOSS MySQL projects on these sites. No surprise really, but [...]

Filed under: Software and tools | by walter Social tagging: forge.mysql.com > FOSS Projects > google code > launchpad > mysql > sourceforge
1 Comment »

A post by Ronald reminded me I wanted to write about watch. The Linux watch command is a fab tool, it allows you to run a program at a set interval, such as every 5 seconds. Handy for keeping an eye on stuff!
Update 2009-06-30: yesterday I wrote “… watch does not re-load and run the program, [...]

Filed under: Software and tools | by arjen Social tagging: mysql > tools > watch
8 Comments »

I’m decently familiar with grep so I can usually make it do what I want. I frequently need to search for instance MySQL source code for certain pattern strings, and this makes life so much easier. But Akash pointed out ack to me, which has the specific tagline “better than grep” (has the domain even) and I [...]

Filed under: Software and tools | by arjen Social tagging: ack > grep > tool > tools
2 Comments »