Recently I had the discussion with one of my colleague about the impact of MySQL binary logs . It was a nice discussion and triggered me further to benchmark the MySQL with/without binary logs . The result is amazing 🙂 Server configuration : 4 CPU 8 GB RAM 100 GB SSD MySQL version : 8.0.19Continue reading “MySQL performance benchmark ( with/without binary log )”
Author Archives: hercules7sakthi
Monitoring MySQL using MySQL Shell ( \show & \watch )
We know the MySQL Shell is the advanced client tool for communicate to the MySQL server . MySQL Shell has lot of features like InnoDB Cluster control , InnoDB ReplicaSet, MySQL Shell utilities , MySQL server management etc … Today I came to know, MySQL shell helps lot in monitoring as well ( query, threads,Continue reading “Monitoring MySQL using MySQL Shell ( \show & \watch )”
InnoDB ReplicaSet in MySQL 8.0.19 ( configuration + Switchover the primary member )
At 13th January 2020, MySQL Community has released the very latest MySQL 8.x version ( 8.0.19 ). The MySQL 8.0.19 has released with the good amount of bug fixes and the cool features . InnoDB ReplicaSet is one of them and most interesting feature for me . In this blog I am going to explainContinue reading “InnoDB ReplicaSet in MySQL 8.0.19 ( configuration + Switchover the primary member )”
MySQL InnoDB Cluster Tutorial 3 ( Switching cluster mode and primary member )
So far, I have written two tutorial blogs about MySQL InnoDB Cluster . Those blogs describe about the InnoDB Cluster configuration and how to integrate InnoDB Cluster with the MySQL router . You can get them through the below links . MySQL InnoDB Cluster Tutorial 1 ( Group Replication + MySQL Shell ) MySQL InnoDB ClusterContinue reading “MySQL InnoDB Cluster Tutorial 3 ( Switching cluster mode and primary member )”
MySQL InnoDB Cluster Tutorial 2 ( Integrating with MySQL router )
From my last blog , I have explained the details about the configuration of InnoDB Cluster ( Group Replication + MySQL shell ) . You can find the link below . MySQL InnoDB Cluster Tutorial 1 ( Group Replication + MySQL Shell ) In this blog, I am going to explain How to integrate the MySQLContinue reading “MySQL InnoDB Cluster Tutorial 2 ( Integrating with MySQL router )”
MySQL InnoDB Cluster Tutorial 1 ( Group Replication + MySQL Shell )
MySQL InnoDB Cluster has introduced by the MySQL team for the High Availability ( HA ) purpose . It provides a complete high availability solution for MySQL. Alright, I am planning to write the series of the blogs about the InnoDB Cluster configurations / Management with MySQL Shell / Monitoring etc … In this blogContinue reading “MySQL InnoDB Cluster Tutorial 1 ( Group Replication + MySQL Shell )”
wsrep_sst_auth is no more exist ( Percona Xtradb Cluster 8.x )
Before PXC 8.x , wsrep_sst_auth is the variable which was used to assign the SST ( State Snapshot Transfer ) user and password . From , PXC 8 the variable is deprecated and completely removed as it is causing the security concern because the user and password was saved in the .txt file and itContinue reading “wsrep_sst_auth is no more exist ( Percona Xtradb Cluster 8.x )”
Backup streaming with Mariabackup
Recently one of my friend had the requirement to configure the slave with MariaDB 10.4 . He planned to stream the backup from the standalone master to slave node and configure the replication . He was familiar with the Percona Xtrabackup and this is the first time he is working on the Mariabackup streaming .Continue reading “Backup streaming with Mariabackup”
Sakthi's MySQL Blog 