by Sri Sakthivel | Sep 14, 2023 | Insight for DBAs, MySQL
MySQL is an outstanding open source transactional database used by most web-based applications and is very good at handling OLTP workloads. However, modern business is very much dependent on analytical data. ClickHouse is a columnar database that handles analytical... by Sri Sakthivel | Aug 10, 2023 | Insight for DBAs, MySQL, Security
MySQL 8.0.34 brings us a new password validation parameter. Using this, we can control the minimum number of characters in a password that a user must change before validate_password accepts a new password for the user’s account. In this blog, I offer a few... by Sri Sakthivel | Oct 12, 2021 | MySQL, ProxySQL
ProxySQL 2.3.0 was recently released and when I was reading the release notes, I was really impressed with the Group Replication enhancements and features. I thought of experimenting with those things and was interested to write a blog about them. Here, I have focused... by Sri Sakthivel | Sep 22, 2021 | Insight for DBAs, MySQL
MySQL 8 comes with a lot of good features, and recently I explored its password management systems. I wanted to put together a series of blogs about it, and this is the first part. In this post, I am going to explain the following topics in detail. Password Reuse... by Sri Sakthivel | Apr 19, 2021 | Insight for DBAs, Insight for Developers, MySQL
MySQL Group Replication is a plugin that helps to implement highly available fault-tolerant replication topologies. In this blog, I am going to explain the complete steps involved in the below two topics. How to convert the group replication member to an asynchronous... by Sri Sakthivel | Mar 26, 2021 | Insight for DBAs, Insight for Developers, MySQL, Storage Engine
For MySQL, MyISAM and InnoDB storage engines are very popular. Currently, we are mostly using InnoDB engines for high reliability and high performance. Apart from those engines, we also have some other alternative engines and they have some nice features in them. In... by Sri Sakthivel | Mar 24, 2021 | Insight for DBAs, MySQL
Transportable tablespaces were introduced in MySQL 5.6. Using this feature, we can directly copy a tablespace to another server and populate the table with data. This is a very useful feature for large tables. The transportable tablespace mechanism is faster than any... by Sri Sakthivel | Feb 25, 2021 | Insight for DBAs, Monitoring, MySQL
MySQL Shell is the advanced MySQL client, which has many excellent features. In this blog, I am going to explain the MySQL shell commands “\show” and “\watch”. Both commands are very useful to monitor the MySQL process. It provides more... by Sri Sakthivel | Feb 11, 2021 | Insight for DBAs, MySQL, Storage Engine
The goal of this blog post is to explain the various types of transaction isolation levels available in MySQL. After reading the blog, you will be able to explain dirty reads, non-repeatable reads, and the concept of phantom rows as well. What is the Isolation Level... by Sri Sakthivel | Jan 15, 2021 | Insight for DBAs, Insight for Developers, MySQL
The “SHOW PROCESSLIST” command is very famous and very useful for MySQL DBAs. It will help you to understand the ongoing thread activities and their current states. By default, the “show processlist” output details will be collected from the... by Sri Sakthivel | Jan 11, 2021 | MySQL, Open Source, Percona Software
In this blog, I am going to explain the different ways of electing the PRIMARY node in MySQL group replication. Before MySQL 8.0.2, primary election was based on the member’s UUID, with the lowest UUID elected as the new primary in the event of a failover.From... by Sri Sakthivel | Dec 16, 2020 | Insight for DBAs, MySQL, Open Source
MySQL Shell is an advanced client tool that has many features and is easy to use. The recent MySQL release (MySQL 8.0.22) has the utility “exportTable()”, which supports exporting the data into a file from a table using MySQL shell. The exported data file... by Sri Sakthivel | Oct 26, 2020 | Insight for DBAs, Insight for Developers, MySQL
MySQL 8.0.22 was released on Oct 19, 2020, and came with nice features and a lot of bug fixes. Now, you can configure your async replica to choose the new source in case the existing source connection (IO thread) fails. In this blog, I am going to explain the entire... by Sri Sakthivel | Oct 6, 2020 | MySQL, Open Source, Percona Software
Schema changes are the big challenges in Galera replication. So, it is recommended to understand the schema changes operation for everyone who uses the Percona XtraDB Cluster (PXB)/Galera clusters. In this blog, I am going to explain the operation and impact of the... by Sri Sakthivel | Oct 2, 2020 | Insight for DBAs, MariaDB, MySQL
MariaDB 10.5 was released in June 2020 and it will be supported until June 2025. This is the current stable version and comes with more exciting new features. In this blog, I am going to explain the new and exciting features involved in MariaDB 10.5. Amazon S3... by Sri Sakthivel | Aug 27, 2020 | Insight for DBAs, MySQL, Percona Software
by Sri Sakthivel | Aug 7, 2020 | Insight for DBAs, Insight for Developers, MySQL
Rewriting a MySQL query for performance is an important process that every DBA should be aware of so they can fix the wrong queries on runtime without code changes on the application end. ProxySQL has great support for rewriting the queries, which Alkin Tezuysal... by Sri Sakthivel | Jul 27, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
I would say that innodb_rollback_on_timeout is a very important parameter. In this blog, I am going to explain “innodb_rollback_on_timeout” and how it affects the transaction behavior at the MySQL level. I describe two scenarios with practical tests, as it... by Sri Sakthivel | Jul 17, 2020 | Benchmarks, Insight for DBAs, MariaDB, Storage Engine
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source, production-ready, and enterprise-grade MySQL alternative. Learn More MariaDB 10.5 has an excellent engine plugin called “S3”. The S3 storage engine is based... by Sri Sakthivel | Jul 9, 2020 | Insight for DBAs, MySQL
In this blog, I will look at the tool binlog2sql, designed by Cao Danfeng. The tool will help to decode the MySQL binary logs and extract the raw SQL, which also helps to generate the ROLLBACK statements for point in time recovery (PITR) using the...