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 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'))'
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.
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.
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..
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.🙏
@@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?
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.
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.