For those who don’t know me (mostly everybody who may read this), I am close to graduating from college, getting a full time job, and experiencing a decent amount of money for the first time. I have a rather unusual list of things that I’d like to acquire within my first few months. I doubt [...] [...more]
At some point in time I need to clone many of our databases over to another MySQL server. This will require locking all users out of our severs (Apache) so that none of the databases can be updated during the clone. Because this must be preformed in a very timely manner at a very untimely [...] [...more]
Today I set up some MySQL replication for a server that I set up a few weeks ago. This was my first time doing replication and it was quite a learning experience. This was using MySQL 5.0 and CentOS 5.3, but this should work for most semi-recent versions of both. In this setup, transactions are [...] [...more]
Imagine this: You are viewing the account information for a customer whom you are about to call. You see their phone number and you click it. Instantly, your phone on your desk starts to call that number. Today at work we decided it would be cool if we took advantage of our Cisco IP phones [...] [...more]
Today at work I had to pull a large set of data out of a database. The data needed to be displayed in a particular order by multiple fields/columns. Normally this is as simple as using ORDER BY column_name ASC, etc. However I needed to sort by ticket status IDs which were not in numerical [...] [...more]
