Whether you are upgrading, decommissioning or putting your current master server in maintenance - here's a quick howto on promoting your slave server as new master for your application writes. This instructions (for my notes and the benefit of the...
In case you are upgrading to Fedora 16 and trying to use a software RAID for the /boot partition, at some point Anaconda is bound to complain that the RAID metadata version is invalid. Well this is a known bug and a workaround is available from this bug...
While working on a PHP script recently when I stumble upon a nasty bug that leaves only a "Segmentation fault" while preparing statements with Zend_Db_Adapter_Mysqli. Attempting to gdb the same process only results in gibberish like below and nothing...
When designing you backup strategy which involves using XtraBackup, it is often part of the job to be able to rotate backups not to fill the disks and not be able to take further backups. However, sometimes I've seen people how they can do this when...
err: Could not retrieve catalog from remote server: certificate verify failed
If you're new to puppet, this error is a bit tricky to identify. Even after recreating the certificates on the client the error still persist. If this is the case, most...
rdiff-backup is a great tool for mirroring or backing up files locally and between remote servers. It is based on rsync and works on top of SSH. To this note, I recently encountered one caveat when using the --user-mapping-file and --group-mapping-file...
Maatkit's mk-parallel-dump and mk-parallel-restore are great tools for quickly dumping and restoring your MySQL databases. I mean "quick" because it does this via user configurable number of threads. However, if you're new to the tools, you may encounter...
If you are migrating your cacti data and find that your graphs are not populating properly, try running poller.php with the --debug option.
Most probably, you will also need to run php cli/rebuild_poller_cache.php to make sure the poller picks up any...
If you think the below error is trivial, there might just be two possible causes.
ERROR 1467 (HY000) at line 1: Failed to read auto-increment value from storage engine
Your table's auto increment column datatype is too small i.e. MySQL is not able...
Recently I was playing around with the Maatkit tools specifically mk-parallel-dump and mk-parallel-restore for refreshing development database copies with production copies. A problem arises when BLOB data is being displayed on the console and...