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/23 10:22]
angelos [On-premise installation]
system_requirements [2022/03/23 11:18] (current)
Line 12: Line 12:
 | Network interface ​   | 100MBps | 1Gigabit| | Network interface ​   | 100MBps | 1Gigabit|
  
- * SQLServer on same machine ​or otherwise? +SQL Server can also be installed in a separate ​machine. The requirements for the computer hosting only SQL Server are the following: 
- CPU / Number of cores + 
- * Memory +^ Component ​     ^ Minimum ​      ^ Suggested ​         ^ 
- * SQLite requirements?​+CPU cores    | 4     | 8        | 
 +| RAM    | 8GB | 16GB | 
 +| Disk    | 250GB HDD | 500GB SSD | 
 +| Network interface ​   | 100MBps | 1Gigabit|
  
 === Additional comments regarding SQLServer === === Additional comments regarding SQLServer ===
- +SQL Server ​Express can be used but poses two limitations which have to be taken into account: 
-SQL CE vs. "​full" ​SQL Server+  - 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.1648020172.txt.gz · Last modified: 2022/03/23 10:22 by angelos