Instant ADD COLUMN, Until a FULLTEXT Index Shows Up: A MariaDB Migration That Froze Writes
Adding a nullable column to an InnoDB table is supposed to be a non-event. On MariaDB 10.3+ and MySQL 8.0+ it is usually an instant operation: a met…
DevOps
⚑ Сообщить о проблемеПоследние новости DevOps от Tech News
Все темы
agents
ai
api
architecture
automation
aws
backend
beginners
cloud
database
devchallenge
devops
docker
javascript
kubernetes
llm
machinelearning
mcp
node
opensource
performance
productivity
programming
python
security
showdev
testing
tutorial
typescript
webdev
Cloning a staging MongoDB and MySQL to your laptop without installing a single database client
Every week someone on my team needs a copy of our staging data on their laptop. Two databases, MongoDB and MySQL, a few gigabytes. For years the ans…
MySQL Connector/Python Fails to Close Pooled Sockets on App Termination: Solution Explored
Introduction In the world of database-driven applications, efficient resource management is critical. However, a subtle yet significant issue has em…
Squashing Laravel Migrations: 5 Ways schema:dump --prune Bites a Real Team
Originally published at hafiz.dev A recent r/laravel thread was titled "250 migrations in 3 years. What's yours at?" The standard answer is one comm…
"Duplicate entry '0' for key PRIMARY" usually means your database lost AUTO_INCREMENT
Installing a plugin fails with: Duplicate entry '0' for key 'PRIMARY' The obvious reading is that the plugin tried to insert a row with id 0. The ac…
Jev was the tipping point - I built the last MySQL search statement
The problem that kept finding me was mapping unstructured data into an existing corpus. Supplier products that needed to match a catalog. Text that…
MySQL to PostgreSQL Migration: A Practical UK Guide for Decision-Makers
Database migration is rarely just a technical exercise. For UK businesses, moving from MySQL to PostgreSQL can affect application performance, opera…
The rollback that only rolled back half of it
I was testing a new screen against the production ERP database: a box comes back from the customer, and the screen has to release the material insid…
Firebase больше не тянет: как мы строили real-time-чаты на Centrifugo
Расскажу, как мы отказались от внешних серверов, безболезненно пережили переезд, избежали сбоев в высокий сезон и сократили расходы на эксплуатацию…
Cost-Effective Public Hosting for Typescript/MySQL Monorepo: Optimizing for Small User Base Without Unnecessary Expenses
Introduction Hosting a Typescript/MySQL monorepo application for a small user base (4-5 users) presents a unique challenge: balancing cost-effective…
Appwrite shipped managed Postgres and MySQL (real engines, not our document API)
Hey. I'm Jake (abnegate). I work on databases at Appwrite. We just shipped managed native PostgreSQL and MySQL, and I wanted a place to talk about w…
Installing WordPress on Ubuntu 24.04
WordPress is a free, open-source content management system (CMS) built with PHP and backed by MySQL or MariaDB. It began as a blogging tool and has…
Laravel's Native Vector Search Now Speaks MariaDB — Plain MySQL Is Still Left Out
Originally published on my blog . On August 20, PR #61250 was merged into Laravel's 13.x branch, bringing the query builder's native vector search —…
Мой опыт перехода на Grafana для самописного веб‑сервера Интернета вещей
Есть у меня сервис собственной разработки по визуализации данных из базы: сенсоры упорядочены, я могу посмотреть, какие значения были на том или ино…
Safely Test a MySQL 5.7 -> 8.0 Upgrade on Azure
Upgrading a production database? Don't make production your test environment. A safer approach is to restore production to a separate Azure MySQL se…
1.5 миллиона событий в день и ни одной таблицы events: как мы считали продуктовую аналитику 300K-бота по голому проду
Маркетолог прислал мне скрин дашборда и одно слово: «пусто». На скрине — панель «Количество пришедших по реферальной ссылке за период». Ноль. Под не…
A Complete Guide to Install XAMPP, Configure Apache & MySQL Services, and Deploy WordPress Using PowerShell Commands
Setting up a reliable local web development environment is one of the first steps for anyone working with WordPress, PHP, MySQL, or Apache. While XA…
Как я написал свой мигратор для ClickHouse — и почему он до сих пор жив
В 2020-м мне понадобилось версионировать схему ClickHouse в CI/CD, а готового инструмента под Go с поддержкой ClickHouse не нашлось ни одного. Пришл…
OCI - Connecting to an OCI Always Free MySQL DB System: Installing MySQL Shell and Building a "Poor Man's VPN"
%0A%20%20%20%20%20%20%20%20.libutton%20{ %0A%20%20%20%20%20%20%20%20%20%20display:%20flex; %0A%20%20%20%20%20%20%20%20%20%20flex-direction:%20column…
How I Debugged a phpMyAdmin 500 Error While Importing a Large SQL File on Laragon
I recently ran into a weird issue while working on a Laravel project on Windows using Laragon . Everything was working fine until I tried to import…
MySQL Will Quietly Eat Your Data If You Let It: Truncation, Charsets, and the 1366 You Never See
A WhatsApp button on a shop was dialling the wrong number. Not a formatting problem — a genuinely different number, three digits short of the one in…
Docker, Index, and a very expensive lesson in reading pricing tables
Quiet learning day, mostly — until AWS almost let me subscribe to something that costs $57,600 a month. Dockerizing Bludit, locally Containerized ng…
Как уронить базу данных
Так получилось, что пару десятилетий занимался в тои числе и базами данных. Ставил. Тюнил. Выносил логику В базу. Вынос иллогику ИЗ базы. Поднимал к…
Beyond the Switchover: Using RDS Snapshots to Safely Test MySQL 8.4 Compatibility Before Your Blue/Green Cutover
AWS RDS Blue/Green deployment is a powerful zero-downtime tool, but its Green environment is read-only by design. Here is how to layer a snapshot-ba…
Shopify Replaced Redis With MySQL for Inventory Reservations — and It Scaled Better
Shopify just did something that would make most engineers do a double-take: they replaced Redis with MySQL for their inventory reservation system, a…
How We Evolved a Cultural Recommendation Feed From a Weighted SQL Ranker to a Narrative Affinity Model
Building a personalization engine for a multi-format content feed, without machine learning, and the testing process that forced us to rebuild it. T…
Build a Maintainable Node.js CRUD API with Express and MySQL
Writing SELECT , INSERT , UPDATE , and DELETE queries is not the difficult part of a CRUD API. The difficulty begins when every route starts handlin…
The Query That Ate 75% of Our Database CPU: A MySQL Full-Text Post-Mortem
A news platform I maintain started serving pages in six seconds. Load average sat at 16 on a 12-core box for hours. Nothing had been deployed. Traff…
Understanding Two-Phase Commit (2PC) by Building One in Go
Introduction Imagine sending 100 from Alice to Bob. If both accounts are in one database, this is easy: start a transaction, update both balances, a…
Moving a 136 GB MySQL table to another disk at 2 a.m. (the safe way, not a symlink)
Heads up: the database, table, and column names in this post are dummies. I've swapped the real production names for generic ones ( app_prod , call_…