Single mysql db accessed by multiple servers
For a new project initially I will have 1db server and 1 application server. However I will need to add more application servers which all need access to the db and doing reads and writes. Is there a correct way of doing this to avoid corruption etc ie queuing of some sort.
Or is there a better way to approach this?