server_id | BestHub

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

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

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