MySQL

Summary: In this post, we will discuss some of the best ways to repair a corrupt InnoDB table in MySQL, which may get corrupted due to hardware failure, MySQL Server crash, …

Configuring MySQL 8 MySQL has two types of parameters: Static, which takes effect after restarting MySQL server Dynamic, which can be changed online without restarting MySQL server works in version …

MySQL 8 supports common table expressions, both non-recursive and recursive, A CTE (Common Table Expression) is a temporary result set that you can reference within another SELECT, INSERT, UPDATE, or …

In this article, we’ll discuss binary tarball MySQL installation. We will discuss MySQL 8 installation using binary tarballs and install MySQL 8 on CentOS 7 using binary tarballs. Binary tarballs …

If you want to roll back to old : # Now, we are going to turn GTID’s off Slave 192.168.66.7 mysql> set global gtid_mode='on_permissive'; Query OK, 0 rows affected (0.02 …

In this article, we are going to take a look at migrating from traditional replication to GTID, we will discuss how to do it completely online. First, let’s discuss some …

In this article we are going to discuss sysbench, the actual standard for MySQL benchmarking. We are going to take a look at sysbench usage basics and how can we …

In this article, we are going to talk about the new feature in MySQL 8 related privilege system, which is Roles. So, let’s talk about roles, this article is completely …

The Percona Toolkit is a group of cutting-edge open-source command-line tools that were build and used by Percona technical staff, build to perform a variety of MySQL® and MongoDB® server …

We should consider installing ProxySQL on client nodes for efficient workload management across the cluster without any changes to the applications that generate queries. This is the recommended high-availability solution for …