Archive for April, 2008

MySQL Load Balancer

Wednesday, April 23rd, 2008

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 ...

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

Wednesday, April 16th, 2008

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, ...

How curl_exec and urlencode killed my single sign on

Wednesday, April 16th, 2008

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 ...

Awesome Awk Tutorial

Tuesday, April 15th, 2008

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.

Decimal vs Float in MySQL

Tuesday, April 1st, 2008

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 used > ...