The changelog for key MemSQL Ops releases is listed here.

2016-04-29 Version 5.0.3 (LATEST)

• Bug: Fixed issues with checkpointing database in Streamliner

2016-03-30 Version 5.0.2

• Feature: The new Schema Explorer allows users to explore the hierarchy of databases and tables in MemSQL. This tool can be used to help capacity plan or provide insight on data distribution.
• Feature: The new Query Explorer provides access to under-performing queries along with aggregated metrics over the historical record.
• Feature: Ops now includes a visual way to import your data into MemSQL from S3, HDFS and MySQL.
• Feature: Ops now includes a feedback form to enable issues to be easily reported.
• Stability: MemSQL Ops 5.0.0 (BETA) includes numerous performance, stability and bug fixes.

2016-01-28 Version 4.1.11

• Tweaked host sorting in memsql-list output to match agent-list.
• Added a –all option for memsql-update-config.
• Displayed cancelled batches for pipelines in the web UI.
• Various bug fixes

2015-12-15 Version 4.1.10

• Added NUMA support and memsql-optimize command
• Added agent-backup and agent-restore commands
• Added Python and pip support to Streamliner
• Added Identity transformer
• Added a MemSQLContext to prelude for spark-shell
• Added pipeline-import and pipeline-export commands
• Added Spark minimum version nag
• Various bug fixes

2015-11-03 Version 4.1.9

• Minor bug fixes

2015-11-02 Version 4.1.8

• Renamed cluster-start, cluster-stop, cluster-restart, cluster-upgrade and cluster-enable-high-availability commands to memsql-start --all, memsql-stop --all, memsql-restart --all, memsql-upgrade and memsql-enable-high-availability to be more consistent with agent-start, etc.
• Added a --all flag to agent-uninstall to remove all MemSQL Ops agents in the cluster
• Added a --all flag to memsql-delete to delete all MemSQL nodes in the cluster
• Added an agent-move-memsql-installs-dir command to move MemSQL nodes to another directory
• Improved various backend components to improve Ops’s performance on large clusters
• Add running batches and more batch metrics to Streamliner Pipeline page

2015-09-24 Version 4.1.7

• MemSQL Streamliner: Use Apache Spark to stream data from various sources into MemSQL
• Tons of bug fixes and enhancements to the entire ecosystem

2015-08-31 Version 4.0.35

• Feature: Show swap as a separate bar on the cluster & host pages.
• Performance: The web interface now receives data via Push rather than the much less performant pull based model.
• Feature: Added –num-parallel to agent-ssh –multi.
• Security: The user can specify allowed websocket origins via the new websocket_origins setting.
• Security: MemSQL Ops no longer returns a Server field in HTTP responses.
• Bug: Remove loopback network tracking - now network speed is all interfaces except for loopback.
• Various other bugfixes

2015-07-31 Version 4.0.34

• Added –skip-disk-check option to cluster-enable-high-availability and changed –ignore-stopped-nodes to –skip-snapshot in the cluster-upgrade command.
• Allow custom data directories when –no-backup-data-directories is set in cluster-upgrade
• Use human-readable names in the MemSQL installs directory. Previously, MemSQL nodes were installed in directories with hex names; now, they’ll be in directories named after their role and port (e.g. ‘leaf-3306’). Existing MemSQL nodes will have their directories renamed the next time they are restarted.
• Added –hard-stop to memsql-stop
• /var/lib/memsql now points to the MemSQL Ops installs directory
• No more anonymous read-only access to web UI when superusers are enabled. Now a login page is shown for each page load.
• Follower UI now just tells user to go to the Primary Agent’s UI
• Cluster upgrade and agent upgrade now allows the user to pass in an archive file to upgrade to.
• HA node pairings are now visible on the Host page and MemSQL Node page
• Improvements to cluster reports.
• User can now specify whether to show the ip, hostname or other address for hosts on the cluster page.
• All addresses known about a given host are accessible on the Host page.
• Added –use-hostname flag when starting MemSQL Ops to set the host property on a agent to the machine’s hostname.

2015-07-10 Version 4.0.32

• Added –no-backup-data-directories flag to cluster-upgrade which avoids backing up MemSQL data directories during an upgrade. This allows the upgrade to happen in place, with the assumption that the user has made their own ba
• Various bugfixes

2015-06-30 Version 4.0.31

• Use the provided hostname when deploying agents, rather than guessing on each machine
• Added the memsql-restart CLI command
• Show an error when starting MemSQL Ops if it was previously started with root privileges
• Added the memsql-update-root-password CLI command
• Added a new cluster state column to memsql-list output
• Added the ssl-set-cert and ssl-disable CLI commands for enabling SSL in the web UI (only available to Enterprise users)
• Made MemSQL Ops idle rather than shut down when it has run out of disk
• Checked memory and CPU count during MemSQL Ops installation and failed if either is too low (unless –ignore-min-requirements is passed in)
• Added a –settings-path flag to all MemSQL Ops commands to let users use a settings.conf file in a custom location
• Disabled cluster upgrades for MemSQL nodes with a custom datadir setting
• Added support for upgrading a MemSQL cluster from redundancy level 1 to redundancy level 2 in both the CLI and the web UI
• Added a –memsql-role option to the agent-ssh, agent-put, and agent-get CLI commands
• Added some nags in the web UI for offline agents and MemSQL nodes that are not connected to the cluster
• Added a MemSQL speed test for testing cluster performance in the web UI

2015-05-25 Version 4.0.28

• Improved report command so that it works in more cases
• Improved algorithm for finding IP addresses during agent installs

2015-05-20 Version 4.0.27

• Initial public release

Was this Article Helpful?

Thanks For Your Feedback!