ProxySql is a service that can help you to load balance read/write, sharding and caching request to your mysql server. It can handle more than 100k connection.Here’s how to install Proxysql server on your Ubuntu server. wget -O- ‘https://repo.proxysql.com/ProxySQL/repo_pub_key’ |…
Zfs send and receive to migrate a VM
Here is a tutorial on how to use zfs send and zfs recv to migrate a virtual machine (VM) from one system to another: zfs snapshot pool/filesystem@snapshot zfs send pool/filesystem@snapshot | ssh destination “zfs recv pool/filesystem” zfs list -t snapshot
How to Setup rsnapshot in Ubuntu 22
This post is abut setup rsnapshot in your ubuntu. Please adjust the configuration per your needs. sudo apt-get update sudo apt-get install rsnapshot sudo cp /etc/rsnapshot.conf /etc/rsnapshot.conf.bak sudo nano /etc/rsnapshot.conf config_version 1.2 snapshot_root /mnt/backup no_create_root 1 cmd_cp /bin/cp cmd_rm /bin/rm…
How to Setup Automysqlbackup in Ubuntu 22
My post this time is about how to setup automysqlbackup in ubuntu 22. Please remember to adjust configuration per your needs. sudo apt-get update sudo apt-get install automysqlbackup sudo cp /etc/default/automysqlbackup /etc/default/automysqlbackup.bak sudo cp /usr/share/doc/automysqlbackup/automysqlbackup.conf.gz /etc/automysqlbackup/automysqlbackup.conf.gz sudo gunzip /etc/automysqlbackup/automysqlbackup.conf.gz sudo…
Block Bad IPs form AbuseIPDB with CSF
ConfigServer Firewall (CSF) is a firewall and security tool for Linux servers. It provides a number of features for protecting servers from malicious activity, including IP address blocking, port blocking, and rate limiting. IP Abuse is a database of IP…