Which three types of db systems can you deploy on oracle cloud infrastructure?

Database introduction

“

(intro music plays) - [Instructor] Welcome. In this lesson, we are going to look at what kind of managed database services you get in Oracle Cloud infrastructure. So let's look at these options here. OCI offers single node DB systems on either bare metal or virtual machines and two node real application cluster DB systems on virtual machines. Let's look into each of them separately. For one node virtual machine DB systems, OCI provides a fast provisioning option that allows you to create your DB systems using something called logical volume manager, as your storage management layer. The alternative is called standard provisioning and is provisioned with Oracle automatic storage management also known as ASM. So that use of logical volume manager gives this VM DB system one node virtual machine DB systems fast provisioning times. On the other hand, OCI also has bare metal DB system which consists of a single bare metal server running Oracle Linux with locally attached NVMe storage. If this single node fails, you can simply launch another system and restore the database from current backups. Then we also have an option to provision a two node real application cluster DB system which, which runs on OCI. In this case, when you provision this two node rack DB system, the system assigns each node to a different fault domain and that's how we are able to provide you managed high availability with this two node clusters. So these are the first three options, what we typically refer to also as DB systems. And let, let's look at some other options. The fourth option which is available is the Exadata cloud service, and think about this as as a service that lets you leverage the power of Exadata in the cloud. Oracle workloads have the highest performance running on this Exadata cloud service. In the latest version of the service X8M, we support an industry leading 1600 database server course, 12 million read, and around 6 million right IOPS, and databases which can be up to 2.5 petabyte in scale. This is just massive scale, not achievable anywhere else in any of the cloud managed database offering. And then the other database option which is available in OCI, are the autonomous databases. Now, autonomous database is a cloud database that uses machine learning to automate database tuning, security, backups, updates, and other routine management tasks traditionally performed by DBS. There are two kinds of workloads which are supported as part of the autonomous database. One is called autonomous data warehouse also sometimes referred to as ADW. And the other one is autonomous transaction processing also sometimes referred to as ATP. So those are the two workloads supported as part of the autonomous databases. There are two kinds of deployment models. The first one, as you can see on the screen here is called the shared deployment model. Here, you provision and manage only the autonomous database while Oracle handles accelerator infrastructure deployment and management as you can, as you can see on this slide, autonomous makes use of Exadata underneath. So that's the first deployment option. The second deployment option is dedicated. With this option, you have the exclusive use of the accelerator hardware, which runs underneath. So shared, sort of think about as a multi-tenant shared environment. Dedicated, single tenant dedicated to you. Now with Accelerator, you hear these three terms all the time. What do these terms mean? Well, self-driving, as we just explained, means that our database and infrastructure management monitoring and tuning processes are automated. So DBS can now focus on more important tasks. So that's what we meant, mean by self driving. Self-securing basically means autonomous database has built-in capabilities that protect against both external attacks and malicious internal users. So has these robust security capabilities built-in. And then self-repairing means that the database can prevent downtime including unplanned maintenance and there are some SLAs around that. So those are what we mean by self-driving, self-securing and self-repairing. So these are the, the first five or six database options which are available as managed cloud databases within OCI. Some of the, and you can see the broad spectrum here going from fast provisioning, fast performance all the way to completely automated self-driving, self securing, self repairing database options. Then some of the other options which are available in OCI also include a few open source database options including MySQL. So MySQL database service is a fully managed OCI service developed, managed, and supported by the MySQL team working within Oracle. Then we also have a NoSQL database service, which offers on demand throughput and storage based provisioning. This particular service supports JSson table and key value data types, all with flexible transaction guarantees and single digit millisecond latencies. And then the last one is autonomous JSON database, and this one is, is geared towards developing NoSQL style applications that use JSON documents. So, so just to recap, we just went over all the managed cloud database offerings within OCI, and there are eight or nine different options starting with VMDB systems, bare metal DB systems, two node VMDB rack DB clusters, Exadata cloud service autonomous, which comes in two workloads type, data warehouse transaction processing, two deployment models, shared and dedicated, and then few other database services including open source database options like MySQL, and then NoSQL database service, as well as JSON database service. So this OCI offers a full range of broad and deep managed cloud database services. And some of the subsequent lessons, we will dive deeper into many of these services. I hope you found this lesson useful. Thanks for watching.