Wednesday, August 10, 2022

.::: Enable server audit in MariaDB MySQL :::.

›
  1.    Check plugin log [root@teguhth data]# mysql -u root -p Enter password: Welcome to the MariaDB monitor.  Commands end with ; or \g. Y...

.::: Enable Slow Query Log in MariaDB MySQL :::.

›
1.    Configure using CLI. For testing . long_query_time using 0.0000000001 from default 10 direct command in mysql MariaDB [(none)]> set...
Tuesday, August 9, 2022

.::: Create Event Scheduler to run Query & List Store Procedure in MySQL, MariaDB :::.

›
  1. refer link https://teguhth.blogspot.com/2020/12/database-size-table-capacity-in-mysql.html http://teguhth.blogspot.com/2022/08/create-s...

.::: Create Store procedure for database & size capacity in MariaDB, MySQL :::.

›
  1. referlink https://teguhth.blogspot.com/2020/12/database-size-table-capacity-in-mysql.html http://teguhth.blogspot.com/2022/08/create-st...
Monday, August 8, 2022

.::: Backup & restore Single Table, Database & All Database MariaDB, MySQL include single-transaction & skip-lock-tables include,ignore using Date Time file Name :::.

›
  database/table non encripted can restore to database encripted but database/table encripted cannot restore to database non encripted A. B...
Tuesday, August 2, 2022

.::: Create user MariaDB MySQL admin, readonly, show priviledge database MySQL MariaDB & change password with all hostname & specific hostname :::.

›
1. Create user & database;   -- for access local CREATE USER 'root'@'localhost' IDENTIFIED BY 'root'; GRANT ALL ...
Monday, July 25, 2022

.::: Compare date and time and if statement in MySQL MariaDB, SQL Server :::.

›
A. Date and Time -- MariaDB MySQL select curdate() as tanggalskrng; SELECT DAYNAME(curdate()) as haritanggal; select date(NOW()) - interval ...
Monday, July 11, 2022

.::: Install MySQL Dashboard and Collector in Grafana :::.

›
 B. Install MySQL Dashboard and Collector in Grafana 1. visit to collect Dasboard template (2mysql-simple-dashboard_rev6.json) https://grafa...

.::: install and configure Grafana on CentOS 7 :::.

›
A. Install Grafana 1. Disable SELinux 2. Installing Grafana via YUM Repository [root@nmslinux ~]# cat  /etc/yum.repos.d/grafana.repo [grafan...
Friday, June 24, 2022

.::: Install MySQL Router load balancer for Galera MariaDB MySQL :::.

›
1. Disable selinux & firewalld [root@mysqlrouter data]# sestatus SELinux status:                 disabled [root@mysqlrouter data]# syste...
1 comment:
Monday, June 20, 2022

.::: How to Install and Configure MaxScale for MariaDB :::.

›
1. Add into the MaxScale server MaxScale server the MariaDB repositories [root@maxscale data]# curl -sS https://downloads.mariadb.com/MariaD...
Sunday, June 19, 2022

.::: Install ProxySQL load balancer for Galera MariaDB MySQL :::.

›
 1. Disable selinux & firewalld [root@proxysql ~]# sestatus SELinux status:                 disabled [root@proxysql ~]# [root@proxysql ~...
Wednesday, June 15, 2022

.::: How to Enable Performance report performance-schema MySQL, MariaDB :::.

›
1. Open MySQL WorkBench Server -> Performance report mysqld --verbose --help | grep performance-schema 2. enable performance_schema in /e...