Wednesday, June 18, 2025

.::: Shell Script to compare table Database MariaDB MySQL :::.

›
    correlation with https://teguhth.blogspot.com/2025/03/query-to-check-table-column-compare_28.html 1. check table server1    

.::: Shell Script to compare value table a Database MariaDB MySQL :::.

›
   correlation with https://teguhth.blogspot.com/2025/03/query-to-check-table-column-compare_28.html 1. check value table barang server1    
Tuesday, June 17, 2025

.::: Trial Backup & Restore MariaDB MySQL with crontab -l / crontab -e & /etc/crontab :::.

›
  A. Prepare Script backup & Restore 1. create backup script [root@teguhth cron]# pwd /data/cron [root@teguhth cron]# cat backup_test.sh...
Thursday, June 12, 2025

.::: Simulation Query Select from Java to MariaDB using mariadb-java-client-3.5.3.jar (MariaDB Driver) :::.

›
   https://teguhth.blogspot.com/2025/06/simulation-connection-java-to-mariadb.html 1. Script java  [root@teguhth maria]# cat queryjoin.java ...
Thursday, June 5, 2025

.::: Simulation connection java to MariaDB for Success & Fail using mysql-connector-j-8.0.33.jar (MySQL Driver) (com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.) :::..

›
  1. Download (Platform independent) MySQL Driver https://repo1.maven.org/maven2/com/mysql/mysql-connector-j/8.0.33/mysql-connector-j-8.0.33...

.::: Simulation connection java to MariaDB for Success & Fail using mariadb-java-client-3.5.3.jar (MariaDB Driver) (java.sql.SQLNonTransientConnectionException: Socket fail to connect to 10.10.10.9. No route to host) :::.

›
  1. Download (Platform independent) https://mariadb.com/downloads/connectors/connectors-data-access/java8-connector   java -version dnf ins...
Monday, June 2, 2025

.::: Move TempDB to other folder (move SQL Server MDF and LDF Files location):::.

›
    correlation https://teguhth.blogspot.com/2023/06/move-sql-server-mdf-and-ldf-files.html 1. check  sp_helpdb tempdb USE tempdb; GO SELECT...
Tuesday, May 27, 2025

.::: Quary query to simulation High CPU & High Memory Usage In EDB PostgreSQL :::.

›
    A. Simulation High CPU 1. Contoh query untuk Simulasi CPU Tinggi   Untuk mensimulasikan CPU utilization tinggi di PostgreSQL menggunakan...
Thursday, May 22, 2025

.::: Shell Script Kasir cashier with & Without MariaDB :::.

›
  A. Simple Cashier without Database 1. Struktur File listbarang.txt 2. Script: kasir.sh   [root@teguhth program]# cat kasir.sh #!/bin/bash ...
Monday, May 19, 2025

.::: Quary to simulation High CPU & High Memory Usage In MySQL MariaDB :::.

›
  A. Simulation High CPU 1. Contoh untuk Simulasi CPU Tinggi   Untuk mensimulasikan CPU utilization tinggi di SQL Server menggunakan T-SQL, ...
Wednesday, May 14, 2025

.::: Quary T-SQL to simulation High CPU & High Memory Usage In SQL Server :::.

›
  A. Simulation High CPU 1. Contoh T-SQL untuk Simulasi CPU Tinggi   Untuk mensimulasikan CPU utilization tinggi di SQL Server menggunakan T...
Tuesday, May 6, 2025

.::: Insert data table to another table with different Database in Oracle Database :::.

›
  A. Without Date 1. Check select * from pembelian;   2. table after create CREATE TABLE pembelian_clone (     KODE_PEMBELIAN     CHAR(10) N...
Monday, May 5, 2025

.::: Insert data table to another table with different Database in PostgreSQL EDB :::.

›
  A. Without Date 1. Check select * from pembelian;   2. table after create CREATE TABLE pembelian_clone (     KODE_PEMBELIAN     CHAR(10) N...