THANKS A LOT DOOD !!! I use WAMP on 2012 R2 so I had to change it a little (the part on bind-address) and finaly it works !!! Just don't forget to stop the slave and only start it again when you have done the dump (sync problems).
Your voice very danger and beautiful thanks for Very Good Tutorial.kindly upload video about two same website different url replication files data Website Directory
Great video thanks. I am setting up the same in bitnami, Is there any special thing we have to do in bitnami...? When i change the bind_address to ip address provided by azure server.... its unable to restart the mysql. Please let me know if i am doing any mistake.
Wow 6 years old and still going well, the video was so clear and exciting i had to give it a go was a bit different in places for some reason but maybe is coz of newer MySQL software and i also had to install ssh to get the data to go to the other server. Question now that i have a master and a slave i original was trying it as a possible backup but now i see that i should use it for writes and slave as reads. do you know if i should just have the Apache on the master or have apache on all the slaves as well? sorry if obvious answer
So I now have 2 masters with there own slave each on 2 diffrent computers and a load balance too, and so at any one time there are three slaves and one master, many thanks
Can someone help me? In My Raspberry Pi (Master) at 4:09 it says scp masterdump.sql (ip address) I input the ip address of my laptop the one that im going to make as slave. but after typing it gives me an error ssh: connect to host (ip address) port 22: connection refused lost connection. I tried sudo service ssh start and also enable ssh in sudo raspi-config but nothing happens. Thanks
what happens when there is a spotty connection between the master and the slave? will the slave reconnect automatically? what parameters control that? what is the re-try timeout and number of attempts?
sir, i configured mysql with the help of your video it is running for the first session but when we try it after rebooting system ,it shows following error please guide me error:accessd for user 'root'@'localhost' (using password no )
Hi My configurations are present in /etc/my.cnf, where this log-bin and server id is not present i manually added it , after that am not able to start mysql.
When you first create a slave you have to import the data from the master to the slave. Once the master and the slave are synced, you do not have to keep importing the data from the master to the slave. You asked "Why do we need to import the snapshot?" The answer is to establish a syncing relationship from the master to the slave. They have to know about each other. They have to agree about what data exists currently and what data needs to be synced. Just because you think things should work a certain way doesn't mean they actually work that way. ;-)
I necessarily have to pass my data from the master DB to the slave? Can't it just be to create the slave and the data I have is automatically passed from the master to the slave?
When you first create a slave you have to pass (import) the data from the master to the slave. Once the master and the slave are synced, you do not have to keep importing the data from the master to the slave. This step of importing the existing data to a slave is a one-time step, and it is a necessary step. If it wasn't necessary I wouldn't have told you to do so. ;-)