Everything You Ever Wanted to Know About MariaDB Replication but Were Afraid to Ask

MariaDB customers frequently choose replication to achieve high availability, distributed processing and failover. Replication is easy to set up and its benefits are quickly realized. When it fails however, replication can be tedious and stressful to repair. This session provides a brief overview of replication by looking at both simple and complex topologies, and details how to use MaxScale to realize all the benefits of a replicated database. This session demonstrates how to set up replication and methods you can use to fix broken replication in real time.
►Slides: https://mariadb.com/wp-content/uploads/2023/05/OpenWorks-2023-Everything-You-Want-to-Know-About-Replication-Ed-Stoever.pdf
►Try MariaDB with Docker: https://mariadb.me/3qPBGHM

Table of Contents
0:28 What is Replication?
1:45 3 types of replication
3:14 Key Concept: GTID
4:02 Key Concept: Binary and Relay Logs
11:40 Key Concept: Physical/Logical Copies
12:15 Demo Setup
12:43 Demo
28:42 Review and Summary

►Follow MariaDB on Twitter: https://twitter.com/mariadb
►Subscribe to the MariaDB channel:
https://www.youtube.com/mariadb
►Explore MariaDB: https://mariadb.com
►Learn about SkySQL: https://mariadb.com/products/skysql
►Check out the MariaDB DeveloperHub: https://mariadb.com/developers/
►Get in touch with MariaDB experts via Slack: https://mariadb-community.slack.com/

MariaDB is making a big impact on the world. Whether you’re checking your bank account, buying a coffee, shopping online, making a phone call, listening to music, taking out a loan, or ordering takeout–MariaDB is the backbone of applications used every day. Companies small and large, including 75% of the Fortune 500 run MariaDB, touching the lives of billions of people. With massive reach through Linux distributions, enterprise deployments, and public clouds, MariaDB is uniquely positioned as the leading database for modern application development.

#MariaDB #Database #Data #SQL