MySQL Related Topics
What is MySQL asynchronous replication? Today we will learn about MySQL asynchronous replication setup with detailed steps. Let's go through it : Pre Requisites : Source IP : 192.168.29.249 (Hostname…
Do you know how to change Binary Log Location in MySQL? So today in this article, we will learn about this. In our previous article, we have already seen how…
Do you know what is Binary Log in MySQL? Binary logs are transactional logs in MySQL. Whatever changes are made to the database, that is stored in the Binary Logs.…
Binlogs in MySQL are like transactional logs which are also called binary logs. So whatever changes are made to the database, like any insert, delete, etc that information is stored…
In our previous article, we have already seen how to take a backup of MySQL databases and tables. So today we will learn about how to restore MySQL database and…
Do you know how to take the MySQL database and table Backup? Today we will learn about this. Generally, in MySQL, Backup can be taken in three ways: i) mysqldump…
After the installation of MySQL, as a DBA we need to login to the database. Here is the article today we will learn how to login to MySQL database after…
While installing MySQL through rpm packages, you can encounter the below error while installing mysql-community-libs packages : Error 1 : [root@vm3 mysql1]# rpm -ivh mysql-community-libs-8.0.35-1.el7.x86_64.rpm warning: mysql-community-libs-8.0.35-1.el7.x86_64.rpm: Header V4 RSA/SHA256…
Mysql Installation in Linux can be done in many ways like rpm, yum, docker, repository etc. Today in this article we will learn how to install MySQL in Linux through…