Over the past week or so I’ve ended up bookmarking a lot of links that I thought would make good blog posts. (All are technical in nature.) I haven’t had the time, so I’ll just post them here as bullet points with brief comments:
- I discovered the Prowl API today. It’s meant as a simple API for sending push notifications to iPhones. They call it Growl for the iPhone. And they have a lot of pre-written plugins, too. (Maybe Nagios can start sending Growl notifications instead of text messages!)
- If you’re doing much with MySQL, you really owe it to yourself to check out Maatkit. It’s a set of tools written by people who say “I really wish I could…” even more often than I do. Some highlights:
- Delayed replication. Set up a MySQL slave that runs an hour behind, and when you accidentally DROP DATABASE mission_critical, you’ve got an hour to STOP SLAVE and start recovery. (Sure, sure, you have backups. But having a live version in MySQL somewhere is extraordinarily handy, especially if you can just promote it to master for a while.)
- There’s really no easy way to show all grants in MySQL, and I know that I’m far from the only person peeved by this. mk-show-grants does exactly that.
- Some neat profilers on query stats and such.
- An equivalent to UNIX “find” exists, allowing you to search tables by various criteria. Doing it by disk usage (data and index, split as you wish) is something any DBA should do often. Why in the world do we have an archive table with indexes turned out?
- Xapbr builds on Maatkit a bit with this post on watching traffic via tcpdump instead of MySQL Proxy and showing errors; showing the queries with errors is just one idea.
- The one tool that doesn’t exist and I’ve always wanted is a “tail -f”, both on a table’s data (to see new rows of data as they’re added), and just on binlogs. There are a lot of situations where this would be an unmanageable amount of traffic
- Percona is probably a well-known name to anyone who does anything interesting with MySQL, but I have to admit that I hadn’t seen their Percona builds page before. They’ve added some nifty patches, and, because they’re totally awesome, released them under the GPL. (And I’m still eager to toy with XtraDB somewhere.)
- VeriSign (whose name is really too confusingly similar with Verizon) has announced that DNSSEC for the root zones and .com and .net is coming proceeding. (The ability to spoof DNS is kind of scary, largely because it’s so easy to go unnoticed. Your browser will legitimately show that it’s connected to “paypal.com” because it is, it’s just that the DNS server was tricked into giving some phisher’s IP instead of PayPal’s IP.)
- Link Roundup
- MySQL Replication
- Link Roundup
- Religion Roundup
- Hilarious Video Roundup