BestHub
Sign in
Tag

server_id

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 16, 2024 · Databases

MySQL Cascade Replication Failure Caused by Duplicate server_id and Its Resolution

The article analyzes a MySQL cascade replication issue where the new slave failed to sync due to duplicate server_id values, explains the root cause stemming from automated server_id assignment, and provides step‑by‑step remediation to ensure unique server_id settings and reliable replication.

Database TroubleshootingMySQLcascade replication
0 likes · 6 min read
MySQL Cascade Replication Failure Caused by Duplicate server_id and Its Resolution
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 16, 2020 · Databases

Analyzing Data Loss When Restoring MySQL Master from Replica Backup Using GTID

This article explains a MySQL replication experiment where a master is restored from an outdated backup, leading to missing GTID transactions due to server_id filtering, and provides analysis and solutions such as changing server_id or enabling replicate-same-server-id to prevent data loss.

BackupData LossGTID
0 likes · 7 min read
Analyzing Data Loss When Restoring MySQL Master from Replica Backup Using GTID
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 11, 2019 · Databases

MySQL Replication server_id and server_uuid: Pitfalls, Causes of Data Loss, and Best‑Practice Recommendations

This article explains how duplicate MySQL server_id or server_uuid values in replication topologies can cause data loss during high‑availability failover, illustrates the underlying mechanisms with diagrams, and provides practical configuration recommendations to avoid these issues.

Data LossHigh AvailabilityMySQL
0 likes · 6 min read
MySQL Replication server_id and server_uuid: Pitfalls, Causes of Data Loss, and Best‑Practice Recommendations