AWS

Some thoughts about working with/on AWS

In the last year working with/on AWS has become an almost daily task in my life as a consultant and trainer. From a trainer perspective there is not much to say about it because we use a very limited amount(…)

Rapid PostgreSQL cloning using AWS EBS snapshots

When you go for AWS EC2 instances to host your PostgreSQL deployments and you want to rapidly clone PostgreSQL instances for development or testing purposes you can make use of AWS EBS(…)

Using AWS Storage Gateway as a backup target for PostgreSQL – Cached volume gateway

In the last post we had a look on how you can use AWS Storage Gateway as File gateway to store your PostgreSQL backups safely offsite on AWS(…)

Using AWS Storage Gateway as a backup target for PostgreSQL

In the last post we had a quick look at AWS Kinesis data streams and how you can push data to AWS S3 using(…)

Sending PostgreSQL data to AWS S3 by using AWS Kinesis data streams

Before we really start with this post: This is just an experiment and you should not implement it like this in real life. The goal of this post is just to show what is possible and I am not saying(…)

Migrating an Oracle instance to AWS Aurora – 4 – AWS DMS Change Data Capture (CDC)

This is the last post in this little series about migrating on Oracle instance to AWS Aurora with PostgreSQL compatibility. For the previous one you can check here, here and(…)

Migrating an Oracle instance to AWS Aurora – 3 – Data replication with AWS DMS

If you followed the last two posts in this little series (here and here) this is the current status of this demo migration project: We have converted the Oracle SH schema and(…)

Migrating an Oracle instance to AWS Aurora – 2– The AWS Schema Conversion Tool (SCT)

Having the required infrastructure ready now it is time to have a look at the AWS Schema Conversion Tool (SCT). The goal of this tool is to convert a source schema (Oracle(…)

Migrating an Oracle instance to AWS Aurora – 1 – Setting up the base infrastructure

Migrating database to the cloud is a hot topic since a few years. As more and more of our customers are in the cloud, and some of them in AWS, migrating some of their Oracle databases(…)

AWS Automation – Stop a RDS instance

Introduction I created a RDS SQL Server instance on AWS. I use it for test purpose and to minimize the costs I needed to ensure that my instance is stopped automatically at the end of the working day and also(…)