Tuesday, December 19, 2023

.::: Grouping if using filter Day,date & year in MariaDB MySQL :::.

›
1. correlation with archive table http://teguhth.blogspot.com/2023/12/grouping-sql-server-by-dateday-dan_18.html 2. sample query all selec...
Monday, December 18, 2023

.::: Grouping SQl Server by Date/day. dan Archive Database (table) base on Date/Day In MariaDB / MySQL :::.

›
1. create database source & destination; create database teguhth; create database teguhth_archive;

.::: Grouping SQl Server by Date/day. dan Archive Database (table) base on Date/Day SQL Server :::

›
  1. create database source & destination create database teguhth; create database teguhth_archive; select @@servername as ServerName,* ...
Monday, December 11, 2023

.::: Script to backup All user & specific MySQL MariaDB & MarinaDB :::.

›
A. Backup Specification User MariaDB MySQL 1. capture user select @@hostname,user,host from mysql.user where user like 'teguh%'; sho...
Friday, November 24, 2023

.::: How to SwitchOver Master Slave GTID Replication MariaDB Using MaxScale :::.

›
  A. check status before swo 1. query to cek master mysql -uroot -p -e "select @@hostname,@@version"; mysql -uroot -p -e "sho...
Monday, October 23, 2023

.::: Using MariaDB MySQL Show Binary Logs in, clause, limit, convert to sql base datetime & position :::.

›
  1. show bin log event (in, from, limit ) MariaDB [(none)]> SHOW BINLOG EVENTS in 'mysql-bin.000027'; +------------------+------...
Saturday, October 21, 2023

.::: How to Administration & Maintenance MaxScale v23 for MariaDB, MySQL :::.

›
 corelation http://teguhth.blogspot.com/2022/06/how-to-install-and-configure-maxscale.html 1. set maintenance maxctrl list servers maxctrl s...
Thursday, October 19, 2023

.::: How to Check Uptime PostgreSQL, EDB, Yugabyte & Service PostgreSQL server was started :::.

›
  1. check starttime teguhth=# SELECT pg_postmaster_start_time() as StartTime;            starttime -------------------------------  2023-10...
Wednesday, October 18, 2023

.::: Get BINLOG_GTID_POS, Slave status, get gtid, master status in MariaDB, MySQL :::.

›
  1. check master status in master SHOW MASTER STATUS [root@teguhth01 ~]# mysql -uroot -proot -e "SHOW MASTER STATUS;" +----------...
Tuesday, October 17, 2023

.:: How to Fix Error: Failed to download metadata for repo CentOS-8 'AppStream': Cannot prepare internal mirrorlist: No URLs in mirrorlist (Install Centos 8) :::.

›
  Make sure for instalation like add repository "Minimal" file://    /run/install/repo/minimal   1. Try Install [root@teguhth02 ~]...

.::: Upgrade PostgreSQL from 15 to 16 on CentOS 8 :::.

›
 1. check version before upgrade SELECT version(); select pg_read_file('/etc/hostname') as hostname, version();   [root@teguhth ~]# ...
Wednesday, October 11, 2023

.:: Simulate Deadlock in PostgreSQL & Solution :::.

›
  1. create table CREATE TABLE ABC (ID INT PRIMARY KEY); CREATE TABLE XYZ (ID INT PRIMARY KEY); 2. Open Session – 1 and execute below code: ...

.::: How to Sample Simulation Blocking in PostgreSQL EDB :::.

›
1. Create a Test Table: -bash-4.2$ psql psql (15.4) Type "help" for help. postgres=# \c teguhth You are now connected to database ...