Install Galera Load Balancer on This Running MariaDB Galera Cluster

Run the mysql_secure_installation script using the provided lab credentials:

sudo mysql_secure_installation

Configure the following settings:

• Enter current password for root (enter for none): Enter
• Switch to unix_socket authentication: y
• Change the root password: y
• New password: Any new password
• Remove anonymous users? y
• Disallow root login remotely? y
• Remove test database and access to it? y
• Reload privilege tables now? y

Connect to the database as the root user and create a user account, using the newly created root password:

mysql -u root -p

Create a remote user, replacing "mypasswd" with a password of your choice:

create user remote identified by 'mypasswd';

Grant remote usage on all objects and allow user to log in from any host:

grant usage on *.* to 'remote'@'%' identified by 'mypasswd';

Enter quit to quit the program.

Install the packages for building Galera Load Balancer, using the password provided for node0 on the lab page:

sudo yum -y install git autoconf automake libtool gcc-c++ nmap-ncat

Clone the GitHub repository:

git clone https://github.com/codership/glb

Move into the glb repository:

cd glb/

Run the Bootstrap script:

./bootstrap.sh

Run the configure script:

./configure

Create the binaries:

make

Install the binaries:

sudo make install

Start the GLB manually on the command line:

glbd -v -c 127.0.0.1:4444 10.0.1.100:13306 10.0.1.100:3306:1

Open a second terminal window and log in to node1 using the provided lab credentials:

ssh cloud_user@<PUBLIC_IP_ADDRESS>

Connect to the cluster on node1 using the newly created remote user login credentials:

mysql -u remote -h 10.0.1.100 -P 13306 -p

Return to the node0 terminal and confirm the connection was made.

Open up a new terminal window and log in to node0 using the provided lab credentials:

ssh cloud_user@<PUBLIC_IP_ADDRESS>

Add a node using port 4444:

Note: This command must be run on the same node as the load balancer.

echo "10.0.1.110:3306:1" | nc 127.0.0.1 4444

Return to the first node0 terminal (the one running the load balancer) and confirm the second node is running.

Query for statistics on the control port:

echo "getstat"  | nc 127.0.0.1 4444

Close the first node0 terminal window to stop the service.

On node0, move into the files directory of the cloned GitHub repository:

cd glb/files

Copy the Galera Load Balancer shell script file and log in using provided lab credentials:

sudo cp glbd.sh /etc/init.d/glb

Copy the configuration file to /etc/sysconfig/glbd:

sudo cp glbd.cfg /etc/sysconfig/glbd

Edit the configuration file:

sudo vim /etc/sysconfig/glbd

Uncomment and edit the following file parameters:

• Set the listen address: LISTEN_ADDR="13306"
• Change the control address: CONTROL_ADDR="127.0.0.1:4444"
• Set both nodes as default targets: DEFAULT_TARGETS="10.0.1.100:3306:1 10.0.1.110:3306:1"

Hit :wq! to save and exit the file.

Start the service and check its status:

sudo service glb start
sudo service glb status

Query for load balancer statistics:

sudo service glb getstats

Remove nodes:

sudo service glb remove 10.0.1.100:3306

Add nodes:

sudo service glb add 10.0.1.100:3306:1