MYSQL replication architecture is vital for building high available REST API servers.
In order to avoid singe-point of failure problem, it`s recommended that setting 2 application servers and Master-Slave database in MYSQL. Of course, you have to set up the application servers behind the load balancer.
The following details how to setup REST API server by using Spring framework of Java.
How to set up MYSQL Master/Slave replication ?
// Edit
vim /src/main/resources/application.properties
## Master and Slave
spring.datasource.url = jdbc:mysql:replication://localhost1:3306,localhost2:3306/userdb
The source codes of REST server can be seen here.
No comments:
Post a Comment