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...
Thursday, February 29, 2024

.::: Study Kasus Praktis belajar Query create & insert table/Collection MongoDB (Data Warehouse) dengan Primary Key :::.

›
1. correlation with other post http://teguhth.blogspot.com/2020/12/study-kasus-praktis-belajar-query.html 2. create collection with primaryk...
Wednesday, February 28, 2024

.::: Create User MongoDB role admin and readonly and authenticationRestrictions :::.

›
1. create user admin use admin db.createUser({ user: "admin",pwd: "admin", roles: [{ role: "readAnyDatabase", ...
Tuesday, February 27, 2024

.::: Create a dblink to a remote server MariaDB MySQL to PostgreSQL EDB and using metode SRCDEF :::.

›
1. install ODBC postgresql * configure http://teguhth.blogspot.com/2024/01/install-postgresql-odbc-driver-on-linux.html A. using dblink 1. c...
Monday, February 26, 2024

.::: Access MariaDB from PostgreSQL using dblink /FOREIGN DATA WRAPPER mysql_fdw :::.

›
1. install mysql_fdw wget https://download.postgresql.org/pub/repos/yum/15/redhat/rhel-7.9-x86_64/mysql_fdw_15-2.8.0-2.rhel7.x86_64.rpm yum ...

.::: Enable pgaudit & pgauditlogtofile in PostgreSQL EDB ::.

›
  1. Download pgaudit & pgauditlogtofile https://download.postgresql.org/pub/repos/yum/16/redhat/rhel-8.2-x86_64/ yum install -y https:/...