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 Default Value Comment
api_Key api key needed to connect to MOM HOST in TIBCO Cloud™ Mashery.
api_Secret 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.
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™ Mashery.
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.
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.

Specifying a password for MySQL database deployed with Docker

At the time of Mashery Local installation, you can specify your own password for a MySQL database deployed with Docker. Specify the password in the following file: docker-deploy/set-user-variables.sh. Change the MySQL password before running compose.sh.