IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
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 »Using Roles New in MySQL 8
MySQL
Install and Use Percona Toolkit on Centos 7
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 …
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 »Most Popular Database Management Systems in the World
Hi, I will explain DB-Engines Ranking ranks database management systems according to their popularity in the world.
Read More »Mysql Sorgu Log’larını Listeleme
Merhaba Mysql db’mizde query loglarını tablo veya txt, log gibi dosyalarda saklayabiliriz. Ben bu örnekte tabloda saklama yöntemini set ettim dilerseniz küçük bir sh ile logları düzenli alıp saklayabilirsiniz. SET …
Read More »