Learn About Running Any Size Workload More Sustainably on Oracle Cloud

Faced with spiking energy consumption and associated costs, Deutsche Bank turned to Oracle cloud architects for help.

After running advanced data analytics, and machine learning algorithms to optimize its energy consumption, the Frankfurt-based multinational financial giant consolidated 10,000 databases, ran them on Oracle Exadata Database Service on Cloud@Customer, and was able to reduce its energy consumption by 15% within the first year.

Oracle Exadata Database Service on Cloud@Customer allows companies to run Oracle's cloud services on their own premises, rather than in a public cloud environment. In the case of Deutsche Bank, this solution enabled the bank to consume less energy and reduce costs by:

  • Optimizing data center resources by running Oracle Cloud services in its own data center
  • Automating energy management to better monitor and control energy use, especially during low traffic cycles to conserve energy
  • Predicting energy requirements, using Oracle Exadata Database Service on Cloud@Customer, which includes Oracle Advanced Data Analytics that can help Deutsche Bank make informed decisions about its energy use, such as where it could improve energy efficiency and reduce waste
  • Running energy-efficient hardware from Oracle, of which 99.9% has been recycled and reused

Architecture

Oracle Exadata Database Service on Cloud@Customer allows customers to run Oracle databases on Oracle's Exadata hardware within their own data centers. This architecture provides the benefits of cloud computing while keeping the data within the customer's control.

The following diagram illustrates the architecture:



energy-efficient-workloads-oracle.zip

To set up a highly available Oracle Exadata Database Service on Cloud@Customer service, Deutsche Bank tapped Oracle cloud regions in Frankfurt, London, the US, and Singapore, all of which are powered by renewable energy. These data centers have been configured to work in an active-passive mode, with one data center serving as the primary site and the other serving as the standby site.

To set up this configuration:

  1. Configure the Exadata hardware and software in two or more data centers to be identical.
  2. Configure the databases in the primary site to use Oracle Data Guard, which provides automatic failover to the standby site in case of a disaster.
  3. Configure the standby database in the secondary data center to replicate the data from the primary database in real time using Oracle Data Guard.
  4. Configure the network connectivity between the two data centers to ensure that there is a reliable, low-latency connection between the two sites.
  5. Monitor the status of the primary and standby databases to ensure that they are synchronized and that the standby database is ready to take over in the event of a disaster.
  6. With this architecture, in the event of a disaster, the standby database in the secondary data center can be automatically activated to take over from the primary database in the primary data center, providing a highly available and disaster-resistant solution for your Oracle Exadata Database Service on Cloud@Customer environment.

This architecture supports the following components:

  • Tenancy

    A tenancy is a secure and isolated partition that Oracle sets up within Oracle Cloud when you sign up for Oracle Cloud Infrastructure. You can create, organize, and administer your resources in Oracle Cloud within your tenancy. A tenancy is synonymous with a company or organization. Usually, a company will have a single tenancy and reflect its organizational structure within that tenancy. A single tenancy is usually associated with a single subscription, and a single subscription usually only has one tenancy.

  • Region

    An Oracle Cloud Infrastructure region is a localized geographic area that contains one or more data centers, called availability domains. Regions are independent of other regions, and vast distances can separate them (across countries or even continents).

  • Compartment

    Compartments are cross-region logical partitions within an Oracle Cloud Infrastructure tenancy. Use compartments to organize your resources in Oracle Cloud, control access to the resources, and set usage quotas. To control access to the resources in a given compartment, you define policies that specify who can access the resources and what actions they can perform.

  • Availability domain

    Availability domains are standalone, independent data centers within a region. The physical resources in each availability domain are isolated from the resources in the other availability domains, which provides fault tolerance. Availability domains don’t share infrastructure such as power or cooling, or the internal availability domain network. So, a failure at one availability domain is unlikely to affect the other availability domains in the region.

  • Virtual cloud network (VCN) and subnets

    A VCN is a customizable, software-defined network that you set up in an Oracle Cloud Infrastructure region. Like traditional data center networks, VCNs give you complete control over your network environment. A VCN can have multiple non-overlapping CIDR blocks that you can change after you create the VCN. You can segment a VCN into subnets, which can be scoped to a region or to an availability domain. Each subnet consists of a contiguous range of addresses that don't overlap with the other subnets in the VCN. You can change the size of a subnet after creation. A subnet can be public or private.

  • Route table

    Virtual route tables contain rules to route traffic from subnets to destinations outside a VCN, typically through gateways.

  • Security list

    For each subnet, you can create security rules that specify the source, destination, and type of traffic that must be allowed in and out of the subnet.

  • FastConnect

    Oracle Cloud Infrastructure FastConnect provides an easy way to create a dedicated, private connection between your data center and Oracle Cloud Infrastructure. FastConnect provides higher-bandwidth options and a more reliable networking experience when compared with internet-based connections.

  • Dynamic routing gateway (DRG)

    The DRG is a virtual router that provides a path for private network traffic between VCNs in the same region, between a VCN and a network outside the region, such as a VCN in another Oracle Cloud Infrastructure region, an on-premises network, or a network in another cloud provider.

  • Service gateway

    The service gateway provides access from a VCN to other services, such as Oracle Cloud Infrastructure Object Storage. The traffic from the VCN to the Oracle service travels over the Oracle network fabric and never traverses the internet.

  • Object storage

    Object storage provides quick access to large amounts of structured and unstructured data of any content type, including database backups, analytic data, and rich content such as images and videos. You can safely and securely store and then retrieve data directly from the internet or from within the cloud platform. You can seamlessly scale storage without experiencing any degradation in performance or service reliability. Use standard storage for "hot" storage that you need to access quickly, immediately, and frequently. Use archive storage for "cold" storage that you retain for long periods of time and seldom or rarely access.

  • Identity and Access Management (IAM)

    Oracle Cloud Infrastructure Identity and Access Management (IAM) is the access control plane for Oracle Cloud Infrastructure (OCI) and Oracle Cloud Applications. The IAM API and the user interface enable you to manage identity domains and the resources within the identity domain. Each OCI IAM identity domain represents a standalone identity and access management solution or a different user population.

  • Policy

    An Oracle Cloud Infrastructure Identity and Access Management policy specifies who can access which resources, and how. Access is granted at the group and compartment level, which means you can write a policy that gives a group a specific type of access within a specific compartment, or to the tenancy.

  • Logging
    Logging is a highly scalable and fully managed service that provides access to the following types of logs from your resources in the cloud:
    • Audit logs: Logs related to events emitted by the Audit service.
    • Service logs: Logs emitted by individual services such as API Gateway, Events, Functions, Load Balancing, Object Storage, and VCN flow logs.
    • Custom logs: Logs that contain diagnostic information from custom applications, other cloud providers, or an on-premises environment.
  • Vault

    Oracle Cloud Infrastructure Vault enables you to centrally manage the encryption keys that protect your data and the secret credentials that you use to secure access to your resources in the cloud. You can use the Vault service to create and manage vaults, keys, and secrets.

  • Oracle Exadata Database Service on Cloud@Customer

    Oracle Exadata Database Service on Cloud@Customer provides Oracle Exadata Database Service that is hosted in your data center.

    Oracle Exadata Database Service enables you to leverage the power of Exadata in the cloud. You can provision flexible X8M and X9M systems that allow you to add database compute servers and storage servers to your system as your needs grow. X8M and X9M systems offer RDMA over Converged Ethernet (RoCE) networking for high bandwidth and low latency, persistent memory (PMEM) modules, and intelligent Exadata software. You can provision X8M and X9M systems by using a shape that's equivalent to a quarter-rack X8 and X9M system, and then add database and storage servers at any time after provisioning.

About Required Services and Roles

This solution requires the following services and roles:

  • Oracle Cloud Infrastructure

  • Oracle Exadata Database Service on Cloud@Customer

These are the roles needed for each service.

Service Name: Role Required to
Oracle Cloud Infrastructure: Administrator Manage policies, create dynamic groups, and set policies for function access.
Oracle Exadata Database Service on Cloud@Customer: sys
  • Create the standby database in Oracle Exadata Database Service on Cloud@Customer.
  • Log in to primary database and create Data Guard association between the primary and standby databases.

See Oracle Products, Solutions, and Services to get what you need.