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]
In further effort to learn how to do things the most complicated way possible on Linux, I wanted to be able to access my Gmail account when using SSH to log onto my computer from anywhere. First Method: Using Lynx The first method I thought of to access my Gmail was to use Lynx, a [...] [...more]
Today I tried to install Ubuntu 9.04 (Jaunty Jackalope) on a rack server at work that did not have a CD drive. The easiest thing to do was to use an external USB CD drive. Unfortunately I was getting an error once Ubuntu started loading: Buffer I/O error on device sr0, logical block xxxxxx end_request: [...] [...more]
