Skip to main content

Jama Connect User Guide

Install and configure MySQL

MySQL is the recommended database server. Follow these steps to install and configure it.

Important considerations

  • Before installing Jama Connect 8.62.x, you must create two additional database schemas for the installation/upgrade to succeed (see step 3).

  • If you want to upgrade MySQL, see Upgrade and configure MySQL.

To install and configure MySQL:

  1. Make sure that the InnoDB engine is enabled.

  2. Download and install a supported version of MySQL. To find out which version of MySQL you need, see Supported software, environments, and system requirements and click the link for your version of Jama Connect.

  3. On the MySQL database server:

    1. Create an empty Jama Connect schema / database that uses UTF8:

      CREATE DATABASE jama character set utf8mb4;
    2. On the MySQL database server, create two additional database schemas and a user ("jamauser") with the ability to access, create, and update tables within the database:

      CREATE DATABASE jama character set utf8mb4;
      CREATE DATABASE saml;
      CREATE DATABASE oauth;
      CREATE USER 'jamauser'@'%' IDENTIFIED BY 'password';
      CREATE USER 'oauthuser'@'%' IDENTIFIED BY 'password';
      CREATE USER 'samluser'@'%' IDENTIFIED BY 'password';
      GRANT ALL PRIVILEGES ON jama.* TO 'jamauser'@'%';
      GRANT ALL PRIVILEGES ON oauth.* TO ‘oauthuser’@‘%’;
      GRANT ALL PRIVILEGES ON saml.* TO ‘samluser’@‘%’;
    3. (KOTS only) To enable horizontal scaling in KOTS, run these commands:

      CREATE DATABASE quartz;      
      CREATE USER 'quartzuser'@'%' IDENTIFIED BY 'password';            
      GRANT ALL PRIVILEGES ON quartz.* TO 'quartzuser'@'%';
  4. Restart the database server.

The following recommended settings require 8 GB of memory allocated to MySQL Server for a typical installation and 16 GB for an enterprise installation.

Depending on your database server's operating system, this can be added to your my.cnf file (Linux) or my.ini file (Windows). You can also make these changes directly to the database.

Property

Typical Installation

Enterprise Installation

max_allowed_packet

1 GB

1 GB

tmp_table_size

2 GB

2 GB

max_heap_table_size

2 GB

2 GB

table_open_cache

512

512

innodb_buffer_pool_size

2 GB

12 GB

innodb_log_file_size

256 MB

256 MB

innodb_log_buffer_size

12 MB

12 MB

innodb_thread_concurrency

16

16

max_connections

151

351

wait_timeout

259200

259200

Here is a sample text config file at an enterprise level. You must add the following values for your environment:

bind-address=0.0.0.0
key_buffer_size=16M
max_allowed_packet=1G
thread_stack=192K
thread_cache_size=8
tmp_table_size=2G
max_heap_table_size=2G
table_open_cache=512
innodb_buffer_pool_size=12G
innodb_log_file_size=256M
innodb_log_buffer_size=12M
innodb_thread_concurrency=16
max_connections=351
wait_timeout=259200