MySQL Replication (Master to read only Slave)

MySQL replication will not help in this scenario, as it’s primary purpose is to keep you running in case a DB server fails. E.g. it will synchronously or asynchronously replicate the data from the >master< to slaves. Slaves are read-only. There are concepts of active-active masters, but this is intended for systems with very high speed and reliable links and for a completely different use case. This is at least what I know about. The predominant solution is Percona for MySQL/MariaDB (also from what I know, there might be others).

Anyway, similar thread:

HTH