Linux, Apache, PHP, MySQL Musings
February 2, 2012 | In: Linux, MySQL
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...
November 24, 2011 | In: Backups, Linux, MySQL
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...
August 13, 2011 | In: MySQL, Solr
When using Solr DataImportHandler with MySQL, the JDBC connection treats TINYINT(1) columns as BOOLEAN even if you have other values greater than. Most likely with a properly defined field of int type on your schema.xml you will get an error while...
February 7, 2011 | In: Linux, MySQL, Perl
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...
November 24, 2010 | In: Linux, MySQL
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...
August 1, 2010 | In: BSD/Mac OSX, Linux, MySQL, Perl
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...
November 20, 2009 | In: BSD/Mac OSX, Linux, MySQL, Windows
I was reviewing a year old code which I am adding a feature to. It so happened I came to a familiar issue about having two timestamp/datetime columns, one which should have the CURRENT_DATE / NOW() as default value and the other with an 'ON UPDATE...
August 2, 2009 | In: Apache, Certifications, Linux, MySQL, PHP
I have been reading on a number of project management articles lately and trends on open source projects. There seems to be a lot of fellow PHP developers who are as well Linux administrators for many server functions inluding HTTP servers like Apache and...
May 20, 2009 | In: Apache, MySQL, PHP, Server Security
Hosting accounts being compromised has been a common incident, however a sudden surge of this variant is quite alarming. This trojan does not target any particular software or script and is commonly exploited from a users computer where he usually FTP...