Related Articles
Useful MySQL Commands
Database with size SELECT table_schema “DB Name”, Round(Sum(data_length + index_length) / 1024 / 1024, 1) “DB Size in MB” FROM information_schema.tables GROUP BY table_schema; Create a database. mysql> create database [databasename]; List all databases on the server. mysql> show databases; Switch to a database. mysql> use [db name]; To see all the tables in the […]
Setting up the Basic High-Availability Cluster on Centos/RHEL 7
Networking: We have two nodes that are reachable by below Networks: 10.1.1.0/24 : Cluster heartbeat vlan. 172.16.1.0/24 : LAN with access to the Internal LAN network and Internet. We have set the following hostnames: [master ~]# hostnamectl set-hostname master.sysadmin.lk [client ~]# hostnamectl set-hostname client.sysadmin.lk We defined the Hostname and IP Address in “/etc/hosts” file(On both […]
How to Set up Nginx High Availability with Pacemaker and Corosync
Prerequisites 2 or more CentOS 7 Serverpre web01 10.0.15.10 web02 10.0.15.11 web03 10.0.15.12 Floating IP Address 10.0.15.15 Root Privileges What we will do: Map the Host File Install Epel Repository and Nginx Install and Configure Pacemaker, Corosync, and Pcsd Create and Configure the Cluster Disable STONITH and Ignore the Quorum Policy Add the Floating-IP and […]