Designing Database Architecture
02/07/2022Designing Database Architecture – Single Server Deployment and Vertical Scaling
02/07/2022Reference Architecture Examples
The typical real-world use case for a database is to store and handle structured information as part
of an application’s software stack. The foundation of a simple web application is the operating system of your server, with a web server, database, and application code layer running on top of it The OS provides basic networking functionality that the web server relies on to serve content In the code layer, a programming language and application software framework are used to direct the client-side UI in your users’ browser. We can look at a server running a WordPress site to illustrate these concepts:
Single Node Web Server Architecture
A WordPress site commonly leverages a software stack called LAMP, which is composed of the Linux operating system, Apache HTTP web server, MySQL database, and PHP programming language LAMP is one of the most popular web application software stacks in use. There are also alternatives to the LAMP stack. For example, you can use Python and an associated web application framework (like Django) instead of PHP Or, you can use the NGINX web server instead of Apache; this is referred to as the LEMP stack (the “E” comes from the pronunciation of NGINX, which is “Engine X”) There are many other variations of this concept, but the following scenario focuses on a traditional LAMP stack.