fantastic video, but what format is the bin-log using? is it row based replication or SBR or is it mixed? and also this works only for brand new databases, right? because if we have old data on the master, i guess it is not being copied to the server.
Hi there, thank you for the nice tutorial. I have a question, who (which role) in an organised company is responsible for configuring a replication or server side tasks in general? What skills are needed?
Nice video! Just one question, if I have Mysql-Master deployed on Server A using Docker, what should change to implement a Slave MySQL on Server B? Many thanks! :)
how to do maintenance of master-slave replication, like for Master DB we need to reboot but no downtime so , in this case can we do one thing like slave server become master and vice versa so we can reboot the server and then again change it back to previous
Thanks, but I have a question. did we can reverse this action synchronization as slave to master. Let me explain. I am using a database under a website and its replication at different server. Now I point my domain to other server that holding slave database will it work fine as like master database. If yes, Now changes will in the slave database and its replication can be handle in the master. two way replication at the same time.
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..
on the slave status, i'm getting Last_IO_error : "The slave IO thread stops because master and slave have equal mysql server ids", However i've used different server ids in both the my.cnf files. Can you please help
Hi My friend... Excellent vídeo! But I have a task to make the DB replica in the same physical server, to be used for testing purposes, and not deal with production DB. Would it be possible with this method? What would be the changes I have to make?
@@EMultiSkillsDatabaseServices thank You very very much for the fast reply, My dear friend. In the meantime, Could You enlight me with any link for that subject, for me to read or follow,? Because I think the assignment has to be done in few days. Sorry, again for me to bother you
Officially MySQL supports replication from one release series to the next higher release series. You can replicate from a source running MySQL 5.7.* to a replica running MySQL 8.0.* You might see some issues due to some functionality working in lower version and obsolete in higher version.
@@EMultiSkillsDatabaseServices But Want to develop a desktop application that can make database replication real time as well as data like files, directory images, docs etc that may be a specific directory or a complete project.