Tuesday, July 30, 2024

.::: How to enable the MySQL/MariaDB general query logs :::.

›
1. enable general log temporary SET GLOBAL general_log_file='/var/lib/mysql/general.log'; SET GLOBAL log_output = 'FILE,TABLE...
Sunday, July 14, 2024

.::: Create User Access MariaDB MySQL using PAM example OS Linux Login :::.

›
  1. install pam plugin INSTALL PLUGIN pam SONAME 'auth_pam'; MariaDB [(none)]> INSTALL PLUGIN pam SONAME 'auth_pam'; ERR...
Saturday, July 6, 2024

.::: Script Backup Full + Differential + Transaction Log in MariaDB MySQL & Scheduler just like SQL Server for SingleDB & MultipleDB include Restore in One File Script :::.

›
  A. SingleDB 1. run script one time to full backup sh /data/script/scriptbackup/backup_full_log_single_db.sh   2. run script two time to lo...
Thursday, June 20, 2024

.::: How to configure Transparent Data Encryption (TDE), Monitoring & Remove TDE in SQL Server :::.

›
  A. Create TDE 1. Create Master Key USE Master; GO CREATE MASTER KEY ENCRYPTION BY PASSWORD='TDEpassword!'; GO     2. Create Certif...
Sunday, May 19, 2024

.::: Additional Environment PostgreSQL EDB example pg_ctl: command not found :::.

›
 1. Run pg_ctl pg_ctl [root@teguhth ~]# su - postgres Last login: Sun May 12 08:18:13 WIB 2024 on pts/1 -bash-4.2$ pg_ctl -D /var/lib/pgsql/...
Tuesday, April 23, 2024

.::: Enable userstat USER_STATISTICS, CLIENT_STATISTICS, INDEX_STATISTICS, and the TABLE_STATISTICS MariaDB MySQL :::.

›
A. Enable Statistic Plugin 1. Check configuration statistic From query show variables like '%userstat%'; From mariadb configuration ...
Tuesday, April 16, 2024

.::: Backup & Restore Database MongoDB Using Mongodump & mongorestore :::.

›
Step 1: Create Direct Backups Using Mongodump mongodump   [root@teguhth ~]# mongodump 2024-04-15T14:59:40.783+0700    writing admin.system.u...
Tuesday, April 9, 2024

.::: How to enable CDC (Change Data Capture) in PostgreSQL, EDB :::.

›
1. Enable WAL (Write-Ahead Logging): PostgreSQL uses Write-Ahead Logging for durability. Ensure that your PostgreSQL server is configured to...
Saturday, April 6, 2024

.::: Convert pgaudit & pgauditlogtofile log insert into table in PostgreSQL EDB :::.

›
 continue from http://teguhth.blogspot.com/2024/02/enable-pgaudit-pgauditlogtofile-in.html 1. Create table pgaudit_log CREATE TABLE pgaudit...
Wednesday, March 20, 2024

.::: Check Status Backup & Restore Progress in % Percent MSSQL SQL Server :::.

›
A. Backup 1. Query 1 SELECT @@servername as ServerName, command, percent_complete,total_elapsed_time, estimated_completion_time, start_time ...
Sunday, March 17, 2024

.::: How to enable CDC (Change Data Capture) in MariaDB, MySQL, MarinaDB in Table :::.

›
Enable Binary Logging 1. check table for sample SELECT *,@@hostname,@@version FROM teguhth.pembelian   2. Create table for cdc # create tab...
Saturday, March 16, 2024

.::: Script check cpu usage & memory usage & Total Memory Server SQL Server include using sqlcmd to monitoring NMS PRTG:::.

›
  correlation with https://teguhth.blogspot.com/2025/02/add-sensor-microsoft-sql-v2-sensor.html   1. create store procedure cpu monitoring ...

.::: Script to check cpu & memory usage service in linux include custome service, mariadb, mysql, mongodb :::.

›
1. check custome cpu usage and memory usage [root@teguhth special]# cat custom_service.sh #!/bin/bash echo "run custom_service.sh <n...