Tag: replication
-
New binlog implementation in MariaDB 12.3
I have recently completed a large project to implement a new improved binlog format for MariaDB. The result will be available shortly in the upcoming MariaDB 12.3.1 release.
In this article, I will give a short overview of the new binlog implementation. For more details, check the documentation which is in the source tree as the file Docs/replication/binlog.md, or here: https://github.com/MariaDB/server/blob/knielsen_binlog_in_engine/Docs/replication/binlog.md
EDIT: Also see Mark Callaghan’s benchmark of the new feature.
Using the new binlog
To enable the new binlog, […]
-
On the results from the replication poll
Here are the results of a recent poll on LinkedIn and mariadb.org about the popularity of a few of the major replication features (I aggregated the results from the two sites):
What is your favorite MariaDB replication feature?
I want to share some reasons why the poll results match my own thoughts on the relative importance of these features:
1. Parallel replication
Parallel replication brings a much needed performance boost to replication. This is not only useful for the big […]
-
Talk: The implementation of MariaDB parallel replication
On November 6 2024 I presented a talk with the title: “The implementation of MariaDB parallel replication” at a local TeqHub meetup in Copenhagen.
In the talk I first presented how MariaDB replication works overall. I then described the central idea of optimistic parallel replication. Finally I described three details of the implementation: transaction scheduling; conflict detection; and efficient commit ordering. Here are the slides for the presentation.
I was very impressed by the level of the engagement of the […]
-
MariaDB semi-sync replication using containers
In the blog MariaDB replication using containers, we showed how to properly replicate data in MariaDB using Docker containers.We used standard or asynchronous or lazy replication.
The problem with this type of replication is potential data loss if the primary goes down. Transactions that are committed on the primary are not being sent to replicas, and the replica doesn’t commit the changes. Failover from primary to replica in this case may lead to missing transactions relative to the primary.
To […]
-
MariaDB replication using containers
In this blog we are going to demonstrate how to replicate a MariaDB database that runs in a Docker container (let’s call it primary) to one or more MariaDB servers that run in a Docker container (let’s call them replicas) using binary logging, a method that creates binary log files and an index that contains the record of all changes to the database (both data and structure). You can find an overview of how replication works here and you can […]
-
MariaDB 10.1 is stable GA
With the release of 10.1.8, MariaDB takes a next step. MariaDB 10.1 is now considered a stable release.
MariaDB 10.1 has a couple of main themes:
- Security
- High Availability
- Scalability
-
MariaDB Eventually Consistent?
Background
Eventual consistency is a consistency model used in many large distributed databases which requires that all changes to a replicated piece of data eventually reach all affected replicas; conflict resolution is not handled and responsibility is pushed up to the application author in the event of conflicting updates [13].
Eventual consistency is a specific form of weak consistency; the storage system guarantees that if no new updates are made to the object, eventually all accesses will return the last […]