MemSQL Studio Architecture

Info

MemSQL Studio is designed to work with MemSQL 6.5 or later and is only supported on Chrome and Firefox browsers at this time.

MemSQL Studio has a one-to-many relationship with MemSQL clusters, which provides a number of advantages:

  • Easy upgrades: MemSQL Studio can be upgraded in minutes, making it easy to stay up to date with the latest features.

  • Multi-cluster management in one UI: A single instance of MemSQL Studio can communicate with all of your clusters.

  • Easily scalable: Because multiple Studio instances can communicate with a single cluster, you can easily scale out studio by creating new instances to manage user load.

Studio Directory Layout

For installations using the MemSQL Studio RPM and Debian packages, MemSQL Studio follows the Linux Standard Base layout. In addition, MemSQL Studio is also available as a tarball to provide flexibility and support for non-Debian or RPM-based deployments.

RPM And Debian Package Installation

The MemSQL RPM and Debian packages will place files in the following directories:

etc/
	memsql/
		memsql-studio.hcl
var/
	log/
		memsql-studio/
			memsql-studio.log
			memsql-studio.2017-11-09T10:23:03-08:00.log.gz
	lib/
		memsql-studio/
			studio.hcl
usr/
	bin/
		memsql-studio

Single Directory Installation

For installations using a tarball or single directory installation, the layout is as follows:

path/to/memsql-clients-{VERSION}/
	memsql-studio.hcl
	memsql-studio

memsql-studio-logs/
	memsql-studio.log
	memsql-studio.2017-11-09T10:23:03-08:00.log.gz

state/
	studio.hcl
Was this article useful?