Difference between revisions of "CyberShake Database Server Requirements"

From SCECpedia
Jump to navigationJump to search
Line 30: Line 30:
  
 
== Moment ==
 
== Moment ==
 +
 +
Moment is the production database for CyberShake, used to keep track of CyberShake runs, store intensity measures, and produce hazard curves.
 +
 +
=== Configuration ===
  
 
==== Hardware ====
 
==== Hardware ====

Revision as of 20:05, 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

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 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