Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

A description of what this website tries to achieve is in the Planet MySQL Community - Requirements RFC.

And a clarification about the MySQL Community/Ecosystem: it is not limited the users of the MySQL Database. In the current context, it also includes people interested in MySQL Variants including MariaDB Server, Percona Server, Galera, Amazon RDS and Aurora, Google Cloud SQL for MySQL, and Azure and Alibaba flavor(s) of MySQL/MariaDB/Percona Servers.

Thursday, 30. October 2025

Encryption support in PMM Dump (from Percona Community Blog)

pThe codepmm-dump/code client utility performs a logical backup of the performance metrics collected by the PMM Server and imports them into a different PMM Server instance. PMM Dump allows you to share monitoring data collected by your PMM server with the Percona Support team securely./p pUp until now dumps, created by the tool, were not encrypted. It was possible to encrypt them after they are do [...]

$5 PlanetScale (from PlanetScale Blog)

Introducing the $5 PlanetScale plan. [...]

Last Call: State of MariaDB 2025 Survey (+ New Preview Insights) (from MariaDB Foundation Blog)

pThere are a couple days left until the survey closes – take this as a gentle nudge to participate if you’ve been meaning to 🙂 br Take the survey now! … /p pContinue reading \"Last Call: State of MariaDB 2025 Survey (+ New Preview Insights)\"/p pThe post Last Call: State of MariaDB 2025 Survey (+ New Preview Insights) appeared first on MariaDB.org./p [...]

MySQL Basics: Trust the Process—Mastering Transactions Step by Step (from The Oracle MySQL Blog)

Discover how to use transactions in MySQL to keep your data safe and organized—just like a diligent librarian! This beginner-friendly post explains what transactions are, why they matter, and how to use them with easy library metaphors, clear SQL examples, and essential tips for database reliability. [...]

Wednesday, 29. October 2025

What’s New in MariaDB Enterprise Kubernetes Operator 25.10 (from MariaDB Corporation Blog)

Managing stateful, mission-critical databases on Kubernetes demands automation, reliability and a predictable lifecycle. We’re excited to announce the general availability […] [...]

Zero-Downtime MySQL Certificate Rotation (from Continuent Blog)

Learn how to rotate MySQL SSL/TLS certificates with zero downtime using Tungsten Clustering 7.2.0/8.0.1 and the tpm cert tool, including generating certs, dual-alias rollout, safe node-by-node restarts, SELinux fixes, and cleanup to retire old aliases without interrupting production.Tags: zero-downtime MySQLcertificate rotationtungsten clusterMySQL TLS [...]

No, you probably dont need Kubernetes (from The consistent voice)

pEt ouais, vous ne rêvez pas, je l’affirme en toute confiance. Haut et fort. Sur Linkedin le paradis de la hype et des buzzwords./ppComme le souligne fort justement Nicolas Martinez dans son excellent post, K8s ajoute une couche de complexité souvent inutile :/ppMaintenance lourde, coûts cachés, temps perdu, obligation d’avoir une équipe DevOps/SRE : le jeu en vaut-il la chandelle ?/ppConcernant Ma [...]

How deep can a bug be? (from MariaDB Foundation Blog)

pLast year I filed a bug report MDEV-33603 on what a looked like a benign problem with an optimizer taking a different code path in a particular trivial looking test. … /p pContinue reading \"How deep can a bug be?\"/p pThe post How deep can a bug be? appeared first on MariaDB.org./p [...]

Tuesday, 28. October 2025

Performance Engineered: MariaDB Enterprise Server 11.8 Accelerates OLTP Workloads by 2.5x (from MariaDB Corporation Blog)

MariaDB 11.8 delivers up to 2.5x higher OLTP throughput on Dell PowerEdge R7715 servers powered by AMD EPYC™ processors MariaDB […] [...]

Keyword vs. semantic search with AI (from Programming Brain)

How to build keyword and semantic search in MariaDB using Python, LangChain, and AI embeddings. [...]

Practical Data Masking in Percona Server for MySQL 8.4 (from Percona Database Blog)

♦Data masking lets you hide sensitive fields (emails, credit-card numbers, job titles, etc.) while keeping data realistic for reporting, support, or testing. It is particularly useful when you collaborate with external entities and need to share your data for development reasons. You also need to protect your data and keep your customers’ privacy safe. Last […] [...]

MySQL 9.5 – Thank you for your contributions! (from The Oracle MySQL Blog)

MySQL 9.5 has been released, here is a list of the contributions we included in it. Thank you to all contributors! [...]

MySQL 9.5 – Thank you for your contributions! (from lefred's blog)

On October 10th, 2025, we released MySQL 9.5, the latest Innovation Release. As usual, we released bug fixes for 8.0 and 8.4 LTS, but this post focuses on the newest release. In this release, we can see contributions related to Connector J and Connector Net, as well as to different server categories. Connector / J […] [...]

High Availability with MariaDB Galera Cluster Guide (from Mydbops Blog)

Ensure zero downtime and data consistency with our guide to setting up a MariaDB Galera Cluster, covering installation, configuration, and monitoring. [...]

MySQL Basics: The Inside Track—Speeding Up Searches with Indexes (from The Oracle MySQL Blog)

Unlock the secret to faster data searches with indexes! This post introduces beginners to the power of indexes in MySQL, using friendly library metaphors and simple SQL examples. Learn how—and why—to create indexes, understand their impact, and keep your growing database running at page-turning speed. [...]

Monday, 27. October 2025

Optimize and troubleshoot database performance in Amazon Aurora PostgreSQL by analyzing execution plans using CloudWatch Database Insights (from AWS Database Blog)

In this post, we demonstrate how you can use Amazon CloudWatch Database Insights to analyze your SQL execution plan to troubleshoot and optimize your SQL query performance in an Aurora PostgreSQL cluster. [...]

Effortless Document AI with MySQL HeatWave GenAI (from The Oracle MySQL Blog)

This post demonstrates how you can use HeatWave GenAI to transform an unstructured PDF of a purchase order into a structured, queryable format directly within your database. We'll walk through the process of loading a PO from an object store and then asking natural language questions to retrieve key details like order dates, item costs, and supplier information. [...]

Rethinking Scale: TiDB’s Evolution Into an AI Agent Database (from PingCAP Blog)

pRecently, I’ve been meeting customers across industries including AIaaS, Web3, and FinTech. No matter where I go, the conversation always turns to one thing: AI. Everyone’s asking the same question: “How will AI transform our business, and how does TiDB embrace this change?” So, I started sharing what had been on my mind lately. “The era […]/p pThe post Rethinking Scale: TiD [...]

ClusterControl 2.3.4 Adds MySQL Group Replication, Streamlined Air-Gapped Installation, and Controller Pooling for Scalable Management (from Severalnines Blog)

pWe’re happy to announce the release of ClusterControl v2.3.4, delivering powerful updates that strengthen high availability, secure deployment options, and scalability for enterprise-scale database management.  As with every release, we’ve focused on tackling real-world challenges our users face. Below, we’ll dive into the key features that define this release, followed by additional improvem [...]

How to Replicate TiDB to a Mirrored Database in Microsoft Fabric with TiCDC (from PingCAP Blog)

pTiDB is an open-source distributed SQL database built for cloud-native, data-intensive, and AI-driven applications. It is MySQL compatible and features horizontal scalability, strong consistency, and high availability. By leveraging a TiCDC replication solution for Open Mirroring, TiDB seamlessly integrates with Microsoft Fabric. This unlocks continuous, real-time data synchronization from any TiD [...]

MariaDB Cloud – kicking the tires with openflights data (from MariaDB Foundation Blog)

pMariaDB plc recently acquired SkySQL and rebranded it MariaDB Cloud that offers serverless MariaDB as a service. Kaj Arnö interviewed the technical father, and now it is time for a practical, technical kick-the-tires look at MariaDB Cloud. … /p pContinue reading \"MariaDB Cloud – kicking the tires with openflights data\"/p pThe post MariaDB Cloud – kicking the tires wit [...]

Sunday, 26. October 2025

RAG Series – Agentic RAG (from dbi Blog)

pIntroduction In earlier parts, we moved from Naive RAG (vector search) to Hybrid RAG (dense + sparse) to Adaptive RAG (query classification and dynamic weighting). Each step improved what we retrieve. Agentic RAG goes further: the LLM decides if and when to retrieve at all and can take multiple steps (retrieve → inspect → refine […]/p pL’article RAG Series – Agentic RAG est apparu en premier [...]

Alfresco – When a JDBC driver breaks after years of stability (from dbi Blog)

pA customer recently contacted us regarding an issue with an old Alfresco Enterprise 4.2.2 environment. The system had been running stably for years, with a nightly restart of the Tomcat/Alfresco service to help recycle the memory and fix long-standing issues in this version. Earlier this week, one of these nightly restarts suddenly failed and since […]/p pL’article Alfresco – When a JDBC dri [...]

Do We Really Need RPO = 0 for Regional Disaster Recovery for database services? (from siddontang on Medium)

pA few years ago, if someone told me an entire AWS region could go down, I might have smiled politely and said, “Maybe in theory.” But then it actually happened./pWhen the Unthinkable Became RealitypDuring the world-shaking AWS DynamoDB outage in US-EAST-1, countless engineers across the globe were suddenly thrown into chaos./ppEveryone was frantically refreshing AWS status pages, hoping for one up [...]

Friday, 24. October 2025

How efficient is RocksDB for IO-bound, point-query workloads? (from Small Datum)

pHow efficient is RocksDB for workloads that are IO-bound and read-only? One way to answer this is to measure the CPU overhead from RocksDB as this is extra overhead beyond what libc and the kernel require to perform an IO. Here my focus is on KV pairs that are smaller than the typical RocksDB block size that I use -- 8kb.brbrBy IO efficiency I mean: br    (storage read IOPs from RocksDB [...]

Accelerate Similarity Search with Automatic HeatWave Vector Index (from The Oracle MySQL Blog)

Accelerate Similarity Search with Automatic HeatWave Vector Index [...]

Enhance Your Data Processing with HeatWave Temporary Tables (from The Oracle MySQL Blog)

Enhance Your Data Processing with HeatWave Temporary Tables [...]

Simplify Real-Time Analytics with MySQL HeatWave Auto-Refresh Materialized Views (from The Oracle MySQL Blog)

Simplify Real-Time Analytics with MySQL HeatWave Auto-Refresh Materialized Views [...]

MariaDB Cloud: A Semi-Technical Introduction (from MariaDB Foundation Blog)

pWhen co-founding MariaDB plc under the name SkySQL Corporation fifteen years ago (before MariaDB Foundation existed), we picked the name SkySQL with a bit of a reference to the cloud. … /p pContinue reading \"MariaDB Cloud: A Semi-Technical Introduction\"/p pThe post MariaDB Cloud: A Semi-Technical Introduction appeared first on MariaDB.org./p [...]

Thursday, 23. October 2025

Where can you find MySQL during November 2025 - January 2026! (from The Oracle MySQL Blog)

MySQL events in Nov-Jan 2026 [...]

MySQL Basics: Count Me In—Aggregating and Grouping Your Data (from The Oracle MySQL Blog)

Discover how to use aggregate functions and GROUP BY in MySQL to answer big questions about your data! This post guides beginners through counting, averaging, and categorizing records with friendly library metaphors, clear examples, and humor. A great way to level up your SQL skills and get your data stories told. [...]

Wednesday, 22. October 2025

Schema Changes Made Easy with MySQL Cluster/J 9.4 (from The Oracle MySQL Blog)

Introducing new APIs in Cluster/J to help applications handle schema changes [...]

Introducing MySQL Cluster/J 9.4 (from The Oracle MySQL Blog)

The first of two parts describing new features in Cluster/J, the NoSQL Java development environment for MySQL NDB Cluster. [...]

Introducing MariaDB Exa: 1,000x Faster Analytics on Live Data (from MariaDB Corporation Blog)

The Challenge: Grappling with Growing Datasets We are excited to announce our partnership with Exasol, a collaboration set to revolutionize […] [...]

UUIDv7 and Time-Based Partitioning in PostgreSQL 18 (from MinervaDB Blog)

UUIDv7 and Time-Based Partitioning in PostgreSQL 18: A Complete Guide Introduction: The UUID Evolution That Changes Everything PostgreSQL 18 introduces native support for UUIDv7, a game-changing identifier format that solves one of the database world’s [...] [...]

Faster Recommendations with User & Item Features: MySQL HeatWave's Two Tower Model (from The Oracle MySQL Blog)

We are excited to share how MySQL HeatWave brings powerful recommendation capabilities directly into your database with the integration of the TwoTower model, a deep learning architecture that's become the gold standard for large-scale recommender systems [...]

FromDual Backup and Recovery Manager for MariaDB and MySQL 2.3.2 has been released (from Shinguz's Blog)

pFromDual has the pleasure to announce the release of the new version 2.3.2 of its popular Backup and Recovery Manager for MariaDB and MySQL (codebrman/code)./p pThe new FromDual Backup and Recovery Manager can be downloaded from here. The FromDual Repositories were updated. How to install and use the Backup and Recovery Manager is described in FromDual Backup and Recovery Manager (codebrman/code) [...]

Announcing the Release of MariaDB Enterprise Platform 2026 (from MariaDB Corporation Blog)

We are thrilled to announce the launch of MariaDB Enterprise Platform 2026, establishing MariaDB as the definitive database platform for […] [...]

What the AWS Outage Showed Us: Resilience is Built Across Clouds (from Continuent Blog)

An analysis of the AWS outage and how cross-cloud continuity ensures uptime across cloud providers using solutions like Tungsten Cluster.Tags: cloud resiliencecross-cloud continuityHigh Availabilitymulti-cloud strategy [...]

Tuesday, 21. October 2025

Monitoring multithreaded replication in Amazon RDS for MySQL, Amazon RDS for MariaDB, and Aurora MySQL (from AWS Database Blog)

In this post, we discuss methods to effectively monitor parallel replication performance and tune its related parameters for Amazon Aurora MySQL and Amazon Relational Database Service for MySQL and MariaDB. [...]

Overview and best practices of multithreaded replication in Amazon RDS for MySQL, Amazon RDS for MariaDB, and Amazon Aurora MySQL (from AWS Database Blog)

In this first post, we dive into the world of MySQL replication, with a special focus on parallel replication techniques. We start with a quick overview of how MySQL replication works, then explore the intricacies of multithreaded replication. We discuss key configuration options and best practices for optimization. [...]

Advanced Database Performance Tuning for MariaDB (from MinervaDB Blog)

Advanced Database Performance Tuning for MariaDB Introduction MariaDB performance tuning is a multi-layered discipline that requires deep understanding of database internals, storage mechanisms, query execution paths, and system-level interactions. Effective optimization can yield performance improvements [...] [...]

Does Your Black Friday Database Scaling Strategy Involve Duct Tape and Prayers? (from Readyset Blog)

Scale MySQL for Black Friday traffic without read replicas. Readyset QueryPilot automates query caching to boost MySQL performance and stability. [...]

How to Stream Data from Kafka to TiDB (from PingCAP Blog)

pModern applications generate enormous amounts of event data with user actions, transactions, logs, and metrics all happening in real time. To handle this scale, many teams rely on Apache Kafka, a distributed messaging system that decouples applications from their data pipelines and ensures reliable, high-throughput data delivery. On the storage side, TiDB provides a distributed SQL [...]

MySQL Basics: Join the Party—Bringing Tables Together with JOINs (from The Oracle MySQL Blog)

Discover how to combine information from multiple tables using JOINs in MySQL! This beginner-friendly guide explains INNER JOINs (and friends) with fun library metaphors, approachable SQL examples, and practical tips to help you unlock the true power of your relational database. [...]

What’s New At Releem - September 2025 (from Releem Blog)

September was a month of momentum. We focused on problems that frustrate every DBA: deadlocks, incomplete visibility, and cloud deployment quirks. We’ve shipped real-time deadlock monitoring, expanded the weekly reports, and fixed key issues with Releem Agent for RDS. [...]

Monday, 20. October 2025

Determine how much concurrency to use on a benchmark for small, medium and large servers (from Small Datum)

pWhat I describe here works for me given my goal, which is to find performance regressions. A benchmark run at low concurrency is used to find regressions from CPU overhead. A benchmark run at high concurrency is used to find regressions from mutex contention. A benchmark run at medium concurrency might help find both./ppMy informal way for classifying servers by size is:/pp/pullismall - has less t [...]

How to Succeed in the MariaDB Python Hackathon, Bangalore (from MariaDB Foundation Blog)

pLast Friday, we hosted an Ask Me Anything session with HackerEarth – and we promised to share the same insights here in written form. So here it is: your guide to success in the MariaDB Python Hackathon! … /p pContinue reading \"How to Succeed in the MariaDB Python Hackathon, Bangalore\"/p pThe post How to Succeed in the MariaDB Python Hackathon, Bangalore appeared first on MariaDB.org [...]

Saturday, 18. October 2025

Measuring scaleup for MariaDB with sysbench (from Small Datum)

pThis post has results to measure scaleup for MariaDB 11.8.3 on a 48-core server./pptl;dr/pp/pulliScaleup is better for range queries than for point queries/liliFor tests where results were less than great, the problem appears to be mutex contention within InnoDB/li/ulp/ppBuilds, Configuration & Hardware/ppThe server has an AMD EPYC 9454P 48-Core Processor with AMD SMT disabled, 128G of RAM and [...]

Measuring scaleup for Postgres 18.0 with sysbench (from Small Datum)

pThis post has results to measure scaleup for Postgres 18.0 on a 48-core server./pptl;dr/pp/pulliPostgres continues to be boring (in a good way)/liliResults are mostly excellent/liliA few of the range query tests have a scaleup that is less than great but I need time to debug/li/ulpBuilds, Configuration & Hardware/ppThe server has an AMD EPYC 9454P 48-Core Processor with AMD SMT disabled, 128G [...]

Ten Years, Starting Again: My Journey with TiDB (from siddontang on Medium)

pThe most precious things in life are memories and reflection. After we released the next generation TiDB Cloud, I think it is time for some reflection./ppTime flies — ten years have passed. On April 1, 2015, Max asked me, very seriously on April Fools’ Day, “Do you want to start a company together?” From that moment, I jumped on the TiDB train. The ride has been bumpy and brilliant./ppIn these ten [...]

From Events to Impact: The Power of Shared Ownership (from siddontang on Medium)

pThe Blame Game After Every Event/ppContinue reading on Medium »/p [...]

SQL Anti-Patterns You Should Avoid (from One-Time MySQL Community/Ecosystem Posts)

Today, I will be talking about some of the common and high impact SQL anti-patterns I have seen from experience that can make queries and pipelines difficult to maintain, or have slower than expected performance. [...]

Friday, 17. October 2025

My Impressions from Oracle AI World 2025 – MySQL, AI, and Its Open Source Future (from Another Boring Tech Blog)

pNote: The opinions below represent my personal perspective only. They don’t include any confidential information or represent the views of Oracle or my current employer, Percona.   The question I brought home after this conference is: Was this an AI conference because everyone is already using AI, or because they want you to use AI?.../p pO post My Impressions from Oracle AI World 2025 – MySQ [...]

MySQL HeatWave feature announcements at Oracle AI World (from The Oracle MySQL Blog)

MySQL HeatWave feature announcements at Oracle AI World [...]

Welcoming Wolf Software Systems Ltd as a New Sponsor of the MariaDB Foundation (from MariaDB Foundation Blog)

pWe are excited to announce that Wolf Software Systems Ltd has joined the MariaDB Foundation as a new Silver sponsor! Their support helps strengthen our shared mission of advancing open-source database technology, and we warmly welcome them into our community. … /p pContinue reading \"Welcoming Wolf Software Systems Ltd as a New Sponsor of the MariaDB Foundation\"/p pThe post Welcoming Wolf S [...]

Thursday, 16. October 2025

Is MariaDB Used in Production? Real-World Setups, Proof & AI (from MariaDB Corporation Blog)

When interacting face-to-face with developers at meetups and conferences, I frequently get asked whether MariaDB is used in production for […] [...]

Why is RocksDB spending so much time handling page faults? (from Small Datum)

pThis week I was running benchmarks to understand how fast RocksDB could do IO, and then compared that to fio to understand the CPU overhead added by RocksDB. While looking at flamegraphs taken during the benchmark I was confused that about 20% of the samples were from page fault handling. This confused me at first.brbrThe lesson here is to run your benchmark long enough to reach a steady state bef [...]

Database Sharding Explained: Strategies for Scalable SQL Performance (from PingCAP Blog)

pDatabase sharding is a data architecture strategy that increases database performance by splitting up data into chunks and then spreading these chunks “intelligently” across multiple database servers (or database instances). These chunks of data are called shards, while each shard contains a subset of our data. All shards represent the entire set of data, and […]/p pThe post Database Shardin [...]

How Readyset Handles Window Functions Under the Hood (from Readyset Blog)

Learn how Readyset optimizes SQL Window Functions for faster, scalable queries on MySQL and Postgres with no code changes. [...]

Performance optimization strategies for MySQL on Amazon RDS (from AWS Database Blog)

In this post, we share infrastructure-level optimizations, RDS-specific performance features, and database design patterns to help improve MySQL performance on Amazon RDS. We focus on practical configurations and monitoring techniques that complement existing parameter tuning documentation, helping you make informed decisions for your specific workload requirements. [...]

Change Data Capture (CDC): A Complete Guide for Modern Data Teams (from PingCAP Blog)

pIn the areas of data management and real-time analytics, Change Data Capture (CDC) has become an indispensable tool. CDC is a software operation that enables you to monitor and record changes in your source database. From there, you can subsequently apply those changes to your target database. These changes could be new records, updates, or […]/p pThe post Change Data Capture (CDC): A Comple [...]

Supercharge MySQL: Introducing WebAssembly Integration for Next-Gen Data Apps (from The Oracle MySQL Blog)

This blog post introduces WebAssembly (Wasm) support in MySQL Heatwave! For the first time, you can bring high-performance, portable code, compiled from Rust, C++, and many more languages, directly to your MySQL data, unlocking a new universe of speed, flexibility, and innovation. [...]

MySQL HeatWave and MySQL AI integration with Model Context Protocol (from The Oracle MySQL Blog)

This blog is focused on Model Context Protocol (MCP). MCP is an open standard enabling seamless integration between applications powered by large language models (LLMs) and external data sources and/or tools. The MySQL HeatWave MCP Server provides a collection of specialized tools that help you leverage the full capabilities of both MySQL HeatWave and MySQL AI. [...]

Introducing Delta Lake in MySQL HeatWave Lakehouse (from The Oracle MySQL Blog)

MySQL HeatWave Lakehouse enables queries on file formats like Parquet, Avro, ND-JSON and CSV in an object store. This blog introduces support for the Delta Lake table format, thereby enabling ACID-compliant applications on data in the object store. [...]

Semantic and Keyword—Hybrid Search in MySQL HeatWave (from The Oracle MySQL Blog)

This blog explains Hybrid Search capabilities within MySQL HeatWave, describing how it combines the strengths of keyword-based (BM25) and semantic (embedding) search. It explains the benefits for advanced information retrieval and Retrieval Augmented Generation (RAG) pipelines, highlighting how hybrid search supports complex business scenarios that require both contextual understanding and exact ma [...]

This Month in MariaDB Foundation: September 2025 (from MariaDB Foundation Blog)

pSeptember was a month of big ideas, long-term thinking, and vibrant community energy for the MariaDB Foundation. Our Board of Directors met for what may well have been the most strategic session in Foundation history – … /p pContinue reading \"This Month in MariaDB Foundation: September 2025\"/p pThe post This Month in MariaDB Foundation: September 2025 appeared first on MariaDB.org./p [...]

Riding the Waves – the MariaDB adoption index in October 2025 (from MariaDB Foundation Blog)

pEven positive trends have hiccups. Last month we celebrated “onwards and upwards”. This month the adoption index took a bit of a knock. … /p pContinue reading \"Riding the Waves – the MariaDB adoption index in October 2025\"/p pThe post Riding the Waves – the MariaDB adoption index in October 2025 appeared first on MariaDB.org./p [...]

MySQL Basics: The Keys to the Kingdom—Primary and Foreign Keys Explained (from The Oracle MySQL Blog)

Unlock the secrets to reliable databases with primary and foreign keys! This beginner-friendly post uses engaging library metaphors and approachable SQL examples to show how keys keep your MySQL tables organized and your data relationships strong. Learn how to build, enforce, and practice these essential building blocks in your own projects. [...]

Wednesday, 15. October 2025

Streamlining GenAI and ML Application Development with the MySQL HeatWave Python SDK (from The Oracle MySQL Blog)

This document provides a walk-through of the MySQL HeatWave Python SDK. It offers helpful tips on how to use the SDK to accelerate your application development culminating in three demonstrations of developing applications to solve real-world problems with, a Retrieval Augmented Generation (RAG) bot, an LLM-based agent with tool-calling, and a machine learning pipeline for fraud detection. [...]

MySQL HeatWave Now FedRAMP Authorized and Live in OCI Government Realms (from The Oracle MySQL Blog)

Big news for our public sector customers! Oracle's MySQL HeatWave has achieved Authorization to Operate (ATO) in both the OC2 (FedRAMP High / DISA IL4) and OC3 (DISA IL5) realms of the Oracle Cloud Infrastructure (OCI) Government Cloud. This is a massive milestone that unlocks powerful new capabilities for government agencies, contractors, and other public sector organizations. Let's break down wha [...]

Top 50 MySQL Interview Questions and Answers for Every Skill Level  (from Devart MySQL Tool Blog)

pExplore the top 50 MySQL interview questions and answers fit both for newbies and experienced devs. Get prepared with real-world MySQL queries./p pThe post Top 50 MySQL Interview Questions and Answers for Every Skill Level  appeared first on Devart Blog./p [...]

Custom Port Support in Azure Database for MySQL – Flexible Server is Now Generally Available (from Azure for MySQL Blog)

pWe are excited to announce that custom port support for Azure Database for MySQL – Flexible Server is now generally available (GA). This long-requested feature gives you greater flexibility to align MySQL server deployments with your network and security requirements. By default, MySQL uses TCP port 3306; with this GA release, you can configure a custom port (between 25001 and 26000) when cre [...]

SaaS Multi-Region MySQL: Operational Excellence & Monitoring (from Continuent Blog)

A deep dive into operational excellence and monitoring strategies for multi-region MySQL in SaaS environments — including deployment automation, observability, compliance, and recovery best practices.Tags: multi-region mysqlSaaS operationsMySQL monitoringdatabase automationcompliance monitoringDisaster Recovery [...]

7 newer data science tools you should be using with Python (from InfoWorld)

pPython’s rich ecosystem of data science tools is a big draw for users. The only downside of such a broad and deep collection is that sometimes the best tools can get overlooked./p pHere’s a rundown of some of the best newer or less-known data science projects available for Python. Some, like Polars, are getting more attention but still deserve wider notice. Others, like C [...]

Sneak preview of State of MariaDB 2025 – survey still open! (from MariaDB Foundation Blog)

pThe State of MariaDB 2025 survey is well underway, and the insights are fascinating. Thank you to all who have participated so far! If you haven’t yet, the survey is open at: mariadb.typeform.com/survey-2025?utm_source=blogprvbr Take the survey now! … /p pContinue reading \"Sneak preview of State of MariaDB 2025 – survey still open!\"/p pThe post Sneak preview of State of MariaDB [...]

Amazon RDS for MySQL and PostgreSQL zero-ETL integration with Amazon Redshift now available in 8 additional regions (from AWS What's New)

pAmazon RDS for MySQL and Amazon RDS for PostgreSQL zero-ETL integration with Amazon Redshift is now available in the Asia Pacific (Hyderabad), Asia Pacific (Jakarta), Asia Pacific (Melbourne), Canada West (Calgary), Europe (Spain), Europe (Zurich), Israel (Tel Aviv), and Middle East (UAE) regions. Zero-ETL integrations enable near real-time analytics and machine learning (ML) on petabytes of trans [...]

Replit versus Vercel (from DoltHub Blog)

Dolt is the world's first version-controlled relational database. Dolt lets you branch, fork, clone, merge, and diff your relational data… [...]

Tuesday, 14. October 2025

Security Advisory: CVE Affecting Percona Monitoring and Management (PMM) (from Percona Database Blog)

♦A critical security vulnerability has been identified in the following software that Percona has made available and that you may be using:  PMM 3.x installations (that is, 3.0 and forward). The Common Vulnerabilities and Exposures (CVE) identifier for this issue is on request from mitre.org. Vulnerability details We were notified via an external report that […] [...]

MySQL HeatWave 9.4.2 - Improvements In Reloading Data Into The HeatWave Cluster After Rebooting (from The Oracle MySQL Blog)

This blog post explains the in-memory data cluster reloading improvements of MySQL HeatWave version 9.4.2 [...]

Amazon Aurora MySQL zero-ETL integration with Amazon SageMaker Lakehouse (from AWS Database Blog)

In this post, we explore how zero-ETL integration works, the key benefits it delivers for data-driven teams, and how it aligns with the broader zero-ETL strategy in AWS services. You'll learn how this integration can enhance your data workflows, whether you're building predictive models, entering interactive SQL queries, or visualizing business trends. By eliminating traditional extract, transform, [...]

Is it time for TPC-BLOB? (from Small Datum)

pIf you want to store vectors in your database then what you store as a row, KV pair or document is likely to be larger than the fixed-page size (when your DBMS uses fixed-page sizes) and you will soon care about efficient and performant support for large objects. I assume this support hasn't been the top priority for many DBMS implementations and there will be some performance bugs./ppIn a SQL DBM [...]

TiDB Cloud Essential Now Available in Public Preview on AWS and Alibaba Cloud (from PingCAP Blog)

pTiDB Cloud Essential is our new plan for teams that need a stronger balance of scalability, performance, and security than TiDB Cloud Starter, without the full enterprise surface area of TiDB Cloud Dedicated. Starting today, you can now provision fixed Request Capacity Units (RCUs) for predictable performance, grow instantly when you need more headroom, and […]/p pThe post TiDB Cloud Essenti [...]

Modular Magic: Reusing Code in MySQL with the New LIBRARY Feature (from The Oracle MySQL Blog)

An overview of Library Feature in the MySQL HeatWave managed cloud service and elsewhere. [...]

From MEM to Automation: Managing MySQL Enterprise with ClusterControl (from Severalnines Blog)

pWhen Oracle announced the deprecation of MySQL Enterprise Monitor (MEM), many organizations running MySQL Enterprise Server suddenly faced a gap in their operations stack. MEM had long been part of the Enterprise subscription, providing monitoring and limited automation. Now, DBAs and DevOps teams must look elsewhere for visibility and control. The good news? Moving away […]/p pThe post From [...]

Querying the Unstructured: Natural Language to SQL for JSON Data (from MySQL expert Diary)

pBridging natural language processing with semi-structured data brings both opportunity and complexity./p pMySQL HeatWave GenAI’s NL2SQL feature shows how natural language can simplify data interaction — even for JSON documents. Yet, because JSON embeds both data and metadata within a single column, LLMs may struggle without explicit schema cues./p pBy creating well-structured views that reveal JSO [...]

MySQL Basics: Turning the Page—Using LIMIT and OFFSET for Pagination (from The Oracle MySQL Blog)

Discover how to tame big tables using LIMIT and OFFSET in MySQL! This post makes pagination easy for newcomers, using friendly library metaphors, step-by-step SQL examples, and practical tips to help you view your data one page at a time. [...]

Dolt SQL Server MariaDB Client Support (from DoltHub Blog)

Imagine connecting to your database with the same MariaDB client you've always used, but suddenly having access to Git-style version control… [...]

Benchmarking Postgres 17 vs 18 (from PlanetScale Blog)

Postgres 18 brings a significant improvement to read performance via async I/O and I/O worker threads. Here we compare its performance to Postgres 17. [...]

Monday, 13. October 2025

Removing the index guesstimate with MySQL Autopilot Indexing (from The Oracle MySQL Blog)

This blog post introduces the MySQL Autopilot Indexing feature. [...]

Interact with MySQL in natural language (from The Oracle MySQL Blog)

We are excited to announce the release of Natural Language to SQL (NL2SQL) capability for MySQL (with the AI option) and MySQL HeatWave cloud service. Natural language interface is essential for modern data platforms, allowing users to explore information more quickly. [...]

Top ideas in the MariaDB-Python hackathon (from MariaDB Foundation Blog)

pAs we blogged last week, the ideation phase of the MariaDB-Python hackathon ended with a heap of ideas. Due to the sheer mass, we had a tough time evaluating suitable ideas and teams for the development phase. … /p pContinue reading \"Top ideas in the MariaDB-Python hackathon\"/p pThe post Top ideas in the MariaDB-Python hackathon appeared first on MariaDB.org./p [...]

Build a Smart Weather Agent with LangChain and MySQL HeatWave GenAI (from The Oracle MySQL Blog)

This article showcases the power of combining the LangChain framework with an LLM hosted on MySQL HeatWave GenAI. Our goal is to create an agent that can answer the question, "What is the current weather in Fahrenheit?". To do this, the agent must first fetch the weather (which is in Celsius) and then convert it to Fahrenheit, a classic multi-step task. This agent will demonstrate how a Large Langu [...]

Build a RAG System with LangChain and MySQL HeatWave GenAI (from The Oracle MySQL Blog)

This post will guide you through building a simple RAG workflow using the popular LangChain framework, powered entirely by the in-database AI capabilities of MySQL HeatWave GenAI. We will ingest a public blog post, index it in the HeatWave Vector Store, and use a HeatWave-hosted LLM to answer questions based on its content following the LangChain guide to creating vector stores and using them for [...]

Friday, 10. October 2025

Updated MariaDB ODBC, Python, and Node.js Connectors now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Connector/ODBC 3.2.7, Connector/Python 1.1.14, and Connector/Node.js 3.5.0. MariaDB Connector/ODBC 3.2.7 […] [...]

Do You Need An AI Assistant? (from Dave's MySQL Stuff)

p/pbrbr Artificial Intelligence has been over hyped the last several years. But one of the bright, shining spots for AI is acting as an assistant. a super-powerful IDE, when working with a database.p/pExamplepYou want to find your top three customers in the Sakila database. This database has been used for decades in the MySQL world./ppAs your question in English (or another language)/p♦The '@a [...]

On Teaching MySQL. Q&A with Michael Scott Brown (from ODBMS.org)

Q1. From your experience managing the Database System Technology Masters program and teaching at diverse institutions ranging from community colleges to Division I universities, how have you seen the role of MySQL evolve in database... [...]

Thursday, 09. October 2025

Advanced observability and troubleshooting with Amazon RDS event monitoring pipelines (from AWS Database Blog)

AWS provides a wide range of monitoring solutions for your Amazon RDS and Amazon Aurora instances, such as Amazon CloudWatch, Amazon CloudWatch Database Insights, and AWS CloudTrail. Amazon RDS event monitoring pipelines make troubleshooting operational events like reboots, errors, and failovers more efficient. In this post, we present a solution to get a head start on troubleshooting by sending an [...]

September 2025 Recap: Azure Database for MySQL (from Azure for MySQL Blog)

pJoin us live on our YouTube channel on October 15, 2025 for an exclusive webinar where we’ll dive deeper into the latest Azure Database for MySQL updates and answer your questions! Watch it live here./p Support for In-Place Major Version Upgrade from 8.0 to 8.4 pWe previously announced that Azure Database for MySQL version 8.4 is now generally available. We’re now happy to share that in- [...]

MySQL Basics: WHERE’s the Data? Filtering Results with WHERE Clauses (from The Oracle MySQL Blog)

Ready to grow your querying skills? This post introduces curious newcomers to the WHERE clause in MySQL, showing how simple conditions, clever operators, and cheerful library metaphors can help you filter data like a pro. Find the exact records you need using approachable SQL examples—no dusty catalogs required! [...]

A Data Importing AI Agent (from DoltHub Blog)

For the past few months, I've been blogging about my experience with agents. My first blogs on the subject were about using agents with Dolt… [...]

Wednesday, 08. October 2025

Here’s the Message I Sent Welcoming Percona’s New CEO Peter Farkas (from Peter Zaitsev)

pFirst, I want to give a big thank-you to Bennie Grant, who has been our Interim CEO over the past few months. Stepping into the CEO role is never easy — and doing it on an interim basis can be even tougher. Bennie, we’re grateful for the way you’ve helped steer us through this transition […]/p pThe post Here’s the Message I Sent Welcoming Percona’s New CEO Peter Farkas appeared first o [...]

Introducing TiDB X: A New Foundation for Distributed SQL in the Era of AI (from PingCAP Blog)

pAsk any engineering team managing a modern application today, and you’ll hear the same frustrations: traffic spikes that can’t be predicted, autoscalers that react too slowly, and workloads that look nothing like they did yesterday. One hour you’re processing transactions, the next you’re serving analytical or vector queries — all in real time, all under […]/p pThe post Introducing TiDB X: A [...]

What’s New in MySQL HeatWave on AWS? (from The Oracle MySQL Blog)

We’re introducing a powerful set of enhancements aimed at boosting service availability and manageability thereby simplifying migrations from AWS Aurora, RDS, or MySQL on EC2, and improving performance. [...]

From Vision to Action: Strengthening the MariaDB Foundation Board – Welcome, Frank Karlitschek! (from MariaDB Foundation Blog)

pStrengthening the Board with industry leaders is a key goal for the MariaDB Foundation in 2025 – and beyond./p pAt the MariaDB Foundation, we believe that leadership in open source isn’t just about code — … /p pContinue reading \"From Vision to Action: Strengthening the MariaDB Foundation Board – Welcome, Frank Karlitschek!\"/p pThe post From Vision to Action: Strengthening [...]

Why MySQL on Kubernetes Fails Without the Right Operator (from Continuent Blog)

Challenges of running MySQL on Kubernetes and how Operators ensure reliability through replication, failover, and observability.Tags: kubernetesoperatorMySQL [...]

Tuning BLOB for performance in NDB [Part 2] (from The Oracle MySQL Blog)

This blog post shows the performance evaluation of the BLOB_INLINE_SIZE column option for NDB tables in comparison without it, as well as the benefits of batching BLOB read and writes. [...]

What is JPA? Introduction to Java persistence (from InfoWorld)

pThe Jakarta Persistence API (JPA) is a specification that defines a standardized framework for data persistence. Persistence is the fundamental mechanism for saving and retrieving data over time. In Java, the data we persist is held in objects. The JPA specification lets you define how your objects will be persisted while leaving the work itself to an underlying framework. /p [...]

Audit Log Filters Part II (from Percona Community Blog)

pIn my first post on the MySQL 8.4 Audit Log Filter component, I covered how to install the component and configure a basic filter that captures all events. The Audit Log Filter framework offers a highly granular and configurable auditing mechanism, enabling administrators to log specific events based on criteria such as user, host, or event type. This selective approach enhances observability, sup [...]

Tuesday, 07. October 2025

Celebrating a New Chapter: Percona Welcomes Peter Farkas as its New Chief Executive Officer (from One-Time MySQL Community/Ecosystem Posts)

Today, we are excited to announce that Peter Farkas will serve as Percona’s new Chief Executive Officer, where he will build on the company’s long-standing track record of success with an eye toward continuous innovation and growth. [...]

MySQL Basics: Seek and You Shall SELECT—Retrieving Data from Your Tables (from The Oracle MySQL Blog)

Curious about what's inside your MySQL tables? This post introduces beginners to the SELECT statement, using friendly library metaphors, approachable SQL examples, and helpful tips—including how to alias column names. Get ready to start exploring your data with confidence! [...]

Impressive stats from ideation phase of Bengaluru Python hackathon, now closed (from MariaDB Foundation Blog)

pThe ideation phase of the MariaDB-Python Hackathon wrapped up on Sunday — and the response was phenomenal!br A huge thanks to everyone who joined the journey: from the BangPypers’ … /p pContinue reading \"Impressive stats from ideation phase of Bengaluru Python hackathon, now closed\"/p pThe post Impressive stats from ideation phase of Bengaluru Python hackathon, now closed appea [...]

Let Your AI DBA Assistant Write Your MySQL Queries (from MySQL expert Diary)

pHaving explored the innovative MySQL HeatWave technology that converts Natural Language into SQL (Ask Your Database Anything: Natural Language to SQL in MySQL HeatWave), our next article in this series, dives into a practical use case demonstrating how an AI DBA Assistant can significantly simplify your query generation workflow. In MySQL, there are 3 specialized […]/p The post Let Your AI D [...]

Why TiDB Is the Best Database for AI as a Service(AIaaS) (from siddontang on Medium)

pRecently, I visisted many customers, like AIaaS, Web3, Fintech, etc, different industires, but the same topic. No matter who I talked to, the conversation invevitably turned to AI./ppEveryone is trying to figure out how AI will help their bussiness, and wants to know how TiDB embraces AI. (Notice: feel free to visit TiDB Cloud to experience the TiDB x AI journey immediately)./ppSo I started to sha [...]

Run Bats with a Single Click on Windows using GoLand (from DoltHub Blog)

Dolt is a plug-in MySQL-compliant database that behaves like Git, allowing you to version control your data. In the last couple of months, I… [...]

Monday, 06. October 2025

September Product Update (from Readyset Blog)

♦pSpooky season is here, and so are the latest updates from Readyset:  /pQueryPilot Demo: It's Not Broken, It's Just That Fast. pQueryPilot automatically finds and optimizes your most expensive queries with zero manual tuning or configuration. Its performance is so instant that results are/p [...]

Optimizing queries by using observability (from InfoWorld)

pIn a modern enterprise data environment, the increasing volume of data, distributed architecture, and complex application dependencies challenge traditional query-tuning methods. Observability enhances query optimization by providing constant, fine-grained visibility into query behavior, resource consumption, and systemic interactions. Taking advantage of this data shifts th [...]

Launching the State of MariaDB 2025 survey (from MariaDB Foundation Blog)

pWe want to know how you’re really using MariaDB. Not the marketing version. Not the idealized case study. The real story—what you’re building, what tools you’re using, what’s working, and what’s frustrating. … /p pContinue reading \"Launching the State of MariaDB 2025 survey\"/p pThe post Launching the State of MariaDB 2025 survey appeared first on MariaDB [...]

Introducing Tungsten Dashboard v8.0.2 (from Continuent Blog)

Tungsten Dashboard v8.0.2 introduces major performance improvements, real-time cluster visibility, and enhanced usability with an intuitive Add/Edit Cluster workflow, namespace visibility, and configurable light/dark themes. The release also includes a redesigned installer with configuration reset, Docker Compose plugin support, and self-signed certificate generation. New tools like collect-diag.pl [...]

Introducing Tungsten Cluster & Tungsten Replicator v8.0.1 (from Continuent Blog)

Tungsten Cluster & Tungsten Replicator v8.0.1 focus on improving security, configuration management, and observability. The release introduces tpm INI upgrade and validation enhancements, dual MySQL SSL certificate for seamless certificate rotation, and new Prometheus metrics for deeper Replicator insights. It also delivers multiple CLI and stability fixes and adds certification for MariaDB 11. [...]

Sunday, 05. October 2025

Performance Framework Autobench3's Profiler Runner – MySQL Benchmarking Series #5 (from One-Time MySQL Community/Ecosystem Posts)

When chasing changes in performance, it’s not enough to know which commit introduced the change — we need to understand how it has changed workloads. [...]

Friday, 03. October 2025

When Oracle Drops the Ball: Why MariaDB is the Future of the MySQL World (from MariaDB Foundation Blog)

pThe news has circulated quietly in industry corners, but the implications are far too significant to brush aside: Oracle seems to have ended the Open Source era of MySQL. … /p pContinue reading \"When Oracle Drops the Ball: Why MariaDB is the Future of the MySQL World\"/p pThe post When Oracle Drops the Ball: Why MariaDB is the Future of the MySQL World appeared first on MariaDB.org./p [...]

Get Ready for MySQL HeatWave at Oracle AI World 2025! (from The Oracle MySQL Blog)

This blog gives you a complete overview of MySQL HeatWave sessions so you can plan your agenda, mark your calendar, and make the most of the event. [...]

Failing 100 Real World Postgres Dumps (from DoltHub Blog)

We're continuing to make progress on DoltgreSQL, which is a version of Dolt built to be a drop-in replacement for PostgreSQL. Dolt is a drop… [...]

Thursday, 02. October 2025

MariaDB C++ Connector 1.1.7 and 1.0.6 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/C++ 1.1.7 and 1.0.6 releases. Release Notes MariaDB Connector/C++ […] [...]

Data Integrity in a Database: How to Ensure Accuracy and Security (from Devart MySQL Tool Blog)

pLearn what data integrity in DBMS means, why it’s vital for database accuracy, and how to maintain it effectively. Read on to protect your data now./p pThe post Data Integrity in a Database: How to Ensure Accuracy and Security appeared first on Devart Blog./p [...]

Success Story: zvoove Switzerland AG – From Legacy Systems to Scalable Solutions with MariaDB (from MariaDB Foundation Blog)

pPhillippe Balzli, CTO at zvoove Switzerland AG, shared in an interview with Kaj Arnö of MariaDB Foundation how the company navigated legacy software, rapid growth, and evolving customer needs – … /p pContinue reading \"Success Story: zvoove Switzerland AG – From Legacy Systems to Scalable Solutions with MariaDB\"/p pThe post Success Story: zvoove Switzerland AG – From Legacy Syste [...]

Bring your data to your code with Azure’s Data API Builder (from InfoWorld)

pAzure is now so big it’s hard to keep on top of all its features, let alone drill down into its ever-growing line of developer tools. That’s not surprising; in the past two decades or so, it’s become the place where Microsoft builds its own and its customer-facing products./p pThat internal developer focus eventually brings tools to the rest of us, as internal APIs and se [...]

Using Microsoft’s Data API builder for Azure databases (from InfoWorld)

pMicrosoft Azure is now so big it’s hard to keep on top of all its features, let alone drill down into its ever-growing line of developer tools. That’s not surprising. In the past two decades, Azure has become the place where Microsoft builds all of its products, both the tools for its own use and those for its customers./p pThat internal developer focus eventually brings [...]

Multi-Region MySQL for SaaS: Architecture Patterns (from Continuent Blog)

An in-depth guide to multi-region MySQL for SaaS, covering design principles, challenges, and proven architecture patterns for global scale.Tags: SaaSArchitecturemulti-region mysql [...]

MySQL Basics: Change Is Good—Updating and Deleting Table Data (from The Oracle MySQL Blog)

Learn how to responsibly update or delete your MySQL data—including the concept of soft deletes—using engaging library metaphors and practical SQL examples. This post guides beginners through UPDATE and DELETE statements, safety tips, and real-world scenarios. [...]

Wednesday, 01. October 2025

Dbeaver: For postgres 2 mysql data migration. (from MySQL-Med)

Want to migrate Postgres data to MySQL/MariaDB with an open-source community tool that will knock your socks off? Please keep reading... Continue reading → [...]

Understanding Foreign Data Wrappers in PostgreSQL (from MinervaDB Blog)

Understanding Foreign Data Wrappers in PostgreSQL: A Complete Guide to postgres_fdw Introduction In today’s distributed data landscape, organizations often need to access and integrate data from multiple database systems. PostgreSQL Foreign Data Wrappers (FDWs)provide an [...] [...]

Vercel v0 Works with Dolt (from DoltHub Blog)

Dolt is the world's first version-controlled relational database. Dolt lets you branch, fork, clone, merge, and diff your relational data… [...]

Larger than RAM Vector Indexes for Relational Databases (from PlanetScale Blog)

A new hybrid design for scalable vector indexes and a reference implementation in MySQL [...]

Tuesday, 30. September 2025

MariaDB and AI: Building the Bridge That Really Matters (from MariaDB Foundation Blog)

pNot what AI can do for MariaDB – but what MariaDB can do for AIbr I have hinted at this before (This Month in MariaDB – … /p pContinue reading \"MariaDB and AI: Building the Bridge That Really Matters\"/p pThe post MariaDB and AI: Building the Bridge That Really Matters appeared first on MariaDB.org./p [...]

Ask Your Database Anything: Natural Language to SQL in MySQL HeatWave (from MySQL expert Diary)

pNatural Language to SQL in MySQL HeatWave makes data accessible to everyone, not just SQL experts. By turning plain English into optimized queries, it removes barriers and speeds up insights. While best practices help ensure accuracy, the feature already shows how LLMs are transforming the way we work with data. With the NL_SQL routine, asking your database questions is as simple as asking a colle [...]

MySQL Basics: Filling the Gaps—Inserting Data into Your Tables (from The Oracle MySQL Blog)

Learn how to bring life to your database by inserting records into your MySQL tables! This post shows beginners how to use INSERT statements—with lighthearted library metaphors, approachable SQL examples, and helpful tips for common pitfalls. A perfect next step on your MySQL journey. [...]

Multi-stage Docker Builds for Dolt (from DoltHub Blog)

Imagine if every change to your database was as traceable as every line of code in your Git repository. What if you could branch your… [...]

Monday, 29. September 2025

Meta’s Infrastructure Evolution and the Advent of AI (from Engineering at Meta)

p  Over the past 21 years, Meta has grown exponentially from a small social network connecting a few thousand people in a handful of universities in the U.S. into several apps and novel hardware products that serve over 3.4 billion people throughout the world. Our infrastructure has evolved significantly over the years, growing from a [...]/p pRead More.../p pThe post Meta’s Infrastructure Evo [...]

MariaDB Bangalore Hackathon: Ideation Phase Closing (from MariaDB Foundation Blog)

pThe final days are here for the Foundation’s first large-scale hackathon, the MariaDB Python Hackathon we’re organising in partnership with BangPypers (the Bangalore Python Meetup, a group with about 14,000 members) and HackerEarth (a Hackathon organiser). … /p pContinue reading \"MariaDB Bangalore Hackathon: Ideation Phase Closing\"/p pThe post MariaDB Bangalore Hackathon: Ideat [...]

Common Table Expressions in MySQL: How and Why with Examples (from DoltHub Blog)

In this guide, learn how to use common table expressions (CTEs) in MySQL, what they're good for, and try out some simple examples. What's a… [...]

Sunday, 28. September 2025

Readyset MySQL BR Conf 2025 Challenge – Sorteio de R$500 (from Readyset Blog)

pObrigado por participar do MySQL BR Conf 2025 e celebrar os 30 anos do MySQL! Tivemos um tempo fantástico conectando com vocês e mal podemos esperar para ver os resultados do desafio. /pComo participar para ter a chance de ganhar um prêmio em [...]

Friday, 26. September 2025

MySQL and MariaDB GPL licence error? (from SQL And Its Sequels (Ocelot Blog))

To comply with GPL requirements, MySQL and MariaDB include a COPYING or LICENSE file, which has You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA. and maybe something’s wrong with… Continue Reading MySQL and MariaDB GPL licence error? [...]

Announcing SQLyog 13.3.1 (from Webyog Blog)

pWe’re excited to announce the release of SQLyog 13.3.1, packed with new features, important fixes, and updates to keep SQLyog running smoothly with the latest MySQL and MariaDB versions. What’s […]/p pThe post Announcing SQLyog 13.3.1 appeared first on Webyog./p [...]

PG NYC 2025 (from Dave's MySQL Stuff)

p PG NYC 2025 starts November 29th, and you can find me in the DBeaver booth.  This event has become one of my favorites, packed with three days of intense content. And it will all happen less than a week after the release of PG 18./ppTickets are still available if you can make it to Manhattan./ppAnd I will be demoing new DBeaver features, including talking to the AI Assistant. Pleas [...]

MySQL 8.0 End of Life Support: What Are Your Options? (from Percona Database Blog)

♦We’ve mentioned this a few times here on the blog already, but in case you missed it, MySQL 8.0’s end-of-life date is April 2026. This probably sounds forever away, but it’s going to sneak up before you know it. Maybe you’ve been putting off thinking about it, or maybe you’re already weighing your options but […] [...]

Datagraph releases an extension of RonDB, a Common Lisp NDB API (from Mikael Ronstrom)

pDatagraph develops a Graph database called Dydra that can handle SPARQL, GraphQL and Linked Data Platform (LDP). Dydra stores a revisioned history, this means that you have access to the full history of your data. This could be a development of some document, a piece of software, a piece of HW like a SoC (System-on-a-Chip) or a building or something else. Essentially any data./ppThis blog describe [...]

Passbolt becomes Silver Sponsor of MariaDB Foundation (from MariaDB Foundation Blog)

pMariaDB Foundation is delighted to announce that Passbolt has joined as a Silver Sponsor, further strengthening the European open source ecosystem.Passbolt is the European open source platform for secure credential collaboration. … /p pContinue reading \"Passbolt becomes Silver Sponsor of MariaDB Foundation\"/p pThe post Passbolt becomes Silver Sponsor of MariaDB Foundation appeared first on [...]

Thursday, 25. September 2025

MariaDB 12.2 preview available (from MariaDB Foundation Blog)

pWe are pleased to announce the availability of a preview of the MariaDB 12.2 series. MariaDB 12.2 will be a rolling release. … /p pContinue reading \"MariaDB 12.2 preview available\"/p pThe post MariaDB 12.2 preview available appeared first on MariaDB.org./p [...]

MySQL HeatWave on AWS Now in Mexico (from The Oracle MySQL Blog)

We’re excited to announce the general availability of MySQL HeatWave in a new AWS region — Mexico Central (Querétaro) — reinforcing our commitment to expanding globally and meeting growing customer demand. [...]

Spec-driven AI coding with GitHub’s Spec Kit (from InfoWorld)

pMicrosoft and GitHub have made AI assistance a key part of their software development tools. Embedded in the latest Visual Studio and Visual Studio Code releases, GitHub Copilot puts a multifaceted pair programmer—combining AI-powered code completion, coding agents, and various Model Context Protocol servers—right inside your editor./p pThe resulting tool kit is especiall [...]

MySQL Basics: Table Manners – Setting up Your First Schema and Table (from The Oracle MySQL Blog)

Take your first hands-on steps in MySQL! This post teaches you how to create schemas and tables using relatable library analogies, beginner-friendly SQL examples, and tips to avoid common pitfalls. Perfect for newcomers, it’s your foundation for all future data adventures. [...]

Grafana's metrics backend for go-mysql-server (from DoltHub Blog)

We're building Dolt, the world's first and only version-controlled SQL database. Dolt's SQL engine, the part that parses SQL queries and… [...]

Wednesday, 24. September 2025

Indexing Materialized Views in PostgreSQL (from MinervaDB Blog)

Indexing Materialized Views in PostgreSQL What are Materialized Views? Materialized views in PostgreSQL are precompiled queries that store their results physically on disk, unlike regular views which are virtual and execute the underlying query each [...] [...]

Why Databases in Kubernetes Need Operators (from Continuent Blog)

Learn why Kubernetes alone isn’t enough for running stateful databases and how Operators solve challenges like failover, scaling, backups, and upgrades. Discover how Tungsten Operator brings proven MySQL clustering, replication, and enterprise-grade HA/DR into Kubernetes.Tags: kubernetesDatabaseoperatorMySQLHigh Availability [...]

Partnering with Cloudflare to bring you the fastest globally distributed applications (from PlanetScale Blog)

You can now easily set up PlanetScale databases with Cloudflare Workers using this native integration. [...]

Processes and Threads (from PlanetScale Blog)

Processes and threads are fundamental abstrations for operating systems. Learn how they work and how they impact database performance in this interactive article. [...]

Tuesday, 23. September 2025

Long-term storage and analysis of Amazon RDS events with Amazon S3 and Amazon Athena (from AWS Database Blog)

In this post, we show you how to implement an automated solution for archiving Amazon RDS events to Amazon Simple Storage Service (Amazon S3). We also discuss how to analyze the events with Amazon Athena which helps enable proactive database management, helps maintain security and compliance, and provides valuable insights for capacity planning and troubleshooting. [...]

Extracting and Substituting Text with Regular Expressions in PostgreSQL (from MinervaDB Blog)

Extracting and Substituting Text with Regular Expressions in PostgreSQL PostgreSQL provides a powerful built-in regex engine that enables sophisticated text manipulation through pattern matching, extraction, and substitution operations. Regular expressions are essential for data cleaning, [...] [...]

PostgreSQL 18: Accelerating Disk Reads with Asynchronous I/O (from MinervaDB Blog)

PostgreSQL 18 Asynchronous I/O: Accelerating Disk Reads with Asynchronous I/O The database world is about to witness a significant leap forward with PostgreSQL 18, scheduled for release on September 25, 2025. Among the many enhancements [...] [...]

TuningWizard Team Joins Releem: Building the Future of Database Management Together (from Releem Blog)

The TuningWizard team, led by founder Gabriel Ciciliani, is joining the Releem team — bringing SQL Query Optimization to Releem. [...]

Monitoring MySQL HeatWave on AWS: From Console to CloudWatch (from The Oracle MySQL Blog)

MySQL HeatWave on AWS extends its monitoring capabilities by integrating with Amazon CloudWatch, allowing you to view many additional metrics and track its history over time. [...]

dbForge Hits a New Milestone With 2025.2! (from Devart MySQL Tool Blog)

pNew dbForge milestone is achieved! This time, it brings us enhancements in AI Assistant, long-awaited user interface improvements, and further significant advancements in cloud support underway./p pInterested in learning more? Let's get started!/p pThe post dbForge Hits a New Milestone With 2025.2! appeared first on Devart Blog./p [...]

What MySQL configuration you hate the most? (from Kedar MySQL Blog)

pEver spent your weekend debugging a MySQL production issue that could have been avoided with better configuration? I have, and it’s beyond frustrating. I have prepared my list of the…/p The post What MySQL configuration you hate the most? first appeared on Change Is Inevitable. [...]

MySQL Basics: Getting TYPE-cast – Choosing the Right Data Type for the Job (from The Oracle MySQL Blog)

Demystify MySQL data types with this lighthearted guide for beginners! Learn how choosing the right type for each column—numbers, text, or dates—keeps your database organized, efficient, and easy to use. Packed with simple analogies, practical tips, and helpful examples, this post will help you master the essentials of structuring your tables in MySQL. [...]

Monday, 22. September 2025

Introducing Backup Validation and Backup Preparation in MySQL HeatWave (from The Oracle MySQL Blog)

Introducing Backup Validation and Backup Preparation in MySQL HeatWave [...]

PlanetScale for Postgres is now GA (from PlanetScale Blog)

PlanetScale for Postgres is now generally available. [...]

Saturday, 20. September 2025

Preventing Read-Write Conflicts: Lockless Concurrency in MySQL JSON Duality Views (from The Oracle MySQL Blog)

An overview of lockless optimistic concurrency control feature introduced for MySQL JSON Duality Views in version 9.4. [...]

Hands-on with JSON Duality Views in MySQL: From Creation to Day-to-Day Use (from The Oracle MySQL Blog)

An overview of DDL support for JSON Relational Duality Views introduced in version 9.4. [...]

Friday, 19. September 2025

Manipulating Data in MySQL JSON Duality Views: Deep Dive into DML Operations (from The Oracle MySQL Blog)

An overview of DML support for JSON Relational Duality Views introduced in version 9.4. [...]

Amazon RDS for MySQL announces Innovation Release 9.4 in Amazon RDS Database Preview Environment (from AWS What's New)

pAmazon RDS for MySQL now supports community MySQL Innovation Release 9.4 in the Amazon RDS Database Preview Environment, allowing you to evaluate the latest Innovation Release on Amazon RDS for MySQL. You can deploy MySQL 9.4 in the Amazon RDS Database Preview Environment which provides the benefits of a fully managed database, making it simpler to set up, operate, and monitor databases.br br MySQ [...]

Oracle’s MySQL Layoffs — Strategy, Timing, and What It Means for Enterprise Customers (from One-Time MySQL Community/Ecosystem Posts)

The recent layoffs at Oracle’s MySQL team are not just another corporate restructuring. They are a signal — one that raises important questions for enterprises and the broader open-source community. [...]

Thursday, 18. September 2025

Dynamic view-based data masking in Amazon RDS and Amazon Aurora MySQL (from AWS Database Blog)

Data masking is an important technique in cybersecurity, allowing organizations to safeguard personally identifiable information (PII) and other confidential data, while maintaining its utility for development, testing, and analytics purposes. Data masking involves replacing original sensitive data with false, yet realistic information. This process helps ensure that the masked version preserves th [...]

Sysadmin’s Inconceivable Tales – Squeezing More Performance out of tar (from Shattered Silicon OSDB Blog)

pHow we squeezed 33% moreperformance out of tar on x86-64 Linux./p pThe post Sysadmin’s Inconceivable Tales – Squeezing More Performance out of tar appeared first on Shattered Silicon./p [...]

Help Shape the Future of Vector Search in MySQL (from Percona Database Blog)

♦AI and machine learning are seemingly everywhere, and that’s forcing every database company to think about vector search. Companies want to build things like smart search that actually understands what you mean, recommendation systems that know what you’ll like, and tools that can spot when something’s off. To make all of this work at the […] [...]

Monitoring and Managing MySQL Clusters Without Downtime (from Continuent Blog)

For organizations running mission-critical MySQL clusters, even brief service interruptions can translate to significant losses. Modern MySQL environments face unprecedented complexity through geographic distribution, diverse workload patterns, and stringent availability requirements. Traditional monitoring approaches cannot address these challenges effectively, requiring comprehensive strategies t [...]

MySQL Basics: Into the Shell—Cracking Open Your Database Journey (from The Oracle MySQL Blog)

This post guides newcomers through accessing and exploring their databases using MySQL Shell. Clear instructions, friendly guidance, and practical tips ensure a confident start for any data explorer eager to interact with tables and data in real time. [...]

Audit Log Filter Component (from Percona Community Blog)

pThe audit log filter component in MySQL 8.4 provides administrators with a powerful mechanism for auditing database activity at a fine-grained level. While it offers significant flexibility—such as selectively logging events based on users, hosts, or event types—it can also be challenging to understand and configure correctly./p pIn this article, we will examine how the audit log filter component [...]

Wednesday, 17. September 2025

Announcing MySQL AI (from The Oracle MySQL Blog)

Announcing the release of MySQL AI, an option to MySQL Enterprise Edition, that provides built-in predictive and generative AI capabilities and a vector store. [...]

MySQL with Diagrams Part Three: The Life Story of the Writing Process (from Percona Database Blog)

♦When you run a simple write, …it may look simple, but under the hood, MySQL’s InnoDB engine kicks off a pretty complex sequence to ensure your data stays safe, consistent, and crash-recoverable. In the top-left corner of the diagram, we see exactly where this begins — the moment the query is executed: [crayon-690375df721ab034944776/] The log […] [...]

Amazon RDS for MySQL announces Extended Support minor 5.7.44-RDS.20250818 (from AWS What's New)

pAmazon Relational Database Service (RDS) for MySQL now supports new Amazon RDS Extended Support minor version 5.7.44-RDS.20250818. We recommend that you upgrade to this version to fix known security vulnerabilities and bugs in prior versions of MySQL. Learn more about upgrading your database instances, including minor and major version upgrades, in the Amazon RDS User Guide.br br Amazon RDS Extend [...]

Tuesday, 16. September 2025

Installing MariaDB Enterprise Kubernetes Operator on Ubuntu VM (from MariaDB Corporation Blog)

2. Install minikube & start minikubeminikube sets up a local Kubernetes clusterOffical guide: minikube start curl -LO github.com/kubernetes/minikube/releases/latest/download/minikube-linux-amd64 sudo install […] [...]

MySQL Deadlock Detection (from Releem Blog)

Understand, detect, and resolve deadlocks in your database with Releem’s automated monitoring and alerting. [...]

MySQL Basics: Understanding the Building Blocks of Databases (from The Oracle MySQL Blog)

Begin your hands-on MySQL adventure! This post guides newcomers through accessing and exploring their databases using MySQL Shell. Clear instructions, friendly guidance, and practical tips ensure a confident start for any data explorer eager to interact with tables and data in real time. [...]

Monday, 15. September 2025

Developing applications using LangChain and MySQL HeatWave GenAI – Part 1 (from The Oracle MySQL Blog)

Create a chatbot in LangChain using HeatWave GenAI [...]

Deploying Percona Operator for MongoDB Across GKE Clusters with MCS (from Percona Database Blog)

♦Ever needed a robust, highly available MongoDB setup that spans multiple Kubernetes clusters on GCP? This step-by-step guide shows you how to deploy the Percona Operator for MongoDB in two GKE clusters, linking them using Multi-Cluster Services (MCS) for seamless cross-cluster discovery and connectivity. Step 1: Prepare your GKE clusters & enable MCS 1. Prepare […] [...]

MySQL Podcast: InnoDB Cluster Group Replication (from Kedar MySQL Blog)

pI’m working on sharing MySQL tips, tricks, and other related tech topics in my MySQL podcast. It’s a bit of a challenge to stay consistent, but I’m pushing through. Finally…/p The post MySQL Podcast: InnoDB Cluster Group Replication first appeared on Change Is Inevitable. [...]

Sunday, 14. September 2025

Mydbops Joins the MariaDB Foundation as a Silver Sponsor (from Mydbops Blog)

Mydbops is proud to announce its Silver Sponsorship of the MariaDB Foundation. Learn why we're committed to supporting the open-source community. [...]

Archiving MySQL Audit Logs into OCI Object Storage buckets using OCI Data Integration(OCI-DI) (from The Oracle MySQL Blog)

Customers need to analyze MySQL audit logs for compliance, monitoring, and troubleshooting, but managing large volumes in MySQL can be costly. An archival system addresses this by extracting logs and storing them in a cost-effective repository. OCI Object Storage offers durability, scalability, and easy integration. Once archived, logs can be analyzed using OCI Logging Analytics or third-party tool [...]

Zero-configuration TLS and password management best practices in MariaDB 11.8 (from Optimized by Otto)

♦pLocking down database access is probably the single most important thing for a system administrator or software developer to prevent their application from leaking its data. As MariaDB 11.8 is the first long-term supported version with a few new key security features, let’s recap what the most important things are every DBA should know about MariaDB in 2025./p pBack in the old days, MySQL a [...]

Saturday, 13. September 2025

Strategic Shift from Oracle to PostgreSQL (from MinervaDB Blog)

Introduction: The Strategic Shift from Oracle to PostgreSQL The “Why”: Drivers of Modernization The enterprise database landscape is undergoing a seismic shift. For decades, Oracle Database has been a cornerstone of corporate data infrastructure, renowned [...] [...]

Friday, 12. September 2025

Unlocking Simplicity: Setting Up REST Service for MySQL HeatWave (from The Oracle MySQL Blog)

Today’s developers strive for agility without sacrificing security or performance, especially when building data-driven apps and AI solutions. That’s why we’re excited to introduce the MySQL HeatWave REST Service (MRS), a fully managed, integrated solution that lets you create RESTful API endpoints instantly, directly from your MySQL HeatWave databases. There’s no need for backend coding, middlewar [...]

Postgres High Availability with CDC (from PlanetScale Blog)

Why a lagging client can stall or break failover, and how MySQL’s GTID model avoids it. [...]

Thursday, 11. September 2025

MariaDB Java Connector 3.5.6 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/J 3.5.6 release. Release Notes and Changelogs MariaDB Connector/J […] [...]

Postgres 18rc1 vs sysbench (from Small Datum)

pThis post has results for Postgres 18rc1 vs sysbench on small and large servers. Results for Postgres 18beta3 are here for a small and large server./pptl;dr/pp/pulliPostgres 18 looks great/liliI continue to see small CPU regressions in Postgres 18 for range queries that don't do aggregation on low-concurrency workloads. I have yet to explain that. /liliThe throughput for the scan microbenchma [...]

Monty Widenius 'heartbroken' at the extent of Oracle's MySQL job cuts (from The Register)

Original author of open source database 'not surprised' but 'saddened' as critics slam vendor's layoffs pOracle has instigated "widespread layoffs" across its core MySQL development team, sparking concern about the future of one of the world's most popular open-source databases.…/p [...]

In Depth MySQL Checks for HAProxy With Systemd Socket-Based Activation (from Continuent Blog)

Learn how to implement advanced MySQL health checks for HAProxy using systemd socket-based activation. Execute custom SQL queries for deeper database verification before routing traffic, replacing shallow TCP probes with intelligent failover decisions.Tags: haproxyMySQL health checkssystemd socket activationdatabase monitoringload balancer configuration [...]

Wednesday, 10. September 2025

Real-time analytics and simplified data pipelines with auto-refresh in MySQL HeatWave Lakehouse (from The Oracle MySQL Blog)

With automatic refresh of Lakehouse tables, MySQL HeatWave brings near real-time analytics and simplified data pipelines to data from object storage also. In this blog post we take a look at this feature, including setting it up, and its benefits. [...]

MariaDB Python Hackathon: Building Momentum with Quality Idea Submissions (from MariaDB Foundation Blog)

pThe MariaDB Python Hackathon is gaining impressive traction! Following our AMA session (Ask Me Anything) on Friday, September 5th, we’ve seen even more encouraging engagement. … /p pContinue reading \"MariaDB Python Hackathon: Building Momentum with Quality Idea Submissions\"/p pThe post MariaDB Python Hackathon: Building Momentum with Quality Idea Submissions appeared first on MariaDB [...]