SCG efaplus, Thailand · 2026, ongoing
Three-node Odoo 19 cluster operations
Operate a load-balanced Odoo 19 cluster on PostgreSQL 18: deployment rules, shared storage, database tuning, UAT clone and the diagnosis of a page-loading storm caused by asset bundle regeneration.
Role: Platform engineer
Odoo 19High availabilityPostgreSQL 18ProxmoxCloudflare Tunnel
Highlights
- Load balancer plus two application nodes and a dedicated database node, with a documented deploy and restart procedure per node.
- Shared document storage mounted on every node so attachments survive node failover.
- PostgreSQL 18 tuning and a targeted attachment index that removed the slowest queries.
- Resolved an “Odoo keeps loading” incident traced to two nodes regenerating asset bundles against each other.
- UAT clone on its own database port, exposed securely for client acceptance testing.
- Custom module work including a serial and lot auto-generation package for manufacturing.