MySQL

How to Configure Multi Master Replication on MYSQL 8

How to Configure MySQL 8 Multi Master Replication on Ubuntu Note : Please follow the Master-Slave Configuration and make sure replication is working between Master to Slave. I tested and created the document on the same here Now let us continue how to enable the replication from Slave to Master. We can call it as Multi Master replication or Bi-directional
Read More »

---

How to Configure MySQL 8 Replication

How to Configure MySQL 8 Master Slave Replication on Ubuntu Setup Prerequisites:You need to have MySQL Server installed on all serversMake sure the Hostname and IP addresses are added on /etc/hosts# Hosts Entry for MySQL Master & Slave Node192.168.0.8 MySQL-Master MySQL-Master192.168.0.9 MySQL-Slave MySQL-Slave Step 1: Configure the Master Server: server-id and log_bin location have to be configured The first configuration
Read More »

---

How To Install MySQL 8 on Ubuntu

Step 1: Install Oracle VM VirtualBox or Any available virtual environment Step 2: Download Ubuntu 18 VM Image from any available website. I downloaded from linuxvmimageshttps://www.linuxvmimages.com/images/ubuntu-1804/Please make important note provided in the page where you are downloading the imagesSYSTEM & LOGIN DETAILSvCPU: 1 , RAM: 2GB , DISK: 100GB , /boot : 500MB , swap : 4GB , / :
Read More »

---

How to Make Replication Faster in MySQL

How to Make Replication Faster in MySQL innodb_flush_log_at_trx_commit to 2 will help on increasing speed of replication in case of latency between Master and Slave. It is not a recommended solution and you should not consider as permanent solution. The default setting of 1 is required for full ACID compliance. Logs are written and flushed to disk at each transaction
Read More »

---

How to Replication Works in MySQL

How to – Replication Works in MySQL MySQL Replication Events: Statement based – in which case these are write queries Row based – in this case these are changes to records, sort of row diffs if you will Master : Master needs to be writing replication events to a special log called binary log. This is usually very lightweight activity
Read More »

---