Archive for the ‘MySQL’ Category

Bash script to execute a MariaDB query multiple times

This simple bash script will execute a query 100 times against a MySQL instance. It also uses the time command to report how long the entire process took. I use this for some very simple bench-marking. The query used here creates a temporary table and inserts 100K rows into it. You need the sequence engine […]

Adding ISCSI volumes 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 2GB disk. Added a second disk 1GB in […]

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.