ETEduard Tymchenkoinreleemdev.hashnode.devComplete Guide to MariaDB Logs: Audit, Configuration, and MoreMariaDB logs are a cornerstone of effective database management. They capture critical details about your database’s operations, offering invaluable insights for administrators, developers, and system19h ago·10 min read
ETEduard Tymchenkoinreleemdev.hashnode.devHow to use EXPLAIN to fix slow queries in MySQLSlow queries can quietly erode performance, which frustrates users and strains your system. Fortunately, MySQL offers EXPLAIN, a diagnostic tool that reveals how your queries execute. Think of it as a1d ago·8 min read
PAPiyush Agrawalinblog.devopswithpiyush.inCross-Project Cloud SQL Migration Using Google Database Migration Service (DMS)Migrating a Cloud SQL database from one Google Cloud project to another can be challenging—especially when you want minimal downtime and continuous replication (via Change Data Capture — CDC). Google'2d ago·6 min read
ETEduard Tymchenkoinreleemdev.hashnode.devHow MySQL Tuning Dramatically Improves the Drupal PerformanceMySQL Configuration tuning is an important component of database management implemented by database professionals and administrators. It aims to configure the database to suit its hardware and workloa2d ago·5 min read
ETEduard Tymchenkoinreleemdev.hashnode.devHow MySQL Tuning Improves the Laravel PerformanceMySQL Configuration tuning is an important component of database management implemented by database professionals and administrators. It aims to configure the database to suit its hardware and workloa3d ago·5 min read
Rrecca0120inrecca0120.hashnode.devFix the Missing mysql Command After Installing DBnginOriginally published at recca0120.github.io DBngin lets you run multiple versions of MySQL, PostgreSQL, and Redis simultaneously. However, since it supports multiple versions, it doesn't automatically add the mysql executable to your PATH. Running my...5d ago·1 min read
Ttechsfreeinai-agent-eng.hashnode.devConsolidating TechsFree Platform from 2 Servers to 1Consolidating TechsFree Platform from 2 Servers to 1 Running a 9-node home cluster means you'll eventually lose track of which service is running where. Today I did a full audit and migrated everything from the infra server to the web server in one s...5d ago·4 min read
DSDavid Shustermanindavidshusterman.hashnode.devWordPress Database Optimization: Queries That Kill PerformanceEvery WordPress developer has been there: a site that loads blazingly fast in development suddenly crawls to a halt in production. The culprit? Database queries that seemed innocent enough but scale terribly under real traffic. After optimizing hundr...5d ago·7 min read
WBWiktoria Blomgren Strandberginpentesting-dvwa.hashnode.devSQL Injection in DVWAIn this post, the DVWA SQL Injection vulnerability is described. The objective for attacks on all levels is to extract user login credentials. . Lab environment The penetration test is performed usingMar 6·14 min read
PKPratiksha kadaminrunning-cloud.hashnode.devAurora MySQLThis project provides a step-by-step guide to create an Amazon Aurora MySQL database, connect to it from a local MySQL client, create a test table, and then delete the database. It also covers key con6d ago·4 min read
