This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-24. For the latest, interactive version please visit https://mariadb.com/kb/.

Starting with Catalogs

MariaDB starting with 11.8

Catalog support is planned for 11.8.

Background

mariadb-install-db initializes the MariaDB data directory and creates the system tables in the mysql database.

When used with the --catalog options it will initialize MariaDB server to use catalogs. The mariadbd server will automatically discover if catalogs are used or not.

Note that one cannot change a 'normal server' to a server with catalogs or a server with catalogs to a 'normal server'. In the future we will add tools that will allow one to easily move an existing server inside a catalog or move an server inside a catalog to a standalone server.

Initializing a New Server with Catalog Support

To initialize a server with 4 catalogs (the def catalog, that holds the catalog root user (CRU) is automatically created):

mariadb_install_db --catalogs="cat1 cat2 cat3" --datadir=/my/data/

The above will create a directory /my/data and the 4 directories under it, one for each catalog.

Adding More Catalogs to a Running Server

Creating Catalogs with CREATE CATALOG

One can create a new catalog with CREATE CATALOG catalog_name

Creating Catalogs with mariadb_install_db

When adding more catalogs to an existing server, mariadb_install_db will start the mariadb client to execute the needed commands on the running server. This is why one has to supply user and password to mariadb_install_db.

mariadb_install_db --catalogs="cat4 cat5 cat6" --datadir=/my/data --catalog-user=monty --catalog-password

One benefit of using mariadb_install_db is that it's possible to create many catalogs with one command.

See Also

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.