Day 9: Fix a Failed MariaDB Service by Checking Permissions, Not the Engine

·5 views

A Day 9 exercise from the 100 Days of DevOps and Cloud series tackled two practical tasks: reviving a failed MariaDB service and enabling EC2 termination protection on AWS. The MariaDB failure was traced not to the database engine itself but to a wrong directory ownership — /run/mariadb was owned by root, preventing the mysql user from writing its socket and PID files. Fixing the issue required a single chown command followed by a service restart, with systemctl logs serving as the diagnostic tool throughout. On the AWS side, termination protection was enabled on an EC2 instance using the --disable-api-termination flag, which blocks accidental permanent deletion via the API. The exercise highlighted that termination and stop protection are separate settings, and that API-level protection does not cover attached volume deletion.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Dev Team Cuts Worker Response Times Below 10ms Using Hono.js on Cloudflare Edge

A development team has detailed how they restructured their off-chain task validation engines to achieve sub-10ms response times on edge infrastructure. The team migrated from traditional monolithic server setups to Cloudflare Edge Workers using the Hono.js framework to reduce latency and overhead. They adopted a split-tier storage approach, using Cloudflare KV for ephemeral session state and Cloudflare Queues to handle high-volume interaction data without causing execution timeouts. A sample code snippet was shared showing how incoming task validation requests are queued asynchronously to prevent endpoint blocking. The team noted that core application repositories remain private and are audited through internal channels to protect user data and configurations.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Sigrow Opens API to Connect Greenhouse Sensors with Major Climate Computers

Sigrow has published an API that allows its LoRa-based greenhouse sensors to feed data directly into third-party climate control systems without requiring any hardware modifications. Sensors including the Stomata Camera, Pixel, Soil Pro+, and DrainSense transmit readings every five minutes to the Sigrow cloud platform, which then exposes the data via API, Modbus, or BACnet. Compatible climate computers from Priva, Hoogendoorn, Ridder, HortOS, and Argus Controls can consume this data as supplementary input alongside their existing sensor networks. The integration allows climate computers to act on real-time substrate, drain, and canopy metrics — for example, adjusting fertigation based on EC readings from the Soil Pro+. Sigrow's system is designed to augment, not replace, the climate computer's existing control logic, recipe management, and alarm handling.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

How a missing ANALYZE call turned a seconds-long SQL insert into a 25-minute freeze

A developer building a star-schema data warehouse on PostgreSQL using the Brazilian Olist e-commerce dataset found that loading 112,647 rows into a fact table took over 25 minutes instead of seconds. The root cause was not corrupt data or faulty SQL, but stale table statistics: because dimension tables were populated within the same uncommitted transaction, PostgreSQL had no accurate statistics for them and mistakenly assumed they were empty. This led the query planner to choose an inefficient Nested Loop with Sequential Scan, generating billions of comparisons across all rows. Running ANALYZE on each dimension table before loading the fact table updated the statistics mid-transaction, prompting the planner to switch to a Hash Join and reducing load time to seconds. The case highlights that PostgreSQL's query optimizer relies entirely on statistical models, and feeding it inaccurate table-size data silently produces disastrously slow execution plans.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Three Ways to Manage Kubernetes Deployments with Python: A Tradeoff Guide

Developers using the official Kubernetes Python client must choose how to manage manifests: via native Python API objects, embedded YAML strings, or external Jinja2 templates. Each approach carries distinct tradeoffs in readability, maintainability, and runtime flexibility. A core issue is that deployment logic and platform configuration change at different rates, and tightly coupling them increases maintenance costs and the risk of configuration drift. Native Python objects offer maximum programmatic control but are verbose and harder to review, while embedded strings suit small one-off scripts. External YAML templates with Jinja2 score highest for maintainability and readability, making them the recommended choice for standardized application deployments and CI/CD pipelines.

0 comments Read more at DEV Community