# Server recomendation

**URL:** <https://forum.inductiveautomation.com/t/server-recomendation/43170>\
**Category:** Ignition\
**Created:** [February 9, 2021, 12:37pm UTC](https://forum.inductiveautomation.com/t/server-recomendation/43170 "2021-02-09T12:37:02Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![zarkokv](https://avatars.discourse-cdn.com/v4/letter/z/73ab20/32.png) [@zarkokv](https://forum.inductiveautomation.com/u/zarkokv)\
**Post date:** [February 9, 2021, 12:37pm UTC](https://forum.inductiveautomation.com/t/server-recomendation/43170/1 "2021-02-09T12:37:02Z")

</div>

Hello,  
I have project of monitoring remote location over GSM network using ModbusTCP protocol. I will have 10000 tags total. From that, I will have historian on 100 tags, one tag per location. Number of users would be max 10.  
What system requirements you suggest? How to know how big will be database and how large storage to buy?  
Thank you in advance.

---

<div class="post-metadata">

**Author:** ![jgooding](https://avatars.discourse-cdn.com/v4/letter/j/a88e4f/32.png) [@jgooding](https://forum.inductiveautomation.com/u/jgooding)\
**Post date:** [February 9, 2021, 2:17pm UTC](https://forum.inductiveautomation.com/t/server-recomendation/43170/2 "2021-02-09T14:17:02Z")

</div>

This is a little hard to recommend. What is your tag update rate? How long do you want the data for?

I recommend you setup a simple PC and run a trial to see what you get. Call IA and see if you can get a 30 day trial license and that should provide you all the answers you need. You do not need a lot of hardware to run that simple of a system. A modern desktop PC running Linux would probably do it.

For example, I have 34 million records (every time a tag changes) and it takes up 1.64GB. Their are techniques to keep your historian from being too large and they are based on how much of a change you want to notice. The historian records a timestamp and a value. I can tell it to only record a new value when the tag changes by x%. See [https://docs.inductiveautomation.com/display/DOC81/Configuring+Tag+History](https://docs.inductiveautomation.com/display/DOC81/Configuring+Tag+History)

Then when it pulls the data back your tell it what you want it to do with the data between the two time stamps. If I do not have any data it interpolates between the two values. Here is the manual if you have questions.  
[https://docs.inductiveautomation.com/display/DOC81/Tag+Historian#TagHistorian-TagHistorianQuerying](https://docs.inductiveautomation.com/display/DOC81/Tag+Historian#TagHistorian-TagHistorianQuerying)

This is how the historian store values is SQL:

| tagid | intvalue | floatvalue | stringvalue | datevalue | dataintegrity | t\_stamp |
| --- | --- | --- | --- | --- | --- | --- |
| 852 | NULL | 248.406433105469 | NULL | NULL | 192 | 1612161575184 |
| 852 | NULL | 248.26676940918 | NULL | NULL | 192 | 1612161576183 |

---

<div class="post-metadata">

**Author:** ![zarkokv](https://avatars.discourse-cdn.com/v4/letter/z/73ab20/32.png) [@zarkokv](https://forum.inductiveautomation.com/u/zarkokv)\
**Post date:** [February 9, 2021, 2:39pm UTC](https://forum.inductiveautomation.com/t/server-recomendation/43170/3 "2021-02-09T14:39:03Z")

</div>

> [@jgooding](#):
>
> What is your tag update rate? How long do you want the data for?

First, thank you very much for detail answer.  
Tag update rate will be on every minute and I will need to keep data for one year period.  
Maybe server with 4 CPU core, 16 GB of RAM and 1TB HDD would be OK for long run?

---

<div class="post-metadata">

**Author:** ![brandon1](https://avatars.discourse-cdn.com/v4/letter/b/ea666f/32.png) [@brandon1](https://forum.inductiveautomation.com/u/brandon1)\
**Post date:** [February 9, 2021, 2:59pm UTC](https://forum.inductiveautomation.com/t/server-recomendation/43170/4 "2021-02-09T14:59:21Z")

</div>

I would recommend 32GB of RAM just because RAM is so cheap. Also consider using a 1TB M.2 SSD because it just so much faster and it will help you tremendously when you run queries.

You may want a larger HDD (4TB?) to do backups of your system. Hope you find this helpful and welcome to the Ignition community! 😀

---

<div class="post-metadata">

**Author:** ![zarkokv](https://avatars.discourse-cdn.com/v4/letter/z/73ab20/32.png) [@zarkokv](https://forum.inductiveautomation.com/u/zarkokv)\
**Post date:** [February 9, 2021, 4:36pm UTC](https://forum.inductiveautomation.com/t/server-recomendation/43170/5 "2021-02-09T16:36:52Z")

</div>

Thank you. Glad to be part of Ignition community.

---

<div class="post-metadata">

**Author:** ![zarkokv](https://avatars.discourse-cdn.com/v4/letter/z/73ab20/32.png) [@zarkokv](https://forum.inductiveautomation.com/u/zarkokv)\
**Post date:** [February 10, 2021, 8:32am UTC](https://forum.inductiveautomation.com/t/server-recomendation/43170/6 "2021-02-10T08:32:11Z")

</div>

> [@brandon1](#):
>
> I would recommend 32GB of RAM just because RAM is so cheap. Also consider using a 1TB M.2 SSD because it just so much faster and it will help you tremendously when you run queries.
> 
> You may want a larger HDD (4TB?) to do backups of your system.

Yes, RAM and SSD are cheap but only when we speak about desktop PC components. Server components are much more expensive. RAM maybe not so much but SSD... 😳

---

<div class="post-metadata">

**Author:** ![brandon1](https://avatars.discourse-cdn.com/v4/letter/b/ea666f/32.png) [@brandon1](https://forum.inductiveautomation.com/u/brandon1)\
**Post date:** [February 10, 2021, 1:01pm UTC](https://forum.inductiveautomation.com/t/server-recomendation/43170/7 "2021-02-10T13:01:36Z")

</div>

Fair point. But you have to admit they are steadily going down in price. If you want to better future proof this build, SSD is the way to go. Just my 2 cents though.

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [February 10, 2021, 1:18pm UTC](https://forum.inductiveautomation.com/t/server-recomendation/43170/8 "2021-02-10T13:18:10Z")

</div>

> [@zarkokv](#):
>
> 4 CPU core, 16 GB of RAM and 1TB HDD

I take it the intention is to put the Database and the Gateway on the same server?

If so depending on what DB you plan to use you will most likely need more RAM.

I wouldn't recommend having the Gateway and DB on the same server but if you don't have an option, then it will work.

---

<div class="post-metadata">

**Author:** ![zarkokv](https://avatars.discourse-cdn.com/v4/letter/z/73ab20/32.png) [@zarkokv](https://forum.inductiveautomation.com/u/zarkokv)\
**Post date:** [February 10, 2021, 1:42pm UTC](https://forum.inductiveautomation.com/t/server-recomendation/43170/9 "2021-02-10T13:42:08Z")

</div>

> [@lrose](#):
>
> I take it the intention is to put the Database and the Gateway on the same server?

Yes, Database and Gateway will be on same server. I was planing to use MySQL.

---

<div class="post-metadata">

**Author:** ![jgooding](https://avatars.discourse-cdn.com/v4/letter/j/a88e4f/32.png) [@jgooding](https://forum.inductiveautomation.com/u/jgooding)\
**Post date:** [February 10, 2021, 2:33pm UTC](https://forum.inductiveautomation.com/t/server-recomendation/43170/10 "2021-02-10T14:33:51Z")

</div>

I would look at your architecture a little more. You have a GSM cellular network. I am assuming that you want to pull tags back real-time at the lowest total cost. You need to get those tags from the devices and sent back to the server you want to store the data on. Where are your users versus your devices? What side of the network on they on _Local or Remote_?

Most of us have a wired network so network traffic does not present that much of an ongoing cost ( **much** ). For you the network traffic across the GSM radio is going to be significant. Ignition does a really cool thing with tags that if no one is looking at that tag and your are not recording it to history it does not poll the tag. It does poll the controller to make sure it is online but your will reduce your traffic.

All of my servers are sitting on IT’s network with virtualized with separate SQL machines versus the application machine.

You may want to place remote machines on the local device networks (maybe consider Ignition Edge devices). Let them act as the gateway to the devices. They can store the local data and be called on when someone wants to look at a parameter remotely. The local machine can then control the store and forward to your historian to make it more reliable.  
[https://docs.inductiveautomation.com/display/DOC81/Store+and+Forward](https://docs.inductiveautomation.com/display/DOC81/Store+and+Forward)

Ignition is really easy to get up and running but to configure and optimize it takes some effort and thought. I recommend talking to your sales rep about your specific use case and they can provide some really valuable insights and recommendations.

---

<div class="post-metadata">

**Author:** ![zarkokv](https://avatars.discourse-cdn.com/v4/letter/z/73ab20/32.png) [@zarkokv](https://forum.inductiveautomation.com/u/zarkokv)\
**Post date:** [February 10, 2021, 3:01pm UTC](https://forum.inductiveautomation.com/t/server-recomendation/43170/11 "2021-02-10T15:01:45Z")

</div>

> [@jgooding](#):
>
> Where are your users versus your devices? What side of the network on they on _Local or Remote_ ?

Users will connect through Internet, over VPN. I would really like to call some one for recommendations but there is no Inductive Automation representative in Serbia.  
But Inductive University and this forum are gold.

---

<div class="post-metadata">

**Author:** ![ross.moffett](https://avatars.discourse-cdn.com/v4/letter/r/6bbea6/32.png) [@ross.moffett](https://forum.inductiveautomation.com/u/ross.moffett)\
**Post date:** [February 15, 2021, 8:10pm UTC](https://forum.inductiveautomation.com/t/server-recomendation/43170/12 "2021-02-15T20:10:18Z")

</div>

Most cloud computer providers will give you a few hundred dollars in trial credits for you to figure this out. They track every metric you’d want to know and you may decide that’s a lot better and easier than running your own bare metal because you can scale it with the click of a mouse as needed.

---

<div class="post-metadata">

**Author:** ![zarkokv](https://avatars.discourse-cdn.com/v4/letter/z/73ab20/32.png) [@zarkokv](https://forum.inductiveautomation.com/u/zarkokv)\
**Post date:** [March 5, 2021, 10:39am UTC](https://forum.inductiveautomation.com/t/server-recomendation/43170/13 "2021-03-05T10:39:18Z")

</div>

> [@lrose](#):
>
> I wouldn’t recommend having the Gateway and DB on the same server but if you don’t have an option, then it will work.

Hello @lrose,  
I managed to convince company managment that we need backup server. So this will be situation with Ignition Master and Backup server. What would be recomendation for DB?  
Do I need DB on both server, or just on one (backup server). DB is MySQL.

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [March 5, 2021, 1:18pm UTC](https://forum.inductiveautomation.com/t/server-recomendation/43170/14 "2021-03-05T13:18:59Z")

</div>

> [@zarkokv](#):
>
> Do I need DB on both server, or just on one (backup server). DB is MySQL.

Neither, if you are trying to provide redundancy, then you will need the DB on a server that is reachable from both the Master and Backup, but not dependent on either.

A separate server for the DB is the best solution.
