Here’s a step-by-step guide on how to migrate a cPanel/WHM server to another cPanel/WHM server using the command line interface (CLI): /usr/local/cpanel/bin/backup –force This command will create a compressed tarball of all accounts and configurations in the /backup directory. javascriptCopy…
Configure Maria-DB Galera Replications
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’ |…