MySQL Database Read/Write Splitting Scheme

MySQL Router is database middleware that distinguishes write and read requests from front-end clients and determines whether a SQL request is sent to the primary or secondary database and to which database specifically. MySQL Router read/write splitting relies on the primary-secondary replication scheme of MySQL.