Use MySQL for database server
MySQL is the recommended database server.
Download and install a supported version of MySQL.
Note
The InnoDB engine must be enabled.
Create an empty Jama Connect schema / database that uses UTF8.
create database jama character set utf8;
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