The first few days after setting up MySQL replication, I noticed that one small error would stop the replication. When this went production, we couldn’t afford to have the replication stop and not know about it. We can’t log into all our servers and check the status of things on a daily basis, we want [...] [...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]
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]
