MySQL Replication System on CentOS 8 with MySQL 8.0
MySQL replication is a process of copying data changes from a primary server (master) to one or more secondary servers (slaves). This creates a redundant…
Read article
Load balancing in mysql 8.0 using HAPROXY
Introduction to HAPROXY: HAProxy, or High Availability Proxy, is an open-source load balancer and proxy server for TCP and HTTP applications. It’s well-known for its…
High Availability in MySQL 8.0 using INNODB Cluster in CentOS-08
High Availability (HA) in MySQL refers to a collection of options and solutions meant to keep the MySQL database system operational even during times of…
Protect Your Data with Point-In-Time Recovery (PITR) in MySQL
Point-in-time recovery (PITR) helps to recover data from unintentional deletions and modifications. Ways to recover the data Recover the complete database, backup or export it…
Mysql Major Version upgrade from 5.7.44 to 8.0.40 in Centos08
Overview of Changes from MySQL 5.7.44 to 8.0.39 Version The upgrade from MySQL 5.7.44 to 8.0.39 includes major additions and changes which affect safety, performance,…
MySQL Minor Version upgrade from 8.0.26 to 8.0.39
Comparison of mysql 8.0.26 to 8.0.39 MySQL 8.0.26 improves audit logging to include statement digests. Performance Enhancements: Various tweaks to boost overall performance. Bug fixes:…