Uncategorized Archives - Philip McClarence

28/02/202028/02/2020

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.

26/02/202026/02/2020

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

25/02/202025/02/2020

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.

25/02/202001/12/2020

Amazon S3 Games

Amazon S3 is a huge benefit to the gaming industry. In this day of downloads being the main way to access games, it is a massively popular medium for storing the game data to be served out to gamers. Its distributed, fault tolerant and highly scalable architecture mean that it is a reliable way to get game files to users.

Did you know that you can run games directly on Amazon S3 though?. HTML5 games can live in an S3 bucket and be served directly from there.

There are quite a few games running and being served directly from s3 buckets.

03/01/202003/01/2020

Should you migrate to Postgres from Oracle?

The Oracle database has been the gold standard for enterprise applications for a long time now. It has great performance, solid reliability and most of the features that you could want are available. The big problem is that it is expensive. And I mean REALLY expensive. That’s just for the base product as well. All of the extra features that you might want are chargeable extras which means that wench developing for Oracle, you often have to work without some of the more advanced features because they would cost too much.