I currently have a web application and database on the same server. I am moving the database to a new server that is spec'd for being a database. Now i have nightly scripts that run on the web application that insert and update data for the application from our ERP system. Should the scripts that do this import run from the database server or from the application server? It makes sense to me to keep all of the application logic together but from a performance point of view it makes more sense (i think) to have the scripts that update the database nightly to be run from the actual database server.
May or may not be needed for question but i have a website, and 3 web applications that are all being converted from local database installations to the new central database.
Last question should the database server be in the DMZ but locked down to only accept connections for the application serve IP's or should it be behind the firewall?
Additional info if helpful: Python applications (TG and Flask) all running off of postgresql 9
Edit: If this is the wrong place for this please let me know where it should be posted. I originally had it at programmers but didn't get any responses and after re-reading the my questions this site just felt "better".