Category Archives: MySQL

Upgrading MySQL on CentOS 6

Posted on January 21, 2016 by danmassey99

I’ve been migrating a web site from a community web server to a dedicated 30:30 server running CentOS, Apache, MySQL and PHP. The issue is that CentOS stopped updating MySQL at version 5.1 in the CentOS 6 track and the … Continue reading →

Posted in CentOS, MySQL | Leave a comment

MySQL ZFS snapshot restoration

Posted on October 16, 2013 by danmassey99

Since yesterdays test on ZFS snapshots, we now have 25 snapshots in the snapshot archive which can be seen below. # cd /DATA/mysql/.zfs/snapshot/ # ls -lah total 36 dr-xr-xr-x 21 root wheel 21B Oct 16 21:00 . dr-xr-xr-x 4 root … Continue reading →

Posted in FreeBSD Administration, MySQL, ZFS | Tagged , , , | Leave a comment

Using ZFS snapshots to keep MySQL backups

Posted on October 15, 2013 by danmassey99

Whilst at a customer site the other day the question was raised over how they could keep a fair volume of backups of a MySQL database off site, while minimising bandwidth and disk space. So the usual ‘moon on a … Continue reading →

Posted in FreeBSD Administration, MySQL, ZFS | Tagged , , , | Leave a comment

RT – starting from a ticket number larger than 1

Posted on April 23, 2013 by danmassey99

Ok, so not a request you would get every day, but when setting up our new RT (Request Tracker) server, we had a requirement to start at ticket number 200,000. This requirement was to ensure the new RT server’s tickets … Continue reading →

Posted in FreeBSD Administration, MySQL | Tagged , | Leave a comment

Using Dump and Restore to migrate FreeBSD to ESX server

Posted on October 24, 2012 by danmassey99

I’ve a number of  legacy machines which need virtualising with Vmware Vsphere5. Mainly they are old servers running software and websites that cannot be ported to modern OS’s and hardware. I thought to get the ball rolling, I’d migrate our … Continue reading →

Posted in FreeBSD Administration, MySQL | Tagged , , , , | Comments Off on Using Dump and Restore to migrate FreeBSD to ESX server

MySQL innodb buffer pool size issues

Posted on February 5, 2012 by danmassey99

I’m currently archiving some database records from our AVS logging platform. My previous technique was to rename the logging table and create a new one, leaving the renamed table to be cut up as required.  I had to do it … Continue reading →

Posted in FreeBSD Administration, MySQL | Tagged , , , , | Leave a comment

MIMEDefang – processing the valid users list ( filter_recipient() )

Posted on February 5, 2012 by danmassey99

I’m rebuilding our spam scanning platform at the moment and making some changes/improvements along the way. One of our issues was that we want to show customers ‘just how bad it is’ without spam scanning and so would like to … Continue reading →

Posted in FreeBSD Administration, MIMEDefang, MySQL, Perl | Tagged , , , , | Leave a comment

Sloppy File Handling – Perl

Posted on December 15, 2011 by danmassey99

When reading around the subject of file handling in Perl its easy to get sloppy, phrases like ‘automatic cleanup’ and the like lull us into believing that the close statement is just a ‘nice to have’. Well this burnt me … Continue reading →

Posted in FreeBSD Administration, MySQL, Perl | Tagged , , , | Leave a comment

Quick MySQL backups

Posted on November 10, 2011 by danmassey99

As a hosting provider we are often asked to provide a backup or dump of a mysql database. The easiest way to do it is to performa MySQLdump into a file into the webspace and the secure it with file … Continue reading →

Posted in Apache, FreeBSD Administration, MySQL | Tagged , , , | Leave a comment

Perl DBI MySQL failover databases

Posted on October 9, 2011 by danmassey99

Further to the last post on Eval, here is how we can try server A, then if it fails, use server B instead. The hub of the issue is ‘or die’ , ‘or warn’ and ‘or’. Here is my test … Continue reading →

Posted in MySQL, Perl | Tagged , , | Leave a comment