Posts Tagged ‘mysql’

MySQL To Percona Server Gottcha

Decided to replace the aging MySQL 5.1.x on a CentOS Box with a newer Percona Server 5.6. First step was to update MySQL 5.1 to 5.5. This went relatively smoothly after I figured out some mySQL transaction kung-fu and ran mysql_upgrade. Step two was to replace it with Percona Server. It installed fine. Almost to […]

MySQL Going Closed Source

I was a little concerned when MySQL AB was purchased by Sun, however Sun had a pretty long history with open source and mostly seemed to know how to balance things. When Sun was purchased by Oracle, I was quite uneasy knowing Oracle has a way of killing everything that isn’t Oracle. Seems like that […]

DBSlayer + Node.js

Lately it seems the rage among developers is to take node.js and combine it with something else unusual. So here’s my contribution. DBSlayer is a project by NYTimes a few years ago that seems to be somewhat forgotten but is pretty cool. It’s another MySQL proxy, but with a slight twist. Rather than use a […]

MySQL Staying Open

Sun was initially thinking of a commercial fork for MySQL with some enhanced things like encryption and compression backup for commercial users. Obviously this created some outcry. It appears they’ve now reconsidered and those features will be open source. To quote Kaj Arnö: …expect Sun/MySQL to continue experimenting with the business model, and with what’s […]

Summer Of Code 2008

Google announced the project lists for Summer Of Code 2008. Some of the more interesting projects from my perspective: Adium Data Detectors for Adium Dojo Foundation Native cryptography API for Google Gears Dojo-Charting improvements Dojo GFX Enhancement FFmpeg AAC-LC Encoder MLP/TrueHD encoder Apple Lossless Encoder for FFmpeg Gallery Facebook / Flickr Style Image Region Based […]

Getting A Random Row In MySQL

This is a great page on RAND() in MySQL. Very nice breakdown of how to gain performance with one of the biggest “it should be simple but it isn’t” problems in DBMS’s.

MySQL bustage

So my dev instance of MySQL crashed with some InnoDB corruption (as in service won’t even start). Still no idea exactly what caused it, but I don’t really care. The only database using InnoDB wasn’t anything I actually used, just junk that should have been cleaned up anyway. The downside is that I couldn’t even […]

PHP 5.0 is Released!

The PHP development team is proud to announce the official release of PHP 5. Some of the key features of PHP 5 include: The Zend Engine II with a new object model and dozens of new features. XML support has been completely redone in PHP 5, all extensions are now focused around the excellent libxml2 […]

Blog finally up and running

Due to a server move at the end of April/early May, the blog was broke due to an inconsistency between the version of Berkley DB on the old and new host. Now running on mySQL, it’s back up and running!