Welcome to Managed Service for TimescaleDB (MST)! MST is a Database as a Service (DBaaS) offering that provides an easy way for you to analyze time-series. Powered by TimescaleDB, you can create database instances in the cloud and automate many of your most common operational tasks. This allows you to spend more time focusing on your time-series workloads and less time worrying about database management.
Before we start - a couple core concepts and phrases
For reference, a few of the core concepts you will encounter when you are using MST:
Account: Your MST account. You can register for a MST account on the Sign Up page.
Project: An empty project is created for you automatically when you sign-up and are the highest organization level. Projects organize groups of services, and have different billing settings. A way to organize Services in your account and provide access to Services with other users. This is the highest level of access.
Service: Multiple services can be created under each project, and each service corresponds to a cloud service provider tier (e.g. AWS Timescale-Pro-512-IO-Optimized).
Database: Databases are created within the context of a single server, and can be viewed and created after selecting one of your services, and then selecting the databases tab.
Service Plans: A Service Plan defines the configuration and level of database management that will be performed for a given TimescaleDB deployed.
Step 1 - Sign up for Managed Service for TimescaleDB
Verify your account by clicking on the link in the email you will receive.
Step 2 - Create your first service
Login to MST using your credentials.
Click on the "create a new service" button:
Select TimescaleDB, Choose your cloud provider, region, and service plan. (Note: you’ll have $300 of free credits to get started exploring)
Wait a few minutes while the new database is being created.
Step 3 - Install psql (or another preferred SQL client like pgAdmin)
If you don’t already have psql installed, here are the instructions.
Step 4 - Connect to your new database via psql
Click on your new service. In the “Overview” tab, you’ll see the Service URI. Click on the “Copy” link to copy it to your clipboard:
Switch over to a terminal window and paste your connection string after the psql command:
$ psql postgres://tsdbadmin:{YOUR_PASSWORD_HERE}@{|YOUR_HOSTNAME_HERE}:{YOUR_PORT_HERE}/defaultdb?sslmode=require
psql (11.3, server 11.4)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
Type "help" for help.
defaultdb=> Step 5 - Verify that TimescaleDB is installed
Run the \dx command to view all installed extensions:
defaultdb=> \dx
List of installed extensions
Name | Version | Schema | Description
-------------+---------+------------+-------------------------------------------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
timescaledb | 1.3.2 | public | Enables scalable inserts and complex queries for time-series data
(2 rows)
defaultdb=>
Conclusion
Well done! Now you are up and running on MST.
While we're working on having a few example data sets pre-loaded in your database, check out this link to explore examples with time-series weather data, DevOps data, and more.