Elastic File System is known as EFS which is a storage type product of aws. EFS is a scalable storage solution that can be utilized for a variety of applications. We can connect EC2 instances…
STEP 1: Sign in to your AWS account. enter your root user credentials to access the AWS landing page. STEP 2: Navigate to IAM once logged in, locate and select…
ProxySQL can split read and write operations in MySQL replication setups by directing read queries to replica servers while sending write queries to the primary/master server. This improves performance by…
Zabbix is a robust open-source monitoring solution that allows you to keep track of various aspects of your infrastructure. In this guide, we’ll walk through the process of setting up…
MySQL binary installation This method does not involve compiling the MySQL source code, making it a faster and more straightforward way to set up a MySQL database system. Users typically…
MySQL Master-Slave Replication is a database configuration where one MySQL server (Master) shares its data changes with another server (Slave). The Slave server mirrors the Master’s data, enhancing data availability…
Percona XtraDB Cluster 5.7, follow the steps provided below on all instances. These steps will guide you through the installation and configuration process for a successful cluster deployment. STEP1: Install…
Multi-source replication in MySQL 8 allows you to replicate data from multiple source databases into a single destination database. It’s a powerful feature for consolidating data from different sources. To…