You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Update Schema

Download shrine-setup.zip in temporary directory and unpack it.


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 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:

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

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.

[mysqld_safe]
max_connections = 20
  • No labels