Hello,
For a distributed installation of FME Server, what are the database requirements? I imagine it will vary a bit based on number of jobs, engines, and such, but is there a rough guideline for the volume of data the server will need to store?
Solved
FME Server Database Specs
Best answer by geosander
You mean for the internal database? I wouldn't know exactly, but unless you have a ridiculously large setup, I wouldn't worry about it.
The database is only used to store some basic job properties, queues, engine properties and stats. Nothing major (especially if you run cleanup jobs every now and then), and the CRUD-traffic is low. I am quite sure that you can even run it next to your FME Server core (same machine) without affecting performance, especially if it uses an SSD.
Rather focus on enough RAM and (SSD) disk space on your engine machines!
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+7You mean for the internal database? I wouldn't know exactly, but unless you have a ridiculously large setup, I wouldn't worry about it.
The database is only used to store some basic job properties, queues, engine properties and stats. Nothing major (especially if you run cleanup jobs every now and then), and the CRUD-traffic is low. I am quite sure that you can even run it next to your FME Server core (same machine) without affecting performance, especially if it uses an SSD.
Rather focus on enough RAM and (SSD) disk space on your engine machines!
+6- Contributor
- 93 replies
Hi, The FME Server DB is extremely small, i think it is about 100MB +/-
The up-time of the FME Server DB is critical, without that not a lot works.
Ours run in the Corporate SQL Server farm, with high availability.