Odoo Server (MOVED TO GITHUB)

How to size the server for an OpenERP installation

Asked by Pedro Rene Amezcua Ruano

Which factors should be considered to size the Server to run an OPENERP?

We will install a openeERP to handle a small business in the Textil arena, they produce kids clothes. they handle thier environment using excel to keep track of all activities/labor/raw materials (fabrics, cutting, buttons, bordering, etc).

We consider this as a small business, and they want to have all modules from OpenERP (sales, warehouse, production, account).

We plan to have Linux as the SO/environmet

Which server (HW) they could use? how many cores, RAM? This is because we do not want to size something small that produce slow or erratic responses time. Most of the user/activities should run as local LAN, although the have around 10 stores that could access the system to look at inventory.

Regarding storage, do you have formula or experience on how much GB consumes the postgresSQL. I understand that it depends on the amount of user data, but which should be considered as minimum? in the manufacturing

Question information

Language:
English Edit question
Status:
Answered
For:
Odoo Server (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Cuong (bhcuong2008) said : 		#1

Hi,

I'm not an expert in deploying OpenERP server. But I have some suggestions based on your figures

1. 2-way mainboard for upgrade later easily, I prefer Supermicro

2. 1 x CPU Intel Xeon Quad core 5600 series, could add one later (total 2 CPUs)

3. 8 GB RAM DDR3 1333 Full Buffer

4. In production, you should use RAID card for storage for safety/performance reason. (RAID-5/RAID-6, RAID 6 is better). use multiple 250GB / 320GB hard drives. If possible, you could use SAS drives for better performance.

According to my estimation, it costs about 1500-2000 USD.

If economic, you could use 1-way mainboard, 1 CPU Intel Xeon 3400 series. With this configuration, it costs about 900 - 1500 USD.

Regards,

Revision history for this message
Cuong (bhcuong2008) said : 		#2

Hi,

I'm not an expert in deploying OpenERP server. But I have some suggestions based on your figures

1. 2-way mainboard for upgrade later easily, I prefer Supermicro

2. 1 x CPU Intel Xeon Quad core 5600 series, could add one later (total 2 CPUs)

3. 8 GB RAM DDR3 1333 Full Buffer

4. In production, you should use RAID card for storage for safety/performance reason. (RAID-5/RAID-6, RAID 6 is better). use multiple 250GB / 320GB hard drives. If possible, you could use SAS drives for better performance.

According to my estimation, it costs about 1500-2000 USD.

If economic, you could use 1-way mainboard, 1 CPU Intel Xeon 3400 series. With this configuration, it costs about 900 - 1500 USD.

Regards,

Revision history for this message
Numérigraphe (numerigraphe) said : 		#3

I humbly suggest you save on hardware and buy something useful instead: more training for your team, better internet connection...
New hardware (particularly storage) is always faster and cheaper - don't by it until you really need the boost.
You don't need to oversize your server. Scaling up should be very easy when you need it:
- you can change the server an move the database without a real migration
- you can easily split the server, the web client and the database to distinct hosts
- with a bit of work you can set up multiple servers and web clients on distinct hosts and balance the load.

For a project similar to yours we bought a cheap 1U server 2 years ago: 1 quad-core CPU, 4Gb RAM and 250GB SATA software RAID1. It's still oversized for our current 5 users, and we expect it will do just fine when all 50 users bump in.
If it doesn't, well, we'll buy the next cheapest server from Dell and that will still be cheaper that oversizing in the first place.

Can you help with this problem?

Provide an answer of your own, or ask Pedro Rene Amezcua Ruano for more information if necessary.

To post a message you must log in.