Why is bind-address set to 127.0.0.1 in MariaDB?

Setting bind-address to 127.0.0.1 ensures MariaDB only accepts local connections from Frappe Bench workers, preventing external network access to database ports.

Back to Projects

EnterpriseLIVE

ERPNext v15 Production Deployment & Server Optimization🔒

Enterprise Confidential

Production-grade ERPNext v15 deployment & server optimization on Ubuntu 22.04 LTS with Frappe Framework, MariaDB, Redis, NGINX, Supervisor, and AWS EC2.

Deployed and configured ERPNext v15 on a production Ubuntu 22.04 LTS server. Performed installation, server configuration, application testing, performance optimization, and production validation to ensure all ERP services operated reliably. Optimized the deployment environment for stability, security, and day-to-day production usage.

Engineering Impact

DEPLOYMENT SPEED< 15 Mins Setup

AUTOMATION LEVEL95% Automated

Technology Stack

Amazon Web Services (AWS)Amazon EC2Ubuntu 22.04 LTSERPNext v15Frappe FrameworkMariaDBRedisPythonNode.jsNGINXSupervisorLinuxShell Scripting

System Architecture & Overview

Multi-tiered Enterprise ERP architecture running Frappe Framework v15, backed by MariaDB transactional database, dual Redis instances (cache + queue worker), and NGINX web proxy.