Database Recommendations (added in v6.2.0)
Database Settings
The settings below assume that MySQL is running inside a pod or container.
| Resource or configuration | Value | Notes |
|---|---|---|
| CPU | 4-8 vCPU per instance | Although the density of database transactions is low, the periodic batch reads will be CPU-intensive. |
| Memory | 16-32 GB per instance | This is required due to the presence of CLOBS and the need for a higher buffer size for faster retrieval (Refer to innodb_buffer_pool_size for more information). |
| Storage | Approximately 50GB or higher @ 3000 IOPS | This is usually a factor of data size. A higher IOPS is desired due to the presence of CLOB columns. |
| Preferred connectivity | Use a proxy such as RDS Proxy or MySQL Router. | The proxy and router handle fail over better than the database drivers, and it is transparent to the application. |
innodb_buffer_pool_size | Memory *1/2 | This should be at least half to 2/3rd of the memory allocated to the MySQL server. |
innodb_flush_log_at_trx_commit | Set it to value: 2 | A value of 2 indicates that transaction logs wait approximately one second before they are written to physical storage. This enables CLOBS to be handled efficiently in replication. |
Client-side Connection Pool Settings
datasource.pool.maxActive
Values.trafficmanager.datasource.pool.maxActive
The default values for these attributes are sufficient for most cases. Update these values when you notice database connection time or query timeout errors. If you have any questions, consult the Boomi Account Representative.
-
Property that controls the maximum number of active connections to be maintained in the pool.
-
Impacted template:
trafficmanager-deploy.yaml -
Data Type:
integer -
Default Value:
8 -
Acceptable value: Any positive integer. Value depends on the number of connections that the database currently supports.
Values.loader.datasource.pool.maxActive
-
Property that controls the maximum number of active connections to be maintained in the pool.
-
Impacted template:
loader-deploy.yaml -
Data Type:
integer -
Default Value:
8 -
Acceptable value: Any positive integer. Value depends on the number of connections that the database currently supports.
Values.platformapi.datasource.pool.maxActive
-
Property that controls the maximum number of active connections to be maintained in the pool.
-
Impacted template:
platformapi-deploy.yaml -
Data Type:
integer -
Default Value:
8 -
Acceptable value: Any positive integer. Value depends on the number of connections that the database currently supports.
Values.configui.datasource.pool.maxActive
-
Property that controls the maximum number of active connections to be maintained in the pool.
-
Impacted template:
configui-deploy.yaml -
Data Type:
integer -
Default Value:
8 -
Acceptable value: Any positive integer. Value depends on the number of connections that the database currently supports.
Values.logcollector.datasource.pool.maxActive
-
Property that controls the maximum number of active connections to be maintained in the pool.
-
Impacted template:
logcollector-pod.yaml -
Data Type:
integer -
Default Value:
8 -
Acceptable value: Any positive integer. Value depends on the number of connections that the database currently supports.
datasource.pool.minIdle
Values.trafficmanager.datasource.pool.minIdle
- Property that controls the minimum number of active connections to be maintained in the pool.
- Impacted template:
trafficmanager-deploy - Data Type:
integer - Acceptable values: Any positive integer. Value depends on the number of connections that the Database currently supports.
Values.loader.datasource.pool.minIdle
-
Property that controls the minimum number of active connections to be maintained in the pool.
-
Impacted template:
loader-deploy -
Data Type:
integer -
Acceptable values: Any positive integer. Value depends on the number of connections that the Database currently supports.
Values.platformapi.datasource.pool.minIdle
-
Property that controls the minimum number of active connections to be maintained in the pool.
-
Impacted template:
platformapi-deploy -
Data Type:
integer -
Acceptable values: Any positive integer. Value depends on the number of connections that the Database currently supports.
Values.configui.datasource.pool.minIdle
-
Property that controls the minimum number of active connections to be maintained in the pool.
-
Impacted template:
configui-deploy -
Data Type:
integer -
Acceptable values: Any positive integer. Value depends on the number of connections that the Database currently supports.
