User Tools

Site Tools


system_requirements

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
system_requirements [2022/03/21 12:39]
yves
system_requirements [2022/03/23 11:18] (current)
Line 5: Line 5:
 ==== On-premise installation ==== ==== On-premise installation ====
  
- * SQLServer on same machine or otherwise? +^ Component ​     ^ Minimum ​      ^ Suggested ​         ^ 
- CPU / Number of cores +CPU cores    | 4     | 16        | 
- * Memory +| RAM    | 8GB | 16GB | 
- * SQLite requirements?​+| Disk    | 250GB HDD | 500GB SSD | 
 +| Cache disk    | 100GB HDD     | 1TB HDD | 
 +| Network interface ​   | 100MBps | 1Gigabit|
  
-=== Additional comments regarding SQLServer ===+SQL Server can also be installed in a separate machine. The requirements for the computer hosting only SQL Server are the following:
  
-SQL CE vs. "​full" ​SQL Server+^ Component ​     ^ Minimum ​      ^ Suggested ​         ^ 
 +| CPU cores    | 4     | 8        | 
 +| RAM    | 8GB | 16GB | 
 +| Disk    | 250GB HDD | 500GB SSD | 
 +| Network interface ​   | 100MBps | 1Gigabit| 
 + 
 +=== Additional comments regarding SQLServer === 
 +SQL Server ​Express can be used but poses two limitations which have to be taken into account: 
 +  - The maximum database size cannot exceed 10GB. 
 +  - Only one CPU core is used to execute queries.
  
 ==== Installation on an AWS Virtual Machine ==== ==== Installation on an AWS Virtual Machine ====
  
- * EC2 requirements +When installing PMA.core on AWSit is highly recommended to use RDS to host SQL Server instead of installing it on the VM that PMA.core will be installed.
- ​* ​RDS requirements,​  +
- * store slides on local hard disk (additional partition configured ​on the EC2 instance) on S3 bucket storage?+
  
 +^ Component ^ Minimum ^ Suggested ^
 +| PMA.core VM size| t3.large | t3.xlarge |
 +| SQL Server RDS VM size| t3.medium | t3.large |
 +| Cache disk | 100GB EBS | 1TB EBS |
 +
 +Additionally,​ slides can be stored either on local disks attached to the VM or in S3 buckets.
 ==== Installation on an Azure Virtual Machine ==== ==== Installation on an Azure Virtual Machine ====
  
- * VM requirements +When installing PMA.core ​on Azure, it is highly recommended to use the Azure SQL Server service to host SQL Server instead of installing it on the VM that PMA.core will be installed. 
- * SQLServer requirements + 
- * store slides on local hard disk (additional partition configured ​on the EC2 instance) ​on Azure (blob/​table/​data lake?) storage?+^ Component ^ Minimum ^ Suggested ^ 
 +| PMA.core VM size| D2as v5 | D4as v5 | 
 +Azure SQL Server RDS VM size| A2m v2 | A4 v2 | 
 +| Cache disk | 100GB standard HDD | 1TB standard HDD |
  
-==== Additional information ​on cache storage ​requirements ====+Additionally,​ slides can be stored either ​on local disks attached to the VM or in Azure Blob Storage. 
 +When possible, it is recommended to prefer [[https://​docs.microsoft.com/​en-us/​azure/​storage/​blobs/​data-lake-storage-introduction|Azure Data Lake Storage Gen2]] over plain Azure Blob Storage, as this type of service performs directory management operations, such as moving and renaming slides and directories,​ a lot faster.
  
system_requirements.1647855572.txt.gz · Last modified: 2022/03/21 12:39 by yves