| #!/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}" |
| 1. Create SSL | |
| Please adjust IP and domain name as per site. | |
| ========= | |
| Rujukan | |
| https://www.elastic.co/guide/en/elasticsearch/reference/current/configuring-security.html |
MySQL Directory Move Into New Partition (Example /home)
Login as root or any user that NOT using /home stop mariadb service such as systemctl stop MariaDB
Make sure SELINUX is permissive mode. View file /etc/selinux/config
To backup the contents of /home, do the following:
