Semi-Synchronous Replication and Read Replicas

Semi-Synchronous Replication

In this mode, the master waits for at least one slave to acknowledge the transaction before committing.

Setup

INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
SET GLOBAL rpl_semi_sync_master_enabled = 1;

Read Replicas

Use replicas to handle SELECT queries to offload read pressure from the master.

Example Use

-- Application decides read/write routing
READ from slave, WRITE to master