In this blog post, I will discuss Oracle Database on Cloud different choices & options you have for On-premise as well as for Oracle Cloud. It comes with options like:
- Database Cloud Service on Virtual Machine (VMDB) or Bare Metal (BMDB)
- Exadata on Cloud (ExaCS) or Exadata Cloud@Customer (ExaCC)
- Autonomous (ATP & ADW) with two deployment options: Serverless or Dedicated
I will also discuss What are these various Databases on Cloud deployment options, When to use what, Who controls what in these deployment options?
Database Choices & Options
In the diagram shown below, from left to right are the On-premises platform choices (i.e. all manual tasks), Automated, and Cloud choices (i.e. Autonomous).
- Traditional Database Deployment: The most common deployment model prior to the evolution of the Cloud where your DB is on the commodity hardware.
- Oracle Exadata On-premises: You will purchase Exadata and deploy your database & heavy workload on Exadata On-premise.
- Exadata Cloud@Customer: Instead of purchasing, you subscribe to the Exadata machine and work on a pay-as-you-go model.
- DB on Compute (OCI): This is similar to the first option, however instead of running on-premise, you are running it on Cloud (you will not get any tooling).
- DBCS (VMDB & BMDB): Databases run on OCI as a DBCS & this is where you get all the Cloud tooling like automated cloning, patching, backing up & restoring.
- Exadata Cloud Service: Running Exadata but on Cloud, you subscribe to either a Quater rack, Half rack or a full rack. (Note: To know more about Oracle Exadata Cloud Service(ExaCS) Architecture, click HERE)
- Autonomous DB Serverless: You will get the database but no access to the Autonomous DB host.
- Autonomous DB Dedicated: A dedicated Exadata infrastructure is assigned to you, on top of that you create a container DB, and on that, you can create multiple pluggable databases.
(Note: As of now, Dedicated only supports ATP)
Check below to look at what controls you have, for these different Databases on the Cloud as well as On-premise.
Database Service In Oracle Cloud Infrastructure
Databases in Oracle Cloud Infrastructure can be put in two main categories:
- User-Managed Database: User-managed Database are the Databases on bare metal, virtual machine, and Exadata DB systems that enable you to customize with the resources that meet your requirements.
- Autonomous Database: It includes
- ATP: Autonomous Transaction Processing
- ADW: Autonomous Data Warehouse
NOTE: To know more about ADW & ATP, click HERE.
Cloud Database Deployment Choices
Check the image below for an overall picture of deploying Databases on Cloud.
How To Provision Database on Oracle Cloud
1) Register & Log into the Oracle Cloud account, cloud.oracle.com.
Note: First, you should have an Account at Oracle Cloud and if you don’t have one, then you can register FREE using my step-by-step video & guide that I covered in episode 30. You can get it by visiting https://k21academy.com/30 or https://k21academy.com/cloud01.
2) Click on the hamburger menu, and Under ‘Database’, you will get the option to provision DB.
For a User-managed Database, click on ‘Bare Metal, VM & Exadata,’ & the other two for Autonomous (ADW & ATP)
Well, that’s it about database deployment options in Cloud.
Next week, I am going to talk about the Roles and responsibilities of DBAs in Cloud for both Database Cloud Services like VMDB, BMDB and also Autonomous DB.
Join my 30-day FREE training on DBA to Cloud DBA where I will be teaching some technical basics and answering all your queries related to Cloud in a dedicated FREE Facebook community (http://k21academy.com/dba2clouddba) especially for DBA, Apps DBAs & Technical Architects who want to move to Oracle Cloud.