Multi-Account Overview

Unlike MySQL, OmniFabric is a database with built-in multi-tenancy capability. In a OmniFabric cluster, accounts can be created using the CREATE ACCOUNT command. Conceptually, each tenant represents a completely independent data space, with all data and operations being isolated from other accounts. When users log in with the tenant's username and password, they enter a MySQL instance where they can perform various operations such as creating databases and tables without affecting the data of other accounts.

Introduction to accounts

The Account in OmniFabric is part of the permission management system.

Multi-tenancy has various use cases, including multi-tenancy design in SaaS applications, isolating accounts for subsidiaries of a corporation, and database usage for services in a microservices architecture. For more information on application scenarios, see Multi-Account section in the OmniFabric Feature Overview.

Creating and Using Accounts

1. For developers, creating and using accounts in OmniFabric can be done through SQL statements.
2. For operations personnel working with distributed versions of OmniFabric, it is necessary to configure resource isolation and scaling for accounts.

Account-to-Account Publish/Subscribe

In addition to ensuring data and load isolation between accounts, OmniFabric provides a publish/subscribe capability that allows data exchange between accounts. This capability can be used to address data synchronization and large-scale data distribution scenarios. For more information, see Publish-subscribe section.