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 workloads quickly. I recommend you read our previous blog, Using ClickHouse as an Analytic Extension for […]
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.
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 on the following two topics: When the replication lag threshold is […]
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 Policy Random Password Generation Password Reuse […]
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 replica How to convert the asynchronous replica to a group replication member Why […]
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 this blog, I am going to explain some of those engines, which […]
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 other method for exporting and importing tables because the files containing the data […]
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 insights into the foreground and background threads as well. Overview “\show” and “\watch” are the […]
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 in MySQL? Isolation (I) is one of the properties […]
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 thread manager, and it needs the global mutex. From MySQL 8.0.22, we have an alternative way […]
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 MySQL 8.0.2: We can select the node to […]
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 can be imported using the utility “importTable()”, which was released in […]
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 process involved in this configuration […]
Oct 06, 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 various schema changes methods used in the PXB/Galera cluster. Schema changes with […]
Oct 02, 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 engine Column Store INET 6 data type Binaries […]
Aug 27, 2020 |
Insight for DBAs, MySQL, Percona Software
InnoDB ReplicaSet was introduced from MySQL 8.0.19. It works based on the MySQL asynchronous replication. Generally, InnoDB ReplicaSet does not provide high availability on its own like InnoDB Cluster, because with InnoDB ReplicaSet we need to perform the manual failover. AdminAPI includes the support for the InnoDB ReplicaSet. We can operate the InnoDB ReplicaSet using […]
Aug 07, 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 already explored in his excellent blog ProxySQL Query Rewrite Use Case. So […]
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 would be helpful to understand this parameter better. What is innodb_rollback_on_timeout? The parameter Innodb_rollback_on_timeout will control […]
Jul 17, 2020 |
Benchmarks, Insight for DBAs, MariaDB, Storage Engine
Jul 09, 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 “flashback” feature. This feature is also implemented in MariaDB’s version […]