::: 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 (step-by-step, tinggal kamu jalankan di 2 query window / session).

1. SIMULASI LOCKING

Session 1 (Window 1) (session 64 sa)

SELECT @@SPID as session_id;
BEGIN TRAN;
UPDATE pembelian 
SET JUMLAH_PEMBELIAN = 10 
WHERE KODE_PEMBELIAN = 'BEL-E001';
 

Session 2 (session 60 sa)
 

.::: 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 'pam';
SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%pam%';

MariaDB [(none)]> INSTALL SONAME 'pam';
Query OK, 0 rows affected (0.007 sec)

MariaDB [(none)]>
MariaDB [(none)]> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%pam%';
+-------------+---------------+
| PLUGIN_NAME | PLUGIN_STATUS |
+-------------+---------------+
| pam         | ACTIVE        |
+-------------+---------------+
1 row in set (0.002 sec)

MariaDB [(none)]>
 

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

### 10.10.10.200

sqlcmd -U user -P password -S 10.10.10.200 -d dbatools -Q "exec dbatools.[dbo].[sp_backup_full_basic]"
sqlcmd -U user -P password -S 10.10.10.200 -d dbatools -Q "exec dbatools.[dbo].[sp_backup_diff_basic]"
sqlcmd -U user -P password -S 10.10.10.200 -d dbatools -Q "exec dbatools.[dbo].[sp_backup_log_basic]"

2. create sp_cleanbackup.bat for sp_clean

sqlcmd -U user -P password -S 10.10.10.200 -d dbatools -Q "exec dbatools.[dbo].[sp_backup_cleanup_direct]"
 

.::: 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
go mod init pembelian-api
go get github.com/go-sql-driver/mysql

[root@teguhth-all go-pembelian]# cd backend
[root@teguhth-all backend]# go mod init pembelian-api
go: creating new go.mod: module pembelian-api
[root@teguhth-all backend]# ls
go.mod
[root@teguhth-all backend]# go get github.com/go-sql-driver/mysql
go: downloading github.com/go-sql-driver/mysql v1.9.3
go: downloading filippo.io/edwards25519 v1.1.0
go: added filippo.io/edwards25519 v1.1.0
go: added github.com/go-sql-driver/mysql v1.9.3

[root@teguhth-all backend]# pwd
/opt/go-pembelian/backend
[root@teguhth-all backend]# ls
go.mod  go.sum
[root@teguhth-all 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','basedir','log_bin_basename');

 

3. check before move datadir 
 
B. move log_bin_basename 
 

.::: 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');
SHOW VARIABLES LIKE 'log_bin_basename';
 

 

.::: 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://archive.mariadb.org/mariadb-10.11/yum/almalinux9-amd64/rpms/

maxscale archive
https://dlm.mariadb.com/browse/mariadbmaxscale/24.02.7/yum/rhel/9/x86_64/
 

.::: 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.7-1.rhel.9.x86_64.rpm

mariadb archive 
https://archive.mariadb.org/mariadb-10.11/yum/almalinux9-amd64/rpms/

maxscale archive
https://dlm.mariadb.com/browse/mariadbmaxscale/24.02.7/yum/rhel/9/x86_64/

[root@teguhth data]# pwd
/data
[root@teguhth data]# ls | grep -i maxscale
maxscale-24.02.7-1.rhel.9.x86_64.rpm
[root@teguhth data]#

.::: 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    1 12.4G  0 rom
nvme0n1            259:0    0   30G  0 disk
+-nvme0n1p1        259:1    0    1G  0 part /boot
+-nvme0n1p2        259:2    0   29G  0 part
  +-almalinux-root 253:0    0   27G  0 lvm  /
  +-almalinux-swap 253:1    0    2G  0 lvm  [SWAP]
[root@teguhth ~]#
 

mount -o loop rhel-server-6.6-x86_64-dvd.iso /mnt

 

.::: 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.dev/dl/go1.25.7.linux-amd64.tar.gz
--2026-02-09 15:59:22--  https://go.dev/dl/go1.25.7.linux-amd64.tar.gz
Resolving go.dev (go.dev)... 216.239.34.21, 216.239.38.21, 216.239.32.21, ...
Connecting to go.dev (go.dev)|216.239.34.21|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://dl.google.com/go/go1.25.7.linux-amd64.tar.gz [following]
--2026-02-09 15:59:22--  https://dl.google.com/go/go1.25.7.linux-amd64.tar.gz
Resolving dl.google.com (dl.google.com)... 74.125.24.136, 74.125.24.91, 74.125.24.190, ...
Connecting to dl.google.com (dl.google.com)|74.125.24.136|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 59768749 (57M) [application/x-gzip]
Saving to: ‘go1.25.7.linux-amd64.tar.gz’
 

.::: 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
[root@teguhth-all ROOT]#
[root@teguhth-all ROOT]# cat pembelian_api.cfm
<cfquery name="qPembelian" datasource="dbteguhth">
 SELECT
        KODE_PEMBELIAN,
        KODE_BARANG,
        KODE_CUSTOMER,
        TANGGAL_PEMBELIAN,
        JUMLAH_PEMBELIAN
    FROM pembelian
</cfquery>

<cfcontent type="application/json">
<cfoutput>#serializeJSON(qPembelian)#</cfoutput>

[root@teguhth-all 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
https://teguhth.blogspot.com/2020/12/study-kasus-praktis-belajar-query.html

Install 
yum install jq -y

2. data server A & B 
server A mongodb
ip : 10.10.10.9
db : teguhth
port 27017
user : admin
password : admin

server B Mariadb
ip : 10.10.10.90
db : mariamongo
port 3306
user : admin
password : admin

buat script shell untuk migrasi dari server A mariadb to server B mongodb
 

.::: create Tools Migration from MariaDB to MongoDB using bash shell script using insert & no csv :::.

   

correlation with https://teguhth.blogspot.com/2025/12/create-tools-migration-from-mongodb-to.html

1. data migration server A Maria to server B mongo
server A Mariadb
ip : 10.10.10.90
db : teguhth
port 3306
user : admin
password : admin

server B mongodb
ip : 10.10.10.9
db : mariadbsample
port 27017
user : admin
password : admin

buat script shell untuk migrasi dari server A maria to server B mongo 

db.barang.find();

db.barang.drop();

db.suplier.find();

db.suplier.drop();

db.customer.find();

db.customer.drop();

db.pasok.find();

db.pasok.drop();

db.pembelian.find();

db.pembelian.drop();