Tag

DatabaseAdministration

0 views collected around this technical thread.

Raymond Ops
Raymond Ops
Feb 9, 2025 · Databases

How to Set Up MySQL Master‑Slave Replication and Read/Write Splitting with MySQL‑Proxy

This guide walks through building a three‑node lab, installing MariaDB, configuring master‑slave binary‑log replication, creating a test database, and then deploying MySQL‑Proxy on an application server to achieve transparent read/write splitting between the master and slave.

DatabaseAdministrationMySQLOperations
0 likes · 11 min read
How to Set Up MySQL Master‑Slave Replication and Read/Write Splitting with MySQL‑Proxy
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 8, 2023 · Databases

Resolving MySQL Replication Connection Failure Caused by SSL Requirement

This article describes a MySQL replication issue where the I/O thread could not connect to the master due to the replication user’s SSL requirement, explains the analysis steps, reproduces the error, and provides a solution by disabling the SSL enforcement and adjusting CHANGE MASTER parameters.

AccessDeniedChangeMasterDatabaseAdministration
0 likes · 8 min read
Resolving MySQL Replication Connection Failure Caused by SSL Requirement
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 20, 2022 · Databases

Online Enabling and Disabling of GTID Replication in MySQL

This article explains the concepts behind MySQL GTID replication, compares GTID‑based and binlog‑position‑based replication, and provides step‑by‑step commands for safely enabling and disabling GTID mode online with minimal impact on production workloads.

DatabaseAdministrationGTIDMySQL
0 likes · 10 min read
Online Enabling and Disabling of GTID Replication in MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
May 21, 2020 · Databases

MySQL Enterprise Backup: Backup Lock, Redo Log Archiving, and Page Tracking Features

This article explains the importance of database backup and details MySQL Enterprise Backup (MEB) features—Backup Lock, Redo Log Archiving, and Page Tracking—along with usage commands, performance considerations, and comparisons to xtrabackup for MySQL 8.0 environments.

DatabaseAdministrationIncrementalBackupMEB
0 likes · 7 min read
MySQL Enterprise Backup: Backup Lock, Redo Log Archiving, and Page Tracking Features