This is the second part of configure proxysql on ubuntu server. This time, we will create group to handle write and read query. So each querry can be loadbalanced and scaled if needed. You can check my first post about…
C.
Configure Proxysql on Ubuntu Server Part-1
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’ |…
Z.
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
H.
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…
H.
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…