Dental School Servers
Here are some ideas for Dental Schools server organization:
MySQL Server: Running the MySQL database.
Application Server 1: Running our Middle Tier for security.
Application Server 2 (optional): Also running the Middle Tier. Serving more workstations. This may not be needed if Application Server 1 is adequate for the number of workstations.
Remote Desktop Server (optional): Using either MS or a competing remoting solution. This would only be for a few remote users, not for the majority of users.
Report Server (optional): Running a Replication replica database to take some load off the MySQL Server. If a malformed query is run, this report server will go down instead of the MySQL Server. Limit primary keys to a narrow range.
File Server (maybe optional): For storing images, especially radiographs, but also scanned documents. The needed capacity of the file server will vary widely between institutions. If any scanning or digital imaging will be performed, this should be a separate server.