[client]
default-character-set=utf8mb4
Amazon Aurora Configuration Guide
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
-
Amazon Aurora MySQL Version 3
-
Amazon Aurora MySQL Version 2 (End of Support Date: 2024/10/31)
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
.
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:
-
create_tb_watermark.mysql.S118.sql
-
sysinit.S118.sql
-
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&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. |