Biju Augustian

Biju Augustian

1576477929

Oracle Database on AWS: EC2 & RDS from Scratch | Simpliv

Description
I will be looking to delve deeper into the AWS Infrastructure and demystify the entire dilemma around Oracle Database on AWS.

We will take a main architecture diagram as base , where we shall create a custom VPC, which will have a Public Subnet & a Private Subnet. The Public Subnet will have access to the internet and we will have a test Oracle 18c XE Database and an Apache Webserver in this.

The Oracle 12c RDS Database will be created in Private Subnet and will have access only from Webserver. To achieve this our approach would be as follows:

We will start with the very basics like : What is Cloud Computing , What are the meanings of the important acronyms like IaaS/ PaaS/ SaaS, Top Cloud Vendors by Market Share.

A good understanding will be given about AWS Cloud , Sign-Up Process and Understanding the AWS Management Console.

We will be approaching our study from Architecture standpoint by doing a deep dive into the Architecture of AWS and discussing : Regions / AZ / VPC / Security Groups / EBS Voume / S3 Storage,

A number of demos will be done on the creation of Custom VPC , Secury Groups , EBS Disk , S3 Storage. A demo will be done showing the configuration of AWSCLI on Mac OS / Windows.

EC2: We will discuss the details on EC2 / What are AMI: Amazon Machine Images.

We will do a demo to create an EC2 Instance in Custom VPC , Install 18c XE on EC2 Instance, Backups/Recovery using RMAN Backups to S3 Storage.

RDS: What is RDS / RDS for Oracle , Backup/ Recovery , Monitoring , Oracle Vs RDS commands

A demo will be done on Deploying Oracle 12c Database in RDS , Patching the existing version of Oracle.

A Demo will show the creation of EC2 instance which will act as Apache Webserver , then we shall install Apache, PHP and show the entire process around PHP with OCI8 Connectivity.

We will also discuss what is REST API and using a tool Postman call an RDS REST API.
To continue:

#cloud #oracle #database

What is GEEK

Buddha Community

Oracle Database on AWS: EC2 & RDS from Scratch | Simpliv

Split Native Databases Backup and Restore for AWS RDS SQL Server

In this article, we will explore how to split native backup and restore for AWS RDS SQL Server from the AWS S3 bucket.

Introduction

We can deploy SQL Server in Amazon Web Services (AWS) cloud infrastructure using the following ways.

  • AWS Managed RDS SQL Server
  • Customer Managed SQL Server

In the below table, we can see a high-level comparison between EC2 and RDS SQL.

high-level comparison between EC2 and RDS SQL

#aws #aws rds #backup and restore #aws rds sql server #aws s3

Ruth  Nabimanya

Ruth Nabimanya

1621312680

Amazon‌ ‌RDS‌ ‌Proxy:‌ ‌Taming‌ ‌DB‌ ‌Connections

Most developers find databases difficult to scale. There are a lot of frameworks that can run on multiple pods⁠—or even multiple clusters⁠—to handle more load. Some frameworks even support advanced load balancing and caching.

Still, when a spike beyond what the framework can handle happens, the database is almost always the first process to fail. It’s a horror story that every developer has experienced at least once. And it always happens at the most important moment⁠—such as during an important flash sale.

Taming database load management isn’t an easy task, but Amazon Relational Database Service (RDS) has been doing a great job at it. Amazon RDS Proxy though extends the features you can use to manage database connections to a whole new level.

#aws #blog #databases #amazon rds #aws iam #database security #rds #rds proxy

Biju Augustian

Biju Augustian

1576477929

Oracle Database on AWS: EC2 & RDS from Scratch | Simpliv

Description
I will be looking to delve deeper into the AWS Infrastructure and demystify the entire dilemma around Oracle Database on AWS.

We will take a main architecture diagram as base , where we shall create a custom VPC, which will have a Public Subnet & a Private Subnet. The Public Subnet will have access to the internet and we will have a test Oracle 18c XE Database and an Apache Webserver in this.

The Oracle 12c RDS Database will be created in Private Subnet and will have access only from Webserver. To achieve this our approach would be as follows:

We will start with the very basics like : What is Cloud Computing , What are the meanings of the important acronyms like IaaS/ PaaS/ SaaS, Top Cloud Vendors by Market Share.

A good understanding will be given about AWS Cloud , Sign-Up Process and Understanding the AWS Management Console.

We will be approaching our study from Architecture standpoint by doing a deep dive into the Architecture of AWS and discussing : Regions / AZ / VPC / Security Groups / EBS Voume / S3 Storage,

A number of demos will be done on the creation of Custom VPC , Secury Groups , EBS Disk , S3 Storage. A demo will be done showing the configuration of AWSCLI on Mac OS / Windows.

EC2: We will discuss the details on EC2 / What are AMI: Amazon Machine Images.

We will do a demo to create an EC2 Instance in Custom VPC , Install 18c XE on EC2 Instance, Backups/Recovery using RMAN Backups to S3 Storage.

RDS: What is RDS / RDS for Oracle , Backup/ Recovery , Monitoring , Oracle Vs RDS commands

A demo will be done on Deploying Oracle 12c Database in RDS , Patching the existing version of Oracle.

A Demo will show the creation of EC2 instance which will act as Apache Webserver , then we shall install Apache, PHP and show the entire process around PHP with OCI8 Connectivity.

We will also discuss what is REST API and using a tool Postman call an RDS REST API.
To continue:

#cloud #oracle #database

Migrating your on-premises SQL databases to AWS RDS SQL Server using AWS DMS

There are multiple ways to deploy the databases in the AWS RDS SQL Server. Suppose you want to migrate your on-premises SQL Server database to AWS managed relational database service and you have a critical application and require minimal (almost zero) downtime. For this purpose, you can use the AWS Database Migration Service (AWS DMS) in a combination of SQL Server native backups.

You can use the on-premises SQL Server as a source database; however, for demonstration of the steps, I will use the SQL Server on EC2 instance.

#aws #aws rds #aws dms #sql databases

Capturing deadlocks on AWS RDS SQL Server databases

This article will explore the process to capture deadlock XML and deadlock graphs for AWS RDS SQL Server databases.

Introduction

As a database professional, you confront the performance issues with databases. It might be due to a lack of indexes, improper indexes, poorly written T-SQL statements, outdated statistics, blocking, or deadlocks. It is essential to monitor the deadlocks in a SQL database irrespective of hosting on-premises or Cloud infrastructure.

Usually, we receive the following error in an application if SQL Server kills a process as the deadlock victim.

SQL Server deadlocks

#aws #aws rds #deadlocks #aws rds #sql server