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.
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.
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'))'
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.
First check why it's not inserting into master. Slave will take from the log, master is not pushing the data to slave, so it should insert into master first. Then you will check it's updating or not in slave.
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.
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 ..
@@CodingX Would you care to explain why is that so?I noticed you used 0.0.0.0 for your IP, if you were running it on a remote server why didn't you pass that IP?
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
The error indicates that the master deletes a row but when the slave try to do the same, it cannot find it in its database. That means, replication was not working or you hadn't put the same data in slave as master while setting up the slave. For this one solution is, do the all step again.
@@CodingX We have give the access of portal to our client so we can't do the steps again in master database.Please suggest any other method to solve this issue.🙏
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
@@CodingX Thank You, It's working fine to me. My doubt is, we pointed one binlog file name to slave db. But after few days running mysql, new binlog files will generate ? then how it will work. Out pointed binlog will be old one. Please give your suggestions..
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.
@@CodingX I have a problem that I want to set master-slave replication on the same computer. So how can I create two server: master and slave like you did.
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.
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.
Awesome tutorial, actually the only one which i came across that works. I really struggled with replication before this video. Thankyou
Thank you
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
Good tutorial worked for me for an azure master-slave replication
Thanks
This video was very helpful. Thank you!
what if i want to create table dynamically inside db?
is there any way that we can set the slave's server-id by master?
Can you explain performance tuning and query optimzation in mysql
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.
Thank you! this helped
Amazing. Great stuff! Always wanted to learn master slave.
after final command the reply file say as not permission to do.. please help
how to open the master server and slave server
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'))'
Why Database created ? unnecessary new user will be confuse.
Hi, sir just wanted to ask could this setup work for slave localhost and master VPS?
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.
First check why it's not inserting into master. Slave will take from the log, master is not pushing the data to slave, so it should insert into master first. Then you will check it's updating or not in slave.
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.
I think, no need to create config file, it is already there you need to just edit as per your need.
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 ..
Sorry, umesh, I haven't that. Will let you know if I got something.
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.
It won't work on local machine
@@CodingX Would you care to explain why is that so?I noticed you used 0.0.0.0 for your IP, if you were running it on a remote server why didn't you pass that IP?
@@paulousstudio9140 0.0.0.0 is wild IP, it means the server can accept any IP. to replicate, you need two servers
Alright thank you very much
Hi, good tutorial. How to sync both servers so that any change is written to SLAVE also reflect to Master?
You have to achieve this by the distributed database system.
@@CodingX any video on that?
@@rishabhchd19 not yet.
@rishabh : did you achieve ?
To achieve that you must Setup a master - master relationship between your mysql servers.
thanks sir i setup my linux to linux perfectly... sir ask for merge replication tutorials
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
The error indicates that the master deletes a row but when the slave try to do the same, it cannot find it in its database.
That means, replication was not working or you hadn't put the same data in slave as master while setting up the slave.
For this one solution is, do the all step again.
@@CodingX We have give the access of portal to our client so we can't do the steps again in master database.Please suggest any other method to solve this issue.🙏
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
Yes, it will work in 2 clouds and if master is affected then you can switch to slave. If slave affected, it doesn't affect to master.
@@CodingX Thank you, am trying it now
@@CodingX Thank You, It's working fine to me. My doubt is, we pointed one binlog file name to slave db. But after few days running mysql, new binlog files will generate ? then how it will work. Out pointed binlog will be old one. Please give your suggestions..
please provide your suggestions
@@veladisravankumar2635 MySQL keeping the track of log files, if you create slave it's always keep tracking of master log.
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.
so how to create another server with an IP. Can you help me with that?
Can you elaborate? what exactly you want to do?
@@CodingX I have a problem that I want to set master-slave replication on the same computer. So how can I create two server: master and slave like you did.
@@tanhoang5611 Then why do you need master-slave? You can directly access same DB right?
Great video and my doubt was correct the guy behind the video is an Odia… not from name but from pronunciation….
How you find out master ip address I. e 3.14.135.5 ?
This is your server IP where you hosted application
@@CodingX ok. How can I find out that?
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.
please created same video on hindi language
Thank you, I will make same video on Hindi
@@CodingX i need this type of video in hindi language
Getting Slave_IO_Running in Connecting state, please suggest why? tried many times!! :(