Resource Pool on SingleStoreDB Cloud Cluster

{question}

How do I get access to Resource Pools on SingleStoreDB Cloud Clusters?

{question}

{answer}

In SingleStore v7.5, we added new permissions: CREATE POOL and DROP POOL. These permissions are used for modifying Resource Pools. We have added these permissions to the admin user on the SingleStoreDB Cloud cluster so that customers can manage Resource Pool independently. Before, the customer was required to create a support ticket for Creating and Managing Resource Pools.

Admin User Privileges:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, INDEX, ALTER, SHOW METADATA, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, ALTER VIEW, DROP VIEW, BACKUP, CREATE DATABASE, DROP DATABASE, CREATE PIPELINE, DROP PIPELINE, START PIPELINE, ALTER PIPELINE, SHOW PIPELINE, CREATE LINK, DROP LINK, SHOW LINK, DROP POOL, CREATE POOL ON *.* TO 'admin'@'%' IDENTIFIED BY PASSWORD '**********' WITH GRANT OPTION

Reference Links:

Resource Pool Command and Functions

KB on Resource Pool

{answer}