In this chapter, we will discuss in detail about connecting our Node.js  travel application service with MySQL server and perform various CRUD operations. This chapter is a enhancement to our previous chapter which is as follows: https://www.nodexplained.com/crud-operations-with-express-js-using-in-memory-storage-travel-application/ If you haven't already installed MySQL server in

Monitoring and Observability are some of the most important aspects of software engineering. It helps us with debugging issues, getting insightful information about infrastructure and/or application performance, security, & availability, planning for effective utilization of resources and scaling of infrastructure to handle any number of client requests. In this chapter,

In this tutorial, we'll learn how to persist data in a docker container. By default, docker containers are stateless by nature, meaning once a container is destroyed, everything is erased from the container. This is because, all the files created inside a container are stored on a writable layer of

Grafana is one of the most popular multi-platform, open-source software for monitoring and observability. It allow us to query, visualize, alert on and explore various metrics, logs, and traces from different data sources, no matter where they are stored. With the help of grafana, we can create customized dashboards using

Prometheus is an open-source software for monitoring and alerting purposes. It collect and store its metrics as time series data, a series of data that is collected over consistent intervals of time. It collect metrics from configured targets at given intervals, evaluates rule expressions, display the results, and can trigger

Docker is one of the most popular containerization platform, which provides ability to package and run an application in a loosely isolated environment called containers. In this chapter, we are going to discuss about multi-stage build process in docker and it's advantages. Keeping size of docker images as small as

In this chapter, we will discuss about some of the Graphical User Interface(GUI) tools that will helps us in connecting and interacting with MySQL databases very easily. Some of the most popular free version tools are listed below: * MySQL Workbench As per official documentation, MySQL Workbench is one of

In this chapter, we will discuss about image manipulation using NGINX module called ngx_http_image_filter_module.  We can perform various image manipulation tasks like rotating, resizing, cropping, sharpening, changing quality etc of images.  This is very much helpful in optimizing responsiveness of the website and also helps with

In this chapter, we will discuss in detail about MySQL data types, create tables for the travel application and then perform CRUD operations on those tables. As we have already discussed in our previous chapter, MySQL is based on Structured Query Language (SQL). Let's start our chapter with the most

NGINX, at its core, is a collection of modules. It contains several in built modules as well as hundreds of third party modules, contributed by developers from all over the world. With the addition of dynamic module support, modules have given us greater flexibility in adding functionalities to NGINX. In

MySQL is one of the most popular open-source, cross-platform and performant relational database management system (RDMS). It is used by a large numbers of websites all over the world to store and manage data. It's original creator is Michael Widenius, but currently it's backed by Oracle. It is based on

Load balancing is a way to efficiently distribute the incoming network traffic across multiple server instances. For Load balancing, we host the same application in multiple server instances configured at different data centers/regions. This helps us improve the application availability, reliability and scalability. It ensures that no particular server

In this chapter, we will discuss enhancements to our previous server deployment architecture. Previously, it was a very basic implementation and with this enhancement, we are focusing on Scalability, High Availability and Security. Below diagram shows our enhanced architecture and since we are using AWS platform for this series, some

NGINX (pronounced as “Engine-X”) is one of the most popular web server in the world and is trusted by many of the busiest websites. It is Open-Source and as of writing this article, it powers more than 400 million websites. Some of the most commonly used features that can also

In this chapter, we will setup an OpenVPN server so that we can securely connect to our remote servers. A Virtual Private Network (VPN) is a type of network which establishes a secure and encrypted connection over the internet by creating a encrypted tunnel between our device and the internet.

In this chapter, we will run our Node.js application using docker containers in the application server instance. To configure server instance with all the necessary software dependencies, we can use SSH command to connect to the instance. We have multiple options to connect to the instance. Some of them

Amazon Web Services (AWS) is one of the most popular cloud service provider in the world. It offers above 200 cloud services to the customers and is used by organization of all sizes. For our cloud deployment, we will be using one of the computing service from AWS called Lightsail,

Cloud computing is the on-demand delivery of computing resources/services over the internet. These services include computing power, storage, data stores (databases), analytics, streaming & eventing services and many more. In Amazon Web Services(AWS), there are over 200 different cloud services that customers can use to fulfill their business needs.