DiscoverDeep Dive MySQLMySQL Replication Basics - Part 1
MySQL Replication Basics - Part 1

MySQL Replication Basics - Part 1

Update: 2024-11-20
Share

Description

Welcome to the MySQL Replication Basics podcast, where we take a deep dive into one of the most essential features of MySQL for achieving high availability and scalability in your database environments.


Introduction to MySQL Replication

* What is MySQL Replication?

* Overview of replication concepts

* Why Use MySQL Replication?

* Key Terminology in MySQL Replication

Master (Primary)

Slave (Replica)

Binary Log (binlog)

Relay Log

I/O Thread

SQL Thread

Replication Filters (database and table level replication filters)

Comments 
In Channel
MySQL InnoDB Cluster Group Replication - Part 7 - Key Concepts in MySQL Group Replication InnoDB Cluster

MySQL InnoDB Cluster Group Replication - Part 7 - Key Concepts in MySQL Group Replication InnoDB Cluster

2025-09-0617:54

MySQL InnoDB Cluster Group Replication - Part 6 - Comparing InnoDB Cluster with Other HA Solutions

MySQL InnoDB Cluster Group Replication - Part 6 - Comparing InnoDB Cluster with Other HA Solutions

2025-09-0323:16

MySQL InnoDB Cluster Group Replication - Part 5 - Limitations

MySQL InnoDB Cluster Group Replication - Part 5 - Limitations

2025-07-0715:55

MySQL InnoDB Cluster Group Replication - Part 4 - Requirements

MySQL InnoDB Cluster Group Replication - Part 4 - Requirements

2025-07-0707:10

MySQL InnoDB Cluster Group Replication - Part 3 - Use Cases

MySQL InnoDB Cluster Group Replication - Part 3 - Use Cases

2025-07-0716:10

MySQL InnoDB Cluster Group Replication - Part 2 - Introduction to InnoDB Cluster

MySQL InnoDB Cluster Group Replication - Part 2 - Introduction to InnoDB Cluster

2025-07-0706:26

MySQL InnoDB Cluster Group Replication - Part 1 - Introduction

MySQL InnoDB Cluster Group Replication - Part 1 - Introduction

2025-07-0708:23

MySQL Archiving Basics - considerations, mistakes, best practices

MySQL Archiving Basics - considerations, mistakes, best practices

2025-04-1312:56

Choosing ProxySQL Versions

Choosing ProxySQL Versions

2025-03-0410:11

Useful scripts for MySQL in Percona Toolkit

Useful scripts for MySQL in Percona Toolkit

2024-11-2917:24

MySQL Replication Basics - Part 3 Replica Lag

MySQL Replication Basics - Part 3 Replica Lag

2024-11-2921:13

MySQL Replication Basics - Part 2 binary logs and more

MySQL Replication Basics - Part 2 binary logs and more

2024-11-2010:58

MySQL Replication Basics - Part 1

MySQL Replication Basics - Part 1

2024-11-2017:50

Low Hanging Fruits of MySQL Performance

Low Hanging Fruits of MySQL Performance

2024-11-1524:08

Duplicate Indexes in MySQL and more

Duplicate Indexes in MySQL and more

2024-11-1515:05

MySQL Change Buffer - A discussion and FAQ

MySQL Change Buffer - A discussion and FAQ

2024-11-1523:31

Google Play
Download from Google Play
Castbox
Download from App Store
usUnited States
00:00
00:00
x

0.5x

0.8x

1.0x

1.25x

1.5x

2.0x

3.0x

Sleep Timer

Off

End of Episode

5 Minutes

10 Minutes

15 Minutes

30 Minutes

45 Minutes

60 Minutes

120 Minutes

MySQL Replication Basics - Part 1

MySQL Replication Basics - Part 1

Kedar Vaijanapurkar