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’ |…
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…