MySQL 8.2 Introduces Built-in Read/Write Splitting via MySQL Router and InnoDB ReplicaSet
MySQL 8.2 adds native read/write separation using MySQL Router 8.2 with InnoDB ReplicaSet, automatically routing SELECT queries to replicas and writes to the primary without application changes, with transaction-aware routing and configurable access modes.
