Altering large MySQL table using Percona Toolkit on AWS Aurora

Sometimes 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 …

Best 30 Solution Architect Interview Questions and Answers (2024)

Welcome to our guide on Solution Architect interviews! We’ll explore essential technical questions and answers to prepare you for your upcoming interview in 2024. Answer: I began in software development, which provided a strong technical foundation. As I progressed, my interest in system design grew, leading me to Solution Architecture. …

Telegram Search Engines

AWS cloudwatch insights

TOP 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>.*?) …

MacOS Sonoma Keyboard Shortcuts | Cheatsheet 

macOS is a robust operating system used worldwide. However, many Mac enthusiasts might not be aware of the numerous keyboard shortcuts that enhance its usability. Interested in harnessing more from your Mac? Here’s an extensive list of Mac keyboard shortcuts. Whether it’s accessibility functions, desktop configurations, or in-system searches, these …

The 6 Pillars of the AWS Well-Architected Framework

TL;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 …

What is a REST API?

What is REST? REST stands for Representational State Transfer. It’s a software architectural style for implementing web services. Web services implemented using the REST architectural style are known as the RESTful web services. REST API A REST API is an API implementation that adheres to the REST architectural constraints. It acts as an interface. The communication between the client and the server happens over HTTP. A REST API takes …

Client-Server Architecture

You already learned a bit about the client-server architecture when we discussed the two-tier, three-tier and n-tier architecture. Now, we look at it in detail. Client-server architecture is the fundamental building block of the web. The architecture works on a request-response model. The client sends the request to the server for information and the server responds with it. Every website you browse, be it a WordPress blog, …

N-Tier Applications

An n-tier application is an application that has more than three components (user interface, backend server, database) involved in its architecture. What are those components? All the social applications like Instagram, Facebook, TikTok, large-scale consumer services like Uber, Airbnb, online massive multiplayer games like Pokémon Go, Roblox, etc., are n-tier applications. n-tier applications are more popularly known as distributed systems. …

Three-Tier Applications

Three-tier applications are pretty popular and largely used on the web. Almost all simple websites like blogs, news websites, etc., are part of this category. In a three-tier application, the user interface, business logic, and the database all reside on different machines and, thus, have different tiers. They are physically separated. Let’s take the example of …