AWS, Cloud & Database Architecture
4 views
Banking-grade AWS deployments, multi-cloud trade-offs, and database design at scale. The architectural decisions that prevent 3am incidents.
Multistage Build Optimisation: The Difference Between Amateur Containers and Production Systems
Most teams assume containers are lightweight by default, but that assumption does not survive contact with a real production system. Containers become bloated, slow, insecure, and operationally expensive when left unmanaged, and the penalties compound at scale as CI pipelines slow down, deployments lag, autoscaling becomes inefficient, and infrastructure costs quietly rise. This post goes […]
Read more →Mirror a Static Website with wget and Host on AWS S3
I have an old website that I want to avoid the hosting costs and so just wanted to download the website and run it from an AWS S3 bucket using Cloud Front to publish the content. Below are the steps I took to do this: First download the website to your laptop Below is a […]
Read more →
What Is My IP Address? IPv4 Explained for Beginners
Firstly, let me acknowledge that there are lots of these kinds of posts on the internet. But the reason why i wrote this blog is that I wanted to force myself to consolidate the various articles I have read and my learnt knowledge in this space. I will probably update this article several times and […]
Read more →SQL Server Missing Indexes: Query DMVs to Find Them
Most companies will have a fair amount of SQL databases and its likely that most of those databases are performing sub-optimally due to missing indexes. We can debate (for a long time) the pros and cons of indexes, but the undeniable reality is that having missing indexes on large tables create a lot of issues […]
Read more →Delete 50+ EBS Snapshots Using AWS CLI: Step-by-Step
The Amazon EC2 console allows you to delete up to 50 Amazon Elastic Block Store (Amazon EBS) snapshots at once. To delete more than 50 snapshots, use the AWS Command Line Interface (AWS CLI) or the AWS SDK. To see all the snapshots that you own in a specific region, run the following. Note, replace […]
Read more →Protected: Neo by Capitec: AI Client Support That Resolves Issues Proactively
There is no excerpt because this is a protected post.
Read more →SCP Files to EC2: Mac & Linux Command Guide
I always forget the syntax of SCP and so this is a short article with a simple example of how to SCP a file from your laptop to your EC2 instance and how to copy it back from EC2 to your laptop: Copying from Laptop to EC2 scp -i identity_file.pem source_file.extention username@public_ipv4_dns:/remote_path scp: Secure copy protocol-i: Identity […]
Read more →TPC-H Test Data for AWS Redshift and EMR: Setup Guide
If you need to test out your big data tools below is a useful set of scripts that I have used in the past for aws emr and redshift the below might be helpful:
Read more →AWS Error Messages, API Standards & Region Defaults: Fix Needed
This is a short blog, and its actually just simple a plea to AWS. Please can you do three things? North Virginia appears to be the AWS master node. Having this region as a master region causes a large number of support issues (for example S3, KMS, Cloudfront, ACM all use this pet region and […]
Read more →IAM Policy to Enforce EBS Encryption on EC2 Instances
Here is a useful IAM conditional policy which will force EBS volumes to be encrypted when created by an EC2 instances.
Read more →Public Cloud Migration: Why Lift-and-Shift Strategies Fail
The cloud is hot…. not just a little hot, but smokin hot!! Covid is messing with the economy, customers are battling financially, the macro economic outlook is problematic, vendor costs are high and climbing and security needs more investment every year. What on earth do we do??!! I know…. lets start a crusade – lets […]
Read more →Auto-Recover a Failed WordPress Instance on AWS
When WordPress goes down on your AWS instance, waiting for manual intervention means downtime and lost revenue. Here are two robust approaches to automatically detect and recover from WordPress failures. Approach 1: Lambda Based Intelligent Recovery This approach tries the least disruptive fix first (restarting services) before escalating to a full instance reboot. Step 1: […]
Read more →