Archive for the ‘MySQL’ Category

Adding an ISCSI volume to the 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 setup of an iscsi volume on two nodes. The text in bold below represent commands to be executed in the shell. yum install iscsi-initiator-utils iscsiadm -m […]

Linux Cluster Node Configuration

Linux Node1 In VirtualBox, Node1 > Settings > Network. Adapters 1, 2 & 3 should be enabled and set to “Bridged Adapter”. Start the Linux VM to boot CentOS. Login as root. Execute the below command… ?View Code BASHifconfig -a | grep eth[0-9] You should see interfaces eth0, eth1 & eth2. Run the command system-config-network-tui […]

FreeNAS Configuration

This post is part of a series that will deal with setting up a MySQL shared storage cluster using VirtualBox & FreeNAS. This post deals with the configuration of FreeNAS. Fire up VirtualBox and go into FreeNAS > Settings > Storage. Add a SCSI controller with a single 2GB disk. Go to the Network settings […]

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.  

Aria Storage Engine Primer

I’m looking into HA MySQL at the moment. With these types of technologies you need to have a crash-safe storage engine in use. MyISAM just won’t cut it. While my long-term goal is to move to a fully-transactional storage engine, for example InnoDB, I’m looking at other possibilities. Changing to a fully-transactional storage engine may […]