Remote Mysql DBA

MySQL Group Replication 5.7 has ported a few features from MySQL 8.0

Group Replication Features backported to MySQL 5.7 We have brought further enhancement to MySQL Group Replication 5.7 release by backporting some most requested features to MySQL 5.7.20 release: Member weight for automatic primary election on failo…

ZFS a File system to be tested for / .

ZFS for MySQL and MariaDB No matter what database do you use the data is eventually ends up on the filesystem, yes memcached and buffering but once the data is flushed to the

Analysing MySQL binlog made easy with binlog_row_query_log_events in

Read MySQL Binlogs better with rows query log events A blog for MySQL DBA's

Ensure Primary Key in Row Based Replication

The danger of no Primary Key when replicating in RBR (and a partial protection with MariaDB 10.1) TL;DR : unless you know what you are doing, you should always have a primary key on your tables when replicating in RBR (and maybe even all ...

How Flow Control Differs in Group Replication from ?

MySQL Group Replication: understanding Flow Control When using MySQL Group Replication, it’s possible that some members are lagging behind the group. Due to load, hardware limitation, etc… This lag can become problematic to keep good cer…

Windows Function in 10.2 GA

Introduction to Window Functions in MariaDB Server 10.2 | MariaDB This is a guest post by Vicențiu Ciorbaru, software engineer for the MariaDB Foundation.

Tuning using Machine Learning. Will reduce DBA's effort.

Tuning Your DBMS Automatically with Machine Learning | AWS AI Blog