.::: Install postgreSQL Linux using Repository Centos 7 & PostgreSQL 14 :::.

 

A. Install progress using Repository CentOS 7.

1. Update Server (optional)

[root@teguhth01 ~]# yum -y update

2. Install PostgreSQL

[root@teguhth01 ~]# yum install postgresql-server postgresql-contrib -y

3. Inisialisasi Database

[root@teguhth01 ~]# postgresql-setup initdb

Initializing database ... OK

systemctl start postgresql

.::: Importing Exsiting server or cluster MySQL/MariaDB using Severalnines :::.

 1. Generate an SSH key to be used by ClusterControl when connecting to all managed hosts. In this example, we are using the root user to connect to the managed hosts. To generate an SSH key for the root user

[root@teguhth ~]# ssh-keygen -t rsa

2. Before creating or importing a database server/cluster into ClusterControl, set up passwordless SSH from the ClusterControl host to the database host(s). Use the following command to copy the SSH key to the target hosts

.::: Install & Configuration Cluster control Severalnines for HA MariaDB, MySQL :::.

A. Setup ClusterControl repository 
1. Manually import the Severalnines repository public key into your RPM keyring:
[root@teguhth data]# wget http://repo.severalnines.com/severalnines-repos.asc
[root@teguhth data]# rpm --import severalnines-repos.asc 
[root@teguhth data]# 

.::: How to Create HA (High Availability) MariaDB/MySQL uting Galera Cluster on Linux (Include trouble shoot Crash case :::.

A. Installation Galera Cluster (example on 3 node = node1, node2, node3)
1. Disable selinux
[root@teguhth01 ~]# sestatus
SELinux status:                 disabled
[root@teguhth01 ~]# cat /etc/selinux/config 
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#     enforcing - SELinux security policy is enforced.
#     permissive - SELinux prints warnings instead of enforcing.
#     disabled - No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of three values:
#     targeted - Targeted processes are protected,
#     minimum - Modification of targeted policy. Only selected processes are protected. 
#     mls - Multi Level Security protection.
SELINUXTYPE=targeted 
[root@teguhth01 ~]#