SQL DB



What's Inside

  • MySQL DB
  • SQL DB Loader

Services

SQL DB Service

Resource Dependencies

  • MOM Binding
  • Log Producer Binding
  • Registry Binding

Properties

Name Name Default Value
apiKey api key needed to connect to MOM HOST in TIBCO Cloud™ Mashery.
apiSecret api password needed to connect to MOM HOST in TIBCO Cloud™ Mashery.
auto-binding ON When turned ON, logservice urls will be auto-discovered and bound to the TIBCO Mashery Local 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 It is the size of the buffer used for index blocks. The key buffer is also known as the key cache.
log-bin mysql-bin Specifies the base name to use for binary log files.
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.
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™ Mashery.
momConnectTimeout 30000 Sets a specified timeout value, in milliseconds, to be used when opening a communications link to MOM referenced by a URLConnection.
momReadTimeout 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.
syncInterval 15 Sync Interval used to sync tokens.
Note: Starting with Mashery Local 5.0, OAuth tokens are not synced with TIBCO Cloud Mashery.
table-open-cache 1000 The number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires.