Page History
...
Code Block | ||||
---|---|---|---|---|
| ||||
wget https://repo.open.catalyst.harvard.edu/nexus/content/groups/public/net/shrine/shrine-setup/2.0.0/shrine-setup-3.0.0-dist.zip -O shrine-setup.zip unzip shrine-setup.zip |
In that directory find two three database update scripts for your brand of database: adapterAuditDB-update-brand.sql and shrine_query_history-update-mysql.sql . Run each of the appropriate scripts on your databases. For MariaDB run the following:
Code Block | ||||
---|---|---|---|---|
| ||||
mysql -u shrine -pdemouser adapterAuditDB < shrine-setup/adapter/sql/adapterAuditDB-update-mysql.sql mysql -u shrine -pdemouser shrine_query_history < shrine-setup/adapter/sql/shrine_query_history-update-mysql.sql mysql -u shrine -pdemouser qepAuditDB < shrine-setup/adapter/sql/qepAuditDB-update-mysql.sql |
For MS SQL and Oracle, run the scripts appropriate for your databases.
...
Increase the number of connections to mariadb from the default 151 to at minimum 2049. In /etc/my.cnf add a max_connnections value.
|
Overview
Content Tools