From the monthly archives: April 2008

MySQL Load Balancer

By On April 23, 2008 · 2 Comments

I’m not sure how I didn’t see this earlier, but it looks like MySQL 5.1 is coming with a load balancer for replicated servers. I’m absolutely pumped about this – we’ve got a few sites running with multiple db slaves and it’s so annoying having to check if they’re behind the master.

It looks [...]

Continue Reading →

PHP Warning: Memcache::set(): Failed to extract ‘connection’ variable

By On April 16, 2008 · 3 Comments

I got this today. Solved by restarting the Memcached server. Move along.

Edit: this is actually a reoccurring bug we’re seeing with the memcache 2.2.3 stable build on 2 different boxes
2nd Edit: Actually it was a bug in my code. I wasn’t setting the server and ip correctly, there was a typo in [...]

Continue Reading →

How curl_exec and urlencode killed my single sign on

By On April 16, 2008 · 1 Comment

If you do any work with single sign on, you’ll be familiar with the concept of exchanging tokens and validating against the authentication server using that token. One of the issues I’ve just run into which resulted in a huge headache is with urlencoding the result of a curl_exec that had a line ending. It’ [...]

Continue Reading →

Awesome Awk Tutorial

By On April 15, 2008 · Leave a Comment

This is exactly what I look for when I’m trying to find a tutorial. Thank you, Andrew M. Ross.

My favorite awk tutorial ever.

Continue Reading →

Decimal vs Float in MySQL

By On April 1, 2008 · 2 Comments

While I’ve known how floating points are stored, I didn’t know if decimal was stored any differently, or if it was more or less accurate. According to a post on the MySQL list:

Bruno Rodrigues Silva wrote:
> Dear all.
>
> The MySQL Manual inform that Decimal Data Type is [...]

Continue Reading →