Planet for the MySQL Community

Identifying Cacheable Queries: Using tools like pt-query-digest or the MySQL sys schema to pinpoint queries that would benefit from caching ^{(from Readyset Blog)}

IntroductionpIt’s common for DBAs to optimize queries to address bottlenecks and reduce resource contention. However, in production workloads, the most resource-intensive queries aren’t always the longest-running ones. High-frequency queries that execute quickly but are called repeatedly can collectively consume significant resources, increasing overall latency and/p [...]

Published Thursday, 29. May 2025 19:45 • 2 hours ago

Pegadaian boosts both efficiency and customer satisfaction using MySQL Enterprise Edition ^{(from The Oracle MySQL Blog)}

In an era where customer expectations are higher than ever, and businesses must adapt to ever-changing technological landscapes, Pegadaian’s choice to implement MySQL Enterprise Edition has proven to be a strategic move. By upgrading their database infrastructure, the company has enhanced its application quality, ensured reliability, and most importantly, continued to deliver the high level of serv [...]

Published Thursday, 29. May 2025 17:43 • 4 hours ago

Insignia Financial Uses MySQL Enterprise Edition to Improve Performance and Reduce Costs ^{(from The Oracle MySQL Blog)}

In today’s fast-paced financial environment, ensuring that core systems are secure, high-performing, and cost-effective is essential for maintaining a competitive edge. For Insignia Financial, upgrading to MySQL Enterprise Edition has not only addressed the challenges of database performance, security, and administrative overhead but has also provided substantial savings in licensing costs. Read th [...]

Published Thursday, 29. May 2025 17:17 • 4 hours ago

How to Safely Upgrade InnoDB Cluster From MySQL 8.0 to 8.4 ^{(from Percona Database Blog)}

♦In this blog, we continue from where we left off in the previous post, InnoDB Cluster Setup: Building a 3-Node High Availability Architecture, where we demonstrated how to set up a MySQL InnoDB Cluster with three nodes to achieve high availability. Here, we walk through the step-by-step process of performing a rolling upgrade of that […] [...]

Published Thursday, 29. May 2025 13:17 • 8 hours ago

Helsinki Python Hackathon – a role model for future MariaDB hackathons! ^{(from MariaDB Foundation Blog)}

pOne of the most fun and rewarding activities the past two-three months has been working with the participants in the Helsinki Python hackathon on MariaDB Vector. … /p pContinue reading \"Helsinki Python Hackathon – a role model for future MariaDB hackathons!\"/p pThe post Helsinki Python Hackathon – a role model for future MariaDB hackathons! appeared first on MariaDB.org./p [...]

Published Thursday, 29. May 2025 09:03 • 13 hours ago

Helsinki Python meetup with AI RAG and MariaDB Foundation ^{(from MariaDB Foundation Blog)}

pThe Helsinki Python meetup on Tuesday 27th May was hosted by MariaDB Foundation with nearly 100 participants of the 2600+ members of the Helsinki python meetup community. … /p pContinue reading \"Helsinki Python meetup with AI RAG and MariaDB Foundation\"/p pThe post Helsinki Python meetup with AI RAG and MariaDB Foundation appeared first on MariaDB.org./p [...]

Published Wednesday, 28. May 2025 07:57 • a day ago

Building Intelligent AI Agents: A New Data Application Paradigm with MCP and TiDB ^{(from PingCAP Blog)}

pWe’ve entered the Agentic AI Era—a new phase where large language models (LLMs) go beyond understanding instructions to actively making decisions and autonomously executing tasks. In this landscape, the ability to efficiently integrate LLMs with external systems, particularly databases, has become critical for building truly powerful AI applications. The Model Context Protocol (MCP) has emer [...]

Published Wednesday, 28. May 2025 07:56 • a day ago

What is a Vector in AI and RAG? ^{(from Programming Brain)}

What exactly is a Vector embedding in AI apps and how to use them in RAG architectures? [...]

Published Wednesday, 28. May 2025 07:38 • a day ago

Introducing Full-Text Search for TiDB: Enhancing RAG Applications with Hybrid Search ^{(from PingCAP Blog)}

pAt PingCAP, we strive to make TiDB your all-in-one AI database, capable of handling any workload seamlessly to fulfill the demand of the fast-evolving AI ecosystem. With vector search already available in TiDB, we are now excited to announce the native support for full-text search (beta) in TiDB Cloud Serverless clusters. Full-text search allows you […]/p pThe post Introducing Full-Text Sear [...]

Published Wednesday, 28. May 2025 07:14 • a day ago

Why Fresh Data, SQL, and Unified Platforms Are Your Competitive Edge for AI Applications ^{(from PingCAP Blog)}

pDelivering truly personalized AI experiences is complex. It requires Large Language Models (LLMs) to access relevant personal or organizational information and possess the intelligence to translate needs into tangible actions. This pursuit has been a key direction in GenAI application development. With foundational models like GPT-4o and DeepSeek-V2 becoming genuinely practical, their reasoning an [...]

Published Wednesday, 28. May 2025 05:46 • a day ago

MariaDB to Dolt Replication ^{(from DoltHub Blog)}

Dolt is the world's first and only version-controlled SQL database. It gives you the power of a SQL database to quickly and expressively… [...]

Published Wednesday, 28. May 2025 00:00 • 2 days ago

Troubleshooting Thread Contention in Apache Cassandra ^{(from MinervaDB Blog)}

pMastering Thread Contention in Apache Cassandra: A DBA’s Complete Guide As Cassandra DBAs, we’ve all been there—your cluster is running smoothly until suddenly latencies spike, CPU usage soars, but throughput plummets. Welcome to the world [...]/p pThe post Troubleshooting Thread Contention in Apache Cassandra appeared first on The WebScale Database Infrastructure Architecture, Enginee [...]

Published Tuesday, 27. May 2025 19:28 • 2 days ago

Amazon RDS for MySQL announces Extended Support minor 5.7.44-RDS.20250508 ^{(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.20250508. 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 [...]

Published Tuesday, 27. May 2025 17:00 • 2 days ago

The Best MySQL Active/Active Solution Gets Better! ^{(from Continuent Blog)}

Discover how Tungsten Cluster v8 builds on the already powerful v7, adding Kubernetes support, REST API v2, stronger security, and lots of enhancements to redefine MySQL clustering.Tags: MySQLactive/activetungsten clusterClusteringkubernetes [...]

Published Tuesday, 27. May 2025 15:56 • 2 days ago

AWS adds observability support to Aurora PostgreSQL Limitless ^{(from InfoWorld)}

pAmazon Web Services (AWS) has added observability support to its managed Aurora PostgreSQL Limitless service to help enterprises monitor the health of their database fleet and troubleshoot issues around it./p pObservability of databases is crucial for enterprise stakeholders, including DevOps engineers, application developers, and database administrators (DBAs), as it all [...]

Published Tuesday, 27. May 2025 11:19 • 2 days ago

Driving Real-Time Engineering Insights with MySQL Enterprise Edition: The Power Behind Nibana’s ESEC Platform ^{(from The Oracle MySQL Blog)}

ESEC leverages MySQL Enterprise Edition from Oracle to process millions of transactions in real-time, ensuring that stakeholders across the organization have access to accurate and timely insights. Whether it's a design consultancy firm managing a few hundred licenses or a multinational corporation tracking thousands of users working across the globe, ESEC scales to meet the complexity of diverse o [...]

Published Tuesday, 27. May 2025 02:46 • 3 days ago

Union Mobile Financial Technology Co., Ltd. (UMF) Chooses MySQL Enterprise Edition for its Mobile Financial Systems ^{(from The Oracle MySQL Blog)}

UMF’s choice of MySQL Enterprise Edition has proven to be a critical component in delivering secure, stable, and affordable mobile financial systems to their clients. From protecting sensitive customer data to ensuring system uptime and supporting cost-conscious businesses, MySQL continues to help UMF lead the way in the mobile financial technology space. For UMF, MySQL is not just a database solut [...]

Published Tuesday, 27. May 2025 02:01 • 3 days ago

Parkson Credit Levels Up Security with MySQL Enterprise Edition ^{(from The Oracle MySQL Blog)}

Parkson Credit’s selection of MySQL Enterprise Edition has allowed the company to significantly enhance its security, availability, and operational efficiency. The comprehensive suite of features, from enterprise encryption to high availability and disaster recovery, ensured that Parkson Credit not only met regulatory requirements but also provided a seamless and secure experience for their custome [...]

Published Tuesday, 27. May 2025 01:22 • 3 days ago

HeatWave REST Service - The Ultimate REST Builder for Databases, Now Available Everywhere ^{(from The Oracle MySQL Blog)}

We’re thrilled to announce the general availability of the HeatWave REST Service – a powerful, fully managed cloud service that lets you instantly create RESTful API endpoints directly from your HeatWave MySQL databases, without writing a single line of backend code. [...]

Published Monday, 26. May 2025 19:18 • 3 days ago

Comparing DevOps tooling approaches: Terraform, Ansible, Chef, Puppet, and DIY scripting ^{(from Severalnines Blog)}

pIn today’s DevOps landscape, Infrastructure as Code (IaC) tools like Terraform, Ansible, Chef, and Puppet have become essential for automating infrastructure provisioning and configuration, streamlining deployment processes, improving consistency, and enhancing scalability, especially in heterogenous, large-scale environments. While DIY (homegrown) scripts provide flexibility necessary to serve sp [...]

Published Monday, 26. May 2025 10:02 • 3 days ago

Reviewing the Internals of MariaDB’s Vector Index 2 ^{(from Zhao Song's Blog)}

[...]

Published Monday, 26. May 2025 00:00 • 4 days ago

The Round Table Expands: A Queen’s Reflections on Unity and Momentum ^{(from MariaDB Foundation Blog)}

pLegend says Queen Guinevere once presided over a court where knights debated honor and destiny. In my version, the knights bring code diffs, sponsorship agreements, and opinions on open source governance. … /p pContinue reading \"The Round Table Expands: A Queen’s Reflections on Unity and Momentum\"/p pThe post The Round Table Expands: A Queen’s Reflections on Unity and Momentum appeared fir [...]

Published Sunday, 25. May 2025 14:47 • 4 days ago

ACID at Scale: Why MySQL Needs a Distributed SQL Alternative ^{(from PingCAP Blog)}

pMySQL’s simplicity and robust single-instance ACID guarantees have made it a developer favorite for years. The familiar ease of use, quick installation, and a rich ecosystem contribute to its widespread adoption. InnoDB, its default storage engine, ensures Atomicity, Consistency, Isolation, and Durability (ACID), which are vital for data integrity and defined as follows: However, this [̷ [...]

Published Saturday, 24. May 2025 20:20 • 5 days ago

Ironclad Security for Your MySQL Databases ^{(from The Oracle MySQL Blog)}

Your MySQL databases are the backbone of your operations, housing invaluable and often sensitive information. But with increasing cyber threats and evolving regulatory landscapes, securing them can feel like an overwhelming challenge. Can you build a security program that's not just compliant, but truly resilient against the ever-present dangers of data breaches and cyberattacks? The good news is, [...]

Published Friday, 23. May 2025 16:22 • 6 days ago

What Oracle Missed, We Fixed: More Performant Query Processing in Percona Server for MySQL ^{(from Percona Database Blog)}

♦At Percona, we constantly search for ways to make query processing more performant. Our activities include continuous monitoring of Percona Server for MySQL performance by doing performance regression tests. We also challenge Percona Server for MySQL with newly designed tests and analyze bottlenecks for possible improvements. Among our activities in this area is monitoring what […] [...]

Published Friday, 23. May 2025 13:21 • 6 days ago

.NET Aspire update includes AI debugging via GitHub Copilot ^{(from InfoWorld)}

p.NET Aspire 9.3, the latest version of Microsoft’s cloud-ready stack for building distributed applications, has been released. The current update leverages GitHub Copilot as an AI debugging assistant./p pIntroduced May 19 and billed as a minor release, .NET Aspire 9.3 makes AI-based Copilot available in the Aspire dashboard. Copilot supercharges the dashboard’s OpenTeleme [...]

Published Friday, 23. May 2025 09:00 • 7 days ago

Scoped Vector Search with the MyVector Plugin for MySQL – Part I ^{(from AskDba)}

Semantic Search with SQL Simplicity and Operational Control Introduction Vector search is redefining how we work with unstructured and semantic data. Until recently, integrating it into traditional relational databases like MySQL required external services, extra infrastructure, or awkward workarounds. That changes with the MyVector plugin — a native vector indexing and search extension purpose-bui [...]

Published Friday, 23. May 2025 01:21 • 7 days ago

Amazon Aurora Global Database introduces support for up to 10 secondary Regions ^{(from AWS Database Blog)}

In this post, we dive deep into Amazon Aurora Global Database's new support for up to 10 secondary Regions and explore use cases it unlocks. An Aurora Global Database consists of one primary Region and up to 10 read-only secondary Regions for low-latency local reads. [...]

Published Thursday, 22. May 2025 22:58 • 7 days ago

MariaDB Community Server 11.4.7 and 10.11.13 releases ^{(from MariaDB Corporation Blog)}

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 11.4.7, and 10.11.13 maintenance releases. See the release […] [...]

Published Thursday, 22. May 2025 17:03 • 7 days ago

Amazon Aurora reduces cross-Region Global Database Switchover time to typically under 30 seconds ^{(from AWS What's New)}

pAmazon Aurora for MySQL and Amazon Aurora for PostgreSQL now offer faster Global Database cross-Region switchover, reducing recovery time for read/write operations to typically under 30 seconds and enhancing availability for applications operating at a global scale.br br With Global Database, a single Aurora cluster can span multiple AWS Regions, providing disaster recovery from Region-wide outage [...]

Published Thursday, 22. May 2025 17:00 • 7 days ago

Managing Resource Isolation: Optimizing Performance Stability in TiDB ^{(from PingCAP Blog)}

pIn complex business environments, resource isolation is critical to ensure stability, performance, and efficient resource utilization. TiDB offers robust features for resource control, allowing you to achieve efficient resource isolation across multiple levels: This blog focuses on best practices for flow-based resource isolation, helping you understand how to control and isolate workloads at runt [...]

Published Thursday, 22. May 2025 15:13 • 7 days ago

long_query_time for Optimal Query Monitoring ^{(from Shattered Silicon OSDB Blog)}

pProblem In order to facilitate query monitoring in MySQL and MariaDB, you have two options for sourcing the data: performance_schema slow_query_log performance_schema is cheap, but it lacks some of the important information. Specifically, it provides little or no visibility of any queries that run as prepared statements (unless they haven’t been torn down yet – […]/p pThe post lo [...]

Published Thursday, 22. May 2025 13:20 • 7 days ago

OS Platform End of Life (EOL) Announcement for Ubuntu 20.04 LTS ^{(from Percona Community Blog)}

pUbuntu 20.04 LTS (Focal Fossa) is scheduled to reach its official end of life on May 31, 2025. In alignment with the upstream vendor’s lifecycle, we are also ending platform support for Ubuntu 20.04 for all our MySQL related product offerings. This date and others are published in advance on our Percona Release Lifecycle Overview page./p pAs part of our support policy, Percona will continue [...]

Published Thursday, 22. May 2025 00:00 • 8 days ago

How to Convince Your DBA to Run Dolt ^{(from DoltHub Blog)}

So, you found this cool, new database with all the version control features of Git. It's got a funny name, Dolt. It looks like it fits your… [...]

Published Thursday, 22. May 2025 00:00 • 8 days ago

Azure Database for MySQL bindings for Azure Functions (General Availability) ^{(from Azure for MySQL Blog)}

pWe’re thrilled to announce the general availability (GA) of Azure Database for MySQL Input and Output bindings for Azure Functions—a powerful way to build event-driven, serverless applications that seamlessly integrate with your MySQL databases./p Key Capabilities pWith this GA release, your applications can use:/p ul liInput bindings that allow your function to retrieve data from a [...]

Published Wednesday, 21. May 2025 19:59 • 8 days ago

MySQL Hypergraph Optimizer ^{(from The Oracle MySQL Blog)}

Let's have a look at the new MySQL Optimizer: Hypergraph [...]

Published Wednesday, 21. May 2025 18:01 • 8 days ago

Amazon RDS now supports easy retrieval of engine lifecycle support dates ^{(from AWS What's New)}

pAmazon RDS announces a new capability that helps you view engine lifecycle support dates for your databases. This new feature provides a centralized and convenient place to access engine support dates, offering greater control over your database lifecycle management.br br You can view start and end dates for RDS Standard Support and RDS Extended Support for RDS and Aurora major engine versions thr [...]

Published Wednesday, 21. May 2025 17:00 • 8 days ago

MySQL Hypergraph Optimizer ^{(from lefred's blog)}

During the last MySQL & HeatWave Summit, Wim Coekaerts announced that a new optimizer is available and is already enabled in MySQL HeatWave. Let’s have a quick look at it and how to use it. The first step is to verify that Hypergraph is available: The statement won’t return any error if the Hypergraph Optimizer […] [...]

Published Wednesday, 21. May 2025 15:33 • 8 days ago

Evaluate MariaDB’s Powerful Database Proxy: Introducing MaxScale Trial ^{(from MariaDB Corporation Blog)}

[...]

Published Wednesday, 21. May 2025 14:34 • 8 days ago

MySQL Meetups and Events with 30 years of MySQL Celebration! ^{(from The Oracle MySQL Blog)}

meetups&events with 30Y ann.celebration [...]

Published Wednesday, 21. May 2025 13:45 • 8 days ago

Using dlt to get data from Db2 to PostgreSQL ^{(from dbi Blog)}

pFor a recent project at one of our customers we needed to get data from a Db2 database into PostgreSQL. The first solution we thought of was the foreign data wrapper for Db2. This is usually easy to setup and configure and all you need are the client libraries (for Db2 in this case). But […]/p pL’article Using dlt to get data from Db2 to PostgreSQL est apparu en premier sur dbi Blog./p [...]

Published Wednesday, 21. May 2025 11:34 • 8 days ago

Introducing Tungsten Dashboard v8: A New Era for MySQL Cluster Management ^{(from Continuent Blog)}

Discover Tungsten Dashboard v8, the next-gen UI for MySQL & MariaDB clusters. Featuring a new communication protocol, improved security, and user-friendly operation triggers. Learn how to upgrade and streamline your database infrastructure today!Tags: tungsten dashboardtungsten clusterdemogui [...]

Published Wednesday, 21. May 2025 08:07 • 9 days ago

Never-Down MySQL: A Blueprint for Uninterrupted Business Operations ^{(from The Oracle MySQL Blog)}

Uninterrupted IT is vital. MySQL Reference Architectures for High Availability offers blueprints to ensure your MySQL databases are always available, minimizing costly downtime. From Bronze to Platinum, these tiers provide tailored solutions for on-premises, cloud, or hybrid environments. [...]

Published Tuesday, 20. May 2025 18:57 • 9 days ago

Amazon RDS for MariaDB now supports community MariaDB minor versions 10.5.29 and 10.6.22 ^{(from AWS What's New)}

pAmazon Relational Database Service (Amazon RDS) for MariaDB now supports community MariaDB minor versions 10.5.29 and 10.6.22. We recommend that you upgrade to the latest minor versions to fix known security vulnerabilities in prior versions of MariaDB, and to benefit from the bug fixes, performance improvements, and new functionality added by the MariaDB community.br br You can leverage automatic [...]

Published Tuesday, 20. May 2025 17:00 • 9 days ago

Announcing key maintenance experience enhancements for Azure Database for MySQL ^{(from Azure for MySQL Blog)}

pWe are pleased to share a set of major enhancements to the maintenance experience for Azure Database for MySQL, designed to give customers more control, visibility, and predictability over how maintenance is orchestrated across their environments. These improvements are now available through the Azure Portal and are the direct result of feedback from users managing MySQL at scale./p Virtual Canary [...]

Published Tuesday, 20. May 2025 16:00 • 9 days ago

InnoDB Cluster: Set Up Router and Validate Failover ^{(from Percona Database Blog)}

♦Setting up an InnoDB Cluster requires three key components: Group Replication, MySQL Shell, and MySQL Router. In the previous post, we covered the process of building a 3-node InnoDB Cluster. In this post, we shift our focus to configuring MySQL Router and validating failover functionality. Environment overview We are using three InnoDB Cluster nodes along […] [...]

Published Tuesday, 20. May 2025 15:35 • 9 days ago

Ten Years On, We Set Off Again: My Journey with TiDB ^{(from PingCAP Blog)}

pFrom day one, PingCAP has been a company built by and for builders. In this special 10-year reflection, our very first employee and SVP of Product & Engineering shares the raw, unfiltered journey behind TiDB—from the first lines of Go code to running mission-critical workloads across the globe. We hope this inspires the next generation […]/p pThe post Ten Years On, We Set Off Again: My J [...]

Published Tuesday, 20. May 2025 02:23 • 10 days ago

Vault Works with Dolt ^{(from DoltHub Blog)}

At DoltHub, we're building Dolt, the world's first fully version controlled SQL database. It's a MySQL compatible SQL database that supports… [...]

Published Tuesday, 20. May 2025 00:00 • 10 days ago

Must-read MySQL blog posts from ACEs ^{(from Oracle ACE Program)}

In April, Oracle ACEs from all around the world created more than 600 blog posts and articles, sharing tips and tricks, insights, and knowledge on various platforms. We have highlighted some of them for you to read and enjoy, focusing on MySQL. [...]

Published Monday, 19. May 2025 17:49 • 10 days ago

An Introduction to Dictionary Operations in Data Masking Component ^{(from Percona Database Blog)}

♦In this blog post, we will describe typical usage scenarios for dictionary operations in the Data Masking Component, which is available in Percona Server for MySQL as an open source alternative to Oracle’s enterprise version. In particular, we will consider the following functions. gen_dictionary() – a function that returns a random term from a dictionary. gen_blocklist() – […] [...]

Published Monday, 19. May 2025 13:39 • 10 days ago

MEM is dead, long live Oracle Database Management ^{(from lefred's blog)}

MySQL Enterprise Monitor, aka MEM, retired in January 2025, after almost 20 years of exemplary service! What’s next? Of course, plenty of alternatives exist, open source, proprietary, and on the cloud. For MySQL customers, we provide two alternatives: This post focuses on the latter, as there is no apparent reason to deploy an Oracle Database […] [...]

Published Monday, 19. May 2025 09:11 • 11 days ago

Releasing MariaDB for Universities: Lecture Materials for a New Generation ^{(from MariaDB Foundation Blog)}

pWe have long had a vision: that learning relational databases with MariaDB should be accessible to everyone — students, educators, and self-learners alike. Today, MariaDB Foundation and MariaDB plc together take a major step forward in realizing that vision. … /p pContinue reading \"Releasing MariaDB for Universities: Lecture Materials for a New Generation\"/p pThe post Releasing Maria [...]

Published Monday, 19. May 2025 08:25 • 11 days ago

MEM is dead, long live Oracle Database Management ^{(from The Oracle MySQL Blog)}

In this post, we will see how to use Oracle DB Management to monitor an on-premise MySQL instance. [...]

Published Monday, 19. May 2025 08:24 • 11 days ago

Build 2025: Announcing Key Improvements in Azure Database for MySQL ^{(from Azure for MySQL Blog)}

pToday, we're announcing a series of updates to Azure Database for MySQL designed to improve failover performance, operational visibility, and version support for developers and DBAs. These enhancements help you build more resilient applications, manage maintenance with greater control, and stay current with the latest MySQL releases. /p p /p pEnhanced failover performance with High-Avail [...]

Published Monday, 19. May 2025 05:30 • 11 days ago

Percona Bug Report: April 2025 ^{(from Percona Community Blog)}

pAt Percona, we operate on the premise that full transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form, report back on any issues or bugs you might encounter along the way./p pWe constantly update our bug reports and monitor other boards [...]

Published Monday, 19. May 2025 00:00 • 11 days ago

is SQL a high level API ^{(from The consistent voice)}

pSQL stands for Structured Query Language, a declarative, standardized programming language (Turing complete, by the way) specifically designed to manage and manipulate data stored in relational databases./ppAPIs, or Application Programming Interfaces, are sets of rules, protocols, and tools that enable software systems to exchange data and functionality without exposing the internal workings of ea [...]

Published Sunday, 18. May 2025 16:37 • 11 days ago

RocksDB 10.2 benchmarks: large & small servers with a cached workload ^{(from Small Datum)}

pI previously shared benchmark results for RocksDB using the larger server that I have. In this post I share more results from two other large servers and one small server. This is arbitrary but I mean >= 20 cores for large, 10 to 19 cores for medium and less than 10 cores for small./pptl;dr/pulliThere are several big improvements/liliThere might be small regression in fillseq performance, I wil [...]

Published Sunday, 18. May 2025 15:58 • 11 days ago | Updated Sunday, 18. May 2025 16:02 • 11 days ago

Building and testing MySQL 8.0.42 / 8.4.5 / 9.3.0 on macOS ^{(from Laurynas Biveinis' blog)}

p Previously: 8.0.41 / 8.4.4 / 9.2.0 /p p MySQL 8.0.42 / 8.4.5 / 9.3.0 are out, and as usual, I have built and tested the new releases on macOS, due to its popularity as the server OS, of course. /p Build p The 8.0 series don't build with the current XCode clang because of bug 118026 (Build failed with apple clang 17). That's inconvenient, but Homebrew-packaged LLVM clang versions 14 to 18 buil [...]

Published Friday, 16. May 2025 12:46 • 13 days ago | Updated Friday, 16. May 2025 12:46 • 13 days ago

New Silver Sponsor: Senticore Technologies Chooses MariaDB for High-Performance Engineering and AI Applications ^{(from MariaDB Foundation Blog)}

pWe welcome Senticore Technologies as a Silver Sponsor. Senticore, a leader in engineering and manufacturing applications, focuses on cutting-edge AI solutions, particularly for the aerospace and defense sectors, and powers critical systems worldwide. … /p pContinue reading \"New Silver Sponsor: Senticore Technologies Chooses MariaDB for High-Performance Engineering and AI Applications\"/p pT [...]

Published Friday, 16. May 2025 08:59 • 14 days ago

ClusterControl adds Kubernetes Database Operator management in v2.3.2 ^{(from Severalnines Blog)}

pClusterControl v2.3.2 is here and is taking its first sincere step into the cloud native world with its Kubernetes operator management panelTech Preview and support for PostgreSQL’s cloudnative-pg and MySQL’s MOCO operators. It also comes with new major versions for PG and MySQL, as well as a new metrics watchlist mode for improved situational awareness! […]/p pThe post ClusterControl adds K [...]

Published Friday, 16. May 2025 07:00 • 14 days ago

Let Your Database Recommend the Indexes: Smarter Tuning in TiDB ^{(from PingCAP Blog)}

pIndex tuning has always been one of the most effective ways to speed up database queries—but it’s also one of the most time-consuming and complex. When we first introduced the TiDB Index Advisor as a command-line tool in a previous blog, our goal was to simplify index selection for real-world workloads. Now, with TiDB 8.5, […]/p pThe post Let Your Database Recommend the Indexes: Smarter Tuni [...]

Published Thursday, 15. May 2025 14:49 • 14 days ago

New in Percona Everest 1.6.0: Easily Deploy PMM with a Single Helm Command ^{(from Percona Database Blog)}

♦Monitoring your databases is critical, especially in Kubernetes environments where visibility and automation are key. That’s why, in Percona Everest 1.6.0, we introduced a highly requested feature: the ability to automatically deploy Percona Monitoring and Management (PMM) as part of the Everest Helm chart using just one flag. This simplifies the process for teams who […] [...]

Published Thursday, 15. May 2025 13:59 • 14 days ago

Learn MySQL Performance ^{(from Hack MySQL)}

pEvery year new cohorts of programmers, DBAs, managers, and more learn MySQL. After MySQL and HeatWave Summit 2025 a few weeks ago, I realized what job needs to be done for these people and how I could help them make progress: revamping this website to focus on “the path”./p [...]

Published Thursday, 15. May 2025 13:47 • 14 days ago

A quick look at MySQL EE, free for developers ^{(from lefred's blog)}

MySQL provides the MySQL Community Edition, the Open-Source version. In addition, there is the Enterprise Edition for our Commercial customers and MySQL HeatWave, our managed database service (DBaaS) on the cloud (OCI, AWS, etc.). But do you know developers can freely use MySQL Enterprise for non-commercial use? The full range of MySQL Enterprise Edition features […] [...]

Published Thursday, 15. May 2025 12:21 • 14 days ago

Our pledge to help improve the accessibility of open source software at scale ^{(from The GitHub Blog)}

pGitHub takes the Global Accessibility Awareness Day (GAAD) pledge./p pThe post Our pledge to help improve the accessibility of open source software at scale appeared first on The GitHub Blog./p [...]

Published Thursday, 15. May 2025 08:00 • 15 days ago

Creating a Highly Available HeatWave Database System Using Oracle Cloud Shell ^{(from The Oracle MySQL Blog)}

In this blog, we will walk through the process of creating a HeatWave HA Database system using Oracle Cloud Shell. [...]

Published Thursday, 15. May 2025 05:30 • 15 days ago

MySQL Query Optimization: Best Practices to Improve Performance ^{(from Releem Blog)}

Nothing kills a great app faster than slow database queries. Teams often optimize everything else – frontend code, server architecture, caching layers – only to discover their database queries are the actual bottleneck. Your users won't notice all the cle [...]

Published Wednesday, 14. May 2025 23:45 • 15 days ago

Comprehensive Guide to MySQL Full-Text Indexing: Examples, Creation, and Performance Optimization ^{(from Releem Blog)}

Text search in MySQL doesn't have to be inefficient. MySQL's full-text indexing transforms how your applications find and handle large volumes of unstructured text. Instead of the glacial pace of LIKE queries scanning every character, you get a search sys [...]

Published Wednesday, 14. May 2025 22:45 • 15 days ago

Understanding and Inspecting Indexes in MySQL: A Comprehensive Guide ^{(from Releem Blog)}

An index helps MySQL find the data it needs without scanning an entire table. For a handful of rows, this might not seem important. But in a table with hundreds of thousands or millions of rows, the difference between having a lookup structure and lacking [...]

Published Wednesday, 14. May 2025 21:35 • 15 days ago

Amazon Aurora MySQL 3.09 (compatible with MySQL 8.0.40) is now generally available ^{(from AWS What's New)}

pStarting today, Amazon Aurora MySQL - Compatible Edition 3 (with MySQL 8.0 compatibility) will support MySQL 8.0.40 through Aurora MySQL v3.09. In addition to several security enhancements and bug fixes, MySQL 8.0.40 contains enhancements that improve database availability when handling large number of tables and reduce InnoDB issues related to redo logging, and index handling.br br Aurora MySQL 3 [...]

Published Wednesday, 14. May 2025 18:40 • 15 days ago

Amazon Aurora and RDS for PostgreSQL, MySQL, and MariaDB now offer Reserved Instances for R8g and M8g instances ^{(from AWS What's New)}

pCustomers running Amazon Aurora and RDS for PostgreSQL, MySQL, and MariaDB databases can now purchase Reserved Instances for Graviton4-based R8g and M8g instances. These instances provide larger sizes up to 48xlarge with an 8:1 ratio of memory to vCPU and the latest DDR5 memory. Graviton4-based instances deliver up to 40% performance improvement and 29% better price-performance compared to equival [...]

Published Wednesday, 14. May 2025 17:00 • 15 days ago

Amazon Aurora and RDS for PostgreSQL, MySQL, and MariaDB now offer Reserved Instances for R7i and M7i instances ^{(from AWS What's New)}

pCustomers running Amazon Aurora and RDS for PostgreSQL, MySQL, and MariaDB databases can now purchase Reserved Instances for R7i and M7i instances. These instances are powered by custom 4th Generation Intel Xeon Scalable processors and provide larger sizes up to 48xlarge with an 8:1 ratio of memory to vCPU and the latest DDR5 memory.br br Reserved Instances offer significant savings over On-Demand [...]

Published Wednesday, 14. May 2025 17:00 • 15 days ago

Scaling Amazon RDS for MySQL performance for Careem’s digital platform on AWS ^{(from AWS Database Blog)}

Careem powers rides, deliveries, and payments across the Middle East, North Africa and South Asia. As Careem grew, so did its data infrastructure challenges. Their monolithic 270 TB Amazon RDS for MySQL database consisting of one writer and five read replicas— experienced performance issues due to increased storage utilization, slow queries, high replica lag, and increased Amazon RDS cost. In this [...]

Published Tuesday, 13. May 2025 23:14 • 16 days ago

Amazon CloudWatch Database Insights applied in real scenarios ^{(from AWS Database Blog)}

In this post, we show how you can use Amazon CloudWatch Database Insights for troubleshooting your Amazon RDS and Amazon Aurora resources. CloudWatch Database Insights serves as a database observability solution offering a tailored experience for DevOps engineers, application developers, and database administrators. This tool is designed to accelerate database troubleshooting processes and address [...]

Published Tuesday, 13. May 2025 17:26 • 16 days ago

A Brief History of MySQL Replication ^{(from Marcelo Altmann)}

pWhile preparing slides for a presentation, I found myself researching about the history of MySQL Replication and decided to write some key moments of this wonderful functionality of MySQL./p♦pReplication has been one of MySQL’s most powerful and relied-upon features since the early days — long before it had things like foreign keys or even subqueries. It’s one of the foundational pillars that made [...]

Published Tuesday, 13. May 2025 16:22 • 16 days ago

Oracle Dev Days 2025 – French Edition ^{(from MySQL expert Diary)}

pJoin the Oracle Dev Days – French Edition, from May 20 to 22, 2025!br This must-attend event (in French) offers a rich program exploring the latest advancements in AI, databases, cloud, and Java./p pJoin me on May 21 at 2:00 PM for the day dedicated to “Database & AI.” I’ll be presenting “Building an AI-Powered Search Engine with HeatWave GenAI.” I’ll show you how to go beyond the limits of t [...]

Published Tuesday, 13. May 2025 15:43 • 16 days ago

Secure Architectures for MariaDB and Galera in AWS: VPCs and Security Groups ^{(from Vettabase)}

Running any production database deployment in the cloud requires careful consideration of both performance and security. In this article, I’ll share a battle-tested approach for deploying a MariaDB Galera cluster with replicas, a ProxySQL layer in front of them, and monitoring for all these technologies via PMM. The focus will be on building solid security boundaries. Security Requirements We [...]

Published Tuesday, 13. May 2025 11:26 • 16 days ago

MariaDB Vector is available on OPEA ^{(from MariaDB Foundation Blog)}

pI think you’ve come to expect that every collaboration with Intel leads to meaningful, well-executed projects that bring great value to the community. This time, we’re spreading our wings towards empowering enterprises to deploy AI solutions, and we’re excited to show how MariaDB Vector fits into the Open Platform for Enterprise AI (OPEA). … /p pContinue reading \"MariaDB V [...]

Published Tuesday, 13. May 2025 10:59 • 16 days ago

MySQL Cookbook: Solutions for Database Developers and Administrators ^{(from ODBMS.org)}

Authors: Sveta Smirnova (Author), Alkin Tezuysal (Author) For MySQL, the price of popularity comes with a flood of questions from users on how to solve specific data-related issues. That’s where this cookbook comes in. When... [...]

Published Tuesday, 13. May 2025 05:15 • 17 days ago

MySQL: FLUSH HOSTS ^{(from Die wunderbare Welt von Isotopp)}

pSometimes, MySQL throws an error like this:/p blockquote pHost ‘…’ is blocked because of many connection errors/p pUnblock with ‘mysqladmin flush-hosts’/p/blockquote pThis typically means that MySQL has blocked a host after too many connection errors. The usual fix is to run:/p precodemysqladmin flush-hosts /code/prepor/p precodemysql> FLUSH HOSTS; /* deprecated s [...]

Published Tuesday, 13. May 2025 05:06 • 17 days ago

SHOW statements in Doltgres ^{(from DoltHub Blog)}

Last month we announced the Beta release of Doltgres, the world's first and only version-controlled postgres-compatible SQL database. We're… [...]

Published Tuesday, 13. May 2025 00:00 • 17 days ago

Request for comments: Skeema v2 roadmap ^{(from Skeema Blog)}

pDevelopment of Skeema v2 is now underway, with a release target of later this year. We’re excited to share an overview of the potential changes, and would love to hear your feedback./p [...]

Published Monday, 12. May 2025 20:29 • 17 days ago

MySQL Query Optimization with Releem ^{(from Vlad Mihalcea's Blog)}

pIntroduction In this article, I’m going to show you how to optimize the queries executed by a Spring application running on MySQL using Releem. For a short introduction about Releem, check out this previous article, in which I explained how to set up Releem to collect metrics from your MySQL database. Spring Petclinic application The application under test is going to be the well-known Sprin [...]

Published Monday, 12. May 2025 18:46 • 17 days ago

Amazon RDS for MySQL now supports new minor versions 8.0.42 and 8.4.5 ^{(from AWS What's New)}

pAmazon Relational Database Service (Amazon RDS) for MySQL now supports MySQL minor versions 8.0.42 and 8.4.5, the latest minors released by the MySQL community. We recommend upgrading to the newer minor versions to fix known security vulnerabilities in prior versions of MySQL and to benefit from bug fixes, performance improvements, and new functionality added by the MySQL community. Learn more abo [...]

Published Monday, 12. May 2025 17:00 • 17 days ago

Update on MariaDB Community Server Q2 2025 maintenance releases ^{(from MariaDB Corporation Blog)}

[...]

Published Monday, 12. May 2025 15:31 • 17 days ago

InnoDB Cluster Setup: Building a 3-Node High Availability Architecture ^{(from Percona Database Blog)}

♦Modern applications need to be highly available and easy to scale. A three-node MySQL InnoDB Cluster—built on MySQL Group Replication and connected through MySQL Router—provides a reliable way to support critical workloads. To set up this architecture, you start by deploying three MySQL server instances. In this example, the nodes are assigned the following hostname-to-IP […] [...]

Published Monday, 12. May 2025 14:11 • 17 days ago

What GenAI Means for Your Application Data Architecture ^{(from PingCAP Blog)}

pGenerative AI (GenAI) is finding its way into almost every kind of software — and for good reason. It offers a chance to create more valuable, intelligent experiences for users, while strengthening the moat around your product’s data and capabilities. But adding GenAI features, whether to an existing system or a new project, often means […]/p pThe post What GenAI Means for Your Application D [...]

Published Monday, 12. May 2025 09:12 • 18 days ago

Improve Primary Selection on Failover in MySQL Group Replication ^{(from The Oracle MySQL Blog)}

The latest update to MySQL Enterprise Edition, version 9.3, introduces a significant enhancement focused on improving primary selection on failover. This update includes an improvement to Group Replication primary failover, providing users with a better selection method of a new primary based on the member's most current data. This enhancement results in a seamless experience during failover, maint [...]

Published Monday, 12. May 2025 09:00 • 18 days ago

MySQL at 30: Still important but no longer king ^{(from InfoWorld)}

pThis month MySQL turns 30. Once the bedrock of web development, MySQL remains immensely popular. But as MySQL enters its fourth decade, it ironically has sown the seeds of its own decline, especially relative to Postgres. Oracle, the steward over MySQL since 2010, may proclaim MySQL is “the world’s favorite database,” but that has been objectively false for a long time, as s [...]

Published Monday, 12. May 2025 09:00 • 18 days ago

Optimize Database Performance with HeatWave's Enhanced Read Operations ^{(from The Oracle MySQL Blog)}

Managing read traffic efficiently is crucial for maintaining a high-performing database. With Read Endpoints playing a critical role in directing read traffic, having a flexible, configurable and scalable Read Endpoint solution is a must for ensuring high availability and performance in the DB system, or simplifying application configurations. [...]

Published Monday, 12. May 2025 07:17 • 18 days ago

Without Good Data, AI is Useless ^{(from The Oracle MySQL Blog)}

When training AI models, it is important to use "good" data. Without good data, the model si pretty much useless. In this post, I share what I learned when trying to train an AI model for use in Episode 89 of MySQL Shorts. [...]

Published Monday, 12. May 2025 04:00 • 18 days ago

Anomaly Detection with HeatWave AutoML ^{(from The Oracle MySQL Blog)}

Anomaly detection is an effective technique for finding abnormalities in data. HeatWave AutoML offers an automated machine learning pipeline for anomaly detection based on patented algorithm that can detect various types of anomalies and provides better accuracy compared to other anomaly detection techniques. It also supports semi-supervised learning, Principal Component Analysis (PCA) and internal [...]

Published Sunday, 11. May 2025 23:52 • 18 days ago

Floating-Point Columns and AUTO_INCREMENT Changes in MySQL 8 ^{(from Mydbops Blog)}

Learn why MySQL 8.4 has deprecated AUTO_INCREMENT with FLOAT, DOUBLE, and DECIMAL columns. Understand the risks, migration steps, and best practices for maintaining data integrity. [...]

Published Saturday, 10. May 2025 10:07 • 19 days ago

Reviewing the Internals of MariaDB’s Vector Index ^{(from Zhao Song's Blog)}

1. How It’s implemented [...]

Published Saturday, 10. May 2025 00:00 • 20 days ago

Choosing The Correct Shape When Migrating MySQL From On-Premise to HeatWave in OCI ^{(from The Oracle MySQL Blog)}

This post provides information on how to choose the appropriate shape when migrating your MySQL workload from on-premise to HeatWave (MySQL) in Oracle Cloud Infrastructure. The post also provides some additional information for a successful migration. [...]

Published Friday, 09. May 2025 15:29 • 20 days ago

MySQL 9.3! Thank you for your contributions! ^{(from The Oracle MySQL Blog)}

Before the MySQL & HeatWave Summit, we released MySQL 9.3, the latest Innovation Release. The event was terrific, and I had the chance to meet some of the MySQL contributors. As usual, we released bug fixes for 8.0 and 8.4 LTS, but I focus on the newest release in this post. [...]

Published Friday, 09. May 2025 13:11 • 20 days ago

MySQL 9.3! Thank you for your contributions! ^{(from lefred's blog)}

Before the MySQL & HeatWave Summit, we released MySQL 9.3, the latest Innovation Release. The event was terrific, and I had the chance to meet some of the MySQL contributors. As usual, we released bug fixes for 8.0 and 8.4 LTS, but I focus on the newest release in this post.We included patches and code […] [...]

Published Friday, 09. May 2025 13:10 • 20 days ago

Impressive Submissions at the MariaDB AI RAG Hackathon ^{(from MariaDB Foundation Blog)}

pOn Monday we had our final submission day for the MariaDB AI RAG Hackathon. We got several high quality replies in both tracks: integration and innovation. … /p pContinue reading \"Impressive Submissions at the MariaDB AI RAG Hackathon\"/p pThe post Impressive Submissions at the MariaDB AI RAG Hackathon appeared first on MariaDB.org./p [...]

Published Friday, 09. May 2025 12:18 • 20 days ago

Improving Semi-join Performance in MySQL ^{(from The Oracle MySQL Blog)}

This blog post describes the latest performance improvement in semi-join / anti-join queries. [...]

Published Friday, 09. May 2025 08:42 • 21 days ago

Password Management in MySQL 8: Switching Between Authentication Plugins ^{(from Mydbops Blog)}

Explore MySQL 8.4 authentication with caching_sha2_password, covering caching, fast and full authentication to boost security and performance. [...]

Published Friday, 09. May 2025 04:50 • 21 days ago

Generating Golang Source Files at Build-Time with go:generate ^{(from DoltHub Blog)}

If you want to start a shouting match over Thanksgiving dinner, try asking your drunk uncle if generating source code from templates is a… [...]

Published Friday, 09. May 2025 00:00 • 21 days ago

Handling duplicate rows in MariaDB and MySQL ^{(from Vettabase)}

Most tables have a concept of “duplicate rows”, where duplicates should never be allowed. Typical examples are: But should happen when the application tries to insert a duplicate? This depends from case to case. The possible effects are the following: Let’s see how to handle each of these cases in SQL, in a simple way, without re-inventing the wheel. You will save yourself some us [...]

Published Thursday, 08. May 2025 16:48 • 21 days ago

Deploying External Read Replica in MySQL InnoDB Cluster ^{(from Percona Database Blog)}

♦Innodb Cluster or ClusterSet topologies already have secondary instances that can act as a failover for primary or also offload read requests. However, with MySQL 8.4, we now have the feasibility of adding a separate async replica to the cluster for serving various special/ad-hoc queries or some reporting purposes. This will also help offload read traffic away […] [...]

Published Thursday, 08. May 2025 12:52 • 21 days ago

Enhance Data Protection in HeatWave ^{(from The Oracle MySQL Blog)}

This blog describes two new properties of a HeatWave MySQL database system (DB system) on OCI: database and access mode. These DB system properties can be used to update the DB system read-write setting and restrict access only to administrator accounts. [...]

Published Thursday, 08. May 2025 11:36 • 21 days ago

Making it Easy to Load and Query CSV Files with HeatWave Lakehouse ^{(from The Oracle MySQL Blog)}

In this blog we will see how HeatWave Lakehouse automates the detection of dialects when loading CSV (Comma Separated Value) files from object storage. [...]

Published Thursday, 08. May 2025 04:08 • 22 days ago

AI Features Available in HeatWave Always Free Tier ^{(from The Oracle MySQL Blog)}

HeatWave offers a variety of AI features - and many of these features are available in the Always Freed tier. In this post we discuss some of the performance differences when training an AI model and doing predictive analysis. [...]

Published Thursday, 08. May 2025 04:00 • 22 days ago

Amazon’s AI-agents for MariaDB Contributions ^{(from MariaDB Foundation Blog)}

pWe at MariaDB Foundation are thrilled to see Amazon at the forefront of applying artificial intelligence to open source contributions — with MariaDB as their pilot. … /p pContinue reading \"Amazon’s AI-agents for MariaDB Contributions\"/p pThe post Amazon’s AI-agents for MariaDB Contributions appeared first on MariaDB.org./p [...]

Published Wednesday, 07. May 2025 14:18 • 22 days ago

MySQL Routing Guidelines: A Practical Guide to Management and Configuration ^{(from The Oracle MySQL Blog)}

Learn how to configure and manage MySQL Routing Guidelines using MySQL Shell's AdminAPI, with step-by-step examples for InnoDB Cluster, ClusterSet, and ReplicaSet - Enabling smarter and more dynamic query routing. [...]

Published Wednesday, 07. May 2025 13:00 • 22 days ago

Open Source Performance, Benchmarks and MariaDB: A Conversation with Steve Shaw ^{(from MariaDB Foundation Blog)}

pRight after the recent MariaDB Meetup in London, I had the pleasure of sitting down with Steve Shaw – founder and CEO of HammerDB, former Principal Engineer at Intel, and board member of the MariaDB Foundation. … /p pContinue reading \"Open Source Performance, Benchmarks and MariaDB: A Conversation with Steve Shaw\"/p pThe post Open Source Performance, Benchmarks and MariaDB: A Convers [...]

Published Wednesday, 07. May 2025 05:51 • 23 days ago

RocksDB 10.2 benchmarks: large server ^{(from Small Datum)}

p This post has benchmark results for RocksDB 10.x, 9.x, 8.11, 7.10 and 6.29 on a large server./pp\tl;dr/pp/pulliThere are several big improvements/liliThere are no new regressions/liliFor the block cache hyperclock does much better than LRU on CPU-bound tests/li/ulp/pSoftwarepI used RocksDB versions 6.0.2, 6.29.5, 7.10.2, 8.11.4, 9.0.1, 9.1.2, 9.2.2, 9.3.2, 9.4.1, 9.5.2, 9.6.2, 9.7.4, 9.8.4, [...]

Published Wednesday, 07. May 2025 00:20 • 23 days ago | Updated Wednesday, 07. May 2025 00:20 • 23 days ago

RocksDB on a big server: LRU vs hyperclock, v2 ^{(from Small Datum)}

pThis post shows that RocksDB has gotten much faster over time for the read-heavy benchmarks that I use. I recently shared results from a large server to show the speedup from the hyperclock block cache implementation for different concurrency levels with RocksDB 9.6. Here I share results from the same server and different (old and new) RocksDB releases./ppResults are amazing on a large (48 cores) [...]

Published Saturday, 30. November 2024 01:54 • 6 months ago | Updated Tuesday, 06. May 2025 22:41 • 23 days ago

MariaDB Community Server Q2 2025 maintenance releases ^{(from MariaDB Corporation Blog)}

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 11.4.6, 10.11.12, 10.6.22, and 10.5.29 maintenance releases. See […] [...]

Published Tuesday, 06. May 2025 19:06 • 23 days ago

From User to Contributor: Fixing and Enhancing MySQL Tools ^{(from Marcelo Altmann)}

pWorking with open source tools is always a rewarding experience. You can dig into the source code to understand how things work or troubleshoot issues as they come up. And when you do, there’s a great opportunity to give back — whether by fixing a bug or adding a new feature./p♦pAt Readyset, which is fully written in Rust, we make heavy use of the MySQL Rust driver. Since we benefit from these ope [...]

Published Tuesday, 06. May 2025 15:47 • 23 days ago

Tungsten Cluster v8: Expanding Enterprise-Grade MySQL High Availability with Powerful New Features and Tools ^{(from Continuent Blog)}

New release includes nearly 30 new features, enhanced API support and advanced performance optimizations.Tags: tungsten clusterReleasefeaturesbug fixesimprovements [...]

Published Tuesday, 06. May 2025 12:50 • 23 days ago

Ignite 2024: New innovations in Azure Database for MySQL ^{(from Azure for MySQL Blog)}

pThe Azure Database for MySQL team is thrilled to unveil a suite of new features and innovations that are designed to empower both developers and enterprise organizations with the ability to get more out of their data with robust performance and efficiency, advanced security, and greater scalability for their applications./p pWhether you're looking to leverage cutting-edge innovations, accelerate t [...]

Published Tuesday, 06. May 2025 06:14 • 24 days ago

April Product Update ^{(from Readyset Blog)}

Readyset's February update: Grupo Ótima Digital cuts MySQL load by 30%, a new CYBERTEC partnership, product updates, FOSDEM highlights, and more! 🚀 [...]

Published Monday, 05. May 2025 20:00 • 24 days ago

AWS DMS implementation guide: Building resilient database migrations through testing, monitoring, and SOPs ^{(from AWS Database Blog)}

In this post, we present proactive measures for optimizing AWS DMS implementations from the initial setup phase. By using strategic planning and architectural foresight, organizations can enhance their replication system’s reliability, improve performance, and avoid common pitfalls. [...]

Published Monday, 05. May 2025 16:12 • 24 days ago

Database Protection Guide: Best Practices for Ensuring Database Security ^{(from Devart MySQL Tool Blog)}

pDatabase security is essential for protecting sensitive information. Get key tips on best practices, managing threats, and ensuring privacy. /p pThe post Database Protection Guide: Best Practices for Ensuring Database Security appeared first on Devart Blog./p [...]

Published Monday, 05. May 2025 13:40 • 24 days ago

How MCP could add value to MongoDB databases ^{(from InfoWorld)}

pMongoDB has added Anthropic’s Model Context Protocol (MCP) to all its databases, including Atlas, to help developers accelerate software development and manage database administrative tasks./p pMCP, which has seen a rise in popularity since its release in November last year, is an open protocol that allows AI agents inside applications to access external tools and data to [...]

Published Monday, 05. May 2025 11:59 • 24 days ago

Database Normalization in SQL: Key Steps, Benefits, and Examples ^{(from Devart MySQL Tool Blog)}

pLearn the importance of database normalization, its benefits, and key techniques. Understand SQL normalization and improve your database design./p pThe post Database Normalization in SQL: Key Steps, Benefits, and Examples appeared first on Devart Blog./p [...]

Published Monday, 05. May 2025 10:51 • 24 days ago

Uncle bob vs SQL ^{(from The consistent voice)}

pI came across this umpteenth release from Uncle Bob Martin today: x.com/unclebobmartin/status/1917558113177108537/ppIn his codex of clean architecture, UIs and DBs are plugins that should be interchangeable. Yet now he’s ranting about SQL and RDBMS and talking about using low-level functions to process data. This makes no sense in terms of his architectural ideology, because what is SQL apart from [...]

Published Saturday, 03. May 2025 04:35 • 27 days ago

Scaling 3 Million Tables: How TiDB Powers Atlassian Forge’s SaaS Platform ^{(from PingCAP Blog)}

pAtlassian, a global leader in project management and team collaboration, offers widely adopted products like Jira, Confluence, and Forge. As Atlassian’s SaaS platforms scale, so too do their data infrastructure needs, such as scaling millions of database tables efficiently and cost-effectively. That’s where TiDB comes in. This post explores how TiDB empowers Atlassian’s Forge platform [̷ [...]

Published Friday, 02. May 2025 17:54 • 27 days ago

Amazon Aurora now supports R8g database instances in the AWS GovCloud (US-West) Region ^{(from AWS What's New)}

pAWS Graviton4-based R8g database instances are now generally available for Amazon Aurora with PostgreSQL compatibility and Amazon Aurora with MySQL compatibility in the AWS GovCloud (US-West) Region. R8g instances offer larger instance sizes, up to 48xlarge and features an 8:1 ratio of memory to vCPU, and the latest DDR5 memory. Graviton4-based instances provide up to a 40% performance improvement [...]