Tag Archives: FreeBSD

MySQL ZFS snapshot restoration

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

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

Using MTM ITK for Apache

I needed to secure websites on a FreeBSD server to stop ‘cross site contamination’, i.e. stopping virtualhost #1 modifying/reading data within virtualhost #2. In FreeBSD the solution (or at least one solution) appears to be apache22-itk-mpm. Step 1. Install the port … Continue reading

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

FreeBSD and RIP – solving MPLS VPN routing issue

Working on a network consultancy project with a customer to monitor remote sites in a part MPLS VPN/ part IPSec VPN was presenting problems for the Nagios server in our data centre.  below is a basic overview of the network. … Continue reading

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

Autossh and Cloud Backup Appliance

Part of the Cloud Backup solution was to add a client site appliance which would ‘stage’ the backup prior to them being moved off site to the replication servers. The software we use for this product requires a local copy … Continue reading

Posted in FreeBSD Administration | Tagged , | Leave a comment

Creating FTP Accounts on ZFS space with quotas

As part of the Gconnect 30:30 server product, I need to create a 10GB FTP store for each server. Its part of the deal so customers can use it either for backup, if they don’t want the server image backups … Continue reading

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

Using Dump and Restore to migrate FreeBSD to ESX server

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

FreeBSD memstick – Creating a bootable install key on a Mac

I dont make boot keys very often, an seem to have to ‘re-learn’ every time its needed. Hopefully writing it down like this will commit it to memory! So first take the USB key of choice and plug it into … Continue reading

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

MySQL innodb buffer pool size issues

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

FreeBSD8.2 to FreeBSD9.0 upgrade – ssh key issue

Well in a desperate attempt to get ahead of the curve, I decided to update to FreeBSD 9.0 RELEASE before I put my new mailout servers into production. All has gone well except that on boot I get the following … Continue reading

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