...
uPortal relies on database transactional support, which in MySQL is dependent upon the underlying storage engine (per-table). The default (MyISAM) is not transaction safe. The most common transactional table type on MySQL is InnoDB. You configure InnoDB as the default:
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
[mysqld] default-storage-engine=innodb |
...
MySQL table names are case-sensitive depending on the filesystem of the server. e.g. insensitive on Windows & Mac HFS+, Case sensitive on Unix. To prevent issues when moving between platforms it is recommended that you set:
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 | ||||||
---|---|---|---|---|---|---|
| ||||||
# 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 |
...
Edit /uPortal/uportal-impl/src/main/resources/properties/rdbm.properties and add the lines for MySQL. Modify the URL, username and password as appropriate:
Code Block |
---|
##### MySQL - example hibernate.connection.driver_class=com.mysql.jdbc.Driver hibernate.connection.url=jdbc:mysql://my.school.edu:3306/portal hibernate.connection.username=test hibernate.connection.password=mypass hibernate.dialect=org.hibernate.dialect.MySQLDialect |
The /uPortal/uportal-impl/src/main/resources/properties/db/dbloader.xml properties file may also need to be modified. This file is used by the DbLoader tool to create the uPortal database tables and populate the database. It contains several sample entries which create db-type-mappings for different databases. Find the tags for an MySQL database and modify the db-version, driver-name, and driver-version as necessary. For example:
Code Block |
---|
<db-type-mapping> <db-name>MySQL</db-name> <db-version>5.0.32-Debian_7etch5-log</db-version> <driver-name>MySQL-AB JDBC Driver</driver-name> <driver-version>mysql-connector-java-5.0.8 ( Revision: ${svn.Revision} )</driver-version> <type><generic>LONGVARCHAR</generic><local>TEXT</local></type> </db-type-mapping> |
The /uPortal/uportal-impl/src/main/resources/properties/contexts/personDirectoryContext.xml properties file will also need to be modified.
...