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. | Below are a list of requirements for CyberShake database servers, hosted at CARC. | ||
| − | == | + | == Moment == |
| − | + | Moment is the production database for CyberShake, used to keep track of CyberShake runs, store intensity measures, and produce hazard curves. | |
=== Configuration === | === Configuration === | ||
| Line 9: | Line 9: | ||
==== Hardware ==== | ==== Hardware ==== | ||
| − | * | + | *128 GB RAM |
*6-8 TB hard drive space, ideally SSD+redundancy (RAID 5?) | *6-8 TB hard drive space, ideally SSD+redundancy (RAID 5?) | ||
| Line 19: | Line 19: | ||
<pre> | <pre> | ||
innodb_file_per_table = 1 | innodb_file_per_table = 1 | ||
| − | innodb_buffer_pool_size = | + | innodb_buffer_pool_size = 102G |
innodb_buffer_pool_instances = 8 | innodb_buffer_pool_instances = 8 | ||
| − | query_cache_type = | + | query_cache_type = 0 |
| − | |||
tmp_table_size = 64M | tmp_table_size = 64M | ||
max_heap_table_size = 64M | max_heap_table_size = 64M | ||
| Line 30: | Line 29: | ||
*screen | *screen | ||
| − | |||
| − | + | == 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. It should be optimized for fast read access. | ||
=== Configuration === | === Configuration === | ||
| Line 38: | Line 38: | ||
==== Hardware ==== | ==== Hardware ==== | ||
| − | * | + | *At least 64 GB RAM |
*6-8 TB hard drive space, ideally SSD+redundancy (RAID 5?) | *6-8 TB hard drive space, ideally SSD+redundancy (RAID 5?) | ||
| Line 48: | Line 48: | ||
<pre> | <pre> | ||
innodb_file_per_table = 1 | innodb_file_per_table = 1 | ||
| − | innodb_buffer_pool_size = | + | innodb_buffer_pool_size = 52G |
innodb_buffer_pool_instances = 8 | innodb_buffer_pool_instances = 8 | ||
| − | query_cache_type = | + | query_cache_type = 1 |
| + | query_cache_size = 64M | ||
tmp_table_size = 64M | tmp_table_size = 64M | ||
max_heap_table_size = 64M | max_heap_table_size = 64M | ||
Revision as of 20:01, 13 March 2023
Below are a list of requirements for CyberShake database servers, hosted at CARC.
Contents
Moment
Moment is the production database for CyberShake, used to keep track of CyberShake runs, store intensity measures, and produce hazard curves.
Configuration
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.d/* MariaDB config files, and restart the DB server. If not possible, please set the following values:
innodb_file_per_table = 1
innodb_buffer_pool_size = 102G
innodb_buffer_pool_instances = 8
query_cache_type = 0
tmp_table_size = 64M
max_heap_table_size = 64M
innodb_log_file_size = 2G
- SQLite, current stable release (3.41.0 as of 3/7/23).
- screen
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. It should be optimized for fast read access.
Configuration
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.d/* MariaDB config files, 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 = 1
query_cache_size = 64M
tmp_table_size = 64M
max_heap_table_size = 64M
innodb_log_file_size = 2G
- SQLite, current stable release (3.41.0 as of 3/7/23).
- screen
