In MariaDB Cluster, the Server replicates a transaction at commit time by broadcasting the write set associated with the transaction to every node in the cluster. The client connects directly to the DBMS and experiences behavior that is similar to…
Instaling Severalnine Database Controller
Severalnine is Orchestrate your high-availability, open-source databases operations in any environment while maintaining total control using ClusterControl or employ a classic DBaaS experience using CCX. Using Severalnine ClusterControl will help to maintain your Database Clusters including Proxysql configuration, automating recovery…
Configure Proxysql on Ubuntu Server Part-2
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…
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’ |…
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