more quick actions
minimize quick actions
Topic starter
Hello,
Russian team is working on commercial offer for a Web project. There are 7 factories in different cities. We need to develope a web portal to provide access for real and historical data from all factories for some users and for one predifined factory for another users. I applied for my message an architecture of the project. We are going to set PCVue station to collect data from PLC and SCADA on each factory. All PcVue stations will send real time data to centralized PcVue server by VPN. One factory has 500 variables, every other contents 250 variables. So total variables is 2000. The total quantity of web users are 45: 10 users have access for all factories and 5 users for each factiories.
We are afraid of such load on centralized mobility server and acqusition all data in central SQL DB using VPN.
Does anybody have experience with such projects?
Do you knoow any ways to make webportal more reliable?
Also we think about using Azure for SQL date base instead of the SQL on centralized server.
Posted : 27/04/2021 6:23 pm
There is small comment to Marina's question.
The factories don't need any information about each other. Only ten users may has access for all factories. But each of them may has access only to single factory at same time.
May it possible to create a single "pull" of web licences and grant them when it required?
Pavel
Posted : 27/04/2021 10:13 pm
Hi Marina,
First of all, I have moved the topic to the Internal Forum which is more adapted.
Now, about your questions:
- You didn't specify where is located the Web Backend but I assume it is in a Cloud platform (Azure probably)
- In your diagram you must add another component on the Central: The Web Server which is on a DMZ
- Don't be afraid about the load of the web backend, 2000 variables is quite small. You just have to take care the VPN performance.
- You must take care of the number of concurrent web users which is 40. I advise you optimize the mimic number of graphic objects
- About SQL Server: HDS is not compatible with Azure SQL, therefore you will have to install SQL Server on the VM as a standard project
- You must take care of the behaviour when the connection between the backend and 1 site is Off. Do the customer needs a synchronization between the local and central SQL?
To finish: I think the Forum is not really the good place to debate about that kind of subject. If you want, we can organize a meeting to talk about.
Nico
Posted : 28/04/2021 1:36 pm