MySQL’s max_connect_errors … 6 years later…

Having recently been bitten by the awful default value (10) for max_connect_errors on a production server - I'm having a very hard time coming to terms with who the heck thought this would be a good way to do it. This type of "feature" allows you to effecitvely DOS yourself quickly...
Read More

Using Logstash to log SMTP/email bounces like a boss

I've recently worked on a customized emailing suite for a client that involves bulk email (shutter) and thought I'd do a write up on a few things that I thought were slick. Originally we decided to use AWS SES but were quickly kicked off of the service because my client doesn't...
Read More

PHP 5.5 RC1 released – what I’m most excited for..

Where I work we have unfortunately had to skip the 5.4 release of PHP; the release cycle between PHP 5.4 and PHP 5.5 was pretty darn fast and we never got around to replacing APC. We've finally got everything up to speed to adopt 5.5 when it hit's stable release. I...
Read More

A safer approach to using Monolog’s SocketHandler

Monolog is perhaps the most popular logging library out there for PHP at the time of this writing. It has a lot of support and a nice balance of features. Unfortunately I have one gripe to make about the rather closed implementation of the SocketHandler , er, handler?   The problem with the...
Read More

My Google exit strategy

I've been saying this for a long time now, Google can't be trusted. I think it's becoming commonplace in other blogs to start talking about having an exit strategy. I've been planning for a while (starting with the removal of my blog from blogspot). The Google products I've unfortunately come to...
Read More

MySQL command line – zebra stripe admin tool

I came up with a cool usage for the zebra stripe admin tool.  In MySQL you can set a custom pager for your MySQL CLI output; so one can simply set it to the zebra stripe tool and get the benefit of alternated rows for better visual clarity. Something like 'PAGER...
Read More

Atlassian Fisheye starter license and 10 commiter limit

The problem with Atlassian Fisheye starter license: I love using Atlassian Fisheye at work. It's a very nice frill to have for a small team especially since it saves us time and adds a very easy, fast way to document the reviews and be open about feedback. I have one gripe however;...
Read More

pt-online-schema-change and partitions – a word of caution

Just a quick word of wisdom to those seeking to cleverly change the partitioning on a live table using a tool like pt-online-schema-change from the Percona Toolkit. You will lose data if you don't account for ALL of your data's ranges upfront. (E.g: MAXVALUE oriented partition). The reason being is how...
Read More

PHP: array_merge(array $a, [ array …]);

Wait, PHP wants to array_merge an array with... itself? Take another look at this: array_merge(array $a, [ array ...]); If you're good at reading API's - you'll see how ... odd this is. Seeing as I just got nipped in the butt by forgetting to have another array to merge into -...
Read More

Java – What do you want from me!?

But.... Chances are; it's firefox; but I have the plugin disabled......
Read More

Re: Linux and hardware support – specifically Graphics and lack thereof

The passion here says enough: (Linus gives NVidia a what for) Edit: Apparently embedded view won't handle the timestamp I used - skip to 49m 10s http://www.youtube.com/watch?v=MShbP3OpASA&t49m10s...
Read More

JQuery – Sparkline: Re-draw on resize / responsive sparklines

I've been suckered in by the awesome JQuery Sparkline plugin - I won't go over how it works or what it does, but rather a quick 'fix' for fixing issues with how the output deals with browser resizing. (Long story short, it doesn't by default). Here's a visual of the issue...
Read More

Migrating from Blogger (Google) to WordPress

With the sketchy nature of Google, I'm starting to decrease as many dependencies as I can from them. Starting with my blog. A part of it is just a technical test to find out how hard it would be to wean off of the free service. Overall, there's few - if...
Read More

Why Rackspace is bad!

Fanatical support != Customer service, at all! Recently I've migrated a customer that's been on Rackspace for 6 years, and paying a handsome penny for it at that. The migration was to Amazon Web Services (AWS) and I sent a friendly reminder to the client to cancel the RS account (9...
Read More

Why are we spending so much time refuting?

There's a nice juicy war going on in the 'data / web' sector, that seems more heated than I can remember. It essentially boils down to sensationalist claims from the likes of MongoDB and MemSQL, which in turn draw refuting remarks from industry professionals that are typically embedded with RDBMS technologies. The...
Read More

Say goodbye to iGoogle. Boo!

In a clear effort to push Android and Chrome, Google is discontinuing iGoogle Nov, 2013.This announcement comes as an early 4th of July surprise from Google. It's getting really hard to trust Google with how they bait and switch, and kill projects I know are more popular than they even...
Read More

Worthy of distribution: Your cell phone records

This is just too cool, and too perfect a testament for how you can derive a lot through data and social networking.Via the F-Secure labs blog: http://www.zeit.de/datenschutz/malte-spitz-data-retentionShows an extremely well put together example of combining a tidbit of privileged information with social networking and how this truly is a brave...
Read More

MySQL CPU maxing out due to leap second, and AWS US-E1 outage

Wow, US-EAST-1 has the worst luck doesn't it?I had CPU consumption alerts fire off for ALL of my AWS instances running Percona Server (MySQL).I couldn't for the life of me figure it out - I re-mounted all but the root EBS volumes, restarted the services and ensured there was no...
Read More

MySQL COALESCE(), UNION behavior on zerofilled columns

I've just filed a (potential) bug report, depending on your views for MySQL's COALESCE() behavior: http://bugs.mysql.com/bug.php?id=65763 If you have a zerofill column and perform the COALESCE() function on it, the leading zeros are truncated. As I mention in the bug report, this may not matter to most - but it does change the...
Read More

On MySQL: The latest, far-reaching password circumvention

By now, everyone has, or will be hearing about this issue. While it's an extremely simple hack and covers (dare I say the majority) of MySQL installation version. Let's not forget to finish reading the entire disclosure: From the disclosure: But practically it's better than it looks - many MySQL/MariaDB builds are not...
Read More