How to Configure MySQL Master-Slave Replication on Ubuntu Linux

View the full blog post at:

[zeonos]

Followed 4 different guys, and had problems with them all. then found this video, and it worked like a breeze the first time!

[mariaselectronics]

Dude! this is the best tutorial on how to setup replication! :)

[sajeeshnair]

Simple, Precise and to the Point. Very good presentation indeed. Hats off!

[stevenp]

Dude, great, no-nonsense tutorial! Replication setup finally makes sense! Thank you!

[orendado]

Very good, short and accurate. got my replication server working in less than 20 min. great work!!

[sourcilavise]

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

[amosgiture]

Well structured, narrated and demonstrated. A real Pro.

[WiresNStuffs]

If I turn one server off for a period of time and then turn it back on will it automatically sync with it?

[rohaneh]

excellent video; professional and to the point. Thank you very much!

[MansfeldPlPlus]

Many thanks!!! It's really helpful. It works 100% .The same procedure works on Debian 8 too.

[iiiazrockiii]

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

[oah]

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?

[JasonPurkiss]

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

[chaitanyabhagat]

not able to connect two guest ubuntu os using vagrant? how you configured your vagrant file?

are those 2 separate servers on Ubuntu? how to set it up?

[Smaranns]

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.

[iamzaidsiddiqi]

Can you kindly add a video that explains how to promote a slave to master if actual master goes down.

[rayvincentdelacruz]

can you give the description on how much RAM and disk memory used on each Virtual OS? Thanks

[AdekunleLawal]

Easy does it guys. This is the tutorial. 😀

[vitalyRodero]

May I ask. Is there a way to set up the replication within a local network with 192.168.0.x ips?