paint-brush
How to Enable MariaDB Replication: A Guideby@alejandroduarte
1,893 reads
1,893 reads

How to Enable MariaDB Replication: A Guide

by Alejandro DuarteDecember 6th, 2022
Read on Terminal Reader
Read this story w/o Javascript
tldt arrow

Too Long; Didn't Read

Database replication is a process that copies data from one database (primary) to another (replica) This process can happen as data is inserted, modified, or deleted. With MariaDB, setting up replication requires activating the binary log in the primary database. Multi-master replication allows your application to write to multiple nodes. Distributed SQL enables unlimited scalability while keeping the strong consistency capabilities of relational databases. For example, [Distributed SQL](https://mariadb.com/resources/blog/everything-you-need-to-know-about-distributed-sql/#:\~:text=What%20is%20distributed%20SQL%3F,capacity%20and%2

Companies Mentioned

Mention Thumbnail
Mention Thumbnail
featured image - How to Enable MariaDB Replication: A Guide
Alejandro Duarte HackerNoon profile picture

Database replication is a process that copies data from one database (primary) to another (replica). This process can happen as data is inserted, modified, or deleted and also includes data definition modifications.


With MariaDB, setting up replication requires activating the binary log in the primary database and configuring the replicas to automatically read the binary log from the primary.

Why Do We Replicate Databases?

Imagine you have a web application that connects to a single-node database. The application is reading and writing data and, at some point, you realize that you need to scale. Maybe because you found that there are a lot of reads but just a few writes.


Perhaps you want to load-balance reads to improve performance or availability. Maybe you want to run data analytics or backups in a separate node so you don't impact production.


All these situations can be addressed by adding nodes that host the same data as the primary database. Keep in mind that there are other options. For example, multi-master replication allows your application to write to multiple nodes.


Also Distributed SQL enables unlimited scalability while keeping the strong consistency capabilities of relational databases.

How Can I Enable MariaDB Replication?

If you just want to set up replication for a new fresh MariaDB server, you can just enable the binary log in the primary and configure the connection in the replica. However, if you are scaling an already deployed MariaDB database, you have to manually get a backup as well.


Here is a video that demonstrates how to enable MariaDB replication: