Difference between revisions of "CyberShake Database Server Requirements"
From SCECpedia
Jump to navigationJump to search| Line 1: | Line 1: | ||
| − | + | Below are a list of requirements for CyberShake database servers, hosted at CARC. | |
| − | + | == Focal == | |
| − | |||
| − | |||
| − | + | Focal is the user-facing CyberShake database server. It is the database used by the CS Data Access Tool, as well as the database used for user queries. | |
| + | |||
| + | === Requirements === | ||
| + | |||
| + | ==== Hardware ==== | ||
| + | |||
| + | *At least 64 GB RAM | ||
| + | *6-8 TB hard drive space, ideally SSD+redundancy (RAID 5?) | ||
| + | |||
| + | ==== Software ==== | ||
| + | |||
| + | *Linux OS | ||
| + | *MariaDB, current stable release (10.11.2 as of 3/7/23). | ||
| + | *Ideally, user scottcal would be able to edit the /etc/my.cnf MariaDB config file, and restart the DB server. If not possible, please set the following values: | ||
| + | <pre> | ||
| + | innodb_file_per_table = 1 | ||
| + | innodb_buffer_pool_size = 52G | ||
| + | innodb_buffer_pool_instances = 8 | ||
| + | query_cache_type = 0 | ||
| + | tmp_table_size = 32M | ||
| + | max_heap_table_size = 32M | ||
| + | innodb_log_file_size = 2G | ||
| + | </pre> | ||
| + | *SQLite, current stable release (3.41.0 as of 3/7/23). | ||
| + | *screen | ||
| + | |||
| + | == Moment == | ||
| + | |||
| + | ==== Hardware ==== | ||
| + | |||
| + | *128 GB RAM | ||
| + | *6-8 TB hard drive space, ideally SSD+redundancy (RAID 5?) | ||
| + | |||
| + | ==== Software ==== | ||
| + | |||
| + | *Linux OS | ||
| + | *MariaDB, current stable release (10.11.2 as of 3/7/23). | ||
| + | *Ideally, user scottcal would be able to edit the /etc/my.cnf MariaDB config file, and restart the DB server. If not possible, please set the following values: | ||
| + | <pre> | ||
| + | innodb_file_per_table = 1 | ||
| + | innodb_buffer_pool_size = 52G | ||
| + | innodb_buffer_pool_instances = 8 | ||
| + | query_cache_type = 0 | ||
| + | tmp_table_size = 32M | ||
| + | max_heap_table_size = 32M | ||
| + | innodb_log_file_size = 2G | ||
| + | </pre> | ||
| + | *SQLite, current stable release (3.41.0 as of 3/7/23). | ||
| + | *screen | ||
Revision as of 20:02, 7 March 2023
Below are a list of requirements for CyberShake database servers, hosted at CARC.
Focal
Focal is the user-facing CyberShake database server. It is the database used by the CS Data Access Tool, as well as the database used for user queries.
Requirements
Hardware
- At least 64 GB RAM
- 6-8 TB hard drive space, ideally SSD+redundancy (RAID 5?)
Software
- Linux OS
- MariaDB, current stable release (10.11.2 as of 3/7/23).
- Ideally, user scottcal would be able to edit the /etc/my.cnf MariaDB config file, and restart the DB server. If not possible, please set the following values:
innodb_file_per_table = 1
innodb_buffer_pool_size = 52G
innodb_buffer_pool_instances = 8
query_cache_type = 0
tmp_table_size = 32M
max_heap_table_size = 32M
innodb_log_file_size = 2G
- SQLite, current stable release (3.41.0 as of 3/7/23).
- screen
Moment
Hardware
- 128 GB RAM
- 6-8 TB hard drive space, ideally SSD+redundancy (RAID 5?)
Software
- Linux OS
- MariaDB, current stable release (10.11.2 as of 3/7/23).
- Ideally, user scottcal would be able to edit the /etc/my.cnf MariaDB config file, and restart the DB server. If not possible, please set the following values:
innodb_file_per_table = 1
innodb_buffer_pool_size = 52G
innodb_buffer_pool_instances = 8
query_cache_type = 0
tmp_table_size = 32M
max_heap_table_size = 32M
innodb_log_file_size = 2G
- SQLite, current stable release (3.41.0 as of 3/7/23).
- screen
