Catalogs

Introduction to Catalogs, a multi-tenancy feature for isolating database objects and users, planned for future MariaDB releases.

Catalogs are planned for an upcoming release, and don't yet appear in any current releases.

Catalogs are a user account management feature. This section explains their role in organizing database objects and controlling access permissions.

Catalogs Overview

Introduces MariaDB catalogs, a multi-tenancy feature that lets a single server host multiple independent tenants, each with their own users, schemas, and logs.

Starting with Catalogs

Guide to initializing a MariaDB server with catalog support using mariadb-install-db --catalogs and adding new catalogs to a running instance.

Catalog-Specific Functions and Variables

Documents the catalog() function, which returns the current catalog name, and the @@catalogs system variable, which indicates if the server is configured for catalogs.

Catalog Status Variables

Covers status variables related to catalog operations and performance, useful for monitoring multi-tenant environments.

Connecting to a Server Configured for Catalogs

Explains how to connect to a specific catalog using the --catalog client option or the catalog_name.database_name syntax.

CREATE CATALOG

Define external catalogs for data integration. This statement configures connections to remote storage systems, allowing query access to external data sources.

SHOW CREATE CATALOG

Reference for the SHOW CREATE CATALOG statement, which displays the SQL statement used to create a specific catalog.

SHOW CATALOGS

Reference for the SHOW CATALOGS statement, which lists all available catalogs on the server.

USE CATALOG

Reference for the USE CATALOG statement, allowing a user to switch their current session's context to a different catalog.

DROP CATALOG

Reference for the DROP CATALOG statement, used to remove a catalog and all its associated databases and users.

_{This page is licensed: CC BY-SA / Gnu FDL}