SQL DB
Properties
| Name | Default Value | Comment |
|---|---|---|
| api_Key | The API key needed to connect to MOM HOST in TIBCO Cloud™ API Management. | |
| api_Secret | The API password needed to connect to MOM HOST in TIBCO Cloud™ API Management. | |
| auto_binding | ON | When turned ON, logservice URLs will be auto-discovered and bound to the API Management - Local Edition component. |
| data_directory | /var/lib/mysql | The path to the MySQL data directory. Only the last component of the path name is created if it does not exist; the parent directory must already exist or an error occurs. |
| dimdataLogServiceURL | log-set-0-0.log-svc-0.default.svc.cluster.local | |
| expire_logs_days | 30 | Specifies the number of days before automatic removal of binary log files. |
| innodb_buffer_pool_size | 128M | The size in bytes of the buffer pool, the memory area where InnoDB caches table and index data. |
| key_buffer_size | 16M | The size of the buffer used for index blocks. The key buffer is also known as the key cache. |
| mysql_bin | mysql-bin | Specifies the base name to use for binary log files. |
| mysql_log_error | /var/log/mysqld.log | Option to determine whether the default error log destination is the console or a file, and, if a file, the file name. |
| mysql_log_error_verbosity | 1 | The verbosity for handling events intended for the error log, as filtered by the log_filter_internal error log filter component, which is enabled by default. |
| logserviceURL | log-set-0.log-svc.default.svc.cluster.local | Logservice URL to connect to process the logs. |
| max_allowed_packet | 16777216 | Maximum packet length to send to or receive from server. |
| max_binlog_size | 1073741824 | If a write to the binary log causes the current log file size to exceed the value of this variable, the server rotates the binary logs (closes the current file and opens the next one). The minimum value is 4096 bytes. The maximum and default value is 1GB. |
| mom_host | https://api-mom.mashery.com | MOM host to connect to sync data from TIBCO Cloud™ API Management. |
| mom_connect_timeout | 30000 | Sets a specified timeout value, in milliseconds, to be used when opening a communications link to MOM referenced by a URLConnection. |
| mom_read_timeout | 120000 | Sets the read timeout to MOM URL to a specified timeout, in milliseconds. A non-zero value specifies the timeout when reading from Input stream when a connection is established to MOM. If the timeout expires before there is data available for read, a java.net.SocketTimeoutException is raised. |
| plugin_load | validate_password.so | This option tells the server to load the named plugins at startup. If multiple --plugin-load options are given, only the last one is used. |
| query_cache_size | 8M | This system variable was removed in MySQL 8.0.3. |
| server_id | 1234567890 | Specifies the server ID. This variable is set by the --server-id option. The server_id system variable is set to 1 by default. The server can be started with this default ID, but when binary logging is enabled, an informational message is issued if you did not specify a server ID explicitly using the --server-id option. |
| service_sync_interval_minutes | 15 | Service sync interval to sync service configurations with MOM. |
| developer_sync_interval_minutes | 15 | Developer sync interval to sync developer configurations with MOM. |
| table_open_cache | 1000 | The number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires. |
| td_agent_bit_buffer_type | filesystem |
The back pressure buffer type for logs - store in memory or back up to disk. In most conditions, it would not be required to change the default value; but if high disk i/o is noticed, change the setting. Valid values are memory and filesystem. |
| td_agent_bit_metrics_buffer_type | filesystem | The back pressure buffer type for metrics - store in memory or back up to disk. In most conditions, it would not be required to change the default value; but if high disk i/o is noticed, change the setting.
Valid values are memory and filesystem. |
Note: td_agent_bit_buffer_type and
td_agent_bit_metrics_buffer_type properties can be set at deployment time or can be modified using the Cluster Manager CLI.
Example:
cm ls components clustermanager set config --componentType <component type from ls components> --componentId <component id from ls components> --prop td_agent_bit_buffer_type --value filesystem
Changing a Password for MySQL Database Deployed with Docker
It is possible to change an SQL password at the time of deployment and get it deployed through the cluster. For more information, see Configuring Properties Common to All Deployments.Copyright © 2022. Cloud Software Group, Inc. All Rights Reserved.