Infrastructure at your Service

Tag

AWS Archives - Page 4 of 8 - Blog dbi services

Daniel Westermann

Getting started with Exasol – A multi node cluster in AWS

By | AWS, Database Administration & Monitoring | No Comments

As of now, all the previous posts worked with the Community Edition of Exasol. While that is great for getting started quickly (the Community Edition comes with all the features, except multi node support and a limit of 200GB of data) there are some limitations: Can you not really test how data is distributed across cluster nodes because there is only one. You do not have a real access to the operating system as the…

Read More
Cloud Team

Amazon Aurora Serverless (PostgreSQL compatibility)

By | AWS, Cloud | No Comments

By Franck Pachot . I’ve written a blog post about serverless databases and here is an example of Amazon RDS Aurora PostgreSQL in serverless mode: When I’ve created the instance (15:55 – CloudWatch is GMT+2 but event log is UTC), it started with 0 capacity unit (18:03), which means that it was paused (you pay for storage only). Then I connected and the instance was resumed (18:19) to its maximum capacity unit (4 here). And…

Read More
Cloud Team

Amazon or AWS services?

By | AWS, Cloud | No Comments

By Franck Pachot . When I’m writing about a product I like to be precise about the name, the upper and lower case, and even more: do you know that was taking special care of writing Oracle 12cR2 before then non-italic came with 18c? And that’s also the reason I’m not writing a lot about VMware as it takes me 5 minutes to put the uppercase right 😀 You may have seen that many Amazon…

Read More
Cloud Team

Amazon DynamoDB: the cost of indexes

By | AWS, NoSQL | No Comments

By Franck Pachot . That’s common to any data structure, whether it is RDBMS or NoSQL, indexes are good to accelerate reads but slow the writes. This post explains the consequences of adding indexes in DynamoDB. Secondary Indexes What we call an index in DynamoDB is different from an index in RDBMS. They have the same goal: store your data with some redundancy in order to have it physically partitioned, sorted, and clustered differently than…

Read More
Cloud Team

Amazon DynamoDB Local: running NoSQL on SQLite

By | AWS | No Comments

By Franck Pachot . DynamoDB is a cloud-native, managed, key-value proprietary database designed by AWS to handle massive throughput for large volume and high concurrency with a simple API. simple API: Get, Put, Query, Scan on a table without joins, optimizer, transparent indexes,… high concurrency: queries are directed to one shard with a hash function massive throughput: you can just add partitions to increase the IOPS large volume: it is a shared-nothing architecture where all…

Read More

RDBMS (vs. NoSQL) scales the algorithm before the hardware

By | AWS, NoSQL | No Comments

By Franck Pachot . In The myth of NoSQL (vs. RDBMS) “joins dont scale” I explained that joins actually scale very well with an O(logN) on the input tables size, thanks to B*Tree index access, and can even be bounded by hash partitioning with local index, like in DynamoDB single-table design. Jonathan Lewis added a comment that, given the name of the tables (USERS and ORDERS). we should expect an increasing number of rows returned…

Read More
Daniel Westermann

Attaching your own CentOS 7 yum repository to AWS SSM

By | AWS, Database Administration & Monitoring | 2 Comments

From some blogs I’ve written in the past you might already know that we are using AWS SSM to patch and maintain the complete EC2 and onprem instances at one of our customers. The previous posts about that topic are here: Avoiding patching madness by using AWS SSM Avoiding patching madness by using AWS SSM A simple Terraform script to create an AWS EC2 playground Schedule reboots of your AWS instances and how that can…

Read More
Christophe Cosme

AWS – RDS – SQL Server Native backups

By | AWS, Cloud, Database Administration & Monitoring, Database management, SQL Server | No Comments

Introduction RDS provide automatic backup feature. This feature will backup the entire RDS instance. As a DBA sometimes you need to backup individual database, they are many reason for that (legal, migration, replication,…). Unfortunately individual database backups are not available within the RDS instance. This post explains how you can enable the native database backup on RDS , as you are used to with an on-premises SQL Server instance. To summarize we will create a…

Read More
Oracle Team

Oracle Standard Edition on AWS ☁ socket arithmetic

By | AWS, Cloud, Oracle | One Comment

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
Open source Team

AWS Aurora vs. RDS PostgreSQL on frequent commits

By | AWS, Postgres | No Comments

This post is the second part of https://blog.dbi-services.com/aws-aurora-xactsync-batch-commit/ where I’ve run row-by-row inserts on AWS Aurora with different size of intermediate commit. Without surprise the commit-each-row anti-pattern has a negative effect on performance. And I mentioned that this is even worse in Aurora where the session process sends directly the WAL to the network storage and waits, at commit, that it is acknowledged by at least 4 out of the 6 replicas. An Aurora specific…

Read More