Page Comparison

...

Configure InnoDB as the default by adding the following line under the [mysqld] directive. 

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

[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.

# 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

# 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  

...