Monday, March 3, 2025
Latest:
OPERATING SYSTEMSOS Linux

How to Configure MySQL Master-Slave Replication on Ubuntu Linux

View the full blog post at:
http://www.linuxtrainingacademy.com/mysql-master-slave-replication-ubuntu-linux/

source

ubuntu

You May Also Like

How to Install and Configure Ubuntu Desktop Qemu Appliance on GNS3

ADALM PLUTO SDR Unboxing

Learning Linux #8-Security, Data Backup & Recovery, Printing in Linux, & Linux Servers-APCUG WW

37 thoughts on “How to Configure MySQL Master-Slave Replication on Ubuntu Linux”

  • 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?

  • 7m49s of what took me few hours once to figure out!

  • 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?

  • why do we need to import the snapshot, I thought by "connecting" the slave to the master db, the slave data would be sync with the master data

  • 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

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

  • 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?

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

  • Well structured, narrated and demonstrated. A real Pro.

  • This video was a masterpiece. thanks for sharing it.

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

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

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

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

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

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

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

Comments are closed.