Tag Archives: MySQL

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

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

Sloppy File Handling – Perl

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

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

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

Quick MySQL Server setup notes

Here are my quick and dirty setup notes for MySQL server cd /usr/ports/databases/mysql51-server make install ee /etc/rc.conf add –/– mysql_enable=”YES” mysql_dbdir=”/data/mysql” –/– /usr/local/etc/rc.d/mysql-server start Now we need to add a password to secure it and another password for remote admin: … Continue reading

Posted in FreeBSD Administration | Tagged | Leave a comment