Is your InnoDB transactions are completely Atomicity ( ACID ) by default ?

The blog title seems something crazy ? Yes, by default your InnoDB transactions don’t have the Atomicity . But, you can control the atomicity of your InnoDB transaction with the variable innodb_rollback_on_timeout. We had a weird data inconsistency issue within the transaction . In this blog , I am going to explain “How it willContinue reading “Is your InnoDB transactions are completely Atomicity ( ACID ) by default ?”

MySQL Partition over the Virtual / Generated Column

                Had an interesting requirement from one of our client to have the two MySQL partitions ( partition_full / partition_half ) for store the Names based on the user input. Requirement : The table have two columns first_name and last_name. With the user input of both columns, itContinue reading “MySQL Partition over the Virtual / Generated Column”

Galera Replication flow Architecture

Galera is the best solution for High Availability, It is being used by many peoples world wide . Galera is doing synchronous replication ( really it is Certification based replication ) to keep update the data on group nodes . In this blog I have explained about “How the Galera replication works?” . For theContinue reading “Galera Replication flow Architecture”

ProxySQL Config file creation | Backup solution

We are well aware that ProxySQL is one of the powerful SQL aware proxy for MySQL. The ProxySQL configuration is flexible and the maximum part of configurations can be done with the ProxySQL client itself. The latest ProxySQL release ( 2.0.9 ) has few impressive features like “SQL injection engine, Firewall whitelist, Config file generate” . InContinue reading “ProxySQL Config file creation | Backup solution”

MySQL Table can have the WASTED/FRAGMENTED space without data deletion ( DELETE ) ?

Are thinking the table fragmentation will be happened with only DELETE’s ? Do you believe the INSERT’s will also cause the table fragmentation ? Yes, INSERT’s with the ROLLBACK can also create the table fragmentation . In this blog I am going to explain how the INSERT is causing the table fragmentation . How theContinue reading “MySQL Table can have the WASTED/FRAGMENTED space without data deletion ( DELETE ) ?”

MySQL performance benchmark ( with/without binary log )

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 )”

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 )”

Create your website at WordPress.com
Get started