MemSQL Ops

The latest release of MemSQL Ops – version 4.0.34 – is now available for download! In this release, we are offering MemSQL users new features to accelerate productivity.

MemSQL Ops downloads and upgrades are available for free to all MemSQL Community and Enterprise users. Here are some of the features in the new MemSQL Ops release:

Ops Superusers

The new MemSQL Ops comes with an enhanced superuser account that locks down read and write access Superusers can be created with a single command:
memsql-ops superuser-add --password <password> <username>

All users will log-in through a screen that looks like this:
MemSQL Ops Login Screen
Figure 1: MemSQL Ops Superuser Login Page

Ops user accounts are distinct from MemSQL or Linux users: they only allow access to the MemSQL Ops user interface.

Installation Directory Improvements

In this release of MemSQL Ops, we made it more intuitive for users to navigate to MemSQL installation directories and access their content.

MemSQL installation directories were previously stored in /var/lib/memsql-ops/installs. In this release, we moved it to /var/lib/memsql.

MemSQL node installation directories were also previously unique IDs used by Ops for tracking. We changed the naming scheme to be human readable. MemSQL node install directories are now named after their role and port, for example, master-3306 represents a master aggregator running on port 3306.

MemSQL node installation directories can now be discovered more easily, for example:
$ cd /var/lib/memsql/master-3306

More Metadata about Hosts

This release introduces several additional pieces of metadata on the MemSQL Ops cluster page. When a cluster is configured with High Availability, which MemSQL recommends for all mission-critical deployments, individual host pages now contain more metadata about the High Availability (HA) pairings, including their HA group and paired MemSQL node.

memsql-ops-metadata
Figure 2: HA Metadata for MemSQL Leaf Nodes

All internal and external addresses known about a given host (i.e. public/private IP, public/private hostname, or other address) are now displayed on the cluster host page for each machine in the cluster. Furthermore, users can change the address displayed on the cluster page through a new option in the Settings > Config page.

Host Display Ops
Figure 3: Host Display Preference

Customizable MemSQL Upgrade Files

Users can now specify an installer file (tar.gz) for MemSQL cluster and MemSQL Ops upgrades through a new --file-path argument in cluster-upgrade and agent-upgrade commands. This enhancement gives users control over which version of MemSQL they want to install. Without this argument specified, the default behavior is to install the latest version of MemSQL from www.memsql.com/download.

Thanks for reading! Full release notes for current and previous MemSQL Ops releases are available on MemSQL Documentation.