...
Configure InnoDB as the default by adding the following line under the [mysqld] directive.
Code Block | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
[mysqld] default-storage-engine=innodb |
...
MySQL table names are case-sensitive depending on the filesystem of the server. (e.g. insensitive in Windows & Mac HFS+, while case sensitive in Unix.)
The SQL used in uPortal may not always be in the same case so the following line of code must be added to the my.cnf file:
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
[mysqld] lower_case_table_names=1 |
...
You can also set all of the memory, table, and connection limits as well as a host of other options.
Code Block | borderStyle | solid|||
---|---|---|---|---|
| ||||
# Example settings used for uPortal at Manchester max_connections = 1500 table_cache = 512 query_cache_size = 128M set-variable = innodb_buffer_pool_size=128M set-variable = innodb_log_file_size=256M set-variable = innodb_additional_mem_pool_size=20M set-variable = innodb_log_buffer_size=4M innodb_flush_log_at_trx_commit=1 |
Step 2: Configure the Database Filters
1. In the filters/
folder, locate the default local.properties file under uPortal-4.12.x/filters/local.properties and configure the Database Connection Settings
Code Block | ||
---|---|---|
| ||
# HSQL Configuration environment.build.hsql.port=8887 # Database Connection Settings (UncommentSample the Maven Filters section in rdbm.propertiesMySQL Configuration) environment.build.hibernate.connection.driver_class=com.mysql.jdbc.Driver environment.build.hibernate.connection.url=jdbc:mysql://my.school.edu/uPortal environment.build.hibernate.connection.username=user environment.build.hibernate.connection.password=password environment.build.hibernate.dialect=org.hibernate.dialect.MySQLDialect environment.build.hibernate.validationQuery=select 1 |
...