khanhkid

Export:

mysqldump -uroot -p [database] [table1] [table2]> [name].sql

Import:

mysql -u... -p... [database] < [name].sql

Query Slow on Mysql

khanhkid

Step1: Get all projects by API gitlab https://[gitlab.com]/api/v4/projects?per_page=300&page=1 https://docs.gitlab.com/ee/api/projects.html

Step2: Get all user infomation: https://lsv.wsgroup-asia.com:6996/api/v4/users?per_page=300&page=1

https://docs.gitlab.com/ee/api/users.html#list-users

khanhkid

#!/bin/bash
# Save DIR
SAVEDIR=xx
DATE=`date +%Y%m%d`

# xx
DBUSER=xx
DBPASS=xx
DB_NAME=xx
/usr/bin/mysqldump -u $DBUSER -p$DBPASS --skip-lock-tables $DB_NAME | gzip -9 > $SAVEDIR/${DB_NAME}_${DATE}.sql

khanhkid

Server System

I need monitoring my linux server? Prometheus Monitoring + Node Explorer + Grafana

https://devopscube.com/install-configure-prometheus-linux/

Demo Dashboard Grafana: https://github.com/percona/grafana-dashboards

Promotheus mysql: https://computingforgeeks.com/how-to-install-and-configure-prometheus-mysql-exporter-on-ubuntu-18-04-centos-7/

khanhkid

Instance

#push file to a instance

gcloud compute scp [LOCAL_FILE_PATH] [INSTANCE_NAME]:~/

#download file frrm a instance

gcloud compute scp --recurse [INSTANCE_NAME]:[REMOTE_DIR] [LOCAL_DIR]

khanhkid

MySQL

#show proccess list

watch -n 1 'echo "show processlist;" | mysql -uroot -proot';

#kill a thread id

kill <thread_id>;

CPU, RAM, PROCESS

khanhkid

Linux Command

---

Network

#Port open in netstar -tupln

netstat -anp | grep -w 443 | grep ESTABLISHED | wc -l grep -w : count exactly

Check SSLs

khanhkid

# Split MYSQL dump file

zcat dump.sql.gz | awk '/DROP TABLE IF EXISTS/{n++}{print >"out" n ".sql" }'

# Parallel import using GNU Parallel http://www.gnu.org/software/parallel/

ls -rS *.sql | parallel --joblog joblog.txt mysql -uXXX -pYYY db_name "<"

khanhkid

Title

<Additional information about your API call. Try to use verbs that match both request type (fetching vs modifying) and plurality (one vs multiple).>

• URL

  <The URL Structure (path only, no root url)>

• Method:

khanhkid

#!/bin/bash
# Run as root

set -e

apt-get update
apt-get install -y build-essential
apt-get install -y libncurses5-dev
useradd mysql