Lab 3 Web Application and Database Redundancy

Project 3 - Web Application and Database Redundancy

Setup u1, u2, u3

sudo hostnamectl set-hostname db0X-paul
sudo passwd champuser
sudo adduser paul
sudo usermod -aG sudo paul

Setup networking

sudo nano /etc/netplan/00-installer-config.yaml

Setup MariaDB with Galera Cluster

sudo apt install mariadb-server

Edit the Galera Config

sudo nano /etc/mysql/mariadb.conf.d/60-galera.cnf

Resources:
https://www.server-world.info/en/note?os=Ubuntu_22.04&p=mariadb&f=1
https://www.linuxbabe.com/mariadb/galera-cluster-ubuntu

Update ha proxy to support db:

sudo nano /etc/haproxy/haproxy.cfg

Now restart haproxy
Now check if I can connect the database

GRANT ALL PRIVILEGES ON \*.\* TO 'root'@'%' IDENTIFIED BY 'my-new-password' WITH GRANT OPTION;

Make Database:

CREATE DATABASE futurama;

USE futurama;

WEB:

yum install php php-mysql mysql
sudo setsebool -P httpd\_can\_network\_connect\_db on