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

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

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

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.

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

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

Thank you! this helped

Can you explain performance tuning and query optimzation in mysql

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

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

i have one question , if i read from master does the read operation shared between slaves or application has to connect each slave db separately, specifically for read.

This video was very helpful. Thank you!

Why Database created ? unnecessary new user will be confuse.

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

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'))'

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

Thank you, actually I am looking about this concept.
My requirement is "Am going to setup Disaster recovery of Mysql for production. It means if any thing happens for my master database, I need to switch db from master to slave in application. To achieve this, I have setup 2 mysql instances in AWS(master) and GCP(slave)".Is it work bw 2 clouds ? and after setup successful this configuration, if any problem in slave will it effect to master ? (ex: If slave shutdown suddenly, should not effect to master db because it's main production).
Please provide your suggestions....Thanks in advance

Plz help 🙏 I search on whole internet but i can't find any solution... after auditing mysql slave replication error 1032 occurs if you have any idea please guide me,i tried all skipping method but yet same error occur

When I try to create the same database for slave, the shell throws back "Database already exists". Note i am running (testing) on a local machine.

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 ..

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.

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

I followed same instruction step by step... but after inserting a new row in master system is just hanging Its neither inserted nor showing the same record in Slave... Is there anything to do with port openening of mysql (3306)... i am checking out this in Azure , Ubuntu , 18.x . Please help.

What need to mention in Connection string

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

please created same video on hindi language

so how to create another server with an IP. Can you help me with that?

Hi, sir just wanted to ask could this setup work for slave localhost and master VPS?

Hi, sir have you any video to create mysql configuration file like inside this path - nano/etc/mysql/mysql.conf/mysqld ...
Actually i want to know how we can create this (mysql.conf and mysqld) file initially.

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