Archive for the ‘Linux’ Category

Planning the cluster configuration

This post is part of a series that will deal with setting up a MySQL shared storage cluster using VirtualBox & FreeNAS. In this post we specify some brief details of the cluster configuration. Please note this post will be updated in the near future.  

Creating & Installing the CentOS cluster nodes.

This post is part of a series that will deal with setting up a MySQL shared storage cluster using VirtualBox & FreeNAS. In this post we deal with the installation of CentOS in VirtualBox. This post deals with the creation of two Linux servers hosted within VirtualBox. We will download an installer for CentOS, install […]

Installing & Configuring a MySQL shared-storage Cluster

This post is meant as a index of posts dealing with the installation of a shared-storage MySQL cluster running within VirtualBox. I’m learning this stuff too so don’t assume this is the reference implementation. Feel free to point out any issues, or provide recommendations, and I’ll update the post and give you credit. The software […]

Installing FreeNAS in VirtualBox on OpenSuSE

This post is part of a series that will deal with setting up a MySQL shared storage cluster using VirtualBox & FreeNAS. In this post we deal with the installation of VirtualBox & FreeNAS. Firstly we need to install VirtualBox and the VirtualBox-Qt front-end. ?View Code BASHsudo zypper install virtualbox sudo zypper install virtualbox-qt Add […]

Replace the Engine used in mysqldump

Just a little bash snippet to replace the ENGINE type used in a mysqldump. Slightly modified from this stackoverflow thread to perform the dump and replacement in a single step. To dump to a file… ?View Code BASHmysqldump -h hostname -u root -p –routines –databases db_name | sed -re ‘s/^(\) ENGINE=)MyISAM/\1TokuDB/gi’ > output.sql To copy […]