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.

Monday, 02. December 2024

November Product Update (from Readyset Blog)

♦p👋 Hello December! Hope everyone had a great November and for those who celebrated, a wonderful Thanksgiving. brbrBefore we dive in, a quick note: our VP of Product, Tanmay Sinha, and I are currently at AWS re:Invent and would love to connect with you! If you’re/p [...]

Percona Monitoring and Management 3.0.0-Beta - Tech Preview (from Percona Community Blog)

Percona Monitoring and Management 3.0.0 Beta - Tech Preview We’re excited to announce the Tech Preview (Beta) release of Percona Monitoring and Management (PMM) 3.0.0-Beta. This release is intended for testing environments only, as it’s not yet production-ready. The GA (General Availability) release will be available through standard channels in the upcoming months. Release notes To see [...]

Sunday, 01. December 2024

MySQL Retrospective - The Early Years (from The Oracle MySQL Blog)

As part of the Advent calendar of content for this year, we are going to take a stroll down memory lane into the history of MySQL. In this first post, we will highlight some of the major milestones of the early years. [...]

Saturday, 30. November 2024

Duwamish Trail Cleanup – Saturday, December 7, 2024 (from Jeremy Cole)

Who? You! Anyone can help if you can spend a bit of time and muscle power. Whether you like to bike, walk, or just happen to drive by the trail and see others using it, or have never even seen it and want to make Seattle a better place – come on out! We can […] [...]

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

pThis post show 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) s [...]

Friday, 29. November 2024

MySQL October 2024 GA Releases Now Available (from ODBMS.org)

This October release is the third LTS release and second Innovation release since MySQL announced our move to a new LTS/Innovation release model.  For more info click here. Also you can read LEFRED blog... [...]

On MySQL Belgian Days 2025. Q&A with Frederic Descamps (from ODBMS.org)

Q1. You just announced that the MySQL Belgian Days 2025 event will be held before FOSDEM. What is FOSDEM?  And why is it relevant to the MySQL Community?  FOSDEM is a free event for software... [...]

Using Perl to Query Dolt Databases (from DoltHub Blog)

A couple of decades ago, as a brand-new CS grad just entering the world of big tech, I was given the Programming Perl book – also… [...]

Thursday, 28. November 2024

MySQL NDB Cluster replication: Merge replication for active-active clusters (from The Oracle MySQL Blog)

Learn about the merge replication topology used for building scalable, bi-directional, multi-primary replication deployments using MySQL NDB Cluster. This topology makes it possible to reliably scale out circular replication forming three, four, or more clusters all containing the same data. [...]

Try RAG with MariaDB Vector on your own MariaDB data! (from MariaDB Foundation Blog)

pThe day has come that you have been waiting for since the ChatGPT hype began: You can now build creative AI apps using your own data in MariaDB Server! … /p pContinue reading \"Try RAG with MariaDB Vector on your own MariaDB data!\"/p pThe post Try RAG with MariaDB Vector on your own MariaDB data! appeared first on MariaDB.org./p [...]

Auto Adapting Configuration Parameters in MySQL (from The Oracle MySQL Blog)

MySQL 8.4 changes the default values of built-in configurations when compared to MySQL 8.0. These changes are designed to auto adapt with the machine making the MySQL server production ready out of the box. [...]

Wednesday, 27. November 2024

BELGIAN MYSQL, MARIADB and friends COMMUNITY DINNER – FRIDAY 31 January 2025 (from FOSDEM MySQL & Friends Devroom)

FOSDEM is back in town! And the MySQL Devroom is back after one year of absence on the main event. Same as the last few year the MySQL community team is once again organizing the Belgian MySQL Days. This provides us with the opportunity to bring the community together to socialize and exchange idea’s over a […] [...]

MariaDB extensibility (from The consistent voice)

Enhancing MariaDB’s Capabilities: Exploring Extensibility OptionspMariaDB, a powerful open-source database system, offers a versatile feature that many developers overlook: User-Defined Functions (UDFs). This capability, inherited from MySQL’s early days (around 25 years ago in version 3.21.24), allows you to extend the database’s functionality in ways that can significantly enhance your applicatio [...]

On NEXTGRES and the evolution of PostgreSQL. Q&A with Jonah Harris. (from ODBMS.org)

Q1: What is NEXTGRES? NEXTGRES is a next-generation, enterprise-class evolution of PostgreSQL designed to unify diverse data types, code execution, and computational workloads within a single, scalable system. By integrating multiple data models–including relational,... [...]

Productionizing Dolt (from DoltHub Blog)

So you've been using Dolt for a while, and you are ready to take the next step and use it in production. Whether you are running your… [...]

Tuesday, 26. November 2024

Black Friday or Dark Friday? Depends If MySQL Stands the Rush (from Another Boring Tech Blog)

pBlack Friday or Dark Friday? Tips to Ensure Your MySQL Instance Survives Black Friday is one of the most demanding days of the year for e-commerce and online services, and your database is at the heart of it all. A slow or offline MySQL instance can turn your Black Friday into a Dark Friday, costing.../p pO post Black Friday or Dark Friday? Depends If MySQL Stands the Rush apareceu primeiro em Ano [...]

The Light MySQL Startup Optimization on EBS Volumes (from J-F Gagné's MySQL Blog)

In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables.  I already wrote four posts on the subject, they are listed below.  In this post, I use the system analysis of the previous post to revisit the light optimization on EBS volumes.  With this analysis, I am able to determine why the previous tests did not show [...]

Understanding InnoDB Tablespace Duplicate Check (MySQL Startup with Many Tables) (from J-F Gagné's MySQL Blog)

This post is a little long, please bear with me as after the intro, you can skip to the essential.In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables.  I already wrote three posts on the subject, they are listed below.  In this post, I focus on describing the startup phase InnoDB Tablespace Duplicate Check (Duplicate Check for [...]

Faster MySQL Startup with Many Tables (1M+) (from J-F Gagné's MySQL Blog)

I have been scratching my head about MySQL startup for some time.  There is much to say about this, and many other posts will probably follow.  For now, it is enough to know that with many tables (millions) the startup of MySQL 8.0+ (including 8.0, 8.4 and 9.0) is suboptimal (to say the least).  With very little changes, I was able to speed it up, from 2:39 to 1:09 (1 minute and 9 [...]

A New Trend: Organizations Moving Away from Managed MySQL (from Continuent Blog)

Cloud-based managed MySQL services like Amazon Aurora promised simplicity, scalability, and cost savings. But as adoption grows, many organizations are uncovering hidden costs, operational challenges, and limitations. This blog explores why companies are migrating back to on-premises MySQL and how solutions like Tungsten Clusters are empowering them to regain control, cut costs, and ensure flexibil [...]

Monday, 25. November 2024

Use MySQL Shell To Run JavaScript And Python Scripts From The Command Line (from The Oracle MySQL Blog)

How to use MySQL Shell to run JavaScript and Python scripts to connect to a MySQL database and execute queries. In this example, I show you how to dump and load a database table with a JavaScript script. [...]

RocksDB benchmarks: large server, leveled compaction (from Small Datum)

pI recently shared benchmark results for RocksDB a few weeks ago for both leveled and universal compaction on a small server. This post has results from a large server with leveled compaction. /pptl;dr/pp/pullithere are a few regressions from bug 12038/liliQPS for overwrite is ~1.5X to ~2X better in 9.x than 6.0 (ignoring bug 12038)/liliotherwise QPS in 9.x is similar to 6.x/li/ulp/ppHardware/ [...]

RocksDB benchmarks: large server, universal compaction (from Small Datum)

pThis post has results from a large server with universal compaction from the same server for which I recently shared leveled compaction results. The results are boring (no large regressions) but a bit more exciting than the ones for leveled compaction because there is more variance. A somewhat educated guess is that variance more likely with universal./pptl;dr/pp/pullithere are some small regressi [...]

Choosing the Right Data Types for Database Attributes (from The consistent voice)

pSelecting appropriate data types for database attributes is crucial for performance, storage efficiency, and data integrity. Here’s an explanation of the importance of choosing the right data types:/pPerformanceulliQuery Efficiency: Using appropriate data types speeds up query processing./liliIndexing: Certain data types are more efficient for indexing./liliSorting and Searching: Operations are fa [...]

Azure Database for MySQL bindings for Azure Functions (Public Preview) (from Azure for MySQL Blog)

pThe latest addition to the continuous advancements in Azure Database for MySQL is the introduction of Azure Database for MySQL bindings for Azure Functions, now available in Public Preview. These newly released input and output bindings enable seamless integration with Azure Functions, allowing developers and organizations to build at-scale event-driven applications and serverless APIs that integr [...]

MySQL 9.1 is out! Thank you for your contributions! (from The Oracle MySQL Blog)

Within this blog post, we want to thanks all our contributors and list all the contributions that have been processed and released with MySQL 9.1 [...]

MySQL 9.1 is out! Thank you for your contributions! (from lefred's blog)

Last month we released MySQL 9.1, the latest Innovation Release. Of course, we released bug fixes for 8.0 and 8.4 LTS but in this post, I focus on the newest release. Within these releases, we included patches and code received by our amazing Community. Here is the list of contributions we processed and included in […] [...]

Speed is the killer app (from InfoWorld)

pWhy do enterprises so often choose to run applications in the cloud even when it may not be the cheapest option? Why do they turn to open source even if it’s not the most feature-complete choice? And why is generative AI so frothy hot even though, as my InfoWorld colleague David Linthicum argues, “Companies are good at spending money [on AI] but bad at building and deploying [...]

Talk: The implementation of MariaDB parallel replication (from MariaDB Foundation Blog)

pOn November 6 2024 I presented a talk with the title: “The implementation of MariaDB parallel replication” at a local TeqHub meetup in Copenhagen. … /p pContinue reading \"Talk: The implementation of MariaDB parallel replication\"/p pThe post Talk: The implementation of MariaDB parallel replication appeared first on MariaDB.org./p [...]

Enhancing Developer Agility and Performance in Financial Services with MySQL Enterprise Edition (from The Oracle MySQL Blog)

This blog outlines how MySQL Enterprise Edition enhances developer agility and performance in financial services. [...]

RBL Bank Enhances Security and Efficiency with MySQL Enterprise Edition (from The Oracle MySQL Blog)

RBL Bank's strategic shift to MySQL Enterprise Edition fortified its cybersecurity defenses and streamlined operations, positioning the bank for continued growth and customer satisfaction in the competitive banking landscape. Read the blog. [...]

Sunday, 24. November 2024

Balancing Perf Trade-offs (from DoltHub Blog)

I ran into a performance trade-off last week attempting to improve long-running queries by changing the ways rows are structured. A more… [...]

Saturday, 23. November 2024

How to Identify Processes Using Swap Memory on Linux (from Another Boring Tech Blog)

pIdentifying which processes have pages swapped out of memory when troubleshooting performance issues on a Linux system is often helpful. Swapping can impact system performance, so knowing which processes are affected is important in diagnosing and resolving these issues. Checking Swap Usage by Process Linux provides detailed process information in the /proc directory. By leveraging.../p pO post Ho [...]

Friday, 22. November 2024

Pipelined DML in TiDB: A Breakthrough for Managing Large Transactions (from PingCAP Blog)

pManaging large transactions in distributed databases has always been a tough nut to crack. From processing millions of records during migrations to tackling complex workflows like ETL (Extract, Transform, Load), businesses need database solutions that are not only fast but also reliable. TiDB has long been at the forefront of distributed SQL database innovation, and […]/p pThe post Pipelined [...]

Accelerating Distributed SQL Adoption: How Plaid Migrated 41 Services from Amazon Aurora in One Year (from PingCAP Blog)

pPlaid is a financial services company that builds a data transfer network for applications to connect with users’ bank accounts. At HTAP Summit 2024, Zander Hill, Experienced Software Engineer at Plaid, and Andrew Chen, Engineering Manager at Plaid, shared an in-depth look into their company’s ambitious migration from Amazon Aurora to a distributed SQL database […]/p pThe post Accelerating D [...]

New Contact Management in HeatWave MySQL (from The Oracle MySQL Blog)

Customer contacts in HeatWave is a new feature that streamlines notification management by allowing you to assign specific contacts for all critical databases. With this capability, your Cloud Ops and DBA team can stay informed about operational issues, maintenance updates, and service announcements, ensuring timely responses. [...]

MariaDB 11.6.2 and MariaDB 11.7.1 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 11.7.1, the latest rolling release Release Candidate (RC), and MariaDB 11.6.2, the latest Generally Available (GA) rolling release. … /p pContinue reading \"MariaDB 11.6.2 and MariaDB 11.7.1 now available\"/p pThe post MariaDB 11.6.2 and MariaDB 11.7.1 now available appeared first on MariaDB.org./p [...]

Replica Preserve Commit Order and Measuring Lag (from Hack MySQL)

pWith multi-threaded replication (MTR), a replica can commit transactions in the same order as the source, or not. This is determined by sysvar codereplica_preserve_commit_order/code (RPCO). As of MySQL v8.0.27 (released October 2021) it’s ON by default, but it was OFF by default for several years prior. In either case, it’s relatively new compared to 20+ years of single-threaded replic [...]

Thursday, 21. November 2024

WeSQL Introduction – MySQL running on S3 (from Ronald Bradford Blog)

I recently became aware of WeSQL. A MySQL-compatible database that separates compute and storage, using S3 as the storage layer. The product uses a columnar format by default which is significantly more space-efficient than InnoDB. WeSQL introduces a new storage engine called SmartEngine using a LSM-tree-based structure that is ideal for a storage bucket implementation, […] [...]

Automate database user management with AWS Lambda and AWS Systems Manager (from AWS Database Blog)

Amazon Web Services (AWS) users frequently use multiple accounts, organizing them efficiently with AWS Organizations. This system structures the accounts hierarchically and groups them into Organizational Units (OUs). However, this setup can sometimes add complexity, especially for teams that support the entire organization. Consider the following example of a database operations team’s predicament [...]

Amazon RDS for MySQL LTS version 8.4 is now generally available (from AWS Database Blog)

Today, Amazon RDS has announced support for MySQL version 8.4, which is the latest Long-Term Support (LTS) major version from the MySQL community. With that, Amazon RDS now supports MySQL Community Edition versions 8.0 and 8.4. In addition to the two community-supported LTS releases, Amazon RDS also offers MySQL 5.7 under RDS Extended Support, where RDS provides critical patches and bug fixes for t [...]

Amazon RDS Blue/Green Deployments Green storage fully performant prior to switchover (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) Blue/Green Deployments now support managed initialization of Green storage volumes that accelerates the loading of storage blocks from Amazon S3. This ensures that the volumes are fully performant prior to switchover of the Green databases. Blue/Green Deployments create a fully managed staging environment, or Green database, by restoring the Blue dat [...]

Amazon RDS for MySQL now supports MySQL 8.4 LTS release (from AWS What's New)

pAmazon RDS for MySQL now supports MySQL major version 8.4, the latest long-term support (LTS) release from the MySQL community. RDS for MySQL 8.4 is integrated with AWS Libcrypto (AWS-LC) FIPS module (Certificate #4816), and includes support for multi-source replication plugin for analytics, Group Replication plugin for continuous availability, as well as several performance and feature improvemen [...]

Announcing MariaDB Community Server 11.7 RC with Vector Search and 11.6 GA (from MariaDB Corporation Blog)

We are pleased to announce the general availability (GA) of MariaDB Community Server 11.6 and the release candidate (RC) of … Continued [...]

Testing Dolphie For the First Time: Features and Feedback (from Another Boring Tech Blog)

pIn this blog post, I will test Dolphie, an open-source project by Charles Thompson. Dolphie is an open-source tool that provides real-time analytics for MySQL, MariaDB, and ProxySQL. As a first-time user, my goal is to go from zero to hero, exploring how easy it is to start using the tool while getting familiar with.../p pO post Testing Dolphie For the First Time: Features and Feedback apareceu p [...]

Belgian MySQL Days 2025, Thursday 30th January 2025 9:00AM (from ODBMS.org)

ICAB Incubator, Belgium, 1040  Thursday 30th January 2025 9:00AM Join us for the preFOSDEM MySQL Belgian Days, a must-attend event for all MySQL enthusiasts! TO REGISTER As usual, this exciting in-person gathering will take... [...]

Deploy a Magento Open Source LAMP-stack e-commerce app on Azure with one click! (from Azure for MySQL Blog)

What is Magento Open Source? pMagento Open Source is a free and flexible e-commerce platform that allows you to create and manage online stores. It offers powerful features such as product catalog management, shopping cart, checkout, payment, shipping, marketing, analytics, and more. Magento Open Source is also highly customizable and extensible, enabling you to tailor your store to your specific n [...]

Where can you find MySQL during December 2024 – February 2025 (from ODBMS.org)

By Lenka Kasparova, MySQL Community Manager You can find the new list of conferences and events we are part of during December 2024 to February 2025 here [...]

Wednesday, 20. November 2024

AWS Compute Optimizer now supports rightsizing recommendations for Amazon Aurora (from AWS What's New)

pAWS Compute Optimizer now provides recommendations for Amazon Aurora DB instances. These recommendations help you identify idle database instances and choose the optimal DB instance class, so you can reduce costs for unused resources and increase the performance of under-provisioned workloads.br br AWS Compute Optimizer automatically analyzes Amazon CloudWatch metrics such as CPU utilization, netw [...]

Introducing scaling to 0 capacity with Amazon Aurora Serverless v2 (from AWS Database Blog)

Amazon Aurora Serverless v2 now supports scaling capacity down to 0 ACUs, enabling you to optimize costs during periods of database inactivity. Aurora Serverless is an on-demand, auto scaling configuration of Aurora that automatically adjusts your database capacity based on your workload requirements. Aurora Serverless measures database capacity in Aurora Capacity Units (ACUs) billed per [...]

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

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Java 3.5.1 release. Download Now Release Notes and Changelogs … Continued [...]

Dolphie – “Rerecord not fadeaway” (from MySQL-Med)

One of the coolest features is being able to go back in time with Dolphie and analyze what was happening at a specific moment. Continue reading → [...]

Understanding MySQL DDL Space Requirements (from Another Boring Tech Blog)

pThis blog post will explore MySQL’s file storage behavior during DDL operations, particularly with InnoDB tables. Using a practical example, we’ll discuss where and how MySQL stores data during different types of DDL operations. Setting the Stage: Table Structure Consider a table sbtest1 with 30 million rows, created as follows: [crayon-67475e6392cbe420388237/] This table is actively used.../p pO [...]

Building a Resilient Embedding System for Semantic Search at Airtable (from Airtable Engineering Blog)

pWhen ChatGPT burst into the public eye in 2022, a small team of engineers at Airtable started ideating on the different ways our platform could leverage this new set of capabilities. One idea kept popping up: rich, semantic search over customer data./ppImagine a marketing team asking, “Can you find past campaigns similar to this one?”, a product management team asking “can you find engineers whose [...]

AWS Advanced NodeJS Driver is Generally Available (from AWS What's New)

pThe Amazon Web Services (AWS) Advanced NodeJS Driver is now generally available for use with Amazon RDS and Amazon Aurora PostgreSQL and MySQL-compatible database clusters. This database driver provides support for faster switchover and failover times, Federated Authentication, and authentication with AWS Secrets Manager or AWS Identity and Access Management (IAM).br br The Amazon Web Services (AW [...]

Azure Database for MySQL support for MySQL 9.1 Innovation Release and MySQL 8.4 LTS - Public Preview (from Azure for MySQL Blog)

pWe are thrilled to announce the public preview of Azure Database for MySQL support for two exciting MySQL versions: MySQL 9.1 (Innovation Release) and MySQL 8.4 (LTS). These additions empower developers and database administrators with the latest MySQL features and enhancements to build, innovate, and optimize their applications on Azure./p pDuring the public preview phase, support for MySQL 9.1 ( [...]

Database Security: Best Practices to Protect Your MySQL Infrastructure (from ProxySQL Blog)

pAs of 2024, MySQL ranks as the second most popular database management system globally. MySQL has become a go-to choice for database management due to its dependable performance, stability, and open-source licensing. However, its popularity also brings significant security challenges like SQL injection attacks and unauthorized data access. As cyber threats evolve, protecting MySQL [...]/p pThe pos [...]

How Companies Can Improve Database Performance with ProxySQL (from ProxySQL Blog)

pThe efficiency of a company's database systems is not just an IT concern but a central business issue. Slow databases can drag down the entire user experience, leading to lost revenue and decreased efficiency. So, what's the secret to turbocharging database performance and staying ahead of potential bottlenecks? ProxySQL is an innovative middleware solution [...]/p pThe post How Companies Can Impr [...]

Tuesday, 19. November 2024

Newest MariaDB Enterprise Server release series reaches RC (from MariaDB Corporation Blog)

We are thrilled to introduce our newest major release of MariaDB Enterprise Server. For this release, we looked at how … Continued [...]

Using Dolphie for MySQL focus monitoring & performance tuning. (from MySQL-Med)

We can use so many different observability tools to get notifications, alerts, react, generate reports, etc. from so many different companies, using agents, proxies, repositories, and so on and so forth. And after exchanging experiences with dolphie's author himself, Charles, the idea here is to go that little bit further in monitoring MySQL. Continue reading → [...]

Long and Silent / Stressful MySQL Startup with Many Tables (from J-F Gagné's MySQL Blog)

In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables.  I already wrote two posts on the subject, the links are below.  So far, I did not share what brought my attention to this, and it is the subject of this post.  Also, and because it is related, I come back to the optimization / contribution I already made on [...]

Using Loki and Promtail to Display PostgreSQL Logs From a Kubernetes Cluster in PMM (from Percona Database Blog)

♦This is a follow-up to my colleagues Nickolay and Phong’s Store and Manage Logs of Percona Operator Pods with PMM and Grafana Loki and Agustin’s Turbocharging Percona Monitoring and Management With Loki’s Log-shipping Functionality blog posts. Here, I focus on making PostgreSQL database logs from a Kubernetes cluster deployed with the Percona Operator for PostgreSQL […] [...]

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, ensure high [...]

Where can you find MySQL during December 2024 - February 2025 (from The Oracle MySQL Blog)

MySQL Conferences 12/24-2/25 [...]

Postgres's missing quality of life features (from DoltHub Blog)

We are hard at work building Doltgres, the Postgres-compatible version of Dolt. Dolt is the world's first and only version-controlled SQL… [...]

Anatomy of a Throttler, part 3 (from PlanetScale Blog)

Design considerations for implementing a database throttler [...]

Monday, 18. November 2024

Amazon Aurora MySQL 3.08 (compatible with MySQL 8.0.39) is 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.39. In addition to several security enhancements and bug fixes, MySQL 8.0.39 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.08 also includes multiple av [...]

My “PostgreSQL” story (PostgreSQL, Streaming Replication, Yugabyte, PGD, CockroachDB & StandbyMP story) (from MySQL-Med)

Learning how to evaluate PostgreSQL Streaming Replication, Yugabyte, PGD, CockroachDB & StandbyMP for highly available solutions. Continue reading → [...]

Why Query Caching Is the Most Cost-Effective Way To Scale Databases — and Everyone’s Missing It (from Readyset Blog)

pScaling databases is no small task, and in the rush to find fast, affordable solutions, teams often overlook a key technique: query caching. By intelligently caching database queries, we’re sidestepping many of the typical challenges and costs that come with sharding, complex materialized views and resource-intensive indexes. Yet,/p [...]

Amazon Aurora MySQL now supports R7i instances (from AWS What's New)

pAmazon Aurora with MySQL compatibility now supports R7i database instances powered by custom 4th Generation Intel Xeon Scalable processors. R7i instances offer larger instance sizes, up to 48xlarge and features an 8:1 ratio of memory to vCPU, and the latest DDR5 memory. These instances are now available in the following AWS Regions: US East (N. Virginia, Ohio), US West (N. California, Oregon), Asi [...]

Unleashing Query Power: Advanced Multi-Column Index Optimization in TiDB (from PingCAP Blog)

pIn today’s data-driven world, efficiently handling complex queries on large datasets is critical to keeping applications responsive and performant. For TiDB, a distributed SQL database designed to manage high-scale, high-demand environments, optimizing data access paths is essential to delivering smooth, efficient queries. This post dives into TiDB’s advanced approach to optimizing multi-column in [...]

Ensuring High Availability and Fault Tolerance for Business-Critical Workloads (from Continuent Blog)

In the current MySQL ecosystem, organizations must focus on high availability and fault tolerance to ensure business continuity and maintain customer trust. A recent inquiry to prominent tech executives identified five key themes for achieving this: multi-region deployment to prevent single points of failure, automated self-healing for quick issue resolution, redundancy through system duplication, [...]

MySQL 8 utf8mb4_0900_ai_ci collation confusion (from Kedar MySQL Blog)

pRecently I was asked a question: Why am I getting utf8mb4_0900_ai_ci as the default collation in MySQL 8, despite setting the server to use utf8mb4_general_ci? With the upgrade to MySQL…/p The post MySQL 8 utf8mb4_0900_ai_ci collation confusion first appeared on Change Is Inevitable. [...]

Enhancing Security and Compliance in Financial Services with MySQL Enterprise Edition (from The Oracle MySQL Blog)

This blog highlights how MySQL Enterprise Edition helps financial services companies enhance security and comply with regulations. [...]

SQL Calculations #1 (from MacLochlainns Weblog)

This was principally written for my SQL students but I thought it might be useful to others. SQL calculation are performed row-by-row in the SELECT-list. In its simplest form without even touching a table, you can add two literal numbers like this: SELECT 2 + 2 AS result; It will display the result of the […] [...]

JSON Showdown: Dolt vs Sqlite (from DoltHub Blog)

Dolt was created to be the world's first truly version controlled database. We think it does a great job at that. And in the process of… [...]

Saturday, 16. November 2024

Simplifying Replication with Tagged GTID in MySQL 8.4 (from Mydbops Blog)

Learn how Tagged GTID in MySQL 8.4 enhances replication with selective transactions, conflict resolution, and seamless data flow in complex setups. [...]

Friday, 15. November 2024

Unlocking Modern SaaS Platforms: How Distributed SQL Delivers Multi-Tenancy at Scale (from PingCAP Blog)

pAt HTAP Summit 2024, Dave Burgess, an industry veteran, angel investor, and ex-VP of Data Engineering at Pinterest, walked through why distributed SQL has emerged as a key component of modern SaaS platforms. As Burgess explained during his keynote, traditional databases like MySQL and PostgreSQL may serve startups initially. However, as businesses scale and encounter […]/p pThe post Unlockin [...]

MariaDB Python Connector 1.1.11 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Python 1.1.11 release. Download Now Release Notes MariaDB Connector/Python … Continued [...]

Protect your data with MariaDB Server and Intel® TDX (from MariaDB Foundation Blog)

pIn 2023, Intel launched Intel® Trust Domain Extensions (Intel® TDX), their latest Confidential Computing technology that ensures data in use protection for hardware-isolated virtual machines and verified hardware and software integrity through attestation. … /p pContinue reading \"Protect your data with MariaDB Server and Intel® TDX\"/p pThe post Protect your data with MariaDB Serv [...]

How to Change a Table Name in MySQL in Different Ways (from Devart MySQL Tool Blog)

pRename table operations are common. When business situations and business requirements change, it becomes necessary to change the name of tables in MySQL databases. This article will explore various methods of renaming MySQL tables and essential related issues./p pThe post How to Change a Table Name in MySQL in Different Ways appeared first on Devart Blog./p [...]

FOSDEM 2025 MySQL Devroom – Selection Committee (from FOSDEM MySQL & Friends Devroom)

Now that the call for participation is open, let me present the selection committee members that will read, evaluate, and rate your submissions. Committee members are responsible for evaluating and scoring proposals.They must also consider certain constraints, such as that the project must be open source, and that the session must be technical and in […] [...]

Thursday, 14. November 2024

MariaDB ODBC Connector 3.2.4 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/ODBC 3.2.4 release. Download Now Release Notes MariaDB Connector/ODBC … Continued [...]

Cave adminem (from The consistent voice)

♦pSecuring access to a MariaDB database is essential to protect sensitive data and maintain system integrity. Basic security measures like enforcing strong passwords help prevent unauthorized access, while ensures that data is encrypted during transmission. By combining these practices with regular updates and access control, you can significantly reduce the risk of security breaches. utilizing TLS [...]

Understanding Latency Through a 100m Race: From CPU to NVMe (from Another Boring Tech Blog)

pIn the world of computing, latency is everything. Whether you’re optimizing a database query or fine-tuning a high-performance application, understanding how quickly different components of your system respond can make or break performance. But let’s put these abstract nanoseconds and microseconds into a more relatable scenario—a 100m sprint race. 🏃‍♂️🏃‍♀️ The Runners in the Race.../p pO post Unde [...]

Exploring Kubernetes CPU Resources in View of Percona XtraDB Cluster’s Flow Control (from Percona Database Blog)

♦Even though I used a dedicated Kubernetes cluster to host my test database, I had this belief that by not explicitly allocating (or requesting, in Kubernetes vocabulary) CPU resources to my Percona XtraDB Cluster (PXC) pods or yet making just a small request, Kubernetes could be delaying access to the free CPU cycles available on […] [...]

Podcast: Duplicate Indexes in MySQL (from Kedar MySQL Blog)

pIn this podcast, we’ll explore the issue of duplicate indexes in MySQL; including redundant index, foreign keys, left-prefixed secondary index /w primary key, and how to tackle the issue at…/p The post Podcast: Duplicate Indexes in MySQL first appeared on Change Is Inevitable. [...]

Galera Manager November 2024 Release (from Galera Blog)

Codership is pleased to announce a new release of Galera Manager. The current installer stands at version 1.14.0 (you can check this by typing: ./gm-installer version which will report gm-installer version 1.14.0 (linux/amd64)) and the actual Galera Manager GUI is at version 1.8.7. Users will notice usability improvements, and fixes for issues filed at the […] [...]

MySQL Replication Monitoring : Enhanced Features for the Enterprise Edition (from The Oracle MySQL Blog)

The latest update to MySQL Enterprise edition, version 9.1, introduces significant enhancements focused on replication monitoring. This update includes improvements to Group Replication Flow Control and the replication applier, providing users with better visibility and control over their replication performance, leading to potential long-term cost savings by ensuring efficient usage of their machi [...]

Wednesday, 13. November 2024

Some InnoDB Cluster troubleshooting commands (from MySQL-Med)

A quick overview of some commands to ensure you can handle your InnoDB Cluster when things get difficult. Continue reading → [...]

Enhancements to MariaDB Logical Dump and Import Tools in Release Series 11.5/11.6 (from MariaDB Corporation Blog)

In this post, we’ll explore the enhancements made to MariaDB’s backup and restore tools, mariadb-dump and mariadb-import, implemented in MDEV-33635 … Continued [...]

Amazon RDS for MySQL supports new minor version 8.0.40 (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for MySQL now supports MySQL minor version 8.0.40. We recommend that you upgrade to the latest minor versions to fix known security vulnerabilities in prior versions of MySQL, and to benefit from the bug fixes, performance improvements, and new functionality added by the MySQL community. Learn more about the enhancements in RDS for MySQL 8.0.40 in th [...]

Demystifying EXPLAIN and EXPLAIN ANALYZE (from Readyset Blog)

Dive deep into SQL query optimization with EXPLAIN and EXPLAIN ANALYZE. Learn the differences between these powerful tools, understand their output, and discover how to identify performance bottlenecks in your queries. Boost your SQL skills and take your query tuning to the next level. [...]

BSE (Bombay Stock Exchange) Processes Billions of Transactions Daily with MySQL Enterprise Edition (from The Oracle MySQL Blog)

BSE leverages MySQL Enterprise Edition for processing 150 million trades and 5 billion orders per day. [...]

Tuesday, 12. November 2024

MariaDB C Connector 3.4.3, 3.3.13, and 3.1.26 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Connector/C 3.4.3, 3.3.13, and 3.1.26. Download Now Release Notes and … Continued [...]

Jemalloc install & config for MySQL (from MySQL-Med)

Have a look into how to deploy jemalloc and install, configure & test for your MySQL Server. Continue reading → [...]

Difference Between WAL Files and Transaction Logs in PostgreSQL (from MinervaDB Blog)

pUnderstanding the Difference Between WAL Files and Transaction Logs in PostgreSQL In PostgreSQL, two key components that are frequently discussed in relation to database management and performance are the transaction log and the WAL (Write-Ahead [...]/p pThe post Difference Between WAL Files and Transaction Logs in PostgreSQL appeared first on The WebScale Database Infrastructure Operations Expert [...]

Boosting Profitability in Financial Services with MySQL (from The Oracle MySQL Blog)

MySQL not only helps financial institutions bolster their profitability but also equips them to thrive in a rapidly changing market. Embracing MySQL is a strategic move for any financial services organization looking to secure its future in a digital-first world. Read the full blog. [...]

Grouping and Aggregations on Vitess (from Vitess)

I love my job. One of the best feelings is when I find an interesting paper and use it to solve a real problem. It feels like I found a cheat code. Instead of having to do a lot of hard thinking, I can just stand on the shoulders of really big people and take a shortcut. Here, I want to share a recent project that I could solve using a public paper. [...]

Monday, 11. November 2024

7-point checklist to conquer MySQL 5.7 to 8.0 upgrade challenges (from Azure for MySQL Blog)

pWith the ever-increasing pace of technology, it’s easy to miss out on database end-of-life (EOL) dates, especially in complex multi-database environments. This is especially the case with MySQL 5.7, which reached end-of-life status in October 2023./p pDatabases based on the older versions like MySQL 5.7, after they stop receiving security updates, can have bugs and security vulnerabilities that pu [...]

Evolution of Histograms in MySQL 8.4: From Manual to Automated Performance Optimization (from Mydbops Blog)

Explore the evolution of histograms in MySQL and how MySQL 8.4's automated updates improve query optimization and performance. [...]

Release and version management is hard (from Daniël's Database Blog)

pIn this post I will talk about release management with MySQL as example. Release management has to do with what to put in a release, how often to do a release, how to long to support a release and how to number or name the releases./p The early years pToday software is almost exclusively delivered over the internet, but this didn’t use to be the case. Software used to be delivered in a box that yo [...]

Saturday, 09. November 2024

Managing SQL Drift: Ensuring Stability in Database Transitions (from Ronald Bradford Blog)

SQL drift is a significant challenge that occurs when SQL statements from an existing system produce unexpected results after migration to a new environment or system. These issues manifest in several critical ways: SQL statements may generate new execution errors, experience significant performance degradation, or yield differences in data integrity. Such challenges extend beyond simple […] [...]

Fixing some of the InnoDB scan perf regressions in a MySQL fork (from Small Datum)

pI recently learned of Advanced MySQL, a MySQL fork, and ran my sysbench benchmarks for it. It fixed some, but not all, of the regressions for write heavy workloads that landed in InnoDB after MySQL 8.0.28.brbrIn response to my results, the project lead filed a bug for performance regressions and then quickly came up with a diff. The bug in this case is for regressions that are most obvious during [...]

Efficient MySQL Performance In 10 Sentences (from Hack MySQL)

pDon’t have time to read Efficient MySQL Performance? Here’s the book (10 chapters) in one-liners./p ol liPerformance is query response time./li liProper left-most indexing is required for performance./li liThe less data, the better./li liAccess patterns (part of the workload) help or hinder performance./li liSharding is how to scale writes when single-node performance is truly reached. [...]

RocksDB benchmarks: small server, leveled compaction (from Small Datum)

pI shared benchmark results for RocksDB a few weeks ago and there was a suggestion for me to repeat tests using different (older) values for format_version. Then while replacing a failed SSD, I also updated the OS and changed a few kernel-related config options. Thus, I ended up repeating all tests.brbrThis post has results from a small server with leveled compaction. Results from a large server an [...]

Friday, 08. November 2024

Storing the MySQL Data Dictionary in a 3rd-Party Storage Engine (from Laurynas Biveinis' blog)

pMySQL 8.0 replaced legacy codeFRM/code files with a transactional data dictionary, stored in InnoDB. Here I'll describe how any other storage engine could become the DDSE, that is, serve as the backend for the data dictionary, replacing InnoDB. This is purely an internals post, and will not look into user-facing motivations and implications of the change (which can be found here), now will it disc [...]

How to Connect PHP With MySQL (from Devart MySQL Tool Blog)

pRead on to learn about how to connect PHP with a MySQL database using different methods, including mysqli, PDO, and dbForge for MySQL. /p pThe post How to Connect PHP With MySQL appeared first on Devart Blog./p [...]

Implementing a Tamper-Proof Ledger in PostgreSQL (from MinervaDB Blog)

pImplementing a Tamper-Proof Ledger in PostgreSQL for Auditable and Secure Data Storage In PostgreSQL, a ledger refers to a specialized database structure or extension designed to provide immutable, auditable, and secure data storage. This structure [...]/p pThe post Implementing a Tamper-Proof Ledger in PostgreSQL appeared first on The WebScale Database Infrastructure Operations Experts in Postgre [...]

Thursday, 07. November 2024

Enforcing strong passwords for MariaDB users (from Vettabase)

MariaDB users normally connect using a password. Weak passwords are a common security problem, especially when passwords are generated by humans. However, MariaDB comes with plugins that help validating passwords to make sure they are strong enough. This article is a practical overview of MariaDB password validation plugins. Managing password validation plugins Password validation plugins are just [...]

Introducing sharding on PlanetScale with workflows (from PlanetScale Blog)

Run Vitess workflows right from within PlanetScale. Migrate data from unsharded to sharded keyspaces, manage traffic cutover, and easily revert when problems arise. [...]

The Shift to S3 - Every Database Will Be Rearchitected for S3 in the Next Few Years (from WeSQL Blog)

In recent years, we’ve seen a profound shift in how databases handle storage, [...]

Wednesday, 06. November 2024

Isolation level violation testing and debugging in MariaDB (from MariaDB Corporation Blog)

Isolation is one of key transaction properties in database systems (the I in ACID), and its violation is a serious … Continued [...]

An Elephant in the Cluster: Making PostgreSQL Feel at Home on Kubernetes (from Percona Database Blog)

♦TL;DR Kubernetes was built for stateless apps, but as more stateful applications (like databases) run on it, operators include quite heavy implementations to Kubernetes workload management API (such as StatefulSets) deficits. While creating custom methods allows flexibility and faster time to market, it also leads to inconsistency and complexity. In this blog, I want to […] [...]

MySQL Podcast – Practical Learning & Training (from Kedar MySQL Blog)

pHello, readers! I’m excited to announce the launch of my latest project: a dedicated MySQL Podcast! As a long-time MySQL enthusiast with extensive hands-on experience in database management, I understand…/p The post MySQL Podcast – Practical Learning & Training first appeared on Change Is Inevitable. [...]

Top MySQL Hosting Providers in 2024 for Reliable Database Management (from Devart MySQL Tool Blog)

pCloud-based database hosting seems to be an extremely viable solution for modern apps. After all, the entire management-and-maintenance thing is relegated to the hosting provider, scalability is not an issue, and you are free to focus on product development as you see fit./p pThe post Top MySQL Hosting Providers in 2024 for Reliable Database Management appeared first on Devart Blog./p [...]

RocksDB on a big server: LRU vs hyperclock (from Small Datum)

pThis has benchmark results for RocksDB using a big (48-core) server. I ran tests to document the impact of the the block cache type (LRU vs hyperclock) and a few other configuration choices for a CPU-bound workload. A previous post with great results for the hyperclock block cache is here./pptl;dr/pulliread QPS is up to ~3X better with auto_hyper_clock_cache vs LRU/liliread QPS is up to ~1.3X bett [...]

Tuesday, 05. November 2024

Exploring the MySQL Server System Variables and SET Statements (from The Oracle MySQL Blog)

MySQL system variables configure the server's operation, and the SET statement is used to change system variable. The MySQL SET statements have various options for specifying changes to SYSTEM VARIABLE. It’s important to understand how these changes are reflected in current sessions (connections), later sessions, and after database server restarts. [...]

Get Some REST With The Tungsten API (from Continuent Blog)

Standards allow modern systems to advance, and the REST specification is one very important example. Since this post is about the Tungsten API in specific, let me simply say this - a RESTful API adheres to six principles: Client-server, stateless, cacheable, uniform interface, layered system and optionally code on demand. As part of the watchability/monitoring goal, our software as of version 7.0.0 [...]

MMQ : MariaDB (as a) Messsage Queue (from The consistent voice)

MMQ : MariaDB (as a) Messsage Queuesee Addendum/erratum at the end of the storypLet’s practice a theoritical architectural exercise here./ppWhen faced with the challenge of building an internal asynchronous message queue system without introducing new dependencies, leveraging MariaDB can be an effective solution. Thanks to its robust set of features and rich history, MariaDB is well-suited for this [...]

Multi-Source Replication From Dolt to MySQL (from DoltHub Blog)

One of MySQL's greatest features is its robust replication support. MySQL replication provides scalability, reliability, and high… [...]

Optimizing query planning in Vitess: a step-by-step approach (from Vitess)

Introduction # In this blog post, we will discuss an example of a change to the Vitess query planner and how it enhances the optimization process. The new model focuses on making every step in the optimization pipeline a runnable plan. This approach offers several benefits, including simpler understanding and reasoning, ease of testing, and the ability to use arbitrary expressions in ordering, grou [...]

Monday, 04. November 2024

How to Add an Invisible Primary Key to an Existing Table in MySQL (from Another Boring Tech Blog)

pWith MySQL 8.0.23, the concept of invisible columns was introduced. Columns marked as invisible do not appear in standard [crayon-67475e63930b5666022646-i/]  queries and don’t require changes to existing application code. Later, in MySQL 8.0.30, support for automatically generated invisible primary keys (GIPKs) was added for InnoDB tables created without an explicit primary key. This enhancement, [...]

October Product Updates (from Readyset Blog)

As we head into November, let's take a look at what the Readyset team was up to in October! [...]

RocksDB benchmarks: small server, universal compaction (from Small Datum)

pI shared benchmark results for RocksDB a few weeks ago using leveled compaction and a small server. Here I have results for universal compaction and the same small server./ptl;drulliin general the there are some improvements and some small regressions with one exception (see  bug 12038)/lilifor a cached database/liulliFrom RocksDB 6.0.2 to 9.x QPS drops by ~10% for fillseq and [...]

Let’s go physical(ly separated) (from The consistent voice)

♦pIn my previous article , we discussed best practices for securing and monitoring admin access, such as role-based access controls (RBAC). It’s a good time to have a quick reminder about AAA aka “ Authentication, Authorization and Accounting” , which is a framework designed to manage access to networked resources and ensure secure, controlled interactions :/polliAuthentication : Verifies the ident [...]

MySQL Change Buffer – What When and FAQ (from Kedar MySQL Blog)

pIn the world of database management, efficiency is key. MySQL’s change buffer is a powerful feature that helps optimize how secondary index changes are managed. The idea of introducing a…/p The post MySQL Change Buffer – What When and FAQ first appeared on Change Is Inevitable. [...]

WePay's Journey to Enhanced Database Performance with MySQL Enterprise Edition (from The Oracle MySQL Blog)

WePay, the integrated payments arm of JPMorgan Chase, has taken significant strides to enhance its database infrastructure by upgrading to MySQL Enterprise Edition. For businesses looking to optimize their payment infrastructure, the journey of WePay serves as an insightful case study on leveraging advanced database solutions for maximum uptime and security. [...]

Exposing PostgreSQL with NGINX Ingress Controller (from Percona Database Blog)

♦I wrote a blog post in the past about a generic approach on how to expose databases in Kubernetes with Ingress controllers. Today, we will dive deeper into PostgreSQL with ingress and also review two different ways that can be taken to expose the TCP service. The goal is to expose multiple PostgreSQL clusters through […] [...]

MariaDB 11.4.4, 11.2.6, 10.11.10, 10.6.20 and 10.5.27 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 11.4.4, MariaDB 10.11.10, MariaDB 10.6.20 and MariaDB 10.5.27, the latest stable releases in their respective long-term series (maintained for five years from their first stable release dates), as well as MariaDB 11.2.6 the latest and final scheduled release in the 11.2 short-term series (maintained for one year)br See the r [...]

Embracing Distributed SQL to Drive AI-Readiness in Banking: A Q&A from SACCC 2024 (from PingCAP Blog)

pFinancial services are rapidly transforming to adopt AI, digitize operations, and enhance customer experiences, yet many banks struggle with outdated legacy data systems that limit AI adoption.  At the Silverlake Axis Customer Connect Conference (SACCC), held from October 17 to 20, 2024, in Da Nang, Vietnam, industry leaders focused on modernizing banking infrastructure. C-suite executives, [ [...]

An Ooey GUI Guide to Using Dolt (from DoltHub Blog)

Dolt is inspired by Git and MySQL, two deeply command-line oriented software programs. Thus, Dolt started as a command line utility… [...]

Sunday, 03. November 2024

GenAI chatbot with Laravel, Redis, OpenAI, and LLPhant (from MORTENSI)

pGenAI chatbots help improve the user experience of the visitors to your website. Using natural language, you can connect users with your products, services, documentation, and FAQs and simulate the interactivity of a human operator (kind of). Either choose a third-party service or develop your own; nowadays, you are a few clicks away from offering […]/p pThe post GenAI chatbot with Laravel, [...]

Saturday, 02. November 2024

Celebrating 15 years of MariaDB (from Monty says)

pIt is 15 years since the first MariaDB server release of MariaDB 5.1.38 on 29'th of October 2009./ppMariaDB got its name from my youngest daughter Maria, following the tradition of MySQL, who got its name from my oldest daughter My./ppThe MariaDB project started on April 20 2009, the same day when Oracle announced that Oracle will buy Sun Microsystems, who owned MySQL. The initial MariaDB engineer [...]

Friday, 01. November 2024

MariaDB Community Server Q4 2024 maintenance releases (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 11.4.4, 11.2.6, 10.11.10, 10.6.20, and 10.5.27 maintenance releases. … Continued [...]

Too many performance regressions for InnoDB in MySQL 8.0.29 and 8.0.30 (from Small Datum)

There are many changes to InnoDB in MySQL 8.0.29 and 8.0.30. And many changes increases the chance of performance regressions. A recent report on this from me is here. In the worst-case the throughput drops almost in half for the update-index microbenchmark. This blog post identifies the diff that causes the regression.brtl;drullithis diff causes the update-index regression. The diff adds support f [...]

MySQL 8.0.40 does not fix the regressions I hoped it would fix (from Small Datum)

pPerformance regressions arrived in InnoDB with MySQL 8.0.30. Eventually multiple bugs were filed. The worst regressions were from changes to the hash function (perhaps fixed in 8.0.36) and from changes to how functions are inlined for InnoDB (bug 111538). The problems are obvious if you run CPU-bound workloads, and my CPU-bound workload is sysbench with a cached database./ppBug 111538 is now close [...]

Trying out Advanced MySQL (from Small Datum)

pI recently learned of the Advanced MySQL project on github via a tweet. There is a book and a repo for an enhanced version of 8.0.40. I wish I had the time to read some of that book and learn more about the enhancements but for now I just ran my sysbench tests for it on a few large servers. Hopefully I will also run the Insert Benchmark for it on the same servers./pptl;dr/pp/pulliAdvanced MySQL is [...]

How Can MySQL Catch Up with PostgreSQL’s Momentum? (from Percona Database Blog)

♦When I talk to old-timers in the MySQL community, I often hear this question: “How come MySQL is so awesome and still more popular than PostgreSQL (according to DB-Engines methodology at least), but it is losing ground while PostgreSQL’s growth in popularity has been unstoppable?” Can anything be done in the MySQL ecosystem to reverse […] [...]

Use Dolt With MySQL Connector in Python (from DoltHub Blog)

Dolt is a version controlled MySQL compatible database. It means you can commit, diff and merge along with other Git-like version control… [...]

Thursday, 31. October 2024

Migrating From RDS MySQL 5.7 to RDS MySQL 8.0 Using Blue/Green Deployment and Readyset (from Readyset Blog)

Moving from MySQL 5.7 to 8.0 boosts performance, but removes Query Cache. Here's how to integrate Readyset with ProxySQL to fill the caching gap. [...]

How Dafiti migrated its most critical database to Amazon Aurora MySQL with minimal downtime and improved operational efficiency (from AWS Database Blog)

In the dynamic world of digital retail, performance, resilience, and availability are not only desirable qualities, they are essential. Recently, Dafiti, a leading fashion and lifestyle ecommerce conglomerate operating in Brazil, Argentina, Chile, and Colombia, undertook a significant transformation of its critical database infrastructure by migrating from self-managed MySQL Server 5.7 on Amazon EC [...]

Celebrating 15 years of innovation (from MariaDB Foundation Blog)

pWe have been in festive mode this week, celebrating fifteen years of MariaDB. You may have seen our very own Ian Gilfillan’s blog MariaDB Server turns fifteen! … /p pContinue reading \"Celebrating 15 years of innovation\"/p pThe post Celebrating 15 years of innovation appeared first on MariaDB.org./p [...]

Amazon Aurora supports rolling upgrades for Operating System upgrades (from AWS What's New)

pAmazon Aurora announced rolling upgrades support for Operating System (OS) upgrades. Aurora now seamlessly upgrades the OS version of Aurora database clusters while maintaining read access to the data when using Aurora cluster or reader endpoint. The feature automatically applies upgrades to a few reader instances at a time so the database can continue serving read traffic for clusters with more t [...]

Tracking Dual Passwords in MySQL (from Percona Database Blog)

♦We already have blog posts about Dual Password in MySQL from Brian Sumpter – Using MySQL 8 Dual Passwords, and from Marco Tusa – MySQL Dual Passwords – How To Manage Them Programmatically Let’s skip the details about dual passwords and focus on tracking password usage. How can we be sure that we are using […] [...]

New JSON format for EXPLAIN (from The Oracle MySQL Blog)

MySQL 8.3 introduced a new JSON format for EXPLAIN reflecting how the execution plan actually is built, allowing for programmatic analysis of plans and executions. [...]

Enhancing MySQL Security: Data-at-Rest Encryption with the Keyring Plugin (from Vettabase)

In this article, we'll explain why encrypting tablespaces and binary logs in MySQL is so important. Do expect step-by-step guidelines and practical examples demonstrating common risks coming with non-encryption. [...]

Support for large transactions in Galera: Taking Streaming Replication for a spin (from Galera Blog)

We have documented streaming replication, and we have also mentioned how you can use streaming replication, and we also once did a webinar with recording on it, and we wrote a very in-depth blog post on how to use streaming replication to manage large transactions with Galera Cluster. However, we had a question recently about […] [...]

Sleuthing resource leaks in Dolt (from DoltHub Blog)

Recently, users running SQL queries against their databases hosted on DoltHub has led us to uncovering some really interesting bugs in Dolt… [...]

Wednesday, 30. October 2024

Celebrating 15 years of MariaDB Server (from MariaDB Corporation Blog)

It is now 15 years since the first MariaDB Server release of MariaDB 5.1.38 on 29’th of October 2009. The … Continued [...]

Celebrating the GitHub Awards 2024 recipients 🎉 (from The GitHub Blog)

pThe GitHub Awards celebrates the outstanding contributions and achievements in the developer community by honoring individuals, projects, and organizations for creating an outsized positive impact on the community./p pThe post Celebrating the GitHub Awards 2024 recipients 🎉 appeared first on The GitHub Blog./p [...]

Using the MySQL “SET ROLE” to Enforce “Least Privilege” Principles (from The Oracle MySQL Blog)

How using SET ROLE can be used to define a “Least Privilege” model for accessing database objects based on a user’s current task. [...]

Tuesday, 29. October 2024

Performance testing MySQL migration environments using query playback and traffic mirroring – Part 3 (from AWS Database Blog)

This is the third post in a series where we dive deep into performance testing of MySQL environments being migrated from on premises. In Part 1, we compared the query playback and traffic mirroring approaches at a high level. In Part 2, we showed how to set up and configure query playback. In this post, we show you how to set up and configure traffic mirroring. [...]

Performance testing MySQL migration environments using query playback and traffic mirroring – Part 2 (from AWS Database Blog)

This is the second post in a series where we dive deep into performance testing MySQL environments being migrated from on premises. In Part 1, we compared the query playback and traffic mirroring approaches at a high level. In this post, we dive into the setup and configuration of query playback. [...]

Performance testing MySQL migration environments using query playback and traffic mirroring – Part 1 (from AWS Database Blog)

In this series of posts, we dive deep into performance testing of MySQL environments being migrated from on-premises to AWS. In this post, we review two different approaches to testing migrated environments with traffic that is representative of real production traffic: capturing and replaying traffic using a playback application, and mirroring traffic as it comes in using a proxy. This means you’r [...]

What’s Next for SQL @ Scale? TiDB’s Vision to Evolve Growing Businesses (from PingCAP Blog)

pScaling database systems remains one of the biggest challenges facing growing companies modernizing IT infrastructure. Max Liu, Co-Founder and CEO of PingCAP, discussed these critical scaling challenges during his opening keynote, “What’s Next for SQL @ Scale,” at HTAP Summit 2024. Drawing from real-world examples and industry insights, Liu explored how TiDB addresses the limitations […]/p p [...]

MariaDB Server turns fifteen! (from MariaDB Foundation Blog)

pFifteen years ago, Internet Explorer made up about two-thirds of all browsers, Firefox the majority of the rest, while a newly-released browser called Chrome was starting to appear in the rankings. … /p pContinue reading \"MariaDB Server turns fifteen!\"/p pThe post MariaDB Server turns fifteen! appeared first on MariaDB.org./p [...]

Use HammerDB to run performance tests on Amazon RDS for Db2 (from AWS Database Blog)

To ensure that you properly size your Amazon RDS for Db2 instances and achieve comparable or better performance than your on-premises systems, you can use HammerDB. By using this tool, you can generate OLTP-type workloads using TPC-C tests, enabling you to compare performance between your on-premises Db2 and Amazon RDS for Db2 systems. This post guides you through running HammerDB tests on RDS for [...]

Amazon RDS for PostgreSQL, MySQL, and MariaDB now supports M7i and R7i database instances (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for PostgreSQL, MySQL, and MariaDB now supports M7i and R7i database (DB) instances. M7i and R7i are the latest Intel based offering and are available with a new maximum instance size of 48xlarge, which brings 50% more vCPU and memory than the maximum size of M6i and R6i instance types.br br M7i and R7i DB instances are available for Amazon RDS for P [...]

preFOSDEM MySQL Belgian Days 2025 – save the dates (from lefred's blog)

As announced yesterday, the MySQL Devroom is back at FOSDEM! For people preparing for their travel to Belgium, we want to announce that the MySQL Belgian Days fringe event will be held on the Thursday and Friday before FOSDEM. This event will take place on January 30th and 31st, 2025, in Brussels at the usual […] [...]

preFOSDEM MySQL Belgian Days 2025 - save the dates (from The Oracle MySQL Blog)

For people to prepare for their travel to Belgium, we want to announce that the preFOSDEM fringe event known as the MySQL Belgian Days will take place the Thursday and Friday, January 30 and 31, before FOSDEM. [...]

MariaDB Server Turns 15! Here Are 15 Reasons Why Developers and DBAs Love It (from MariaDB Corporation Blog)

October 29, 2009 was a special day in the database community—it saw the first release of MariaDB Server. Started as … Continued [...]

Announcing Vitess 21 (from PlanetScale Blog)

Vitess 21 is now generally available. [...]

Announcing Vitess 21 (from Vitess)

Announcing Vitess 21 # We're delighted to announce the release of Vitess 21 along with version 2.14.0 of the Vitess Kubernetes Operator. Version 21 focuses on enhancing query compatibility, improving cluster management, and expanding VReplication capabilities, with experimental support for atomic distributed transactions and recursive CTEs. Key features include reference table materialization, mult [...]

Monday, 28. October 2024

FLUSH_PRIVILEGES: A new dynamic privilege to execute FLUSH PRIVILEGES (from The Oracle MySQL Blog)

MySQL 8.4 introduces a new privilege, FLUSH_PRIVILEGES, which allows database users to execute FLUSH PRIVILEGES statement without the need of RELOAD privilege. [...]

How to use passkeys to authenticate to MySQL (from The Oracle MySQL Blog)

MySQL 9.1 adds support for Windows Hello. And this supports passkeys stored on the OS store. Check how to set up and use one of these instead of the hardware based FIDO2 devices [...]

The MySQL Hypergraph Optimizer Now Available in HeatWave MySQL (from The Oracle MySQL Blog)

Starting with MySQL 9.0, users of HeatWave MySQL can now try the new hypergraph optimizer. Read on to learn how to enable the hypergraph optimizer, and to understand what it means for your query plans. [...]

Impressed by Disabling InnoDB Redo Logging for Creating Tables as Fast as Possible (from J-F Gagné's MySQL Blog)

In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables.  I already wrote a post about my work (Faster MySQL Startup with Many Tables).  In that post, I link to a bug report (Bug #115988 : Too Much Disk Read on Startup, penalizing deployments with many tables).  In that bug report, I write, without much details, that the [...]

MariaDB for SQL Server DBA (from MinervaDB Blog)

pMariaDB for SQL Server DBA - How do you configure MariaDB for Transaction Log Backup? While MariaDB does not offer a native transaction log backup feature comparable to Microsoft SQL Server, it provides an equivalent [...]/p pThe post MariaDB for SQL Server DBA appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB, MongoDB and ClickHouse./p [...]

Abandonware in Popular Open Source Databases (from Percona Database Blog)

♦Inspired by this comment in the Hacker News discussion, I posted polls on my LinkedIn network about the tendency (or perception of tendency) to abandon features without deprecating them in some of the most popular open source databases – MySQL, MariaDB, and PostgreSQL.  First, let’s look at why “Abandoning” features rather than formally depreciating them […] [...]

MySQL NDB Cluster 8.4 - What's new (from The Oracle MySQL Blog)

The MySQL NDB Cluster Development team is quite happy to announce that MySQL NDB Cluster 8.4 (LTS) is available for download. This release includes new features made available before under Innovation Releases - 8.1, 8.2 and 8.3 - and new features made available in 8.4. [...]

MySQL Connector/J Observability with OpenTelemetry (from The Oracle MySQL Blog)

The OpenTelemetry project is an open-source, vendor-neutral observability framework, providing a common observability standard. It enables users to instrument their applications in order to export observability data: traces, metrics, and logs, enabling increased granularity of debugging and testing. MySQL Connector/J now supports producing observability data, baked into the driver code, offering a [...]

FOSDEM 2025 MySQL Devroom - call for participation (from The Oracle MySQL Blog)

This is the call for participation for the FOSDEM 2025 MySQL Devroom [...]

FOSDEM 2025 MySQL Devroom – call for participation (from FOSDEM MySQL & Friends Devroom)

We are pleased to announce the Call for Participation (CfP) for the FOSDEM 2025 MySQL Devroom. The Devroom will be held on February 2 (Sunday), 2025 in Brussels, Belgium. The submission deadline for talk proposals is December 1, 2024. FOSDEM is a free event for software developers to meet, share ideas, and collaborate. Every year, […] [...]

FOSDEM 2025 MySQL Devroom – call for participation (from lefred's blog)

We are pleased to announce the Call for Participation (CfP) for the FOSDEM 2025 MySQL Devroom. The Devroom will be held on February 2 (Sunday), 2025 in Brussels, Belgium. The submission deadline for talk proposals is December 1, 2024. FOSDEM is a free event for software developers to meet, share ideas, and collaborate. Every year, […] [...]

MySQL: information_schema.tables performance regression (from Die wunderbare Welt von Isotopp)

pIn IRC codelibera:#mysql/code somebody asked about the performance of codeSHOW TABLES LIKE 'name'/code in MySQL 8.0, which was slow for them, but fast in 5.7. They pointed to a forum article from 2022 that had a similar problem with a codeselect/code-statement on codeI_S.TABLES/code./p pBoth cases had in common a large number of tables in a single schema. The person in IRC had around 40k tables, [...]

MySQL: dual passwords (from Die wunderbare Welt von Isotopp)

pAccount password rotation is often a regulatory requirement. For that very reason, MySQL allows you to have multiple passwords on a single account./p pI have written about this in Rotating Accounts or Passwords? ./p pOf course, if something is a regulatory requirement, you also need to prove that you are meeting it./p pSo Percona has a nice article Tracking Dual Passwords in MySQL which shows h [...]

Galera : understanding Flow Control (from The consistent voice)

Galera : understanding Flow ControlpAs explained in a previous article Galera cluster from Codership is a robust synchronous multi-master replication technology integrated directly into MariaDB Server. This powerful feature enables high availability and data consistency across multiple database nodes without the need for additional software. This tight integration helps MariaDB users can leverage t [...]

Hello, WeSQL (from WeSQL Blog)

MySQL is a popular open-source database with a large user base. [...]

Friday, 25. October 2024

Understanding PostgreSQL I/O Details (from MinervaDB Blog)

pUnderstanding PostgreSQL I/O Details: A Deep Dive into Monitoring and Optimization Introduction Input/Output (I/O) operations play a critical role in database performance. In PostgreSQL, these operations are fundamental to the efficiency of data retrieval and [...]/p pThe post Understanding PostgreSQL I/O Details appeared first on The WebScale Database Infrastructure Operations Experts in PostgreS [...]

Achieve a high-speed InnoDB purge on Amazon RDS for MySQL and Amazon Aurora MySQL (from AWS Database Blog)

This post outlines a set of design and tuning strategies for a high-speed purge in an Amazon Relational Database Service (Amazon RDS) for MySQL DB instance and Amazon Aurora MySQL-Compatible Edition DB cluster. Purge is a housekeeping operation in a MySQL database. The InnoDB storage engine relies on it to clean up undo logs and delete-marked table records that are no longer needed for multiversion [...]

Amazon Aurora Global Database support for tagging global clusters (from AWS What's New)

pAmazon Aurora Global Database now supports applying tags to your global clusters, enabling you to associate metadata information with your overall Global Database cluster. For instance, you can apply a tag to organize resource costs for your entire Global Database cluster, making it easier to categorize and track your AWS costs.br br Aurora Global Database allows a single Aurora database to span m [...]

Announcing the MariaDB Vector Bounty Program! (from MariaDB Foundation Blog)

pToday, we are excited to announce a new fund to help give MariaDB Vector a high-quality integration into as many LLM frameworks as possible. … /p pContinue reading \"Announcing the MariaDB Vector Bounty Program!\"/p pThe post Announcing the MariaDB Vector Bounty Program! appeared first on MariaDB.org./p [...]

Thursday, 24. October 2024

Updated MariaDB Java, R2DBC, and Node.js Connectors now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Connector/Java 3.5.0, Connector/R2DBC 1.3.0, and Connector/Node.js 3.4.0. Download Now   … Continued [...]

Migrate or upgrade your like-to-like databases using AWS DMS homogeneous migration (from AWS Database Blog)

In this post, we highlight common challenges encountered during homogeneous database migrations and how using AWS DMS homogeneous migration can help address them. [...]

Mastering MySQL Instant DDLs: Enhancing Schema Changes with INSTANT (from MinervaDB Blog)

pMastering MySQL Instant DDLs: Enhancing Schema Changes with INSTANT Algorithm, Monitoring, and Rebuild Strategies In MySQL 8.0.12, a new DDL algorithm called INSTANT was introduced, enabling non-blocking schema changes. Initially, INSTANT DDLs allowed adding a [...]/p pThe post Mastering MySQL Instant DDLs: Enhancing Schema Changes with INSTANT appeared first on The WebScale Database Infrastructur [...]

Recent InnoDB Enhancements that Boost Performance in MariaDB Server (from MariaDB Corporation Blog)

The performance of MariaDB Server has been improved over the years thanks to many enhancements to the InnoDB storage engine … Continued [...]

Automatic Statistics (from DoltHub Blog)

DoltDB is the first relational database that supports Git-like version control primitives like branch, diff, and merge. All our versioning… [...]

Wednesday, 23. October 2024

Evaluating the right fit for your Amazon Aurora workloads: provisioned or Serverless v2 (from AWS Database Blog)

In this post, we cover important concepts of Aurora provisioned and Aurora Serverless v2 databases including cost, performance, features, and how to determine which to use for your workload type. [...]

InnoDB busy-wait loops changed in MySQL 8.0.30 (from Small Datum)

pThis blog post attempts to explain some of the performance regressions that landed in InnoDB with MySQL 8.0.30. I'd rather not try to debug perf regressions long after they arrived but here we are. I assume that most of the problems landing in MySQL 8.0.28+ are also in 8.4 and 9.X, so these are problems the community will be dealing with for a long time.brbrOne blog post that documents the regress [...]

October MySQL Meetups - Recap. (from The Oracle MySQL Blog)

Oct 2024 Meetups Recap [...]

Optimizing PostgreSQL Capacity Planning and Sizing with Default Value Settings (from MinervaDB Blog)

pOptimizing PostgreSQL Capacity Planning and Sizing Through Effective Default Value Settings Establishing default values in PostgreSQL is a crucial component of effective capacity planning and sizing. This practice significantly enhances the database's capacity to manage [...]/p pThe post Optimizing PostgreSQL Capacity Planning and Sizing with Default Value Settings appeared first on The WebScale D [...]

Tuesday, 22. October 2024

Offline mode error improvement (from The Oracle MySQL Blog)

This blog post describes work that landed in MySQL v9.0 and implements generic mechanism to attach key/value attributes to a global system variable, used to improve error messages related to "offline mode". [...]

MySQL Enterprise Edition for Financial Services (from The Oracle MySQL Blog)

MySQL Enterprise Edition enables financial services organizations to thrive in a complex and ever-changing environment. By harnessing its capabilities, these institutions can modernize their operations, protect their data, and unlock new opportunities for growth. Modernize your applications and embrace the future of financial services with MySQL Enterprise Edition. [...]

Zero Downtime: Upgrading MySQL Server in a Tungsten Cluster (from Continuent Blog)

Tungsten Clustering allows for many types of maintenance to happen with no downtime at all. This blog post will explore how to upgrade the actual MySQL Server on all cluster nodes with zero downtime. These same steps may be used to upgrade the MySQL server or patch the OS.Tags: MySQLMariaDBzero downtimeMaintenanceupdateHigh Availability [...]

A MySQL 9.1.0 branch with patches (from Laurynas Biveinis' blog)

p Following-up on the previous MySQL 9.0.0 branch with patches, I have rebased them on 9.1.0: patched-mysql-9.1.0. /p p The set of the patches is the same as for 9.0.0: it improves AddressSanitizer support and fixes/improves clone plugin to support a second transactional storage engine: /p ol liFix for Bug 115120: Provide memory debugging macro implementations for AddressSanitizer./li liFix for Bu [...]

TLS in MySQL NDB Cluster 8.4 with MCM 8.4 (from The Oracle MySQL Blog)

Learn how to enable TLS in MySQL NDB Cluster 8.4 with MySQL NDB Cluster Manager 8.4 [...]

OpenID Connect (Oauth2 - JWT) Authentication Support in MySQL (from The Oracle MySQL Blog)

With MySQL 9.1 we introduce support for OpenID Connect, making secure authentication easier for developers and enterprises alike. [...]

Monday, 21. October 2024

The impact of PGO, LTO and more for MySQL on a small CPU: insert benchmark (from Small Datum)

pThis post has results for the impact of PGO, LTO and other compiler options for MySQL using the Insert Benchmark. I previously shared results like this for sysbench. The PGO builds here were created from profiles captured during sysbench and I am curious to understand whether the benefit from those builds extends to other workloads. /pptl;dr/pp/pulliPGO builds created using sysbench also help [...]

Announcing the PlanetScale vectors public beta (from PlanetScale Blog)

You can now use the vector data type for vector search and storage in your PlanetScale MySQL database. [...]