Page History
...
Code Block | ||||
---|---|---|---|---|
| ||||
wget https://repo.open.catalyst.harvard.edu/nexus/content/groups/public/net/shrine/shrine-setup/3.01.0/shrine-setup-3.01.0-dist.zip -O /tmp/shrine-setup.zip unzip -d /tmp /tmp/shrine-setup.zip |
In that directory find three the following database update scripts script for your brand of database: adapter/adapterAuditDB-update-brand.sql, adapter/shrine_query_history-update-mysql.sql and qep/update-brand.sql . Run each of the appropriate scripts script on your databasesdatabase. For MariaDB run the following shell commands:
Code Block | ||||
---|---|---|---|---|
| ||||
mysql -u shrine -pYourPassword adapterAuditDB < /tmp/shrine-setup/adapter/sql/adapterAuditDB-update-mysql.sql mysql -u shrine -pYourPassword shrine_query_history < /tmp/shrine-setup/adapter/sql/shrine_query_history-update-mysql.sql mysql -u shrine -pYourPassword qepAuditDB < /tmp/shrine-setup/qep/sql/update-mysql.sql |
For MS SQL and Oracle, run the scripts appropriate for your databases.
Increase the Number of Connections (MariaDB Only)
Increase the number of connections to mariadb from the default 151 to at minimum 2049. In /etc/my.cnf add a max_connnections value.
...
language | bash |
---|---|
theme | RDark |
...
Overview
Content Tools