In this article, we will learn
- What is SAP HANA Multitenant Database Containers (MDC)?
- Benefits of HANA MDC
- Architecture of HANA MDC
What is SAP HANA Multitenant Database Containers (SAP HANA MDC)?
When deploying SAP HANA, efficient use of hardware resources is key to achieve better performance and scalability while reducing TCO.
Prior to SPS09, SAP HANA supported multiple schemas in one SAP HANA system and multiple SAP HANA systems on single SAP HANA virtualized hardware.
With SPS09, SAP HANA added support for multiple tenant databases
in one SAP HANA system for production use. This feature is called as - "Multitenant database containers".
High level architecture of SAP HANA multitenant database containers
A multiple-container system always has exactly one system database
, used for central system administration, and any number of multitenant database containers (including zero), also called tenant databases
An SAP HANA system installed in multiple-container mode is identified by a single system ID (SID). Databases are identified by a SID and a database name. From the administration perspective, there is a distinction between tasks performed at system level and those performed at database level. Database clients, such as the SAP HANA studio, connect to specific databases.
All the databases in a multiple-container system share the same installation of database system software, the same computing resources, and the same system administration.
However, each database is self-contained and fully isolated with its own:
- Set of database users
- Database catalog
- Traces and logs
Although database objects such as schemas, tables, views, procedures, and so on are local to the database, cross-database SELECT queries are possible.
What is the benefit of HANA MDC architecture?
SAP HANA system with multitenant database containers feature can contain multiple tenant databases. All tenant databases in the same system share the same system resources (memory and CPU Cores).
However, each tenant database is fully isolated with its own database users, catalog, repository, persistence (data files and log files) and database services
so that for example, you can run both SAP Business Suite and SAP Business Warehouse (BW) in one SAP HANA system.
Another major benefit of multitenant database containers feature is that it simplifies development and deployment of secure, multi-tenant cloud-based applications.
While it is possible to build cloud applications without a multi-tenant database, there are several advantages in using one.
If you use a multi-tenancy at database and create a tenant database for each customer, you archive a high-degree of security as in the virtualization scenario. Since multitenant database containers feature is built into the SAP HANA architecture, there is no virtualization layer overhead, giving multitenant database containers performance and scalability advantages.