Can anyone help me on setting up a cluster server step-by-step with the following setups:
1. one load balancer
2. three cluster nodes
3. one database server.
The three nodes will have the read-only copy of the database from the database server.
In addition, when the client will get a request, the load balancer will distribute the task within the three nodes then the node will read the data from the read-only copy of database. But if there will be an update in database, the data in the separate database server will be updated and will be automatically replicated in each nodes.
I'm having a hard time in setting up the database server for clustering. I tried to read different tutorials but i barely understand it. I'm having a hard time in following some of their instructions.