Instructions for configuring MariaDB and MySQL performance :-
File Modification:
/etc/mysql/mariadb.cnf or my.cnf file (note that my.cnf is a soft link to mariadb.cnf).# Provider specific configuration options
wsrep_provider_options="gcache.size=1024M;gmcast.segment=0;gcache.recover=yes"
| #!/bin/bash | |
| # To copy to /etc/nginx | |
| # Harisfazillah Jamel | |
| # 20230208 | |
| # ini 1000 pertama head -1000 dan ambil dari baris ke 2 ke 1000 tail -999 sebab baris 1 ada - | |
| # Rujuk DENYN untuk hanya deny dengan jumlah cubaan lebih daripada | |
| DENYN=200 | |
| DATE1=`printf '%(%Y-%m-%d)T\n' -1` | |
| WRKDIR="/var/log/nginx" | |
| ETCDIR="/etc/nginx" |
| #!/bin/bash | |
| set -ex | |
| UBUNTU_VERSION="14.04" | |
| mkdirs(){ | |
| #lxc delete hadoop-master --force | |
| #lxc delete hadoop-slave-1 --force | |
| #lxc delete hadoop-slave-2 --force | |
| rm -rf /tmp/* |
| #!/usr/bin/env bash | |
| # https://gist.github.com/ppartarr/018a3858bba8655dc421cc4589598d97 | |
| ## sudo snap install lxd --classic | |
| ## this is only for jammy | |
| ## Harisfazillah Jamel 20221009 | |
| set -euo pipefail # -> http://redsymbol.net/articles/unofficial-bash-strict-mode/ | |
| # Reverse what lxd init does | |
| function check_distro() { |
| #!/bin/bash | |
| #https://stackoverflow.com/questions/29710618/vacuum-analyze-all-tables-in-a-schema-postgres | |
| # this is to be run from postgis user | |
| # 20211216 | |
| PG_SCHEMA='yourschema' | |
| PG_USER='postgres' | |
| PG_HOST='localhost' | |
| PG_DB='yourdb' | |
| PG_PASS='' |
| #!/bin/bash | |
| # Harisfazillah Jamel - 20211216 | |
| # Part of script from https://wiki.lyrasis.org/display/DSPACE/Idle+In+Transaction+Problem | |
| # Idle In Transaction Problem | |
| pgprocess_array=( $( /usr/bin/pgrep -f 'idle in transaction' ) ) | |
| /usr/bin/pgrep -f 'idle in transaction' | wc -l | logger | |
| for r in "${pgprocess_array[@]}"; do |
| # uptime report every 1 minutes everyday | |
| */10 * * * * root uptime | logger -t uptime > /dev/null | |
| */10 * * * * root free -h | head -2 | tail -1 | logger -t free > /dev/null |
| Cluster Control On Centos 8 Using Podman | |
| https://severalnines.com/download-clustercontrol-database-management-system | |
| https://severalnines.com/docs/user-guide/ui.html#import-existing-server-cluster | |
| https://severalnines.com/docs/installation.html | |
| https://severalnines.com/product/clustercontrol/clustercontrol-community-edition |
| ==== | |
| Ref: https://www.vultr.com/docs/how-to-deploy-google-bbr-on-centos-7 | |
| yum install byobu openssh fail2ban httpd | |
| rpm --import https://www.elrepo.org/RPM-GPG-KEY-elrepo.org |
| #!/bin/bash | |
| # By Harisfazillah Jamel | |
| # 16 Jan 2021 | |
| #=== backup script | |
| #=== mysqldump-restore-script.sh dbname user password ipaddress | |
| NAMADATABASE="${1}" | |
| NAMAUSER="${2}" | |
| DBPASSWORD="${3}" | |
| HOST="${4}" |