Category Archives: High Availability

Specify Recovery IP Addresses in Group Replication

Group Replication distributed recovery is one of the key features and until now it was restricted to be executed over one mysql connection point automatically defined on mysql system variables port and host.

With group_replication_recovery_endpoints we can specify through which interfaces can group replication recovery take place for a given member so that it controls where recovery traffic flows in the network infrastructure.…

MySQL 8.0.20 Replication Enhancements

We have just released MySQL 8.0.20. And it has some interesting replication enhancements. In particular one big and exciting feature: binary log compression. Here is the list of things in this release:

  • Binary Log Compression (WL#3549). This work done by Luís Soares implements binary log compression, making use of the popular compression algorithm ZSTD.

MySQL User Camp, Bangalore, India – 5th March 2020

A MySQL User Camp was held on 5th March 2020 at Oracle India Pvt Ltd, Kalyani Magnum Infotech Park, Bangalore, India. The attendees included developers, DBAs and trainers from Amex, Robert Bosch, Flipkart and others.

Sanjay Manwani, the Senior Director of MySQL Engineering India, presented an informative session which highlighted MySQL’s recent achievements like the DB of the Year award and the #1 ranking in the Most Popular DB with Developers StackOverflow survey.…

Preserving commit order on replicas with binary log disabled

MySQL 8.0.19 introduces Binlogless replicas with commit ordering which means you can deploy asynchronous replicas without binary logs enabled, and commit transactions in the same order they are replicated in. Yes, you can disable binlog (skip-log-bin) and the logging of changes done by the applier (log-slave-updates=FALSE) while at the same preserve commit order (slave-preserve-commit-order=TRUE).…