Building an HA Virtual Infrastructure

This tutorial will use VirtualBox and Vagrant to create redundant components for an HA Infrastructure.  This includes using HAProxy as a load balancer, Apache webservers, and a MySQL master-master database cluster. The load-balancer will be configured with round robin, a scheduling algorithm that distributes work evenly.  The webservers will be identical Rocky Linux 8 servers running the Apache webserver. The database will be two MySQL servers in a master-master configuration.  Also known as “mirror” because both servers update the data in real-time to ensure that both servers have the latest data. All of this can be done on Mac, Windows and Linux.



'Songs I want to hear'  is a show on SiriusXM Howard Stern channel 101. 

The show is entertaining to listen to because the hosts describe why they like the awesome songs they picked.  Not only is the music great, but the stories add a lot to gaining history and new appreciation for the selections. 

Stewart Copeland 

(born July 16, 1952) is an American musician and composer. He is best known for his work as the drummer of the English rock band the Police from 1977 to 1986, and again from 2007 to 2008. 

Linux Bash Scripts

##### Apache Webserver memory usage #####
# Ubuntu
ps -ylC apache2 | awk '{x += $8;y += 1} END {print "Apache Memory Usage (MB): "x/1024; print "Average Process Size (MB): "x/((y-1)*1024)}'
ps -ylC httpd | awk '{x += $8;y += 1} END {print "Apache Memory Usage (MB): "x/1024; print "Average Proccess Size (MB): "x/((y-1)*1024)}'
##### mysqldump #####
mysqldump testdb $(mysql -Ne 'show tables' | grep -vP '^(history|sessions|watchdog|cache.*)$') | gzip > testdb.sql.gz