12-07-2016
3,843,
841
Join Date: Jun 2007
Last Activity: 29 June 2020, 12:30 PM EDT
Location: Lancashire, UK
Posts: 3,843
Thanks Given: 2,004
Thanked 841 Times in 727 Posts
It depends what you want to achieve. There is the LAMP style of server (Linux, Apache, MySQL, PHP/Perl) that performs a specific role with direct database access (sort of) through the web-server or you may prefer to go for the 3-tier model. One server with the web-server/application, one with the database and one with 'the middle tier', typically a message queuing service, (e.g. IBMs MQ, Oracle's AQ) and worker processes to move messages and trigger processing according to the messages passed.
The latter works best where there are multiple databases to be queried, typically after company merger where a single front-end is required. it takes more to set up but is more flexible afterwards.
What is you eventual goal?
Robin