Configuration·MySQL

MySQL Replication Prerequisites

Three servers, three unique ids, GTID on everywhere and one account with exactly one privilege. Every replication problem later is easier when this part is exactly right.

Replication Guide 26 of 45 Intermediate

OSUbuntu 26.04 LTS (resolute)
MySQL8.4.10-0ubuntu0.26.04.1
ReplicationGTID, ROW format, auto-position
TimeAbout 15 min
Reviewed27 August 2026

Written against the versions above. GTID replication is the modern default approach. File-and-position replication still works and is what most older documentation describes; auto-positioning removes the step where you copy coordinates by hand and get them wrong.

db-a01 is the source. db-b01 and db-c01 become replicas - two, because a single replica cannot show what a second one does differently.
Server Name	IP Address	OS	Roles	CPU	RAM	HDD
db-a01	192.168.0.81	Ubuntu 26.04 LTS	Primary / Source / Replica Set Member 1	2 Core	4 GB	50 GB
db-b01	192.168.0.82	Ubuntu 26.04 LTS	Standby / Replica / Replica Set Member 2	2 Core	4 GB	50 GB
db-c01	192.168.0.83	Ubuntu 26.04 LTS	Replica Set Member 3 / Cascading and Delayed Replica	2 Core	4 GB	50 GB

Before you start

MySQL installed on all three hosts.
Network reachability on port 3306, and bind-address open - see the connections guide in the foundations track.

Give every server a unique identity
Validate, then restart all three
Confirm the topology agrees
Create the replication account

Official sources

← All MySQL guides

MySQL Replication Prerequisites

Before you start

Give every server a unique identity

Validate, then restart all three

Confirm the topology agrees

Create the replication account

Official sources