Infrastructure at your Service

Tag

AWS Archives - Blog dbi services

Franck Pachot

Oracle Standard Edition on AWS ☁ socket arithmetic

By | AWS, Cloud, Oracle | No Comments

By Franck Pachot . Note that I’ve written previously about Oracle Standard Edition 2 licensing before but a few rules change. This is written in May 2020. TL;DR: 4 vCPU count for 1 socket and 2 sockets count for 1 server wherever hyper-threading is enabled or not. The SE2 rules I think the Standard Edition rules are quite clear now: maximum server capacity, cluster limit, minimum NUP, and processor metric. Oracle has them in the…

Read More
Franck Pachot

AWS Certified Database Specialty (DBS-C01)

By | AWS, Cloud | One Comment

Here is my feedback after preparing and passing the AWS Database Specialty certification. There are tips about the exam but also some thoughts that came to my mind during the preparation when I had to mind-shift from a multi-purpose database system to purpose-built database services. Exam Availability This exam was in beta between last December/January and then was planned for production starting April 6, 2020. I initially planned to take the exam this first day…

Read More
Daniel Westermann

AWS RDS for PostgreSQL – 4 – Changing parameters

By | AWS, Database Administration & Monitoring | No Comments

If you followed that last posts about DB Parameter Groups, Subnet Groups and Setting up the RDS instance you should have a running RDS instance. You should also be aware that changing parameters can not be done like you usually do it but you need to do that by changing the DB parameter groups. In this post we’ll look at how you can do that and, especially, what you should avoid.

Read More
Daniel Westermann

AWS RDS for PostgreSQL – 3 – Creating the RDS PostgreSQL instance

By | AWS, Database Administration & Monitoring | No Comments

In the last tow posts we had a look at DB Parameter Groups and Subnet Groups as these need to be ready when you want to deploy a RDS PostgreSQL instance on AWS. In this post we’ll use these two building blocks to bring up a high available PostgreSQL instance using a master instance in one, and a replica in another availability zone. This is usually what you want when you want a production deployment…

Read More
Daniel Westermann

AWS RDS for PostgreSQL – 2 – Subnet groups

By | AWS, Database Administration & Monitoring | No Comments

In the last post we had a look at DB Parameter Groups when it comes to AWS RDS for PostgreSQL. This is one of the first things you should think about. But even before you think about PostgreSQL parameters you need to configure the networks your database instances shall be running in. In real life this is done by one of your network administrators and you will not have much to configure in this area….

Read More
Daniel Westermann

AWS RDS for PostgreSQL – 1 – DB Parameter Groups

By | AWS, Database Administration & Monitoring | No Comments

When your go for AWS RDS you can very quickly bring up a database instance and start using it. I’ve written about my thoughts using this approach here and really encourage you to learn about a specific service in more detail before you start using it. If you want to have a managed service for PostgreSQL in AWS, you can go for AWS RDS for PostgreSQL and this service will be the topic for this…

Read More
Daniel Westermann

Some thoughts about working with/on AWS

By | AWS, Database Administration & Monitoring | One Comment

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 of services (EC2, mostly) and we have a limited amount of trainers that use the platform to deliver our trainings. When the amount of services you use is small and the amount of people managing…

Read More
Daniel Westermann

Rapid PostgreSQL cloning using AWS EBS snapshots

By | AWS, Cloud, Database Administration & Monitoring | No Comments

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 snapshots. In this post we’ll look at how you can quickly spin up EC2 instances that use these snapshots as a base for new PostgreSQL clusters. Although we’ll be using the AWS console to show how this can be done you should use…

Read More
Daniel Westermann

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

By | Database Administration & Monitoring | No Comments

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 S3. Another method of doing that would be to use “Cached Volume gateway” instead of the File gateway we used in the last post. The volume gateways does not provide access via NFS or SMB but does provide a volume over iSCSI and the on-prem machines will…

Read More
Daniel Westermann

Using AWS Storage Gateway as a backup target for PostgreSQL

By | Cloud, Database Administration & Monitoring | No Comments

In the last post we had a quick look at AWS Kinesis data streams and how you can push data to AWS S3 using AWS Firehose. Another great AWS service is AWS Storage Gateway and in this post we’ll use that to push our PostgreSQL backups to AWS. The primary usage of AWS Storage Gateway is to extend you local storage to AWS so that you do not have to extend your local storage on…

Read More