Tag Archives: MySQL

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

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

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

Quick MySQL Server setup notes

Posted on September 5, 2011 by danmassey99

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