Tag Archives: FreeBSD

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

Using MTM ITK for Apache

Posted on August 24, 2013 by danmassey99

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

Posted on January 18, 2013 by danmassey99

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

Posted on December 12, 2012 by danmassey99

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

Posted on November 19, 2012 by danmassey99

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

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

FreeBSD memstick – Creating a bootable install key on a Mac

Posted on September 24, 2012 by danmassey99

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

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

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

Posted on January 12, 2012 by danmassey99

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