SingleStoreDB Toolbox Release Notes
Maintenance Release Changelog
2023-05-08 Version 1.16.0
Updated the
sdb-deploy upgrade
command to validate SSL certificates prior to upgrading to SingleStoreDB version 8.1 and laterUpdated the
sdb-report check
command to report a failure if theMalloc_active_memory
variable (from SHOW STATUS EXTENDED) exceeds 10 GBRefined the error messages should the
sdb-admin add-leaf
command failAdded the
--tag
option to thesdb-admin create-backup
command that allows tags to be assigned to newly created backupsAdded the
--set-configs
option to thesdb-admin create-node
command that allows node variable values to be set before a new node is startedAdded the
--set-configs
option to thesdb-deploy upgrade
command that allows node variable values to be set before an upgraded node is startedUpdated the
sdb-report collect
command to obscure user credentials in the pipeline collector's outputUpdated the
sdb-report collect
command to include information in the final report about hosts that failed to collect reportsUpdated the
sdb-report collect
command to run thetoolboxConfig
collector only on the host where thesdb-report
command is locatedUpdated the
sdb-report collect
command to incorporate all pipeline metadata tables in the cluster report
2023-04-11 Version 1.15.3
Updated the
sdb-deploy upgrade
command to automatically undo an offline upgrade to the specified SingleStoreDB version if it cannot be managed by the current Toolbox versionUpdated the
sdb-deploy upgrade
command to retry the "rebalance partitions" upgrade step in the event of a failureAdded a
--container
option to thesdb-report collect-kube
command to specify the container in which to run the reportAdded a new
informationSchemaDistributedDatabasesOnSites
collector to thesdb-report
commands which collects the contents of theinformation_schema.distributed_databases_on_sites
table on an aggregator nodeAdded a new
informationSchemaInternalTableStatistics
collector to thesdb-report
commands which collects the contents of theinformation_schema.internal_table_statistics
table on an aggregator nodeUpdated the
sdb-report check
command to report a warning when thevm.swappiness
value is greater than10
on a host
2023-02-28 Version 1.15.2
Fixed a bug where the
sdb-report calibrate
command would fail with SingleStoreDB versions 8.0 or laterAdded an
--exclude-ldap-users-to-lower
option to thesdb-admin sync-ldap
command to exclude LDAP usernames from syncing to lowercase database usernames
2023-02-09 Version 1.15.1
Added an
exclude_users
field to the configuration YAML file to exclude the specified LDAP users from syncing with thesdb-admin sync-ldap --config-file
commandAdded
--exclude-ldap-users
and--exclude-ldap-users-file
options to thesdb-admin sync-ldap
command to exclude LDAP users from syncingAdded an
--ldap-users-to-lower
option to thesdb-admin sync-ldap
command to sync LDAP usernames to lowercase SQL usernames
2023-01-30 Version 1.15.0
Fixed a bug where the
sdb-admin configure-monitoring
command incorrectly detected when a user did not have the permissions required to start the exporterFixed a bug where the
sdb-admin summarize-backups
command swapped the “Oldest backup” and “Newest backup” column headersAll engine variables can now be set in the cluster configuration YAML file and used by the
sdb-deploy setup-cluster
commandUpdated the
sdb-admin update-config
command to prevent theresource_pool
engine variable from being changedFixed a bug when the
sdb-deploy ui
command reported an errorUpdated the
sdb-admin show-aggregators
andsdb-admin show-cluster
commands to show theRole
field for aggregator nodesAdded a
--role
option to thesdb-admin add-aggregator
command to create an aggregator node as a voting memberAdded an
--aggregator-role
option to thesdb-admin create-node
command to create an aggregator node as a voting memberUpdated the
sdb-admin describe-node
command to display an aggregator node’s roleAdded an
aggregator_role
field to the cluster configuration YAML file to allow thesdb-deploy setup-cluster
command to set up a cluster with aggregator nodes as voting members
2022-12-14 Version 1.14.4
Added an
--allow-ipv6
option to thesdb-admin create-node
command to allow a newly-created node to use IPv6Added an
--allow-ipv6
option to thesdb-deploy setup-cluster
command that sets theallow_ipv6
engine variable totrue
for each newly-created node in the clusterAdded an
allow_ipv6
variable to the cluster configuration YAML file that creates nodes that can use IPv6 when running thesdb-deploy setup-cluster
command
2022-12-07 Version 1.14.3
Excludes the
processFiles
collector from the default output of thesdb-report collect
commandExcludes the
cpuFreqPolicy
checker from the default output of thesdb-report collect
commandAdded a
--require-ssl
flag to thesdb-admin sync-ldap
command to enableREQUIRE SSL
for sync usersChanged the
sdb-report collect
command to runinformationSchemaTables
andinformationSchemaStatistics
collectors only for the Master Aggregator nodePermits the
allow_unsuported_filesystem
variable to be set in the cluster configuration YAML file for setting up the clusterFixed a bug where the
sdb-admin restore-backup
command would fail when trying to restore a backup from a network file systemChanged the
nodeDirectoriesDiskUsage
collector to collect information for all subdirectories within a node’s main directory
2022-11-29 Version 1.14.2
Fixed a bug where the
sdb-admin update-config
command would fail to set thedata_conversion_compatibility_level engine
variableAdded the
--ssl-ca
and--ssl-capath
options to thesdb-admin start-monitoring
command and the--exporter-ssl-cert
,--exporter-ssl-key
,--exporter-ssl-passphrase
, and--exporter-use-https
options to thesdb-admin configure monitoring
command to support setting up monitoring over HTTPS
2022-11-16 Version 1.14.1
Fixed bug where the
sdb-report calibrate-blob-storage
command would fail when thedata_conversion_compatibility_level
engine variable was set to8.0
Added the
informationSchemaAvailabilityGroups
collector which collects the contents of theinformation_schema.availability_groups
table on an aggregator nodeAdded the
--shard-queries
option to thesdb-report collect-kube
command which reduces the load on the Master Aggregator by sharding queries among the aggregators during report collection
2022-11-09 Version 1.14.0
Prevents the
sdb-deploy upgrade
command from directly upgrading SingleStoreDB 7.1 and earlier to SingleStoreDB 8.0.Added the
--shard-queries
option to thesdb-report collect
andsdb-report collect-and-check
commands which reduces the load on the Master Aggregator by sharding queries among the aggregators during report collectionChanged a
nodeDirectoriesDiskUsage
collector to report only the total size of the node directoriesAdded a
nodeFilesDiskUsage
collector that collects file-level disk usage information for each node directory
2022-09-22 Version 1.13.13
Updated the monitoring schema to improve the performance of data purges
Deprecated the
--purge-limit
option of thesdb-admin start-monitoring
command
2022-09-19 Version 1.13.12
Added an
--ssh-control-persist
option to thesdb-admin
command to control theControlPersist
option in SSH connections
2022-09-16 Version 1.13.11
Changed the
malloc_active_memory
checker to report a warning instead of a failure on values above the thresholdAdded an
--ssh-control-persist
option to thesdb-report
command to control theControlPersist
option in SSH connectionsAdded an
--ssh-strict-host-key-checking
option to Toolbox commands to enableStrictHostKeyChecking
in SSH connectionsAdded an
--ssh-user-known-hosts-file
option to Toolbox commands to specify the path to theknown_hosts
fileUpdated the
sdb-report collect
command to excludesmaps
files from theprocessFiles
collector’s output
2022-08-18 Version 1.13.10
Added a new
systemLimits
report checker that ensuresnproc
andNOFILE
configurations are set to the recommended values on a hostFixed a bug where the
sdb-report collect
command would fail with anhttp2: no cached connection was available
error
2022-07-20 Version 1.13.9
Fixed a bug where
sdb-admin create-backup
did not work for local backupsFixed a bug where the
tracelogHardShutdown
checker reported false-positive warnings
2022-06-06 Version 1.13.8
Added a new
informationSchemaMvReplicationManagement
collector to thesdb-report collect
command that runsSELECT *
for the following tables:MV_REPLICATION_MANAGEMENT
MV_REPLICATION_MANAGEMENT_PARTITIONS_STATE
MV_REPLICATION_MANAGEMENT_REF_DB_STATE
MV_REPLICATION_MANAGEMENT_STATE
2022-05-10 Version 1.13.7
Fixed a bug where the
sdb-report calibrate-blob-storage
command would hang when all blobs were not successfully evictedAdded retrying an online upgrade when the
hit error preparing for failover
error is encounteredUpdated Toolbox to only request
sudo
credentials when more privileges are required than provided by the defaultmemsql
userChanged the order of SQL statements in the output from the
sdb-admin dump
command
2022-03-28 Version 1.13.6
Added the following timestamp flags to the
sdb-report collect
command that allow logs to be collected starting from the provided timestamp:For audit logs:
memsqlAuditlogs.auditLogStartTimestamp
For command logs:
memsqlCommandLogs.commandLogStartTimestamp
For tracelogs:
memsqlTracelogs.tracelogStartTimestamp
Fixed a bug in the
installedPermissions
checker where thesdb-repot check
command would incorrectly report a failureUpdated the
sdb-admin unregister-node
andsdb-deploy setup-cluster
commands to display more detailed messages should an error occur
2022-03-02 Version 1.13.5
Fixed a validation bug in the
sdb-admin register-node
command when configuring a nodeFixed the partition count in the diagnostic output of the
sdb-report calibrate
commandFixed permission issues for the
sdb-report calibrate-blob-storage
commandAdded the
--skip-validation
option to thesdb-admin restore-backup
command to skip validating backups before restoringUpdated incremental backup validation for the
sdb-admin restore-backup
andsdb-admin validate-backup
commandsAdded a
tracelogHardShutdown
checker that checks for hard shutdowns in a node’s tracelog
2022-02-03 Version 1.13.4
Added the
sdb-admin enable-http-api
command to enable the Data API on selected nodesAdded a new
--role
option to thesdb-admin update-config
command. This option allows updating the configuration on all nodes that have selected role.Changed the
sdb-toolbox-config describe-host
command to prompt interactively for a hostnameMade the online upgrade more reliable by making multiple attempts to re-attach a leaf node on account of a failure
2022-01-20 Version 1.13.3
Added a new
--skip-system-warnings
option to thesdb-admin start-node
,sdb-admin restart-node
, andsdb-deploy upgrade
commands. This option allows users to skip displaying the extended version of system configuration limitations and warnings.Fixed a data file-permissions issue in the
sdb-report calibrate-blob-storage
commandFixed the TSV files generated by the
sdb-report collect
commands to escape newlines, tabs, and slashes when saving query resultsBy default, the
sdb-deploy setup-cluster
command now configures the host's operating system per SingleStore's recommendations. To disable this auto-configuration, use the new--skip-auto-config
option in the YAML configuration file. The--skip-auto-config
option has also been added to thesdb-deploy cluster-in-a-box
command.
2021-12-20 Version 1.13.2
Updated the
sdb-deploy setup-cluster
andsdb-deploy cluster-in-a-box
commands to allow the--preinstalled-path
option to be used with Debian and Red Hat package installationsExpanded the output of the
sdb-admin start-node
command with warnings about system configurations and limitsFixed the output of the
sdb-admin update-config
command that is returned when the command is run for multiple hosts or for updating global variables. This fix applies to SingleStoreDB versions 7.3.22 and later, 7.5.15, 7.1.25 and later, and 7.6.7 and laterImproved the Toolbox monitoring commands by optimizing
purge_blobs
andpurge_metrics
proceduresUpdated the
mv_queries.query_text
column's type toLONGTEXT
Added a new
--create-service-only
option to thesdb-admin enable-nodes-autostart
command that allows the command to be run without prompting for aroot
password; this option creates amemsql.service
file on the specified hosts without enabling the serviceAdded a new
informationSchemaMvBlockedQueries
collector to thesdb-report
commands that runs theSELECT * FROM information_schema.MV_BLOCKED_QUERIES
query on the Master AggregatorAdded a new
informationSchemaMvBottomless
collector to thesdb-report
commands that saves data from the following tables:MV_BOTTOMLESS_API_EVENTS
MV_BOTTOMLESS_REMOTE_STATS
MV_BOTTOMLESS_STATUS
MV_BOTTOMLESS_STATUS_EXTENDED
MV_BOTTOMLESS_SUMMARY
MV_MILESTONES
2021-12-06 Version 1.13.1
Added support for using the
rsync
command to copy files on a remote host ifscp
is not foundFixed the
sdb-admin optimize
command to work for SingleStoreDB versions 7.5.13, 7.5.14, 7.6.4, and 7.6.5Updated the
--preinstalled-path
option in thesdb-deploy upgrade
command to work with Debian and Red Hat package installationsUpdated the pre-installation checks of the
sdb-deploy upgrade
command to additionally verify that the folder specified by the--preinstalled-path
option meets the prerequisites
2021-11-23 Version 1.13.0
Added support for starting each node as a separate
systemd
unit viasystemctl
. To perform this action,systemctl
uses ansdb-systemd-client
script, which can be distributed across the cluster using thesdb-admin enable-systemd-client
commandUpdated the
--password
flag insdb-admin change-root-password
andsdb-admin create-node
commands to support theMEMSQL_PASSWORD
environment variableFixed the
sdb-admin update-config
command to work for SingleStoreDB versions7.6.4 and 7.5.13, however, without the support for extended outputImproved the error message caused by running
sdb-deploy
commands with the--preinstalled-path
option in Debian and RPM package installations
2021-11-08 Version 1.12.5
Fixed an error with calling a
nil
function in thesdb-deploy
commandsUpdated the
sdb-deploy install
command not to mark the new version of SingleStoreDB as active in tarball-based installations. To install a new version and make it the active version, upgrade the cluster by running thesdb-deploy upgrade --preinstall-path
commandIn Debian and RPM package installations, only one version of SingleStoreDB can be installed at any given time
Fixed an issue with creating incremental backups on Network File System (mounted on a remote machine) when the target file does not exist
Updated the
sdb-deploy upgrade
command to retry upgrade if the process fails during partition promotionAdded a new
sdb-admin show-cluster
command that outputs the results of bothsdb-admin show-leaves
andsdb-admin show-aggregators
commands. This command can be run on any node in the cluster if the Master Aggregator is not available. This command works with SingleStoreDB version 7.6 and above
2021-10-25 Version 1.12.4
Fixed the default value of the
pipelines_extractor_get_offsets_timeout_ms
variable in thedefaultVariables
checker of thesdb-report check
commandUpdated the
sdb-admin update-config
command to restrict users from setting specific variables on node startup
2021-10-12 Version 1.12.3
Added SAML and JWT authentication methods to the
--auth-method
option of thesdb-admin sync-ldap
command and a new--saml-user-domain-attribute
flag. SAML requires either the--user-principal-name-attribute
or the--saml-user-domain-attribute
specification for successful authentication. For more information, seesdb-admin sync-ldap
command reference.
2021-09-27 Version 1.12.2
Added a new
--precheck-only
flag to thesdb-admin enable-high-availability
command to verify that high availability can be enabled on a clusterAdded a new
force_registration: <true | false>
option to thenode
section of a cluster configuration YAML file for use with thesdb-deploy setup-cluster
commandAdded a new
--temp-dir
flag to thesdb-report calibrate
command to specify the absolute path on the Master Aggregator in which to extract the datasetImproved the
sdb-report
commands to verify that the command is run by amemsql
group member. If so, the report collects data that is otherwise restricted. If not, a warning is displayedUpdated the
sdb-deploy upgrade
command to remove the priormemsql-server
/singlestorerdb-server
version package after a successful upgrade. Use the new--skip-uninstall
flag to skip this stepFixed a file-permissions issue in the
sdb-deploy setup-cluster
command that would sometimes cause the command to fail when run against large, frequently-accessed databases
2021-09-13 Version 1.12.1
By default, the
sdb-toolbox-config register-host
command now configures the host's operating system per SingleStore's recommendations. To disable this option, use the newskip-auto-config
flagAdded support for verifying the length of the path to the runtime directory to prevent SSH issues due to long socket paths
Added new
informationSchemaMvAggregatedReplicationStatus
andreplicationLag
collectors to report when the replication on the secondary cluster is out of sync with the primary clusterImproved the Toolbox command outputs to hide user passwords in verbose mode
2021-08-30 Version 1.12.0
Added
calibrate-blob-storage
to thesdb-report
command to measure blob storage performanceExtended the output of the
sdb-admin update-config
command to better integrate with automation processesImproved the performance of permissions checks for the
sdb-deploy setup-cluster
commandExtended the
defaultVariables
checker to check for all documented variablesFixed a bug in the
sdb-deploy upgrade
command that would not properly set thetoolbox_version
variable on all nodes if an offline upgrade failed
2021-08-16 Version 1.11.11
Improved
sdb-deploy cluster-in-a-box
to optimize the cluster with respect to the NUMA configuration of the hostAdded the ability to limit the number of rows collected by the
informationSchemaPipelines
collectorImproved
sdb-admin restart-node
command to not require the--all
flag when performing an online restartImproved the output of the environment validation checks in the
sdb-deploy setup-cluster
commandExpanded the output from the
memsqlctl
command in thesdb-admin optimize
commandFixed a bug in the
sdb-deploy upgrade
command that may have led to issues with an offline upgrade following a failed online upgrade
2021-08-02 Version 1.11.10
Improved the
sdb-admin create-backup
command to create missing directories specified in the location of file system backupsUpdated the
sdb-report collect
command to allow optional compression of node log filesFixed the
sdb-report collect-and-check --include-performance
command to run performance-related collectors and checkers in addition to the default onesFixed a bug in the
sdb-report check
command that would cause invalid decompression of some files in cluster diagnostics reports
2021-07-19 Version 1.11.9
Added a new
dataSkewness
collector to collect information about data skew in the clusterFixed a bug in the
sdb-report send-alert
command that would cause some collectors to become unavailableUpdated the
sdb-deploy cluster-in-a-box
command to search for free portsImproved the
sdb-report collect-and-check
command to use the values defined by--remote-temp-dir
and--temp-dir
flags
2021-07-05 Version 1.11.8
Added a new
studioVersion
collector to collect information about the Studio versionUpdated the
sdb-report collect
command to compress node log files before adding them to a reportUpdated the
sdb-admin start-monitoring
command to set retention period and purge frequency on individual monitored hostsFixed a pre-installation check in the
sdb-deploy setup-cluster
command that would cause an error in certain incremental cluster setups
2021-06-21 Version 1.11.7
Added pre-installation checks to
sdb-admin add-leaf
andsdb-admin add-aggregator
commands. The checks can be skipped using a new--skip-validate-env
flagAdded support for creating incremental backups to the
sdb-admin create-backup
commandAdded support for incremental backup restoration to the
sdb-admin restore-backup
command. Specific versions of incremental backups can be restored via the--incr-backup
flagAdded support for deleting incremental backups to the
sdb-admin delete-backup
commandFixed the
sdb-admin delete-backup
command to clean up.manifest
filesImproved the JSON output of the
sdb-report check
commandUpdated the
sdb-deploy upgrade
command to allow users to retry the upgrade steps upon the occurrence of specific errors
2021-06-07 Version 1.11.6
Changed the output of the
sdb-admin list-backups
command to include incremental backupsUpdated the
sdb-admin validate-backup
command to validate incremental backupsAdded the
--incr-backup-id
flag to thesdb-admin validate-backup
command to validate specific versions of an incremental backupDuring an offline upgrade of SingleStoreDB 7.0 and later versions via the
sdb-deploy upgrade
command, theleaf_failure_detection
engine variable will no longer be set toOFF
Improved the description of the
sdb-admin optimize
command
2021-05-24 Version 1.11.5
Removed the redundant output from the
sdb-deploy ui
commandAdded support for installing
singlestoredb-server
packages via thesdb-deploy
commandUpdated the
--help
flag in specific Toolbox commands to display the minimum version of SingleStoreDB required to run the commandsChanged the
sdb-admin start-monitoring
command to perform query sampling by default. A newdisable-sample-queries
flag has been added to this command to disable query samplingImproved the
sdb-report collect-kube
command to support in-cluster configurationsFixed a bug in the
sdb-deploy setup-cluster
command that would sometimes cause the command to crash when running pre-installation checks
2021-05-10 Version 1.11.4
Updated the
numaConfiguration
checker to better handle multiple NUMA nodes per hostFixed the
transparentHugepage
checker to display the correct output when transparent huge pages are enabled and/sys/kernel/mm/transparent_hugepage/defrag
is set tomadvise
Added the
toolboxEnv
collector to gather information about the Toolbox configurationFixed a bug in the
sdb-report collect --merge-path
command that would result in either an inconsistent directory structure or a failure when merging reports from remote hostsAdded the
sdb-admin update-node-basedir
command to move the base directory of a node and update the corresponding engine variablesFixed a bug in the
sdb-report collect
command that would cause the command to crash if a node was offlineAdded the
nodeDirectoriesDiskUsage
collector to collect disk usage information for each node directoryImproved the execution time of
informationSchemaTableStatistics
,informationSchemaIndexStatistics
, andinformationSchemaMvQueries
collectors
2021-04-26 Version 1.11.3
Added the
sdb-admin disable-nodes-autostart
command to disable the use ofsystemd
for restarting all nodes on specified hosts at startupAdded an ability to create backup using
WITH SPLIT PARTITIONS
in thesdb-admin create-backup
commandFixed the
installedPermissions
collector that would cause a crash if system information is unavailable for some filesAdded a snapshot retry when a database connection is not established
Added the
--rename-to
flag to thesdb-report restore-backup
command to rename a database while it is restoredFixed a bug in the
minFreeKbytes
checker that would cause the checker to use an incorrect thresholdUpdated the
sdb-deploy
command to prevent the direct upgrade from SingleStoreDB version 6.x to 7.5 and laterUpdated the
sdb-deploy setup-cluster
command to set theskip_install
property totrue
without specifying thepackage_type
property in the cluster fileImproved the
sdb-report collect-kube
command to discover Kube services
2021-04-12 Version 1.11.2
Fixed a bug in the
sdb-admin enable-high-availability
command that would cause it to fail for clusters runningmemsql-server
versions earlier than 7.1Improved the description of the
--reset
flag in thesdb-admin update-config
commandImproved the execution time of the
sdb-admin delete-node
and thesdb-admin sync-ldap
commands
2021-03-29 Version 1.11.1
Added the
sdb-admin dump
command to dump cluster objects into a DDL file similar to the usage ofmysqldump
Added OpenSSL FIPS support for Toolbox via the
--ssl-fips-mode
flag in thesdb-admin create-node
and thesdb-admin register-node
commands, and via thessl_fips_mode
cluster file property in thesdb-deploy setup-cluster
commandAdded the
--load-balanced
flag and theload_balanced
cluster file property to thesdb-deploy setup-cluster
command to allow clusters to be set up with high availability in theload_balanced
modeReplaced the
leafPairs
checker with ahighAvailability
checker in thesdb-report
command that determines the fidelity of high-availability clusters in bothpaired
andload_balanced
modesChanged the
cpuHyperThreading
checker in thesdb-report
command to not report stderr when it only contains whitespace characters, which is considered emptyFixed a bug in the
sdb-admin enable-high-availability
command that would cause leaf nodes to be paired incorrectly
2021-03-15 Version 1.11.0
Added the
sdb-report calibrate
command to calibrate a cluster’s performance against a benchmark using a variety of queriesAdded the
whitespacesInObjectName
checker to thesdb-report
command to check for objects in the schema that have leading or trailing whitespaces in their namesAdded the
--temp-dir
flag to thesdb-report collect
and thesdb-report collect-and-check
commands to select a directory for storing temporary files on both remote and local hosts. The--remote-temp-dir
flag is now deprecated.Added a new option to specify a password while executing the
sdb-admin configure-monitoring
command; the password can now be specified via theEXPORTER_PASSWORD
environmental variable in addition to the--exporter-password
flagAdded a check to verify that a node is registered in Toolbox and runs the same version as the Master Aggregator when the node is added as a leaf or an aggregator
Added the
--load-balanced
flag to thesdb-admin enable-high-availability
command to allow high availability to be enabled in theload_balanced
modeEnabled the
--mask-ip
flag in thesdb-report collect-kube
commandRemoved an unused field from the Toolbox state file
Fixed a bug in the
sdb-report check
command that would cause theduplicatePartitionDatabases
checker to return incorrect output in some cases
2021-03-01 Version 1.10.1
Added
Implementation
andLockfreeTimestamp
fields to the backup cacheImproved the
sdb-deploy setup-cluster
command to skip the root password prompt if each node has a password already setImproved the
dmesg
collector in thesdb-report collect
command to also look for thedmesg
executable in/usr/bin
,/bin
, and/usr/local/bin
directoriesChanged the
informationSchemaProcesslist
collector in thesdb-report collect
command to mask user credentials in the outputChanged the
leafAverageRoundtripLatency
checker in thesdb-report check
command to apply stricter criteria while detecting outliersFixed a bug in the
sdb-admin list-backups
command that would cause a crashFixed a bug in the
sdb-admin start-monitoring
command that would cause timestamps in themv_events
table to be invalid
2021-02-15 Version 1.10.0
Added the
--kerberos-realm
flag to thesdb-admin sync-ldap
command to override the Kerberos realm value, which is used to create new SQL users with the--auth-method kerberos
flagImproved the
sdb-admin describe-host
command to display thememsqlctl
path and thememsqlctl
config path correctly for installations that are not tarball-basedChanged the
informationSchemaUserPrivileges
collector to no longer run during environment validationFixed a bug in the
sdb-report collect --mask-ip
command that would cause an error when the command is run by a non-member of thememsql
group
2021-02-01 Version 1.9.7
Added the
sdb-report collect-kube
command to build a diagnostics report for a Kubernetes clusterAdded the
cgroupInfo
collector and thecgroupMemoryUsage
checker to thesdb-report
command to check if thememsqld
process runs inside the memory cgroup and that memory usage is not too close to the limitAdded an ability to set availability groups in the
sdb-deploy ui
commandAdded an ability to set a
memsql-server.tar
file as an installation target in thesdb-deploy ui
commandImproved the output of the
leafAverageRoundtripLatency
checker in thesdb-report check
command to pinpoint the nodes that have the longest round-trip latencyImproved the error messages caused by running Toolbox with
sudo
Improved error messages in the
sdb-deploy upgrade
commandChanged all Toolbox commands to no longer require a special configuration to run as the
root
user directly and without usingsudo
Changed the validation performed by the
sdb-deploy setup-cluster
command to be less strict for thememsql
directory on each hostChanged the row timeout of some queries used in the
sdb-deploy upgrade
command from 1 minute to 15 minutesFixed the Toolbox auto-complete feature for
bash
andzsh
so that it will work with bothmemsql-*
andsdb-*
commandsAdded taking database(s) snapshots when using Toolbox to stop or restart a node to decrease the time it takes for the node to recover
2021-01-19 Version 1.9.6
Added the
sdb-admin snapshot-database
command to create database snapshotsAdded the
--snapshot
to thesdb-admin restart-node
and thesdb-admin stop-node
commands to create snapshots of databases before restarting or stopping a nodeAdded the contents of the
memsqlctl.hcl
and thenodes.hcl
files to the output of thememsqlcltInfo
collectorAdded the
ServerVersion
and theMemoryUsage
fields to the backup cacheImproved the description of the
--online
flag in thesdb-deploy upgrade
commandImproved the request to run as
sudo
message in the Toolbox commandsChanged the warning messages in the
defaultWorkloadManagement
checker to be more consistentFixed a bug in the
sdb-report collect --mask-ip
command that would cause an error when collecting report information for a stopped node
2021-01-08 Version 1.9.5
Improved the error message of the
sdb-deploy setup-cluster
command when an environment validation fails due to different users owning data directories of a node
2021-01-04 Version 1.9.4
Added the
--mask-ip
flag to thesdb-report collect
command to mask sensitive data in the report files, such as IP addresses, MAC addresses, usernames, and passwordsAdded the
role
column to themv_nodes
table for population by the monitoring pipelineAdded the
sdb-admin enable-nodes-autostart
command to enable nodes autostart on system rebootChanged the
chronydStatus
and thepartitionsStart
collectors in thesdb-report
command to be excluded by defaultChanged the description of
analyzeTable
collector in thesdb-report
commandChanged the memory units in the
consistent_maximum_memory
checker from kilobytes (KB) to megabytes (MB)
2020-12-15 Version 1.9.3
Fixed an issue in the deployment UI that would occur after clicking the Add Another Host button
Fixed a bug in the
sdb-deploy setup-cluster
command that would sometimes place thememsqlctl.hcl
file in an incorrect folder
2020-12-14 Version 1.9.2
As of Toolbox 1.9.2, each
memsql-
command now has an associatedsdb-
analog that is both compatible with, and functionally identical to, thememsql-
command.All memsql-
commands will continue to function as expected. With this enhancement:sdb-admin
is equivalent tomemsql-admin
sdb-deploy
is equivalent tomemsql-deploy
sdb-report
is equivalent tomemsql-report
sdb-toolbox-config
is equivalent tomemsql-toolbox-config
Added the
sdb-toolbox-config state
, thesdb-deploy state
, thesdb-admin state
, and thesdb-report state
commands to display the Toolbox state from thetoolbox-state.hcl
fileAdded the
--preinstalled-path
flag to thesdb-deploy install
,sdb-deploy cluster-in-a-box
, and thesdb-deploy setup-cluster
commands to specify the folder where amemsql-server
.tar
file has been extracted as an install targetAdded the
networdBuffersMax
checker to thesdb-report
command to check that thewmem_max
and thermem_max
values are at least 8MBAdded the
--config-file
flag to thesdb-admin send-alert
command to specify a YAML file containing both the location and the thresholds as an alternative to using the--alert-location
and the--thresholds
flagsAdded the
--monitoring-version
flag to thesdb-admin start-monitoring
command to specify amemsql-server
version to pass to thememsql-exporter
Added the
--batch-interval
flag to thesdb-admin start-monitoring
command to specify a time interval between data extractionsAdded the
--sample-queries
and the--high-cardinality-metrics
flags to thesdb-admin start-monitoring
command to enable the collection of additional monitoring dataUpdated the
sdb-admin start-monitoring
command to support features introduced in the SingleStoreDB 7.3 version of thememsql-exporter
Changed the
mallocActiveMemory
checker to fail ifmalloc_active_memory
is greater than 5GB (up from 2GB)Changed the
diskUsage
and thediskInodesUsage
checkers in thesdb-report check
command to not report high usage on loopback filesystemsChanged the
sdb-report collect
command to not output a stack trace when a collection error is encounteredFixed a bug in the
sdb-deploy upgrade
command that would sometimes cause aggregator actions to be displayed in an incorrect order during a dry run
2020-11-30 Version 1.9.1
Added the
processFiles
collector to thememsql-report
command to collect all/proc/<pid>/*
files for thememsqld
and thememsqld_safe
processesAdded the
autoAttach
checker to thememsql-report
command to warn if theauto_attach
engine variable is not set toON
Added the
--preinstalled-path
flag to thememsql-deploy upgrade
command to specify the folder as an upgrade target where amemsql-server
.tar
file has been extractedImproved the error message for the
memsql-deploy ui
command when registered hosts are detected
2020-11-16 Version 1.9.0
Added the
cgroupDisabled
checker andosRelease
collector to thememsql-report
command to check thatcgroup memory
is disabled for Red Hat 7.x or laterAdded the
memsql-report send-alert
command to automatically runmemsql-report collect-and-check
and alert on fails or warningsUpdated the descriptions of multiple checkers in the
memsql-report
commandImproved the long message for the
memsql-admin change-root-password
commandImproved the long message for the
memsql-admin change-root-password
commandImproved the error message for the
memsql-admin start-monitoring
command when the exporter host is inaccessible from other hostsImproved the error messages related to environment validation in the
memsql-report collect
and thememsql-deploy setup-cluster
commandsImproved the
orchestratorProcesses
checker to include each process in the report only once, even if more than one instance of the process is running on the hostChanged the
memsql-deploy setup-cluster
command to check that all of the nodes that will be registered have the correct file permissions and ownerChanged the output of the
schema
collector to include views definitions, and improved how functions, procedures, and error messages are displayedChanged the
memsql-deploy setup-cluster
command to set thesecure_file_priv
engine variable to a default path of<memsqlctl's-default-install-dir>/db_files
for each newly-created nodeFixed a bug in the
memsq-admin restart-node
command that would sometimes display an incorrect error messageFixed a bug in the
clusterMemoryUsage
checker that would produce incorrect outputFixed a bug in the
memsql-admin enable-high-availability
command that would sometimes cause a kernel panic if Toolbox is configured incorrectly
2020-11-02 Version 1.8.1
Improved the error message in the
memsql-admin
backup-related commands when the--repository
flag contains an invalid valueFixed a bug where the
memsql-report check --validate-env
command would crash when a host has TarInstallDir defined andmemsql-server
installedAdded the
installedPermissions
checker and collector to thememsql-report
command to verify that cluster files and directories have the correct permissionsFixed a bug where the
--skip-validate-env
flag was ignored by thememsql-deploy setup-cluster
commandAdded the
--data-dir
flag to thememsql-deploy setup-cluster
command for specifying the absolute path to each node’s data directory (DataDir)Improved the
memsql-deploy ui
command to support pre-deployment environmental checksImproved the error message in the
memsql-admin restart-node --online
command to inform the user that relevant nodes must be running to perform the restartFixed a bug in the
memsql-deploy upgrade
command that incorrectly determined that all columnstore tables could be safely upgraded
2020-10-19 Version 1.8.0
Added the
memsql-admin sync-ldap
command to synchronize LDAP users and groups with SingleStoreDB/MemSQL database usersAdded a dry (trial) run message to the
memsql-report collect
command that displays the number of collectors that will be executedFixed a bug where the value of the timeout in the
memsql-admin query --row-timeout
command was not taken into account by the commandAdded a
clusterMemoryUsage
checker to thememsql-report check
command to determine if there is at least 10% of unused memory left for each nodeAdded a
diskInodesUsage
checker to thememsql-report check
command to determine if there is at least 15% of unused disk inodes left on each hostFix a bug where the
dmesg -T
command was not executed while collecting reports with thememsql-report collect
commandAdded a
diskLatencyRead
checker to thememsql-report check
command to determine if the disk read latency is below the recommended threshold on each hostAdded a
diskLatencyWrite
checker to thememsql-report check
command to determine if the disk write latency is below the recommended threshold on each host
2020-10-05 Version 1.7.2
Added the
memsql-admin unregister-node
andmemsqlctl unregister-node
commands to unregister nodes in ToolboxAdded the
majorPageFaults
checker and collector to thememsql-report
command to verify if the number of major page faults that the system generates per second is lower than a specific thresholdAdded the
swapUsage
checker and collector to thememsql-report
command to verify if the swap usage is lower than a specific thresholdAdded the
cpuIdle
checker and thecpuUtilization
collector to thememsql-report
command to verify if the percentage of time the CPUs have been idle is higher than a specific thresholdAdded the
memoryCommitted
checker and collector to thememsql-report
command to verify if the percentage of memory required for a given workload is less than a specific thresholdAdded the
swapEnabled
checker to thememsql-report check
command to verify if the total swap memory is not less than 10% of the physical memoryAdded the
vmSwappiness
checker to thememsql-report check
command that checks if thevm.swappiness
kernel setting is greater than0
on each hostAdded environment validation to the
memsql-deploy setup-cluster
commandAdded the
--tar-install-dir
flag to thememsql-deploy cluster-in-a-box
commandChanged the
max_memory_settings
checker of thememsql-report check
command to accept a maximum memory use of 91%, up from 90%Updated the
memsql-admin query
command to not require a password for the MemSQLroot
userUpdated the
memsql-admin change-root-password
,memsql-admin create-node
,memsql-admin query
, andmemsql-admin register-node
commands to prompt for a password only after all of the included flags have been verifiedImproved the warning messages in the
memsql-deploy upgrade --precheck-only
commandFixed a bug in the
memsql-report check
command where messages about unavailable checks were displayedFixed a bug where the
syncCnfVariables
checker in thememsql-report check
command would inadvertently return incorrect resultsFixed a bug in the
memsql-admin query
command that would ignore the--user
flagFixed a bug in the
memsqlctl
command where some commands that were run with the--timeout
flag would not exit after the specified timeout
2020-09-21 Version 1.7.1
Added an
--include memsqlAuditlogs
flag to thememsql-report collect
command to collect audit logsFixed a bug in the
memsql-report check
command wheremaxMemorySettings
reported a failure when a host has more than 10GB of memory freeAdded a
no_start: true
option to thenode
section of a cluster configuration YAML file for use with thememsql-deploy setup-cluster
commandFixed a bug where host fingerprinting would fail to compute on some hosts
Added a
--no-partition-change
flag to thememsql-admin optimize
command to skip any changes made to thedefault_partition_per_leaf
MemSQL variableFixed a bug in the
memsql-admin enable-high-availability
command that would co-locate nodes on the same host that were in different availability groupsImproved the error message for the
memsql-deploy setup-cluster
command when duplicate hosts are found in the cluster configuration YAML fileImproved the logging function by saving all of the messages generated when running Toolbox commands with the
--json
flagImproved the
memsql-deploy setup-cluster
command to display an error message when a node is specified with an incorrect availability group in the cluster configuration YAML fileFixed a bug where standard output of
memsqlctl
commands was sometimes lostMoved the message that
memsqlctl
is an earlier version to verbose output
2020-09-09 Version 1.7.0
Added the
memsql-admin configure-monitoring
command that updates the monitoring configuration for the clusterAdded the
memsql-admin start-monitoring
andmemsql-admin stop-monitoring
commands to start and stop the collection of monitoring dataAdded the
memsql-report collect-and-check
command that runs both collect and check reportsImproved the high availability functionality in the
memsql-deploy setup-cluser
command by pairing leaves of different hostsFixed a bug in the
memsql-admin enable-high-availability
command where nodes were assigned non-optimal availability groupsImproved the
memsql-deploy upgrade
command to report all precheck failuresImproved the
memsql-deploy setup-cluster
command to explain why a clean cluster is required before deploying MemSQLFixed a bug where the
syncCnfVariables
checker would crash in thememsql-report check
commandFixed a bug in the
memsql-admin query
command where--password
was not correctly processed
2020-08-26 Version 1.6.7
Fixed a bug where an “access denied” error would cause the
memsql-deploy upgrade
command to fail
2020-08-21 Version 1.6.6
Added
bash
andzsh
tab completion to all Toolbox commandsFixed a bug in the
memsql-admin query
command where--password
was not correctly processedImproved the
memsql-admin bootstrap-aggregator
,memsql-admin create-node
,memsql-admin set-license
,memsql-deploy cluster-in-a-box
, andmemsql-deploy setup-cluster
commands to use the license from the MEMSQL_LICENSE environment variableFixed a bug where
memsql-deploy upgrade
would fail due to a replicating databaseFixed a bug where a blob existed but couldn’t be opened in the
memsql-admin
backup-related commandsImproved logging to always include output of SQL queries
Fixed the error message in the
memsql-deploy setup-cluster
command when a host withoutmemsql-server
installed was already part of the clusterAdded a warning to not edit the
memsql.cnf
file manuallyAdded retries to
sudo
promptingImproved the error message for the
memsql-deploy upgrade
command when using a tar file without specifyingtar-install-dir
Improved the
transparentHugepage
checker of thememsql-report check
command to not check defrag if THP is disabled
2020-08-10 Version 1.6.5
Added the
attachRebalanceDelay
checker to thememsql-report check
command that verifies that attachRebalanceDelay is not set to 86400Fixed a bug where an error wasn’t displayed when attaching a leaf failed while executing the
memsql-deploy upgrade
commandUpdated the
memsql-toolbox-config register-host
command to validate the--memsqlctl-path
value and added the--skip-validation
flag to skip this validationImproved the
memsql-deploy upgrade
command to attempt to attach and detach a leaf under certain error conditions instead of proceeding to an offline upgradeImproved the error message when an attempted SSH connection fails
Added the
diskBandwidth
checker to thememsql-report check
command that checks disk read, write, and sync-read bandwidthImproved the
informationSchemaMvEvents
checker of thememsql-report check
command to order events by timeAdded the
--disable-spinner
flag to all Toolbox commands to disable the progress spinner, which some terminal sessions/environments may have issues withImproved the
memsql-deploy setup-cluster
command to suppress an error if one or more hosts did not havememsqlctl
installedChanged the
validLicense
checker of thememsql-report check
command to report in units for clusters with a unit-based licenseAdded the
--base-install-dir
flag to thememsql-deploy setup-cluster
command which sets each node’s base install directory on all hosts
2020-07-27 Version 1.6.4
Improved the
memsql-admin delete-backup
command to no longer error if a backup name is listed more than onceAdded a password prompt to all Toolbox commands as an alternative to specifying the password as a command-line argument, which would be captured in the shell’s history
Fixed a bug where tarball-based installations failed for remote hosts
Improved the descriptions of the
memsql-admin delete-node
,memsql-deploy uninstall
, andmemsql-toolbox-config unregister-host
commandsAdded the
consistentMaxMemory
checker to thememsql-report check
command that confirms themaximum_memory
setting is consistent across all leaves and aggregatorsAdded the
memsql-deploy destroy-cluster
command that deletes all data, deletes all MemSQL nodes, and unregisters all hostsImproved the dry runs of the
memsql-admin delete-node
,memsql-deploy uninstall
, andmemsql-toolbox-config unregister-host
commandsImproved the cluster file used by the
memsql-deploy setup-cluster
command to accept the case-insensitive role of a nodeAdded an
--all
flag to thememsql-admin describe-node
command to list the details for all nodesAdded a
--precheck-only
flag to thememsql-deploy upgrade
command to check if a cluster is stable and an upgrade is possible without performing an upgradeImproved the
memsql-admin
command’s backup/restore functionality to search for a backup in a repository if one isn’t found in a cacheImproved the
memsql-deploy upgrade
command to compare the target upgrade version against the major version that is already installedChanged the
syncCnfVariables
checker of thememsql-report check
command to confirm that its value is equal to the runtime value inmemsql-server
2020-07-14 Version 1.6.3
Fixed a bug where the
memsql-deploy ui
command fails to run
2020-07-13 Version 1.6.2
Added the
--master-port
,--leaf-port
, and--bind-address
flags to thememsql-deploy cluster-in-a-box
commandUpdated the
memsql-deploy setup-cluster
commands to not allow SSH for localhostFixed a bug where the
memsql-deploy upgrade
command fails when memsql-server 7.1 is already installed on a hostAdded details as to why some Toolbox commands prompt for a
sudo
passwordAdded a check in the
memsql-deploy upgrade
command that confirms that the activememsql-server
package is the one for the target versionUpdated the
memsql-deploy setup-cluster
command to provide the same output with or without the--config-file
flagRemoved the connections per node limit in the
memsql-deploy upgrade
commandFixed a bug where SSH standard error output was sometimes discarded
Added a
--file-path
flag to thememsql-admin set-license
command to allow the license to be stored in, and read from, a fileUpdated the
memsql-deploy
commands to prompt for which package manager to use if bothdeb
andrpm
package managers are installedImproved the version checks of the
memsql-deploy upgrade
commandAdded a
--skip-version-check
flag to thememsql-deploy upgrade
command that ignores the currently active memsql version and enables downgradingAdded the
--role
,--license
,--user
,--user-password
,--availability-group
, and--force-master
flags to thememsql-admin create-node
command. Refer to the memsql-admin create-node reference page for more information.Improved the functionality of the collector-related flags in the
memsql-report
commands
2020-06-30 Version 1.6.1
Fixed a bug where
memsql-deploy setup-cluster
fails when run with the--cluster-file
flag
2020-06-29 Version 1.6.0
Changed the
memsql-deploy cluster-in-a-box
command to bind nodes to the address127.0.0.1
instead of0.0.0.0
Changed the
memsql-deploy uninstall --all-versions
command to return a0
exit code if there are no versions to uninstallAdded the
memsql-deploy ui
command that runs a web UI to install MemSQL and deploy a clusterAdded
syncCnfVariables
checker to thememsql-report check
command that confirms that there are no sync variables values defined in thememsql.cnf
file on a hostUpdated the
memsql-deploy cluster-in-a-box
command to deduce the package format when the--file-path
flag is specifiedAdded the
--force-package-format
flag to thememsql-deploy list-versions
command that lists the versions installed by the chosen package managerFixed a bug where
memsql-deploy upgrade
displays an error message when attempting to upgrade to the MemSQL version that already installed and activated on the hostChanged the
memsql-report check
command to display results only for checkers that have all needed data, and list those checkers that do notUpdated the
memsql-admin optimize
command to display a message when non-uniform memory allocations for leaves are foundUpdated the description of the
memsql-admin put-file
command
2020-06-15 Version 1.5.5
Added a required
--password
flag to thememsql-deploy cluster-in-a-box
command that sets a password for the MemSQLroot
userFixed a bug where the
memsql-report check
command crashes when theorphanTables
checker does not find specific information in a reportFixed a typo in the
memsql-report
command’s error message when it fails to detect whethermemsqlctl
is installed on a hostFixed a bug where performance collectors were executed by default with the
memsql-report collect
commandAdded support for
file
protocol formemsql-admin
backup functionality
2020-06-03 Version 1.5.4
Added a
--force-package-format
flag to thememsql-deploy uninstall
command which will allow MemSQL to be uninstalled when there are both dpkg and rpm package managers found on a hostFixed a bug where
memsql-admin enable-high-availability
fails with MemSQL version below 7.0.6Added the result of
ANALYZE OPTIMIZER_STATE INTO OUTFILE
of thememsql-report collect
command to the collector’s section of theanalyzeTables
reportFixed a bug where
memsql-report check
would issue a warning on a validdistributed_keepalive_timeout
valueUpdated the
memsql-deploy list-versions
command to display its output more quicklyDisplays a more specific error message when a file on a host cannot be accessed
Updated the output of commands that are run with
-vvv
to be more readableAdded
--remote-temp-dir
flag to thememsql-report collect
command that allows setting a directory for storing temporary files on a hostFixed a bug where a
validLicense
check reports a failure on a valid license
2020-05-18 Version 1.5.3
Added
analyzeTables
collector tomemsql-report collect
that saves column and histograms recorded on each tableAdded the ability to store a path to a license file (rather than the license itself) in the cluster configuration file used by
memsql-deploy setup-cluster --cluster-file
Improved
dmesg
collector with timestamps that users can recognize and interpretFixed a bug where
memsql-deploy upgrade
does not show an error if the final upgrade step failsFixed a bug where
memsql-deploy upgrade
would hang if there were orphan databasesAdded a
--max-column-width
flag to thememsql-admin query
command that allows query output columns to be truncated to the specified number of charactersAdded a
--allow-duplicate-host-fingerprints
flag tomemsql-deploy setup-cluster
andmemsql-toolbox-config register-host
commands that allows hosts with identical SSH host keys to be added to the cluster
2020-05-04 Version 1.5.2
Fixed a bug where
memsql-report collect
hangs when collecting reports from some hostsFixed a bug where a
cpuFreqPolicy
check reports a failure on a valid configurationFixed a bug where the
chronydStatus
collector does not work for a host that does not havepgrep
Removed
maxOpenFiles
andfilesystemType
checks frommemsql-report check --validate-env
Added a warning and the request for user conformation when
memsql-toolbox-config register-host
is run with--localhost
and--host 127.0.0.1
Fixed a bug where
memsql-deploy upgrade
incorrectly estimates the disk space required to upgrade from MemSQL 6 to MemSQL 7Made
memsql-admin delete-backup
faster by deleting multiple backups in parallelAdded
cpuMemoryBandwidth
collector and checker tomemsql-report
that measures CPU-memory bandwidth on each host and confirms that both bandwidth and latency are within acceptable limitsAdded
--include-performance
flag tomemsql-report collect
andmemsql-report check
that is required to run performance checks for a clusterDisplays a detailed error message when the
memsql-toolbox-config register-host
andmemsql-deploy setup-cluster
commands are run with multiple localhosts
2020-04-20 Version 1.5.1
Added new collectors and checkers to
memsql-report collect
andmemsql-report check
commands:“memsqldProcessLimits” collects limits for all
memsqld
processes“chronydStatus” collects the status of the
chronyd
service“chronydDisabled” checks that
chronyd
is disabled“partitionsStart” collects information about each partition’s start sector number
“partitionsConsistency” checks that all partition start sectors are consistent
“cpuThreadingInfo” collects information about CPU threading configuration
“cpuHyperThreading” checks that all CPUs have hyperthreading enabled
“cpuFreqInfo” collects information about CPU frequency configuration
“cpuFreqPolicy” checks that all CPUs have power save disabled and turbo mode enabled
Fixed a bug where the
ulimit
checker reportsFAIL
even when set correctly for thememsql
userDisplays a more meaningful error message when
region
orendpoint_url
is missing in a backup commandFixed a bug where
memsql-report collect
fails if some node IDs could not be readFixed a bug where
memsql-deploy upgrade --online
fails to upgrade from MemSQL version 7.0.15Added “region” to the backup functionality help examples
2020-04-06 Version 1.5.0
Added functionality for backup management:
memsql-admin create-backup
- backup one or more databases to a repositorymemsql-admin delete-backup
- delete a backupmemsql-admin list-backups
- list all the latest backupsmemsql-admin restore-backup
- restore a database from a backupmemsql-admin summarize-backups
- print summary information for backupsmemsql-admin validate-backup
- verify that a backup is correct
Fixed a bug where
memsql-deploy setup-cluster
fails if the cluster configuration file containsskip_install:true
Added a check to
memsql-deploy setup-cluster
that prevents nodes from sharing the same folder on a host when specified in a cluster configuration file
2020-03-23 Version 1.4.4
Added computation of a “fingerprint” for each host to avoid adding the same host multiple times under a different name.
Added
--online
flag formemsql-deploy upgrade
that runs online upgrade for MemSQL.Fixed a bug where detectCrashStackTraces check displayed warnings if the memsqlStacks.files.json file was absent.
Improved error message for
memsql-deploy setup-cluster
when the path to the source file is incorrect.Added toolboxConfig collector to
memsql-report collect
that saves the Toolbox’s configuration to a report file.Added a host collector to
memsql-report collect
that saves each host’s description to a report file.Fixed a bug where
memsql-admin enable-high-availability
does not request the correct privilege.Added a snapshot retry before upgrade if a database is re-provisioning.
Removed extra escape characters in log outputs to make verbose logs more readable.
2020-03-09 Version 1.4.3
Improved command
memsql-deploy upgrade
:Added a disk space check and a database snapshot is taken before an upgrade is started.
Added cleanup steps in case of an unsuccessful upgrade.
Added
memsql-admin put-file
command that copies a file to the same path on all hosts.Fixed a bug where
memsql-admin stop-node --all --force
did not stop any nodes if one node was unavailable.Stopped producing messages if no action will be taken by a command.
Fixed a bug where
memsql-deploy upgrade
did not wait for the database to restart after an upgrade is finished.Fixed a bug in
memsql-admin enable-high-availability
where the command does not work correctly if two leaf nodes on the same host have different hostnames.Added an additional check to
memsql-report
that ensures all cluster hosts have SSD drives.Added
--validate-env
option tomemsql-report
that will validate if MemSQL can be installed.
2020-02-11 Version 1.4.2
Improved the prompt message that is displayed when upgrading databases to the new replication modes in MemSQL 7.0.
Improved the speed of health checks that are performed on columnstore tables during upgrades.
Improved the way
memsql-deploy upgrade
waits for node recovery.Fixed a bug where
memsql-toolbox-config
is not able to resolve a state file but returns incorrect error.Fixed a bug where
memsql-deploy
downloaded the package twice for online upgrade.Fixed the behavior of disk checks before upgrade: always fail upgrade if there is not enough space, show success message on success only.
Fixed a bug where toolbox commands did not close the environment after a command failure.
Added command-line flag checks to
memsqlctl
client.Added possibility to set MaxSSHSessionsPerHost parameter with command line (
--ssh-max-sessions
) or config file.Fixed bug where the
memsql-deploy setup-cluster --cluster-file <cluster-file>
command returns nodes with Unknown role.
2019-11-25 Version 1.4.1
Fixed a bug where all Toolbox commands were not able to pass the
--parallelism
flag.Fixed a bug where running
memsql-deploy upgrade
without any flags would perform a rolling restart on the cluster.Fixed a bug where the user would always be prompted for changes to the replication mode of the databases, instead of only being asked when upgrading to MemSQL 7.0.
2019-11-19 Version 1.4.0
Updated
memsql-deploy
to support upgrade to MemSQL 7.0Added TSV based output for some
memsql-report
collectors.Fixed a bug where
memsql-report check
fails to check for blocked queries with time 0.Updated
memsql-admin update-config --set-global
to automatically run on the Master Aggregator.Updated the
securityLimits
collector to include the output of/etc/security/limits.d
and/proc/PID/limits
Updated the
numactl
checker to check if the sum of numa node memory capacity exceeds machine memory capacity.Added new collectors to
memsql-report collect
:top
informationSchemaMvBackupHistory
Added new checkers to
memsql-report check
:orphanTables
2019-10-09 Version 1.3.0
Added support for
memsql-deploy setup-cluster
to accept a YAML file with cluster configurations.Fixed a bug where
memsql-report
exits with a status of 0 if it fails.Fixed a bug that caused the output of
memsql-report collect
to be not parsable bymemsql-report check
Added new collectors to
memsql-report collect
:uptime
shutdownTime
rebootTime
Added new checkers to
memsql-report check
:tracelogOOM
tracelogOOD
explainRebalancePartitionsChecker
longRunningQueries
detectCrashStackTraces
defaultVariables
Updated the checkers
defaultKeepaliveSettings
anddefaultHeartbeatSettings
to be part ofdefaultVariables
checker
2019-09-03 Version 1.2.3
Fixed a bug where the output of `memsql-report collect` could be missing information.
2019-08-06 Version 1.2.2
Added support for rootless memsql-server installs using tar-based packages.
Added the
--role
flag tomemsql-admin start-node
to start the nodes by role.Added the
--role
flag tomemsql-admin stop-node
to stop the nodes by role.Added the
Bind Address
column tomemsql-admin list-nodes
output.Updated
memsql-admin delete-node
to remove leaves and child aggregators from the cluster before deleting them.Updated the sort order for
memsql-admin list-nodes
to be consistent with other commands.Improved the readability of the
License Expiration
field inmemsql-admin show-license
.Fixed a bug that caused the
schema
collector inmemsql-report collect
to not collect procedures from memsql-server version 6.7.11 and above.Added new collectors to
memsql-report collect
:explainRestoreRedundancy
explainRebalancePartitions
showClusterStatus
Added new checkers to
memsql-report check
:delayedThreadLaunches
2019-04-22 Version 1.1.1
Added the
--stop
flag tomemsql-admin delete-node
to stop the nodes before deleting them.Added the
--host
,--port
,--user
, and--password
flags tomemsql-admin query
for querying a node directly.Added new checkers to memsql-report check:
disconnectedReplicationSlaves
interpreterMode
leafAverageRoundtripLatency
runningBackup
secondaryDatabases
validLicense
Updated checkers in
memsql-report check
:blockedQueries
also looks for sleeping threads with open transactionsofflineLeaves
renamed toleavesNotOnline
Added table-based output for some
memsql-report
collectors.Shortened the filenames inside a cluster report to avoid name length limits in archive files.
2019-03-19 Version 1.1.0
Fixed a bug that prevented NOPASSWD sudo from being considered passwordless sudo.
Added the
memsql-admin query
command.Added more properties to
memsql-admin list-nodes
andmemsql-admin describe-node
.Removed the
swappiness
checker. The setting it checked is not required by MemSQL 6.7.Updated the
informationSchemaPipelines
collector to includeinformation_schema.PIPELINES_CURSORS
andinformation_schema.PIPELINES_FILES
.Added new collectors to
memsql-report collect
:explainOrphanDatabases
informationSchemaMvQueries
licenseMetadata
Added new checkers to
memsql-report check
:defaultHeartbeatSettings
defaultKeepaliveSettings
defaultWorkloadManagement
defunctProcesses
duplicatePartitionDatabase
failedCodegen
offlineAggregators
offlineLeaves
pendingDatabases
queuedQueries
userDatabaseRedundancy
versionHashes
Updated the report format to include the source paths of copied files.
Updated the
env
commands to include the resolvedconfigFile
location.
2019-01-08 Version 1.0.6
Updated
memsql-deploy cluster-in-a-box
to set passwords that are required bymemsqlctl create-node
starting in MemSQL 6.7.8.memsql-admin create-node
now requires the--password
flag.Added the
--base-install-dir
flag tomemsql-admin create-node
.Updated
memsql-report collect --only
to also include thememsqlctlInfo
collector by default.Added a safety check to
memsql-deploy setup-cluster
that prevents enabling High Availability with an odd number of leaves.Added the
--skip-disk-check
flag tomemsql-admin enable-high-availability
.
2018-12-04 Version 1.0.5
Added support for advanced usage of
memsql-admin register-node
.
2018-12-04 Version 1.0.4 (internal only)
Added the attempted command string to error messages due to failed command execution.
Added support for running commands as a Linux user that is part of an unnamed group.
Fixed a bug in
memsql-deploy install
that improperly failed the installation if it was unable to add the target user to thememsql
Linux group.Added support for advanced
memsqlctl
configuration tomemsql-report collect-local
.Reduced spurious errors from
memsql-report check
whenmemsqlctl
is not installed on the target hosts.Added support for changing the SQL root password on all nodes in the cluster with
memsql-admin change-root-password
.
2018-11-27 Version 1.0.3
Added advanced
memsqlctl
configuration flags tomemsql-toolbox-config register-host
.Enabled parallelism for
memsql-report collect
.Added the report file path to the output of
memsql-report collect
andmemsql-report collect-local
.Fixed a bug in
memsql-admin
confirmation messages that incorrectly implied the use of--password
when it was not used.
2018-11-20 Version 1.0.2
Fixed bug preventing the use of
memsql-admin update-config --all
.Added “host” field to
memsql-admin describe-node
output.Fixed a bug in
memsql-deploy list-versions
when there are no hosts registered.Changed permissions logic to use
memsqlctl
configuration to determine the correct user and group for remote commands.
2018-11-09 Version 1.0.1
Fixed bug causing Toolbox to assume passwordless sudo if there were cached sudo credentials in the current session.
2018-11-06 Version 1.0.0
Initial release of memsql-toolbox.