How to Set up Master Slave Replication in MySQL: Hands-on!

In this video, We will understand how to setup master slave replication in mysql on Ubuntu server. Mysql Replication is a process to replicate the data automatically from one Mysql database server to one or multiple Mysql database servers.

00:00 Welcome
00:53 Configure MySQL Master Database
10:53 Configure MySQL Slave Database

#Master_Slave #Replcation #MySQL

⭐ Gadgets I am using for video:

Please do Like, Share, Comment, and Subscribe!

[CodingX]

Hi everyone, If you have any doubts on this video please comment below. Subscribe and stay tuned to get the latest video on #Web Server configuration, #AWS, #Cloud Computing, and many more every week.

[davek]

Awesome tutorial, actually the only one which i came across that works. I really struggled with replication before this video. Thankyou

[Smaranns]

Good tutorial worked for me for an azure master-slave replication
Thanks

[kirpalshergill]

Hello mate, I'm absolutely new to it. Let me start by first asking how to open two tabs and which Mysql are you writing this code on? thabks

[edwardferguson]

This video was very helpful. Thank you!

[Singhe]

Amazing. Great stuff! Always wanted to learn master slave.

[ranvijaymehta]

Why Database created ? unnecessary new user will be confuse.

[aeonzeon]

thanks sir i setup my linux to linux perfectly... sir ask for merge replication tutorials

[harapriyasahoo]

Great video and my doubt was correct the guy behind the video is an Odia… not from name but from pronunciation….

[provlogger]

Can you explain performance tuning and query optimzation in mysql

[ddrr]

how to open the master server and slave server

[pandeyumesh]

Hi Team,
Can any one suggest ..
How to change replication filter in multi source Replication ..
i.e.
Chainal-1 replicate DB1.table1,
Channel-2 replicate DB2.table2
Every chainal replicate spacific databases not all data bases ..

[AsimKhan]

i have setup Mysql Master slave replication, i checked the replication was working fine and today i have this error on SLAVE : Error 'Unknown database 'pgdb'' on query. Default database: 'pgdb'. Query: 'alter table pg_log add partition (partition p20211005 values less than ('2021-10-05'))'

[aathifmohomed]

after final command the reply file say as not permission to do.. please help

[Smaranns]

i need to do it for another database now,
I tried to change the mysqld.cnf file and change the bin log db..
but when i check the show master status it stil shows the old db name.

[Sakshiabrol-pb]

hi i just want to ask you use same configuration file for both master and slave server ?

[ashiqmumtaz]

is there any way that we can set the slave's server-id by master?

[aditidas]

Getting Slave_IO_Running in Connecting state, please suggest why? tried many times!! :(

[rishabhchd]

Hi, good tutorial. How to sync both servers so that any change is written to SLAVE also reflect to Master?

[bilalmajeed]

Thank you for wasting my 2 hours, I knew this, by your vocabulary but still I thought to follow along with you, such a shame.

Slave_IO_State: Connecting to source - you have this same issue but you didn't address it.
Slave_IO_Running: Connecting

THank you again.