hercules7sakthi

MySQL DBA Course – Complete 70+ Hour Training Program – Complete Hands on

The demand for skilled MySQL DBAs continues to grow rapidly as companies rely more than ever on stable, scalable, and high-performing database environments. Whether you’re beginning your DBA journey or looking to strengthen your existing skills, having solid hands-on knowledge of MySQL is essential. To help professionals accelerate their growth, I’m launching a comprehensive 70+Continue reading “MySQL DBA Course – Complete 70+ Hour Training Program – Complete Hands on”

MySQL Group Replication complete setup with SSL on MySQL 9.3.0 Innovation release

In this blog, I am going to explain the complete process involved in the MySQL group replication setup using SSL. The blog covers the complete MySQL config files as well as steps. I used the following aspects for my testing purpose. I also enabled the hostname based authentications between the three VMs. So that, IContinue reading “MySQL Group Replication complete setup with SSL on MySQL 9.3.0 Innovation release”

MySQL 8 InnoDB flow Architecture with related variables

In this blog, I am going to share the MySQL 8 InnoDB architecture diagram with related variables . From the MySQL official document I have seen some InnoDB variables related to MySQL 8.0.20 . The architecture has been prepared based on that . Also, I am providing the variables list which used in this diagramContinue reading “MySQL 8 InnoDB flow Architecture with related variables”

MySQL Query Rewritten plugin now supporting DELETE / INSERT / UPDATE / REPLACE

MySQL has the inbuilt query rewritten plugin for rewrite the SQL statements which received by the server before execute them . Before MySQL 8.0.12 , the query rewritten plugin only supports for SELECT’s From MySQL 8.0.12 , the query rewritten plugin will supports for INSERT , REPLACE, UPDATE, DELETE , SELECT . One of ourContinue reading “MySQL Query Rewritten plugin now supporting DELETE / INSERT / UPDATE / REPLACE”

MySQL ERROR log with JSON format | MySQL Components

MySQL have the nice feature, which helps to write the error log with JSON format . This can be achieved through the MySQL components . In this blog, I am going to show the complete walkthrough involved in this process . What is MySQL component ? from MySQL document , MySQL Server includes a component-basedContinue reading “MySQL ERROR log with JSON format | MySQL Components”

MySQL Client program | Some interesting features

As a MySQL database administrator, we all using the MySQL client program for communicate to MySQL Server . Maximum the client program is used to execute the SQL’s, monitor the traffic and modify the variables . MySQL client program has some good features which can helps to make our work easier . In this blogContinue reading “MySQL Client program | Some interesting features”

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

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