Tuesday, March 31, 2026

.::: Shell script to simulate pararel query thread or Injector CPU in MariaDB :::.

›
   1. run run_query_parallel.sh , cpu lebih rendah  sh run_query_parallel.sh [root@teguhth-all pararel]# sh run_query_parallel.sh Jumlah eks...
Monday, March 30, 2026

::: Simalation Locking, Blocking & Deadlock in SQl Server MSSQL, LCK_M_S(locking), LCK_M_X(Blocking Deadlock) :::.

›
  Mantap ini contoh tabel kamu sudah pas untuk bikin simulasi. Saya buatkan 3 skenario nyata di SQL Server: locking ? blocking ? deadlock (s...
Thursday, March 5, 2026

.::: Create User Access MariaDB MySQL using login Active Directory Windows via PAM :::.

›
  1. correlation from https://teguhth.blogspot.com/2019/08/join-domain-active-directory-on-centos.html 2. enable pam plugin  INSTALL SONAME ...
Wednesday, February 25, 2026

.::: T-SQL Clean backup retention di SQL Server MSSQL :::.

›
   correlation with http://teguhth.blogspot.com/2025/12/create-script-backup-all-database-full.html 1. create sp_backup .bat script for back...
Wednesday, February 18, 2026

.::: Sample Access Database MariaDB via Backend Golang & Frontend using Lucee & PHP :::.

›
  1. Sample for table pembelian mkdir -p /opt/go-pembelian cd /opt/go-pembelian mkdir backend cd backend 2. run mod & driver  cd backend...

.::: Move log_bin_basename (mysqlbinlogs) MariaDB / MySQL using symlink relink symbolic link :::.

›
  A. capture before  1.check mariadb version 2. check log_bin_basename  SHOW VARIABLES WHERE Variable_name IN ('datadir','basedi...

.::: Move Datadir MariaDB / MySQL using symlink relink symbolic link :::.

›
  A. capture before  1. check mariadb version 2. check datadir  SHOW VARIABLES WHERE Variable_name IN ('datadir','basedir');...
Thursday, February 12, 2026

.::: Install MariaDB 10.11.x Using repo local cdrom ISO on Centos 9, Almalinux 9, Redhat 9 :::.

›
  1. enable repolocal  https://teguhth.blogspot.com/2026/02/enable-repo-local-using-cdrom-on-centos.html 2. download mariadb archive  https:...

.::: Install Maxscale 24 Using repo local cdrom on Centos 9, Almalinux 9, Redhat 9 :::.

›
  1. enable repolocal  https://teguhth.blogspot.com/2026/02/enable-repo-local-using-cdrom-on-centos.html 2. download maxscale maxscale-24.02...

.::: Enable Repo Local Using cdrom (ISO file) on Centos 9, Almalinux 9, Redhat 9 :::.

›
    1. check iso/disk/rom  lsblk [root@teguhth ~]# lsblk NAME               MAJ:MIN RM  SIZE RO TYPE MOUNTPOINTS sr0                 11:0   ...
Tuesday, February 10, 2026

.::: Install Golang 25 in Centos 9 :::.

›
  1. download golang  wget https://go.dev/dl/go1.25.7.linux-amd64.tar.gz 2. check after downlaod  [root@teguhth-all golang]# wget https://go...
Monday, February 9, 2026

.::: Sample Access Database MariaDB via Frontend & Backend using Lucee :::.

›
  1. enable datasource    2. backend  http://10.10.10.90:8888/pembelian_api.cfm [root@teguhth-all ROOT]# pwd /opt/lucee/tomcat/webapps/ROOT ...

.::: create Tools Migration from MongoDB to MariaDB using bash shell script nocsv :::.

›
   1. sample data edb & mariadb MySQL MariaDB https://teguhth.blogspot.com/2019/04/study-kasus-praktis-belajar-query-mysql.html MongoDB ...