Test with Example Data
Within the MemSQL client, you will now create a new database and table. Execute the following commands:
CREATE DATABASE quickstart; USE quickstart; CREATE TABLE messages (id text);
Now you will insert data into the new table and query it. Execute the following commands:
INSERT INTO messages VALUES('hello world'); SELECT * FROM messages;
The first statement inserts “hello world” into the new table, and the second statement displays the contents of the table.
MemSQL provides a browser-based management tool called MemSQL Ops. By default, MemSQL Ops can be accessed on port 9000. If you are running MemSQL on Docker, you mapped this port to the same port on your host machine to make MemSQL Ops accessible from any browser on your host machine.
This makes it easy to use MemSQL Ops in Firefox or Chrome simply by navigating to: localhost:9000
This interface can be used for:
- Monitor your cluster’s performance
- Change cluster settings
- Scale out the cluster by adding new nodes
- Explore existing databases and tables
- Create new connections to external data sources such as Apache Kafka, Apache Spark, or Amazon S3.