SingleStore Managed Service

Manage Organizations

There are two types of Managed Service user:

  1. Organization: An organization user resides within the “control plane” of Managed Service and can perform those actions that are available on the portal, such as manage organization users, manage clusters, and run SQL queries against cluster data via the portal SQL editor.

  2. Database: A database user resides in the cluster. A database user’s lifetime is bound to that cluster such that, when a cluster is terminated, all of the users, permissions and groups are permanently removed as well. Database users can connect to the cluster via SQL client and run SQL queries against their data (with certain exceptions due to Managed Service permissions). Unlike organization users, database users must be managed via SQL statements. Note that a database user does not necessarily need to be an organization user to access a cluster created in an organization.

These two types of user work in concert to manage cluster resources and work with cluster data.

About Organizations and Users

SingleStore organizations allow shared access to deployments and resources within a company or group. A default organization is automatically created when a user registers on the portal.

The organization’s configuration can be viewed by expanding the organization menu. This includes:

  • The list of running clusters

  • Licenses for on-prem deployments

  • Members

  • Billing & Usage

  • Settings

Each organization must have a billing account to create production clusters. The billing account is used to pay for on-demand clusters, or to pay for monthly credits and storage usage for subscription customers. Additional billing accounts can also be added, but only the default billing method will be charged for usage.

A user is an Individual who logs into the portal and can access portal services. Each user is associated with a default organization. While most users will have one organization for their company, they can belong to, and be removed from, multiple organizations. An organization allows multiple users within a company to manage clusters and resources affiliated with that organization.

Each organization user is an administrator of that organization. A user that has admin permissions on an organization can:

  • Add users to, and remove users from, the organization

  • Manage billing and payment methods within the organization

  • Create resources (clusters) within the organization

  • Manage/terminate resources (clusters) within the organization

Any user can manage billing accounts as needed. To add a billing account, select the organization name in the left nav (ORG:) > Billing & Usage > Payment Methods, click the Add Payment Method button, and follow the provided instructions.

A user’s organization is shown in the left side navigation in the portal. If a user is a member of multiple organizations, they may select the desired organization using the double arrows (ms-switch-org.png) next to the organization (ORG:) menu.