Hi, Set up an on-premises Odoo deployment involves considering various factors to optimal performance and scalability. Below are some recommendations to help you plan your infrastructure.

(1)VMs and Resource Allocation:

Heavy Usage VM: Role: Application Server, CPU: 4–6 cores, Memory: 16-32 GB RAM

Database VM:-Role: Database Server, CPU: 8–12 cores, Memory: 32-64 GB RAM

Storage: Use SSDs for the database to enhance performance.

Web Server VM (Optional):- Role: Nginx/Apache for serving static content. CPU: 2–4 cores, Memory: 8-16 GB RAM

Notes:Depending on the actual load, you might need to adjust these values.

      Implement load balancing for application servers if necessary.

(2) Separation of Application Server and Database Server,

Separation: Yes, it is generally recommended to separate the application server from the database server for better scalability and performance.

(3) Staging Environments:- Use separate VMs for development and testing. Utilize Odoo.sh for these environments if possible, or set up separate on-premises VMs with a copy of your production database for testing purposes.

Production Maintain a separate VM for the production environment.

Additional Considerations Backup Strategy:- Implement a robust backup strategy and consider regular database backups and off site storage.

Security:- Implement security best practices, including firewalls, intrusion detection systems, and regular security audits.

Scalability:- Consider monitoring tools for performance analysis and capacity planning.

Network:- Ensure high speed, reliable networking between application and database servers.

SSL Termination:- If using HTTPS, consider terminating SSL at the web server for improved performance. And web caching mechanisms to improve website performance.

Thank you!