This session gives an overview of different technologies customers can leverage to run multiple SAP HANA database instances and workloads on the same physical server, thus increasing the utilization of IT resources and lowering TCO.
In the first part of the session we introduce SAP HANA virtualization and multi-tenancy concepts. We talk about the grouping of virtualization technologies into hardware partitioning and software virtualization and discuss which technologies are supported with SAP HANA along with their status. Specific requirements for running SAP HANA in a virtual environment are also discussed, as well as what customers should keep in mind when deciding on their virtualization/partitioning approach.
The focus of the second part of the session is on native SAP HANA multi-tenant capabilities: Multiple Components, one Database (MCOD), Multiple Components, one System (MCOS), and the most recent Multi-tenant Database Containers (MDC) capability that was introduced with SPS 9. The main focus here is on the built-in SAP HANA MDC capability which enables users to run multiple workloads on the same host server. We describe in detail the MDC concept of having a single system database that contains system-wide landscape information and many tenant databases with separate schemas/workloads that are strictly isolated from each other. The role of the central database in administrating and monitoring, individual tenant-based capabilities, as well as user and administration layers and HA-DR settings are also discussed.
We end the session by going over main considerations and trade-offs between virtualization technologies and the native SAP HANA MDC capability. We also discuss what users should keep in mind when deciding on their virtualization or multi-tenancy approach for SAP HANA.
SAP HANA continued innovation includes work on enabling the latest partitioning/virtualization technologies (such as VMware vSphere 6.0, Huawei FusionSphere 5.1), as well as further enhancing native SAP HANA MDC capability. Here is a list of the planned MDC enhancements in the upcoming SPS12 release:
- System replication techniques used for tenant database move or copy with near-zero downtime
- Enhanced monitoring information to increase transparency on status of tenant databases
- Audit logging for cross-tenant access for increased governance
- Choice of GUI or command line interface to simplify conversion of single database to multi-tenant database
For more details and to learn about many new capabilities coming with the SAP HANA SPS12 release in the areas of virtualization, multi-tenancy, and other topics – make sure to sign up for the upcoming iFG Webinar Series: Get Ready for SAP HANA SPS12! scheduled to start on May 12th. In case you were not available to attend these sessions, check the SAP HANA iFG Jam group where all session recordings and materials will be stored for later use.