Jeff Wilson 
These days high availability and database clustering are very important for highly loaded production applications. If your server is down for a fraction of time, you are losing customers and money. Therefore making a database environment highly available has typically one of the highest priorities. Set up a highly available cluster is not easier for any developers and system administrators.
SSH is a “Secure Shell Protocol” used to connect and manage remote Linux systems securely over an unsecured network. It is very useful for system administrators to perform day-to-day tasks on the remote server. So securing an SSH server is an essential part of any system administrator.
By default, you can connect to SSH with a password or using the private key. That means, it is only a single factor authentication. So it is a good idea to implement multi-factor authentication in the SSH server to add an extra layer of security. In multi-factor authentication, you will need to provide your system user password and another password generated on a mobile device. This will significantly enhance your server’s security.
Redis is an open-source and in-memory data structure store that can be used for caching, real-time analytics, searching, and machine learning. Integrate Redis with PHP and MySQL will improve your application performance because Redis stores data in RAM.
You can use it with databases like MySQL or MariaDB. Redis provides a mechanism to cache your queries. For example, when a user requests your application page the first time, a MySQL query is performed on the server, and Redis caches this query to RAM. When another user requests the same page, you don’t need to query the database again.
ERPNext is a completely robust ERP framework intended for small and medium-sized businesses. It covers an extensive variety of features, including accounting, CRM, inventory, selling, purchasing, manufacturing, projects, HR and payroll, website, e-commerce, and more – all of which make it profoundly adaptable and extendable.
ERPNext is developed in Python and depends on the Frappe Framework. It utilizes Node.js for the front end, Nginx for the web server, Redis for caching, and MariaDB for the database.
ERPNext is Open Source under the GNU General Public License v3.
ERP software stands short for Enterprise Resource Planning software. It is a powerful data management tool that integrates all business workflows, streamlines and automates data-driven processes by imposing innovative data viewing and sharing techniques. All of this is aimed at improving their performance.
Every business – be it SMEs or a large-scale enterprise, can reap great benefits from ERP software, especially if it’s flexible and scalable.
In this tutorial, we will guide you through the steps of installing Odoo 12 on Ubuntu 18.04. We will also install Nginx and configure it as a reverse proxy. Odoo (formerly OpenERP) is a simple and intuitive suite of open-source enterprise management applications such as Website Builder, eCommerce, CRM, Accounting, Manufacturing, Project and Warehouse Management, Human Resources, Marketing, and many more. Odoo comes in two editions, the Community edition which is free, and the Enterprise edition. In our case, we will install and use the Community edition.
MongoDB is an open-source and cross-platform NoSQL database system developed by MongoDB Inc. It is 100 times faster than a traditional database system like RDMS. It uses JSON-like documents to store its data. It is used in many modern web applications because it can be easily integrated with several programming languages. It is used by many big companies including, Uber, Stack, Lyft, Accenture, and many more.
EtherCalc is an open-source and web-based spreadsheet that allows you to collaborate and work remotely and in real-time. It allows multiple users to edit the same spreadsheet at the same time. It is an alternative to Google Sheets and accepts various mathematical formulas and functions.
In this tutorial, we will show you how to install EtherCalc on a CentOS 8 VPS.