This guide explains how to enable HTTPS on an AWS Lightsail WordPress instance using Let’s Encrypt SSL certificates. The Bitnami bncert-tool is used to simplify the process. Step 1: Connect to Your Lightsail Instance First, log in to your AWS Lightsail instance via SSH. Using the AWS Console Using Local Terminal (Mac/Linux) If using an […]
Setting up ads.txt on AWS Lightsail (Bitnami WordPress)
Overview If you see the following warning in Google AdSense: “Earnings at risk – You need to fix some ads.txt file issues to avoid severe impact on your revenue.” You need to correctly configure the ads.txt file on your AWS Lightsail instance running Bitnami WordPress. This guide explains the steps to do so. Steps to […]
Return Fast in Golang
What is Return Fast in Golang? Return Fast is a coding style that reduces unnecessary nesting and simplifies error handling by returning early when conditions are not met. This improves readability and maintainability in Go programs. Why Use Return Fast? Basic Example of Return Fast Before (Nested Conditionals) After (Return Fast Applied) ✅ By returning […]
Fixing Master-Slave Replication Desynchronization in MySQL
Checking Replication Status When high database traffic causes Master-Slave replication desynchronization, the first step is to check the replication status on the Slave. Step 1: Check Slave Status Run the following command on the Slave: Key fields to check: Field Description Slave_IO_Running Yes if the I/O thread is running Slave_SQL_Running Yes if the SQL thread […]
Setting Up a Private DNS Domain in Route 53 for VPC
Creating a Private Hosted Zone in Route 53 AWS Route 53 allows the creation of Private Hosted Zones, enabling DNS resolution exclusively within a specific VPC. This feature is essential for internal networking, allowing EC2, ECS, and Lambda (when running inside a VPC) to resolve domain names privately. Steps to Configure a Private Hosted Zone […]
WordPress Block Theme: A Detailed Guide
What is a WordPress Block Theme? A WordPress Block Theme is a theme that fully supports Full Site Editing (FSE). Unlike traditional themes that rely on the theme customizer and PHP templates, block themes allow users to design and customize their entire website—including headers, footers, templates, and widgets—using the block editor. Key Features of Block […]
Analyzing AWS WAF Logs with Athena and Visualizing in QuickSight
When you want to better visualize AWS logs, it is common to use Athena and QuickSight.This time, I will write about the standard approach using Athena and QuickSight. 1. Storing WAF Logs in S3 To query AWS WAF logs using Athena, the logs must first be stored in an Amazon S3 bucket. Enable WAF Logging […]
Importance and Best Practices of Partitioning in Amazon Athena
Why is Partitioning Important? When running a query like SELECT * FROM waf_logs, Athena scans all data in the table, which leads to slow query execution and high costs.To optimize performance and reduce costs, partitioning is essential, and using WHERE to specify partitions is the best practice. Why Use Partitioning? 1. Faster Query Execution Without […]
Exporting MySQL Table Structure to Google Sheets
This guide explains how to export MySQL database structure to Google Sheets efficiently. It covers methods for extracting column details, importing them into Sheets, and automating organization using Google Apps Script (GAS). 1. Retrieve Column Information from MySQL Use the INFORMATION_SCHEMA.COLUMNS table to get details about all tables in your database. SQL Query Output Example […]
AWS, GCP, and Azure Enterprise Usage Comparison
When considering cloud services, the first ones that come to mind are AWS, GCP, and Azure. Cloud infrastructure has reached a mature stage, and each of these services can accomplish the fundamental tasks. This time, I have summarized a comparison from several perspectives for enterprise use. 1. Cost Comparison Overview: The major cloud providers (AWS, […]