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