Skip to end of metadata
Go to start of metadata

If you are considering securing more performance in MySQL, Replication is one of the options you can take.  You may able to setup a main database for Write, and the other option you can take is to setup a replication connection between main and another MySQL server. Another server could be used for read-only. 

Below link has information for replication based on MySQL 5.7 deployed in CentOS 7.x.

https://dev.mysql.com/doc/refman/5.7/en/replication.html