Cross-region DataGuard in OCI coded with Terraform

In one of the latest lessons of my tutorial I have shown how to setup DataGuard locally within the same region. I guess this is some sort of database protection, but in case of the whole region failure it will not help at all. So it is worth to consider the cross-region solution for database security. In this additional lesson I am trying to showcase how to deploy remote DataGuard Association with the usage of Terraform code.

Pic. Topology Diagram

The database archivelogs will be send directly via DRGs and OCI backbone. I hope you will find this dish tasty and it will be somehow useful for your work with the cloud solutions. Let me know if you have any kind of feedback. 🙂

Bon Appetit,

Martin, The Cook.

Subscribe to get access

For now video is blocked, but you can watch it immediately when you subscribe!

How to clone ATP in OCI…

About the flexibility of ATP instances in OCI I have written so far two times. For the first time, it was just a short ride to show how it easy to create this autonomous database in OCI. For the second time, I have shown a new feature of ATP – Private Endpoint. It means ATP instance will be completely separated from the public Internet and visible exclusively in the private subnet. Today I will show you yet another feature of ATP. Now you can quickly clone ATP instance. You can do it in two different ways. The basic is just a clone from the existing instance. A more sophisticated clone is based on ATP automatic backups. In the video below you can watch both use-cases coded with Terraform. I hope it will be a tasty thing as previous recordings 🙂

Bon Appetit,

Martin, The Cook.

 

How to use Terraform and OCI – lesson 7a

A few days back I have written a post about a new feature in OCI related to the DBSystem. Now you can change the shape of your VM where your database is deployed. This level of elasticity is crucial. But what to do in case of a Disaster Recovery scenario. What to do when one AD is not working properly. In that case, you can deploy DataGuard technology. In the on-prem era it was somehow complicated. I do remember well how much time does it has taken to the setup primary-standby database configuration. Now in OCI, it is a matter of few clicks in the Cloud Console or few lines of code in Terraform (check updated repo content in GitHub for lesson 7a).  In the video below you will see how to use this code in practice. Additionally, I will use the network security groups (NSG) approach instead of security lists (SL). Hope this dish will be very tasty 🙂

Bon Appetit,

Martin, The Cook.

 

Subscribe to get access

For now video is blocked, but you can watch it immediately when you subscribe!

Changing the shape of a virtual machine DB System in OCI with Terraform

True public cloud means the elasticity of the cloud resources. The newest feature related to OCI DBSystem enhanced a few days back means exactly this, true database resource elasticity. I can imagine that in many cases your current DBSystem shape is too small or too large for the workload which is executed. In that case, it would be great to have some simple way to change CPU power by alternative VM shapes. That is why recently I was extremely excited about the dynamic option for DBSystem in case of virtual machine shape change.  You know that for sure, I am a huge fan of automation, Infrastructure as Code approach and Terraform runtime. So I have checked immediately if we can find the corresponding change in the Terraform OCI Provider code. Guess what? Version 3.65.0 supports this new OCI feature. Below a short video shows how it was easy to use this new feature in brand new Terraform OCI Provider.

Bon Appetit,

Martin, The Cook.

Private Endpoints for OCI Autonomous Database

Pic. Topology Diagram for Private Endpoint for ATP

It is not the first blog post about ATP, but I think this one is even more interesting. For your information, a few days back at OCI Release Notes webpage I have found information about new features for OCI Autonomous DB offering. I am talking about Private Endpoints for ATP or ADW databases. This feature has been awaited for a very long time. Previously your ATP or ADW databases were available only via public IPs. Now you can nest them inside a particular VCN and subnet. It means your database will be available under private IP enclosed in your subnet’s CIDR. Of course, you need to prepare some Network Security Groups (NSG) on ATP/ADW level and VM level. Since that moment VM can connect to ATP/ADW with SQLNet connection via private IP. For testing purposes I have created small GitHub repo and below you can find a video about how to use that repo. I believe you will find this dish very delicious. 🙂

Bon Appetit,

Martin, The Cook.

Subscribe to get access

For now video is blocked, but you can watch it immediately when you subscribe!

Dinner for tonight – ATP again :)

More then a year ago in this post, I have initiated OCI ATP provisioning topic. After a year I have rewritten the whole repo. Not only because HCL 0.12 is a formal standard now, and all Terraform code was outdated. I have done it also because I feel it is good in general to re-test everything and verify how it works nowadays. On the other hand, after my last course for Terraform, I have found myself confident enough to record videos for blog posts like this one. That is why you can also find a short movie below. 🙂

Bon Appetit,

Martin, The Cook.

How to use Terraform and OCI – lesson 8

This short course, my first tutorial is going to finish… I believe we have achieved good taste of our dish, right! 🙂 Last time in lesson 7 we have created a database with OCI DBSystem. In this last lesson, we will add local VCN peering which is documented here. I hope you have found all of my lessons interesting. I am really curious about your general feedback meaning what was good or great or maybe what was missing and should be added in some form in the future (course update or additional recordings). In case of any questions, you can drop me an email at martin.linxfeld@foggykitchen.com.

Bon Appetit,

Martin, The Cook.

Subscribe to get access

For now video is blocked, but you can watch it immediately when you subscribe!

How to use Terraform and OCI – lesson 7

Oracle is well known for its database, for more than 30 years, meaning for many people on the market, the term database means Oracle and long, long nothing else. Until now in our lessons, we were far from the database. Instead, we were covering cloud networking (VCN, subnets, route tables, load balancers), security (security lists) and ultimately VMs (for web tier). Now it is a time for Oracle RDBMS database! In lesson 7 we will add DBSystem, which is Oracle’s PaaS offering. It is really simple. I guess this soup will taste fantastic!

Bon Appetit,

Martin, The Cook.

Subscribe to get access

For now video is blocked, but you can watch it immediately when you subscribe!