Advanced

MySQL Master-Slave Replication

Posted by linuxize on · Post a comment
linuxize.com; By linuxize
Mail this story
Print this story

MySQL replication is a process that allows data from one database server to be automatically copied to one or more servers.

MySQL supports a number of replication topologies with Master/Slave topology being one of the most well-known topologies in which one database server acts as the master, while one or more servers act as slaves. By default, the replication is asynchronous where the master sends events that describe database modifications to its binary log and slaves request the events when they are ready.

This tutorial covers a basic example of MySQL Master/Slave replication with one master and one slave server on Ubuntu 18.04. The same steps apply for MariaDB.

This type of replication topology is best suited for deploying of read replicas for read scaling, live databases backup for disaster recovery and for analytics jobs.

Full Story

  Nav
» Read more about: Groups: MySQL, Ubuntu

» Get new stories by e-mail: nightly or as they are published

« Return to the newswire homepage

  Related stories
» More like this

Comments

No comments yet. Be the first.

Post a comment

A free account is needed to post. Write your comment here first: your text is kept in this browser while you sign up or log in, and is waiting for you when you come back.

Your message:
|||||
10
Markdown: **bold**, *italic*, [text](https://link), - lists, > quotes, $x^2$ for math. Formatting help

Sign up and post (it is free)  or  Log in and post