Remote Mysql DBA

16/12/2017

There error code in client and its troubleshooting for DBA's

Working in an operations environment means that you get a lot of questions. There’s the inevitable troubleshooting tasks that go along with being a DBA. This is designed to be a quick refer…

12/12/2017

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

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…

14/09/2017

ZFS a File system to be tested for / .

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

13/09/2017

is getting ready with a inbuilt clustering feature.

ProxySQL 1

19/08/2017

Analysing MySQL binlog made easy with binlog_row_query_log_events in

A blog for MySQL DBA's

16/08/2017

Ensure Primary Key in Row Based Replication

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 ...

19/07/2017

8.0.2 Milestone release is out with awesome features on replication,InnoDB and more.

The MySQL Development team is happy to announce our 8.0.2 development milestone release (DMR), now available for download at dev.mysql.com. (8.0.2 adds features to 8.0.1 and 8.0.0). The source code…

07/07/2017

New improvements in 3.2.1 for

The world's most advanced open source database cluster

05/07/2017

How Flow Control Differs in Group Replication from ?

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…

27/06/2017

High Availability Solutions in a high level overview.

In this blog, we’ll look at different MySQL high availability options. The dynamic MySQL ecosystem is rapidly evolving many technologies built around MySQL. This is especially true for the te…

18/06/2017

Windows Function in 10.2 GA

This is a guest post by Vicențiu Ciorbaru, software engineer for the MariaDB Foundation.

08/06/2017

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