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…
Read article
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:…
Optimizing MySQL: Essential Parameters You Need to Know
It is essential to optimize MySQL parameters to make sure your database operates effectively, particularly when it is under a lot of stress. A few…