A replica set is defined as a database cluster of multiple nodes with replication and automated failover configured between them. To make sure the PRIMARY database is elected correctly, it is important to have an odd number of members in the set (including or excluding the Arbiter node). The selected database is responsible for all the major tasks. It processes …
Improving Database Availability and Performance: MariaDB/MySQL Auto-Clustering with Load Balancing and Replication
High data availability and consistently good performance are a necessity for modern applications. Database clusterization makes this a possibility. Clusterization is, however, a complex process that requires a lot of experience and expertise. To simplify the task and make it achievable, CloudSigma PaaS allows its users to access auto-clustering for MariaDB/MySQL. In this guide, we will discuss why database clusterization …
Setting up Replication in MySQL on Ubuntu
MySQL replication is an interesting feature that allows users to manage multiple copies of one or more MySQL databases. The data is copied automatically from source to replica databases. It can be useful in numerous situations, such as working with the data without compromising the main database, data backup, or scaling the database access, etc. In this guide, we will …