Recently, I wanted to confirm that I was running the 64 bit version of the MySQL server as opposed to the 32 bit version… one of my admins had made a symlink from the mysql/bin directory to the 64 bit binary directory. On the command line, you could no longer tell if the mysqld…

If you’re like me, you love the granular permissions capabilities of MySQL but hate the work that goes into managing them…
Unfortunately, there doesn’t seem to be anything like groups in MySQL and according to plans won’t be added officially until MySQL 7.0 (WL#988)…
While searching around, I found Securich…

Reporting projects are the kind of projects which never seem to end. After a couple iterations I’ve come to the following conclusions: Absolutely no reports should run on a production database. Moving/aggregating data from a production database to a reporting database using ETL tools prone to synchronization issues and pretty unreliable. The best option…

I am a huge fan of Sun Microsystems.I love Solaris 10.I love ZFS.I love RBAC.I love zones.I really love T2/T2+ processors.I especially love the T5140 and X4450 servers. One thing I cannot figure out though, is why Sun lets obviously delirious cocaine addicts package their software. Maybe I’m exaggerating but I think that many…

I’m in the process of setting up a machine to host several SAMP (Solaris-Apache-MySQL-PHP) containers. I decided that it would be very efficient to create a generic zone and clone it over and over again. From reading up on the subject it seemed more than possible, after all, what is a zone besides a…