MySQL Replication Primer

High Availability & Scalability with Replication in MySQL

Caveat — Notes on replication taken in 2017. This content is updated till MySQL 5.7 GA release.

What is Replication

Replication enables data from one MySQL database server (the master) to be copied to one or more MySQL database servers (the slaves). Replication is asynchronous by default; slaves do not need to be connected permanently to receive updates from the master

MySQL

--

--

--

I write about tech, Indian classical music, literature, and the workplace among other things. 1x engineer on weekdays. https://kovidrathee.medium.com/membership

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

HP Elitebook 840 G6 Intel Core i7–8665U 1.9–4.70GHz 16GB RAM 256GB SSD Warranty

HP Elitebook 840 G6 Intel Core i7-8665U 1.9-4.70GHz 16GB RAM 256GB SSD Warranty

Open VSCode Here in Windows

3 Core Features to Look for in an Image CDN

Anxious Dyspraxic Learns to Code – Week 1 at Makers

BogSwap Stablecoin Routing Update is LIVE

Why PMS Integration is Hard and What You Can Do (and it’s not just open APIs)

The path to be the Google Ninja

Everybody’s free (to write code)

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Kovid Rathee

Kovid Rathee

I write about tech, Indian classical music, literature, and the workplace among other things. 1x engineer on weekdays. https://kovidrathee.medium.com/membership

More from Medium

Cassandra Database

Basics of Apache Kafka

Keeping audit log of rolled back transaction in the database

Things We Need To Know Before Optimizing PostgreSQL Query