Best of MySQL — 2025

  1. 1
    Video
    Avatar of bytegradByteGrad·1y

    SQL Tutorial - All 38 Concepts You Need To Know

    SQL is a structured query language used to manage and analyze data in databases. Understanding SQL concepts is valuable for both organizations and individual careers. Key SQL concepts include creating and managing databases, tables, and relationships, as well as performing queries to insert, update, delete, and retrieve data. Proper data structuring, using primary and foreign keys, and employing joins are essential for database efficiency. Indexing can optimize queries, and using transactions ensures data consistency. Tools and certifications like those offered by DataCamp can enhance SQL skills.

  2. 2
    Article
    Avatar of strongdmstrongdm·47w

    PostgreSQL vs. MySQL: Differences for Tech Leaders & Teams

    PostgreSQL excels at complex, write-heavy workloads with advanced SQL features, rich data types like JSONB, and strict ACID compliance, making it ideal for financial systems and analytics. MySQL prioritizes speed and simplicity for read-heavy applications, offering lightweight architecture perfect for web apps, CMSs, and MVPs. PostgreSQL provides superior extensibility, query optimization, and enterprise features, while MySQL delivers faster performance for simple queries and lower resource consumption. The choice depends on workload complexity, data consistency requirements, and scalability needs.

  3. 3
    Article
    Avatar of bytebytegoByteByteGo·1y

    How YouTube Supports Billions of Users with MySQL and Vitess

    YouTube scaled its backend to manage billions of users by implementing Vitess on top of MySQL. Vitess acts as a smart intermediary, enabling horizontal scaling, efficient query routing, and automated database management tasks. Key strategies included replication, sharding, vertical splitting, and enhancements like connection pooling, query safety mechanisms, and a specialized row cache. These measures addressed issues like replication lag, data consistency, and high write loads, ensuring YouTube's backend remained efficient and resilient.

  4. 4
    Article
    Avatar of programmingdigestProgramming Digest·50w

    How Databases Store Your Tables on Disk

    Databases store tables using a hierarchical structure of pages and heap files. Data is organized in fixed-size pages (typically 8KB-16KB) that contain multiple rows, with databases reading entire pages rather than individual rows for efficiency. Tables are stored in heap files where pages can be unordered, making full table scans expensive. Indexes solve this by creating separate B-tree structures that point to specific pages in the heap, dramatically reducing I/O operations. Clustered indexes physically organize table data based on the index key, with databases like MySQL's InnoDB storing all tables as clustered indexes by default. The choice of primary key affects performance significantly, as random values like UUIDs can cause page splits and fragmentation.

  5. 5
    Article
    Avatar of communityCommunity Picks·1y

    Online SQL Playground for MySQL, PostgreSQL, and SQL Server

    RunSQL is an online SQL playground designed for learning, testing, and sharing SQL queries for MySQL, PostgreSQL, and SQL Server. Users can easily create and manipulate database schemas using DBML, collaborate on SQL projects, conduct interviews, and create web-based database documentation without needing local database setup. It provides a shared environment tailored for developers and data analysts.

  6. 6
    Article
    Avatar of growwenggGroww Engineering·27w

    When Two Databases Become One: How DuckDB Saved Our Trading Operations from Manual Reconciliation

    A trading platform faced recurring position-order mismatches across two separate MySQL databases, requiring 20-30 minutes of manual reconciliation by two engineers. By leveraging DuckDB's MySQL scanner extension to perform cross-database joins, they automated the entire process into a 2-3 minute operation running every 15 minutes. The solution eliminated manual intervention, improved accuracy from 85% to 99.9%, and enabled proactive monitoring instead of reactive fixes during market hours.

  7. 7
    Article
    Avatar of mlnewsMachine Learning News·1y

    How to Use SQL Databases with Python: A Beginner-Friendly Tutorial

    Learn how to use SQL databases with Python, focusing on MySQL. This tutorial covers environment setup, connecting to a database, and performing CRUD operations. It provides a step-by-step guide to creating databases, tables, and working with data in MySQL using Python.

  8. 8
    Article
    Avatar of bytebytegoByteByteGo·33w

    How Flipkart Built a Highly Available MySQL Cluster for 150+ Million Users

    Flipkart built Altair, an internally managed MySQL service that maintains high availability for 150+ million daily users through automated failover and primary-replica architecture. The system uses a three-layered monitoring approach (agent, monitor, orchestrator) to detect failures, prevent false positives, and execute failovers with minimal data loss. Altair prioritizes write availability over strong consistency using asynchronous replication, implements DNS-based service discovery for seamless failovers, and includes multiple safeguards against split-brain scenarios. The design balances operational simplicity with reliability, achieving near five-nines availability while managing thousands of database clusters across Flipkart's microservices infrastructure.

  9. 9
    Article
    Avatar of planetscalePlanetScale·1y

    Database Sharding — PlanetScale

    Sharding is the process of improving database scalability by distributing data across multiple servers, known as shards. This technique is widely used by large companies like Uber and Slack. Effective sharding involves choosing the right sharding strategy and shard key to optimize performance and avoid issues like cross-shard queries. PlanetScale, built on Vitess, provides tools to simplify sharding implementation and management. Additionally, sharding can help with data durability, high availability, and faster backups by using replicas.

  10. 10
    Article
    Avatar of towardsdevTowards Dev·50w

    Blazing Fast Leaderboards using Redis

    A gaming platform faced severe performance issues with MySQL-based leaderboards, taking 30+ seconds to load for 1 million users. By migrating to Redis sorted sets (ZSETs), they reduced response times from 30 seconds to under 50 milliseconds. The implementation uses ZADD for storing user scores, ZCOUNT for ranking, and ZREVRANGE for pagination. While Redis dramatically improved performance, challenges remain with initial data loading for large datasets and concurrent write operations affecting query response times.

  11. 11
    Video
    Avatar of kikisbytesKiki's Bytes·37w

    How Uber Saved $6,000,000 in Database Costs

    Uber reduced database costs by $6 million annually by migrating their financial transaction system from DynamoDB to DocStore, their custom MySQL-based distributed database. The migration involved building LedgerStore 2.0 with immutable records, data integrity guarantees, and solving hot partition problems through deterministic sharding. The process included careful data backfilling, shadow writes for real-time sync, and dual read validation to ensure zero downtime during the transition.

  12. 12
    Article
    Avatar of devtoolsDev Tools·36w

    Free Valentina Studio 16 now available

    Valentina Studio 16 has been released as a free database management tool supporting major databases including PostgreSQL, MongoDB, MySQL/MariaDB, MS SQL Server, SQLite, DuckDB, and ValentinaDB. The PRO version includes advanced diagramming, reporting, and forms creation capabilities similar to MS Access or FileMaker. A 5-connection version of Valentina Server 16 is also available for free.

  13. 13
    Article
    Avatar of detlifeData Engineer Things·49w

    I Stopped Using SQL for Database Management. Because I use the MCP Server with GitHub Copilot in VS Code

    A developer demonstrates how to replace traditional SQL database management with AI-powered tools by using GitHub Copilot and GibsonAI's MCP server in VS Code. The approach allows creating complete database schemas, deploying serverless databases, and generating CRUD APIs through simple prompts, eliminating manual schema design and boilerplate code. The tutorial shows building a travel agency database schema in under 60 seconds using natural language descriptions.

  14. 14
    Article
    Avatar of hnHacker News·1y

    antiwork/gumroad

    The post provides a comprehensive guide on setting up a development environment for the 'antiwork/gumroad' project. It includes installation instructions for necessary dependencies like Ruby, Docker, MySQL, ImageMagick, libvips, FFmpeg, PDToolkit, Bundler, dotenv, and npm. The guide also covers creating SSL certificates, starting Docker services, and running the application along with Rails, a JavaScript build system, and Sidekiq worker. Additional setup steps like reindexing Elasticsearch and configuring git hooks are included.

  15. 15
    Video
    Avatar of laraveldailyLaravel Daily·51w

    3 Tools to Draw/Manage Database Schema

    Three visual database design tools are showcased for Laravel developers: DrawDB for drag-and-drop visual schema creation, DBDiagram.io for code-based DBML syntax with version control benefits, and RunSQL for testing queries on mock data. The workflow demonstrates using AI to generate database schemas, visualizing relationships, and converting designs to Laravel migrations without writing initial code.

  16. 16
    Article
    Avatar of singlestoreSingleStore·1y

    MySQL vs PostgreSQL vs SingleStore Performance in Docker

    The post compares MySQL, PostgreSQL, and SingleStore using a benchmark with over 100 million transactions in Docker containers. The results show SingleStore has superior performance in handling complex queries involving heavy joins and analytics, while MySQL struggles and PostgreSQL performs better than MySQL but not as well as SingleStore. A full benchmarking setup is shared for readers to try on their own systems.

  17. 17
    Article
    Avatar of bunBun·39w

    Bun v1.2.21

    Bun v1.2.21 introduces major features including unified SQL client support for MySQL, SQLite, and PostgreSQL through Bun.SQL, native YAML parsing, 500x faster string postMessage performance, and a native secrets manager for secure credential storage. The release adds executable compilation via Bun.build() API with cross-platform targets, Windows metadata embedding, and SIMD-accelerated ANSI escape removal. Package management improvements include security scanner API, enhanced audit filtering, optimized lockfile-only installs, and interactive update scrolling. The update fixes 69 issues with extensive Node.js compatibility improvements and bundler optimizations.

  18. 18
    Article
    Avatar of lnLaravel News·1y

    VS Code database management extension launches v2

    DevDb, a lightweight VS Code extension for database management, has launched version 2.0. This update includes new features like one-click row deletion, easy column value editing, SQL query explanation using MySQL Visual Explain, and more keyboard shortcuts. It supports SQLite, MySQL/MariaDB, PostgreSQL, and Microsoft SQL Server, making it versatile for various developers.

  19. 19
    Article
    Avatar of vladmihalceaVlad Mihalcea·1y

    MySQL Query Optimization with Releem

    Releem is a tool that optimizes MySQL queries for applications like Spring Petclinic. It detects performance issues, provides recommendations, and helps prevent CPU and IO spikes. The tool continuously scans the database to offer optimization suggestions, like indexing and limiting result set sizes, to enhance query execution efficiency.

  20. 20
    Article
    Avatar of communityCommunity Picks·1y

    PostgreSQL Optimizer

    EverSQL provides automated optimization for PostgreSQL and MySQL databases using AI-powered algorithms to enhance query performance. It offers ongoing performance monitoring without accessing sensitive data, claiming to significantly improve query speed and helping users save time and costs by optimizing database performance.

  21. 21
    Article
    Avatar of planetscalePlanetScale·35w

    Postgres High Availability with CDC — PlanetScale

    Postgres high availability faces operational challenges when using Change Data Capture (CDC) due to logical replication slots being primary-local objects that can prevent failover. When CDC clients lag or poll infrequently, standby replicas may become ineligible for promotion, forcing administrators to choose between waiting for CDC advancement or breaking the CDC stream. MySQL's GTID-based approach avoids this coupling by embedding replication progress in the binary log itself, allowing seamless failover regardless of CDC client behavior.

  22. 22
    Article
    Avatar of cncfCNCF·29w

    Announcing Vitess 23.0.0

    Vitess 23.0.0 introduces MySQL 8.4.6 as the default version, enhanced observability with new metrics for transaction routing and recovery tracking, and improved operational tooling for VTOrc. The release removes deprecated metrics and APIs, strengthens topology management with better Consul authentication requirements, and includes critical upgrade instructions for Operator users migrating from MySQL 8.0 to 8.4. Key improvements focus on production reliability, monitoring precision, and simplified deployment workflows for horizontally scaled MySQL workloads.

  23. 23
    Article
    Avatar of metalbearMetalBear·30w

    Introducing DB Branching in mirrord: Run Against a Shared Environment With a Personal, Isolated Database

    mirrord introduces DB Branching, a feature that creates temporary, isolated database branches for testing schema changes and migrations safely. When enabled, it automatically overrides database connection strings to point to a separate branch that mirrors the main database, allowing developers to test changes without affecting shared staging environments. The feature currently supports MySQL databases and is available in mirrord for Teams, with a step-by-step guide demonstrating how to test schema changes using a Go service on Kubernetes.

  24. 24
    Article
    Avatar of vladmihalceaVlad Mihalcea·1y

    MySQL Performance Tuning with Releem

    Releem is a tool designed to optimize MySQL performance by monitoring and providing optimization tips. The setup involves creating a database user, configuring the Releem agent, and adjusting MySQL settings for optimal data collection. Users can monitor query response times, throughput, and slow queries through an online dashboard. The tool also offers insights into database schema optimization for better application performance.

  25. 25
    Article
    Avatar of last9Last9·1y

    How to Use MySQL Performance Analyzer

    Dealing with slow MySQL queries? Performance analyzers can help identify bottlenecks and optimize database performance. Understand key metrics such as query response time, CPU usage, and buffer pool efficiency. Discover top tools like Last9, PMM, and MySQL Enterprise Monitor for effective monitoring. Learn setup steps for PMM and essential commands for quick troubleshooting. Explore advanced techniques like partitioning and read/write splitting to further enhance performance.

See all MySQL archives