curl -L -O https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.23-el7-x86_64.tar [root]# rpm -qa|grep mysql [root]# rpm -qa |grep mariadb-libs yum remove mariadb-libs -y tar -xvf mysql-8.0.23-el7-x86_64.tar [root]# groupadd mysql [root]# useradd -r -g mysql -s /bin/false …
Read More »Tag Archives: MySQL
Deploying InnoDB ReplicaSet In Production
InnoDB ReplicaSet, that enables you to administer a set of MySQL instances running asynchronous GTID-based replication. MySQL Replica Set is a set of three components: MySQL Shell MySQL Router Set …
Read More »MySQL 8 Common Table Expressions CTE
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 …
Read More »Set Up MySQL 8 from Binary Tarball
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 …
Read More »How to Benchmark Performance of MySQL Using SysBench
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 …
Read More »Using Roles New in MySQL 8
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 …
Read More »Load balancing with ProxySQL For Percona XtraDB Cluster
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 …
Read More »Installing Percona XtraDB Cluster on CentOS 7
Welcome to another blog. This time I am here to show you guys how to setup percona XtraDB cluster. Ok, so what is percona XtraDB? XtraDB is a MySQL clustering …
Read More »MySQL Replication Health Check script
Today in this article we will get an idea about how to monitor MySQL replication. It is today’s requirement to setup replication in your environment but is it enough? My …
Read More »MySQL Master To Master Replication
Replication is used to keep two or more databases synchronized by replicating either executed DML/statement or data set changes from a master server to one or multiple slave servers. There …
Read More »