wso2-am - WSO2 APIM 3.0.0 MB STORE database

Question

I try to install a WSO2 3.0.0 APIM instance with the traffic-manager profile. Is it possible to configure the MB_STORE datasource to a mysql configuration through the deployment.toml file ? The master-datasources.xml is always overrided at startup with the default h2 database for the MB_STORE datasource.

标签： wso2-am

Answer 1

You can configure the MB source datasource by adding following configurations in <AM-home>/repository/conf/deployment.toml:

[[datasource]]
id = "WSO2_MB_STORE_DB"
url = "jdbc:mysql://<ip-address>:<port>/mb_store"
username = "username"
password = "password"
driver = "com.mysql.jdbc.Driver"
validationQuery = "SELECT 1"
pool_options.maxActive = 50
pool_options.maxWait = 60000
pool_options.validationInterval = 30000
pool_options.defaultAutoCommit = false

To configure the Carbon DB / AM_DB, adding following configurations is sufficient as they are pre-configured, for other databases, you need to add all the above mentioned configurations.

[database.apim_db]
type = "mysql"
url = "jdbc:mysql://localhost:3306/am_db"
username = "username"
password = "password"

[database.shared_db]
type = "mysql"
url = "jdbc:mysql://localhost:3306/reg_db"
username = "username"
password = "password"