Configuring MariaDB Databases

Version

Function Description

The BI system in which you configure external databases can be more stable in cluster environments or situations with large amounts of data.

You can configure external MariaDB databases by installing the Data Migration to MariaDB plugin in the decision-making system.

Note:

1. Do not modify the usernames and passwords of the external databases configured. Otherwise, the project will fail to start.

2. If you need to modify them, see Modifying the Account and Password of the External Database.

Notes

For the BI project configured with a virtual directory, namely the FineBI system accessed directly via IP address in Tomcat, you need to modify the server configuration file before installing the project.

Open the server.xml file in %tomcat_home%\conf, and modify the value of reloadable to false (namely, reloadable=false), as shown in the following figure.

Prepare a database (empty database advised to be created) to which the platform data will be migrated. (For details about the database size, see section "Hardware Configuration.")

Note:

Different FineBI projects cannot share the same external database. Otherwise, data may become disordered.

Version/Driver

Hardware Configuration

Note:

1. You need to modify the occupied space according to the usage rate. You can configure the space to be one to two times larger than the size of the finedb folder in webapps/webroot/WEB-INF/embed (estimated size based on the actual size).

2. You are advised to use the memory reserved for the project configuration database.

3. The external database needs to be in the same network segment as the BI project to avoid network fluctuations.

Plugin Installation

You can obtain the plugin at https://community.finereport.com/plugin/?id=128.

For details about how to install the plugin, see Plugin Management.

External Database Configuration Entry

Log in to the FineBI system as the admin, and choose System Management > System Setting > General > General Parameter > External Database > To Be Configured, as shown in the following figure.

External Database Configuration

After entering the external database configuration page, select the database type and enter the corresponding information of the actual database, as shown in the following figure.

Setting Item

The following table describes the setting items.

Setting Item	Description
Database Type	Select mariadb.
Driver	Retain the default setting. This parameter will be automatically set, requiring no modification.
Database Name	For details, see the database name in section "External Database Preparation." Note: Your project must not share the database with other projects. You are advised to create a database. The database name can contain only numbers, letters, underscores, and periods (.).
Username/Host/Password/Port	Set these parameters according to the actual database information. Note: The host name can contain only numbers, letters, underscores, hyphens (-), and periods (.). You need to have the create, delete, alter, update, select, insert, and index permissions.

Migrating Data to the Database to Be Enabled

You can determine whether to select Migrate Data to Database to Be Enabled based on your own needs. The following describes the details:

1. Select Migrate Data to Database to Be Enabled when the new external database is empty.

After you click Enable New Database, the platform data of the original FineDB database will be migrated to the new external database.

2. Select Migrate Data to Database to Be Enabled when the platform data already exists in the new external database.

After you click Enable New Database, the message "The platform data already exists in the database. Before data import, the original platform data will be cleared. Sure to connect to the database?" pops up.

After you click OK, the original platform data will be cleared, and the platform data of the original FineDB database will be migrated to the new external database.

3. Deselect Migrate Data to Database to Be Enabled when the new external database is empty.

After you click Enable New Database, the message "The target database is a new database and can be used after the current data is migrated to the target database." pops up.

After you click OK, the platform data of the original FineDB database will be migrated to the new external database.

4. Deselect Migrate Data to Database to Be Enabled when the platform data already exists in the new external database.

After you click Enable New Database, the project will automatically detect whether the JAR package version corresponding to the data in the target database is consistent with that in the current project.

• If the versions are inconsistent, the message "Unable to enable it. Project version required to enable the new database: xxx Current project version: xxx Ensure that the project version is consistent." In this case, you fail to configure external databases.

• If the JAR package versions are consistent and the original FineDB database is a built-in database, the new external database is enabled directly.

• If the JAR package versions are consistent and the original FineDB database is an external database, the configuration information of the original database is automatically backed up before migration (as a result of which the db.properties.bak file is generated in webapps\webroot\WEB-INF\config), and the new external database is enabled directly, as shown in the following figure.

Successful Migration

Wait until the migration is successful. Different pop-up prompts may appear depending on the migration situation.

1. New external database using data of the original FineDB database

The message "The target database has been enabled successfully." pops up. Click OK to complete the migration, as shown in the following figure.

2. New external database using data of the original FineDB database (which is a built-in database)

The message "Successfully switched to the target database. If data is different between the old and new databases, system running may be affected. You are advised to restart the project for normal use." pops up.

Click OK and restart the BI project to complete the migration, as shown in the following figure.

3. New external database using data of the original FineDB database (which is an external database)

The following two messages pop up:

• The message "Successfully switched to the target database. If data is different between the old and new databases, system running may be affected. You are advised to restart the project for normal use." pops up.

• The original database configuration has been backed up to the config folder. You can use the backup file to restore the database configuration if necessary.

Click OK and restart the BI project to complete the migration, as shown in the following figure.

Deleting Built-in Database Data Connections

The built-in FineDB database is an HSQL database that creates an in-memory database when used. A large amount of memory will be occupied when the data volume is large.

Therefore, after configuring the external database, check whether a data connection exists for the built-in FineDB database in Data Connection Management.

If a data connection exists, delete the data connection in time. Otherwise, the connection will continue to occupy server memory.