Infrastructure at your Service

Category

AWS

Franck Pachot

See you on Polywork (an new LinkedIn?)

By | AWS, Database Administration & Monitoring, Kubernetes, NoSQL, Oracle, Postgres | No Comments

By Franck Pachot . I have published 105 additional blog posts here since the 500th one https://blog.dbi-services.com/rollback-to-savepoint/ that I have written on my come back to dbi-services. On Oracle Database, of course, other databases as well, on clouds (OCI and AWS mainly, with a look at GCP and Azure). But also with some thoughts on the rise of the “scale-out” obsession of NoSQL. And, because I’m convinced that consistency, referential integrity, and SQL is a…

Read More
Franck Pachot

Amazon RDS Oracle in Multitenant

By | AWS, Oracle | 2 Comments

By Franck Pachot . AWS has just added the possibility to create your oracle Database as as CDB (Container Database), the “new” architecture of Oracle where an instance can manage multiple databases, adding a new level between the heavy instance and lightweight schema: At the time I’m writing this, I see it only in the “old” console (“original interface”) not in “new database creation flow”. It is displayed as a different Edition, however it is…

Read More
Franck Pachot

PostgreSQL on AWS Graviton2: CFLAGS

By | AWS, Postgres | No Comments

By Franck Pachot . In a previous post I’ve compiled PostgreSQL with GCC 7 and GCC 11 with the default options and checked that the ARM v8.2 features were used. However it may not be so simple: PostgreSQL ./configure defines gcc flags to produce a binary that is compatible with older versions of ARM. This means that it may not use the LSE feature introduced in ARM v8.1 With this, the default compilation (-march=armv8-a) doesn’t…

Read More
Daniel Westermann

Getting started with Citus – Setting up a four node cluster

By | AWS, Database Administration & Monitoring | No Comments

One issue with traditional database systems like PostgreSQL is, that you cannot easily scale vertically. Of course you could add read replicas and offload read operations, but that either requires changes in the application, or putting something in front that understands the PostgreSQL dialect and automatically routes writes to the primary and spreads reads across one or more replicas (e.g. pgpool-II). But even if you have something in place, you need to deal with replications…

Read More
Daniel Westermann

Building a PostgreSQL EC2 AMI for testing the latest commits

By | AWS, Database Administration & Monitoring | No Comments

Testing the latest features or bug fixes in PostgreSQL can easily be done by pulling the latest commits from the git repository and compile PostgreSQL from source code. I am doing that frequently on my local sandbox VM but this becomes limited when I need more CPUs or more memory. This is where the public cloud really shines, as you can easily deploy new VMs, do your tests and get rid of it afterwards with…

Read More
Franck Pachot

DynamoDB / Aurora: sparse and partial indexes

By | AWS, Cloud | No Comments

By Franck Pachot . In a previous post I tried to build a glossary about Amazon DynamoDB terms that look like relational database terms, but with a different technical meaning. Here is more about it. If you work with AWS Databases and frequently switch between DynamoDB and Aurora, or other RDS databases, you may be confused by the same terms used for different meanings. An index is a redundant structure that is maintained by the…

Read More
Franck Pachot

A VPC is a private cloud in a public cloud

By | AWS | No Comments

By Franck Pachot . If you are surprised that the first thing you do in a Public Cloud is creating a Virtual Private Cloud, this post is for you. This is a beginner level post. And if you are at that level, interested by what is the Cloud and what is AWS, I recommend our free AWS Discovery Days – I give it next week in French: https://www.dbi-services.com/fr/trainings/aws-discovery-days/ Today, with the “digitalization” trend, people are…

Read More
Daniel Westermann

Deploying a Kubernetes cluster on EC2 with Rancher

By | AWS, Cloud, DevOps, Docker, Kubernetes | No Comments

Once Rancher is up and running, it makes the deployment and management of Kubernetes clusters quite easy. In this post we’ll deploy a brand new cluster on top of EC2. If you want to have a simple and quick Rancher playground you can follow this post, which will give you a Rancher setup on SLES 15. If you want to have a more production like Rancher setup, you can follow these posts: Rancher, up and…

Read More
Franck Pachot

AWS: PostgreSQL on Graviton2 with newer GCC

By | AWS, Postgres | 8 Comments

By Franck Pachot . In the previous post I have run PostgreSQL on AWS m6gd.2xlarge (ARM Graviton2 processor). I didn’t precise the compilation option and this post will give more details following this feedback: @FranckPachot thanks for sharing the results. Our own testing showed similar perf when using the default gcc7. However, with newer compiler and use of LSE, the graviton2 would provide higher performance : https://t.co/x9OgFqiPPy — NB (@N_B__N_B) March 9, 2021 First, the…

Read More