Below are instructions on how to install configure a Percona DB Cluster on Ubuntu (14.04 at time of writing this).

*Carry out on all nodes (servers)

Remove apparmor as it prevents cluster nodes talking to each other:

sudo /etc/init.d/apparmor stop
sudo update-rc.d -f apparmor remove
sudo apt-get remove apparmor apparmor-utils -y

Disable SELinux by editing /etc/selinux/config and add/alter line to disable it:

SELINUX=disabled

Add the following keys to the repository:

apt-key adv –keyserver keys.gnupg.net –recv-keys 1C4CBDCDCD2EFD2A

Add Percona sources:

vim /etc/apt/sources.list
deb http://repo.percona.com/apt trusty main
deb-src http://repo.percona.com/apt trusty main

Generate auth keys:

ssh-keygen -t rsa

Copy public key (id_rsa.pub) to destination server:

ssh-copy-id root@10.10.10.10

*Or manually insert key from id_rsa.pub (host) into /root/.ssh/authorized_keys (destination)

Now try shelling from the host machine to the destination e.g.

ssh root@10.10.10.10

You shouldn’t be asked for a password and dropped straight into the server.

Find the drive name:

fdisk -l

*In this example we will use /dev/sdc

Now access parted to prepare the drive for formatting and mounting:

sudo parted /dev/sdc

Now set the following:

(parted) mklabel gpt
(parted) unit TB
(parted) mkpart primary 0.00TB 4.00TB (Changing 4.00TB to the size of your drive)
(parted) quit

If like me you have issues with a blog duplicating/stealing your blog posts and the following to your WordPress theme’s functions.php (Appearance > Editor):

remove_action('do_feed_rdf', 'do_feed_rdf', 10, 1);
remove_action('do_feed_rss', 'do_feed_rss', 10, 1);
remove_action('do_feed_rss2', 'do_feed_rss2', 10, 1);
remove_action('do_feed_atom', 'do_feed_atom', 10, 1);

This disables the /feed form your website and hopefully stops content being duplicated by other ‘bloggers’ through a plugin.

You can also ask Google to remove the URLs from searches if a copyright infringement here:

http://www.google.com/webmasters/tools/dmca-notice?rd=1

Place the following script in a directory of your choice:

#<?bash
#!/bin/bash
#
# #automysqlcheck.sh
#
# This is a small bash script that checks all mysql databases for errors
# and mails a log file to a specified email address. All variables are
# hardcoded for ease of use with cron. Any databases you wish not to check
# should be added to the DBEXCLUDE list, with a space in between each name.
#
# Note that DBEXCLUDE will only work with GNU sed, as BSD regular expressions
# on Darwin seem to have some trouble with word boundary anchors.
#
# original version by sbray@csc.uvic.ca, UVic Fine Arts 2004
#
# modified by eyechart AT gmail.com (see Change Log for details)
#
# Some of this code was inspired from automysqlbackup.sh.2.0
# http://sourceforge.net/projects/automysqlbackup/
#
#=====================================================================
# Change Log
#=====================================================================
#
# VER 1.1 - (2005-02-22)
# Named script automysqlcheck.sh
# Added PATH variable to make this script more CRON friendly
# Removed the $DBTABLES loop and replaced it with single command
# that executes the CHECK TABLE command on all tables in a given DB
# Changed code to only check MyISAM and InnoDB tables
# Cleaned up output to make the email prettier
# Modified script to skip databases that have no tables
# VER 1 - (2004-09-24)
# Initial release by sbray@csc.uvic.ca
# system variables (change these according to your system)
PATH=/usr/local/bin:/usr/bin:/bin:$PATH
USER=username
PASSWORD=password
DBHOST=localhost
LOGFILE=/var/log/automysqlcheck.log
MAILTO=email@domain.com
TYPE1= # extra params to CHECK_TABLE e.g. FAST
TYPE2=
CORRUPT=no # start by assuming no corruption
DBNAMES="all" # or a list delimited by space
DBEXCLUDE="" # or a list delimited by space

# I/O redirection...
touch $LOGFILE
exec 6>&1
exec > $LOGFILE # stdout redirected to $LOGFILE

echo -n "AutoMySQLCheck: "
date
echo "---------------------------------------------------------"; echo; echo

# Get our list of databases to check...
# NOTE: the DBEXCLUDE feature seemed to only work with Linux regex, GNU sed
if test $DBNAMES = "all" ; then
DBNAMES="`mysql --user=$USER --password=$PASSWORD --batch -N -e "show databases"`"
for i in $DBEXCLUDE
do
DBNAMES=`echo $DBNAMES | sed "s/\b$i\b//g"`
done
fi

# Run through each database and execute our CHECK TABLE command for all tables
# in a single pass - eyechart
for i in $DBNAMES
do
# echo the database we are working on
echo "Database being checked:"
echo -n "SHOW DATABASES LIKE '$i'" | mysql -t -u$USER -p$PASSWORD $i; echo

# Check all tables in one pass, instead of a loop
# Use GAWK to put in comma separators, use SED to remove trailing comma
# Modified to only check MyISAM or InnoDB tables - eyechart
DBTABLES="`mysql --user=$USER --password=$PASSWORD $i --batch -N -e "show table status;" \
| gawk 'BEGIN {ORS=", " } $2 == "MyISAM" || $2 == "InnoDB"{print $1}' | sed 's/, $//'`"

# Output in table form using -t option
if [ ! "$DBTABLES" ]
then
echo "NOTE: There are no tables to check in the $i database - skipping..."; echo; echo
else
echo "CHECK TABLE $DBTABLES $TYPE1 $TYPE2" | mysql -t -u$USER -p$PASSWORD $i; echo; echo
fi
done

exec 1>&6 6>&- # Restore stdout and close file descriptor #6

# test our logfile for corruption in the database...
for i in `cat $LOGFILE`
do
if test $i = "warning" ; then
CORRUPT=yes
elif test $i = "error" ; then
CORRUPT=yes
fi
done

# Send off our results...
if test $CORRUPT = "yes" ; then
cat $LOGFILE | mail -s "MySQL CHECK Log [ERROR FOUND] for $DBHOST-`date`" $MAILTO
else
cat $LOGFILE | mail -s "MySQL CHECK Log [PASSED OK] for $HOST-`date`" $MAILTO
fi
#?>

*Make sure to update user, password, dbhost, log file location and DBNAMES/DBEXCLUE with your own details.

Now make the script executable (chmod +x scriptname.sh) and add a cronjob to run when required e.g.

01 20 * * * /home/user/bin/mysqlcheckscript.sh

*cron will run at 1.20am everyday.