Amazon Aurora Configuration Guide

Administrator
This manual is in pilot operation.

(fusion_place >= 10.0)

fusion_place supports Amazon Aurora, the database service provided by AWS.

Before configuring Amazon Aurora, you must complete fusion_place Setup.

Operating Environment

Aurora MySQL Configuration

The following points require special attention when configuring Aurora MySQL.

Setting the Parameter Group for Amazon RDS

Change the values for the following items in the DB Cluster Parameter Group.

Name Value

character_set_server

utf8mb4

max_allowed_packet

33554432

lower_case_table_names

1

Configuring the MySQL Client Program on the EC2 Instance

Change the MySQL client program settings on the EC2 instance running the fusion_place server. Use option files for configuration.

Client program settings do not affect the operation of the fusion_place server.

Below is an example of setting the connection character set for the mysql command to utf8mb4.

[client]
default-character-set=utf8mb4

Creating the Database Schema and Inserting Initial Data

Create the database schema and insert the system information and initial user data. To perform this task, run the initialization SQL scripts included in aurora_init_S118.zip in the following order:

  1. create_tb_watermark.mysql.S118.sql

  2. sysinit.S118.sql

  3. create_user.sql

It is recommended to execute the initialization SQL scripts using the MySQL client program of the fusion_place server with the connection character set already configured (such as the mysql command).

Configuring the fusion_place Server

Deploying the JDBC Driver

Copy the JDBC driver JAR file (e.g., aws-mysql-jdbc-1.1.1.jar, the number varies by version) into the lib subdirectory of the fusion_place installation directory.

Configuring the Application Server (Tomcat)

For the Tomcat configuration file (server.xml), change the attribute values for the following items.

Setting Environment Variables

Add or modify the following environment variables (JNDI environment properties).

<Environment name="fusionplace/concurrent_update" type="java.lang.Boolean" value="false"/> (1)
<Environment name="fusionplace/dbms" type="java.lang.String" value="MYSQL"/> (2)
1 Enables or disables concurrent updates. If you have an extreme license, you can enable this by setting value="true".

(fusion_place >= 12.0)

If the license grant type is B, the enablement of concurrent updates is controlled by the license grant file. Therefore, the setting of concurrent_update will be ignored.[2]

1 Change from the default value of H2.
Configuring the Data Source

For the fusionplace/datasource resource, add or modify the following values.

<Resource name="fusionplace/datasource"
  <!-- ... -->
  factory="org.apache.commons.dbcp.BasicDataSourceFactory" (1)
  driverClassName="software.aws.rds.jdbc.mysql.Driver" (2)
  username="{Username}" (3)
  password="{Password}" (4)
  url="jdbc:mysql://{Endpoint}:{Port}/wtm?characterEncoding=utf-8&amp;dontTrackOpenResources=true" (5)
/>
1 Add this item if it does not exist.
2 Change from the default value of org.h2.Driver.
3 Specify the username for connection.
4 Specify the password for the username for connection.
5 Specify the endpoint (hostname) and port number for write access.

1. In fusion_place 10.0.0, there is an issue where an error occurs with JDBC Driver for MySQL 8.0.20 or later. Please use fusion_place 10.0.1 or later. For details, refer to https://docs.fusionplace.net/manual/en/releases/all_releases/v10.0.html#v10_0_1.
2. For information about license grant types, see Description of License Management Dialog Fields