Altering large MySQL table using Percona Toolkit on AWS Aurora
April 16, 2024 Tai HaSometimes as backend developer you find yourself in a challenge of updating quite large MySQL table schema. Lately, I had to add a new column to rather large (around 32GB) table in MySQL cluster running on AWS Aurora. This can’t be difficult, right? Sure, the right way of doing is …
AWS cloudwatch insights
October 18, 2023 Tai HaTOP SQL Query No. Purpose Commands 1 Find slow query with query_time greater than 0.250(s) and sort desc parse @message “Query_time: * Lock_time: * Rows_sent: * Rows_examined: *\n*” as Query_time,Lock_time,Rows_sent,Rows_examined,q| filter Query_time > 0.250| sort Query_time desc 2 Find slowest write queries parse @message /Query_time: (?<queryTime>.*?) Lock_time: (?<lockTime>.*?) Rows_sent: (?<rowsSent>.*?) …
The 6 Pillars of the AWS Well-Architected Framework
May 31, 2023 Tai HaTL;DR The AWS Well-Architected Framework is a set of best practices and guidelines for designing and operating reliable, secure, efficient, and cost-effective systems on AWS. The framework is built around six pillars, each of which addresses a critical aspect of cloud architecture: Please follow this blog series as we dive into …
A Look into AWS Data Services
March 23, 2023 Tai HaAWS data services From data movement, data storage, data lakes, big data analytics, log analytics, streaming analytics, business intelligence, and machine learning (ML) to many things in between, AWS offers purpose-built services that provide price performance, scalability, and low costs. Data Lakes and Analytics on AWS lists all the AWS …
Architecture Optimizations
March 23, 2023 Tai HaCaching for Amazon DynamoDB by using Amazon DynamoDB Accelerator Raf mentioned that if you need to improve Amazon DynamoDB performance to microsecond latency, to look into using Amazon DynamoDB Accelerator (DAX). DAX is a fully managed, highly available, in-memory cache for DynamoDB that’s designed to deliver up to a 100-times …
Decoupling Solutions on AWS
March 21, 2023 Tai HaA loosely coupled architecture minimizes the bottlenecks that are caused by synchronous communication, latency, and I/O operations. Amazon Simple Queue Service (Amazon SQS) and AWS Lambda are often used to implement asynchronous communication between different services.You should consider using this pattern if you have the following requirements: A disadvantage of …
Event-Driven Architectures on AWS
March 21, 2023 Tai HaAn event-driven architecture uses events to invoke and communicate between decoupled services. It’s a common architecture in modern applications that are built with microservices. An event is a change in state, or an update, such as placing an item in a shopping cart on an ecommerce website. Events can either …
Databases on AWS
March 21, 2023 Tai HaDatabases are purpose-built on AWS, which means that each AWS database service is built for a specific use case or set of use cases. Using a database that is a best fit for the use case can save a lot of time in development hours. In the past, it was …
Compute on AWS
March 21, 2023 Tai HaWhen you consider what compute service to use for a specific use case, you should ensure that you are up to date on any new AWS service or feature releases. To review a high-level overview of the different AWS compute services AWS, see Compute on AWS – Compute for any …
Monoliths vs Microservices vs Serverless
March 10, 2023 Tai HaIntroduction When we are building a small-scale or large-scale applications, there are many different ways to go about it. While there is no “right” way to do things, I think it’s useful to know the tradeoffs that each option presents. That way you can make an informed decision about which …