Answer
Replication sends changes from a primary server to replicas using async, semi-sync, or GTID-based methods.
Quick Answer
MySQL replication: primary (master) writes changes to the binary log (binlog). Replica (slave) has an I/O thread that copies binlog to its relay log, and a SQL thread that replays the relay log. Replication is asynchronous by default (replica may lag). Supports: read scaling (route SELECTs to replicas), high availability (promote replica if primary fails), and backups (take backup from replica). GTID replication makes failover easier.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ