I have the following archtecture to a simple load balance magento store that I made with NGINX.
So far I have created a round-robin mechanism with NGINX in mySIte.com that redirects the client (user) to the srvMag-1, srvMag-2, srvMag-n,srvMag-1, srvMag-2, srvMag-n, ..., etc (round-robin).
As I am not specilalist in Magento (I am a begginer), my point now is if it is possible to create a server to deal only with the magento databse? The idea is to set srvMag-1, srvMag-2, srvMag-n point to that server db.
If is that possible how to setup only a databse for magento, without to setup the php files and in the other hand how to setup only the magento php files without the database?
To be clear:
- In srvMag-1, srvMag-2, srvMag-n I will only need the complete structure (php files, etc) but I dont want the database.
- In srvDB I only need the databse, but not the complete structure (php files, etc).