Jama Connect User Guide

Use MySQL for database server

MySQL is the recommended database server.

  1. Download and install a supported version of MySQL.

    Note

    The InnoDB engine must be enabled.

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

    create database jama character set utf8;
  3. Use the following commands to create a user called "jamauser" with the ability to access, create, and update tables within the database.

    Because that connection originates in the jamacore container running Tomcat and traffic is forwarded by the application host server, this user information is needed to configure Jama Connect.

    CREATE USER 'jamauser'@'%' IDENTIFIED BY 'password';
    GRANT ALL PRIVILEGES ON jama.* TO 'jamauser'@'%'.

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

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

Property

Typical Installation

Enterprise Installation

max_allowed_packet

1G

1G

query_cache_type

1

1

query_cache_size

256M

256M

tmp_table_size

2G

2G

max_heap_table_size

2G

2G

table_open_cache

512

512

innodb_buffer_pool_size

2G

12G

innodb_log_file_size

256M

256M

innodb_log_buffer_size

12M

12M

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:

ignore_builtin_innodb
bind-address=0.0.0.0
key_buffer_size=16M
max_allowed_packet=1G
thread_stack=192K
thread_cache_size=8
myisam-recover-options=BACKUP
query_cache_type=1
query_cache_size=256M
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