Monday, September 27, 2021

.::: SQL Server: how to simulate and catch deadlock :::.

›
1. Create database  create database dead_lock_lab go  2. create table & row data  USE dead_lock_lab;   CREATE TABLE dbo.invoices (    id...
Thursday, September 23, 2021

.::: How to Sample Simulation Blocking SQL Server & Trouble shoot :::.

›
  1. Login to database and create database create database blocking; go  2. Open 1 Session to New Quary Windows Begin Tran ; select ' qu...
Thursday, September 16, 2021

.::: Install PAF (PostgreSQL Automatic Failover ) on centos7 ( base on pacemaker, pcs, corosys ):::.

›
  A. Install PAF  1. Prepare Node  Node01  10.10.10.241 Node02 10.10.10.242 Ip Virtual  10.10.10.243 2. Install pacemaker, corosys, pacemake...
Thursday, September 2, 2021

.::: How To Set Up Redis as a Cache for MariaDB / MySQL with PHP :::.

›
1. Install Redish https://teguhth.blogspot.com/2021/08/how-to-install-database-redis-on-centos.html 2. Install lamp [root@teguhth /]# yum -y...
Tuesday, August 31, 2021

.::: How To Install Database Redis on Centos 7 :::.

›
1. Enable repository [root@teguhth data]# yum -y install epel-release yum-utils [root@teguhth data]# yum -y install http://rpms.remirepo.net...
Thursday, August 5, 2021

.:: How To Replicate Set (Redundant /Mirroring) MongoDB 5.0 on Centos 7 :::.

›
A. Configuring the Replica Set 1. Setting up the environment Add /etc/host to nodeA nodeB  [root@teguhth01 ~]# cat /etc/hosts 127.0.0.1   lo...

.::: Install MongoDB 5.x on Centos/Redhat 7 using repository :::.

›
  1. Create repo the /etc/yum.repos.d/mongodb-org-5.0.repo file for MongoDB. [root@teguhth02 ~]# cat /etc/yum.repos.d/mongodb-org-5.0.repo [...
1 comment:
Monday, August 2, 2021

.::: Change Standby Slave Database to Master/Normal on PostgreSQL ERROR: cannot execute CREATE DATABASE in a read-only transaction :::.

›
continue from https://teguhth.blogspot.com/2021/08/how-to-setting-streaminng-replication.html     A. Change Database Standby/Slave to Normal...

.::: How to Setting Streaming replication Redundant / Mirroring (Master Slave) postgreSQL 13 on Centos 7 :::.

›
  A.  B. Setting di Master Node 1. Create user replication su - postgres CREATE USER replicate REPLICATION LOGIN CONNECTION LIMIT 1 ENCRYPTE...
Saturday, July 24, 2021

.::: 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@t...
Thursday, July 8, 2021

.::: 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 co...
Wednesday, July 7, 2021

.::: 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]# wg...
Tuesday, July 6, 2021

.::: 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:    ...