دوره آموزش جامع و کاربردی Replication در MySQL از صفر تا صد | متخصص پایگاه داده MySQL (MySQL DBA) - آخرین آپدیت

سرفصل ها و درس ها

Introduction-مقدمه Introduction

• Course Agenda-برنامه دوره Course Agenda

• Replication introduction-معرفی Replication Replication introduction

• Replication Architecture-معماری Replication Replication Architecture

• Types of Topologies-انواع توپولوژی‌ها Types of Topologies

• lab about lab-آزمایشگاه در مورد آزمایشگاه lab about lab

• working with vagrant file-کار با فایل واگرنت working with vagrant file

How to install MySQL-نحوه نصب MySQL How to install MySQL

• How to install MySQL (Percona Server)-نحوه نصب MySQL (Percona Server) How to install MySQL (Percona Server)

How to use XtraBackup-نحوه استفاده از XtraBackup How to use XtraBackup

• Installing Percona Xtrabackup-نصب Percona Xtrabackup Installing Percona Xtrabackup

• Taking Incremental backup and restoring using Percona XtraBackup-تهیه بکاپ افزایشی و بازیابی با استفاده از Percona XtraBackup Taking Incremental backup and restoring using Percona XtraBackup

Configure Replication using different Methods-پیکربندی Replication با استفاده از روش‌های مختلف Configure Replication using different Methods

• Configure Replication based on binlog file position part1 Slide-پیکربندی Replication بر اساس موقعیت فایل binlog قسمت 1 - اسلاید Configure Replication based on binlog file position part1 Slide

• Configure Replication based on binlog file position part2 Practical-پیکربندی Replication بر اساس موقعیت فایل binlog قسمت 2 - عملی Configure Replication based on binlog file position part2 Practical

• what does Show slave status means-منظور از Show slave status چیست؟ what does Show slave status means

• Configure MySQL replication using xtrabackup8-پیکربندی Replication MySQL با استفاده از xtrabackup8 Configure MySQL replication using xtrabackup8

• Streaming MySQL Backups with Percona XtraBackup xbstream-جریان‌سازی بکاپ‌های MySQL با Percona XtraBackup xbstream Streaming MySQL Backups with Percona XtraBackup xbstream

• Configure MySQL replica set using clone plugin-پیکربندی مجموعه replica MySQL با استفاده از افزونه clone Configure MySQL replica set using clone plugin

• Configure Replication using Clone Plugin-پیکربندی Replication با استفاده از Clone Plugin Configure Replication using Clone Plugin

How to Repair MySQL Replication-نحوه تعمیر Replication MySQL How to Repair MySQL Replication

• Repair MySQL replication Intro-معرفی تعمیر Replication MySQL Repair MySQL replication Intro

• How Skip counter works on transactional table-نحوه کار Skip counter در جدول‌های تراکنشی How Skip counter works on transactional table

• How Skip counter works on Non-transactional table-نحوه کار Skip counter در جدول‌های غیرتراکنشی How Skip counter works on Non-transactional table

• How to use Pt-slave-restart to start replication-نحوه استفاده از Pt-slave-restart برای شروع Replication How to use Pt-slave-restart to start replication

How to remove replication-نحوه حذف Replication How to remove replication

• How to remove replication-نحوه حذف Replication How to remove replication

Make your replica consistent-منسجم کردن replica Make your replica consistent

• How to use pt-table-checksum-نحوه استفاده از pt-table-checksum How to use pt-table-checksum

• How to use pt-table-sync-نحوه استفاده از pt-table-sync How to use pt-table-sync

GTID base Replication-Replication مبتنی بر GTID GTID base Replication

• Introduction to GTID-معرفی GTID Introduction to GTID

• configure GTID replication-پیکربندی Replication GTID configure GTID replication

How to Repair GTID Replication-نحوه تعمیر Replication GTID How to Repair GTID Replication

• How to Solve Errors In GTID Replication and use pt-slave-restart-نحوه حل خطاها در Replication GTID و استفاده از pt-slave-restart How to Solve Errors In GTID Replication and use pt-slave-restart

• What is Errant GTID-Errant GTID چیست؟ What is Errant GTID

• How to Find and Fix Errant GTID-نحوه پیدا کردن و رفع Errant GTID How to Find and Fix Errant GTID

• How to fix errant GTID by setting GTI_PURGED Values-نحوه رفع Errant GTID با تنظیم مقادیر GTI_PURGED How to fix errant GTID by setting GTI_PURGED Values

Semi synchronous replication-Replication نیمه همزمان Semi synchronous replication

• Semi synchronous replication intro-معرفی Replication نیمه همزمان Semi synchronous replication intro

• How to setup semi synchronous replication.-نحوه راه‌اندازی Replication نیمه همزمان How to setup semi synchronous replication.

• How to disable Semi synchronous replication-نحوه غیرفعال کردن Replication نیمه همزمان How to disable Semi synchronous replication

Percona Monitoring and Management-Percona Monitoring and Management Percona Monitoring and Management

• Install and configure Percona Monitoring and Management-نصب و پیکربندی Percona Monitoring and Management Install and configure Percona Monitoring and Management

MySQL Parallel Replication-Replication موازی MySQL MySQL Parallel Replication

• What is Multi thread Slave / Parallel Replication-Multi thread Slave / Parallel Replication چیست؟ What is Multi thread Slave / Parallel Replication

• MySQL parallel replication practical-Replication موازی MySQL - عملی MySQL parallel replication practical

orchestrator-orchestrator orchestrator

• Orchestrator Introduction-معرفی Orchestrator Orchestrator Introduction

• How to configure Orchestrator for MySQL Replication Topology-نحوه پیکربندی Orchestrator برای توپولوژی Replication MySQL How to configure Orchestrator for MySQL Replication Topology