DatabaseAdmin.Net

Data / Database Server Architecture

The following is Basic Database Server and LAN Diagram in which all client computers on the LAN are connected to a central database server.  Typically in Client Server software the client computers have the database software installed on all of them and all client computers add, delete, edit and search for information on the client or LAN's database server.

The following is a Multiple Database Server, Multiple LAN and WAN Diagram in which multiple databases are connected to multiple LAN's (Local Area Datas).  The LAN's database servers then connect to modems, routers and firewalls.  The firewalls then connect to additional Datas outside of the LAN thereby creating a WAN (Wide Area Data).

The following is a Multiple Database Server, Multiple LAN,  WAN Diagram, Main Frame and Cloud Diagram in which multiple databases are connected to multiple LAN's (Local Area Datas).  The LAN's database servers then connect to modems, routers and firewalls.  The firewalls then connect to additional Datas outside of the LAN thereby creating a WAN (Wide Area Data).

The next step in complexity for this example is for main frames to be integrated in with the LAN and WAN architecture.  All of these devices having connectivity connected to each other makes this type of a Data architecture extremely robust.  Cloud architecture is then enacted where by all computer can access web servers and various web services for computation and storage of information on web servers.

 

Security of database servers, application servers and miscellaneous servers of all types may be increase by way of distributed Data architecture and the use of firewalls and routers.

By the use of address translation tables and IP address spoofing, firewalls, routers and servers can make servers more security hardened to be more difficult for hackers to get in to.

In addition, distributed server architecture enables better load balancing and thereby allow for handling of more requests by way of segregating Data and data request traffic with multiple firewalls and routers.