CyberShake Database Server Requirements: Difference between revisions

From SCECpedia
Jump to navigationJump to search
← Older editNewer edit →
Scottcal (talk | contribs)
8,097 edits
No edit summary
Scottcal (talk | contribs)
8,097 edits
No edit summary
Line 1: Line 1:
Here are a list of requirements for a CyberShake production database server.
Below are a list of requirements for CyberShake database servers, hosted at CARC.


*Linux OS (Fedora, current version is 33)
== Focal ==
*MariaDB (10.1.48 is the current 10.1 version.  10.1.25 was probably the version installed on moment.)
*SQLite (current version is 3.35.4)


Additionally, the RAID array containing the CyberShake database data should be mounted, and MariaDB configured to use it.
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
Retrieved from "https://strike.scec.org/index.php?title=CyberShake_Database_Server_Requirements&oldid=27671"