All about Logical Replication in Postgres.

What is Logical Replication

Logical replication in PostgreSQL is a feature that allows you to replicate data from one database to another, in a flexible and customizable way. Unlike physical replication, which replicates the entire database and its structure, logical replication allows you to specify which tables and columns you want to replicate, and how you want the data to be replicated. This means that you can replicate only the data that is relevant to your application, and you can apply custom transformations or filters to the replicated data to meet your specific needs.

Continue reading “All about Logical Replication in Postgres.”

All about Table Partitioning in PostgreSQL

What is Partitioning in PostgreSQL

Partitioning in PostgreSQL is a technique for dividing a large table into smaller, more manageable pieces called partitions. Each partition contains a subset of the data in the table, and the data in each partition is organized and stored in a way that is optimized for the specific subset of data it contains.

Overall, partitioning is a useful technique for dividing large tables into smaller, more manageable pieces in PostgreSQL. It can improve the performance and manageability of the table, and can make it easier to work with large datasets in your database.

Continue reading “All about Table Partitioning in PostgreSQL”

The Quick Redshift AWS Tutorial – Everything you need to get started.

AWS Redshift is a very powerful database, but it is quite different from traditional a RDBMS in terms of architecture and also the sorts of decisions that you need to make and planning that you need to perform before building and operating a Amazon Redshift cluster.

This Redshift AWS tutorial aims to give you everything that you need to get started with AWS Redshift in as little time as possible, by covering the basics of architecture and the structure of the database, optimizations that you can make and some advice on performance tuning and maintaining a AWS Redshift cluster.  

Continue reading “The Quick Redshift AWS Tutorial – Everything you need to get started.”

AWS Well-Architected Framework – The 5 Pillars

The AWS Well-Architected Framework is a set of Documents and Tools that sets out best practices and procedures to follow to build high quality applications in the cloud on AWS

The core of the well architected framework is 5 pillars that group the important considerations and practices that you need to stick to when building in AWS.

The 5 Pillars of the AWS Well-Architected Framework

  • Security
  • Reliability
  • Performance Efficiency
  • Operational Excellence
  • Cost Optimization
Continue reading “AWS Well-Architected Framework – The 5 Pillars”

AWS IAM Notes – AWS Solutions Architect

This is some rough notes on IAM in AWS, covering IAM Roles, IAM Users and IAM Policies. The notes are aims at studying for the AWS Solutions Architect Certification and should cover the main points required for that exam.

AWS IAM can be summed up by saying that it authenticates and authorities you to and in AWS.

Root user is first user and has all permissions to everything on the account. It can’t be removed.

Continue reading “AWS IAM Notes – AWS Solutions Architect”