Planet for the MySQL Community

Json2SQL : a simple RESTful API for MariaDB ^{(from The consistent voice)}

Json2SQL : a simple RESTful API for MariaDBpHi everyone!/ppI’m thrilled to share my latest open-source project on GitHub: Simple RESTful API for MariaDB.brThis project is designed to make it easier than ever to interact with your MariaDB databases through a lightweight, efficient, and easy-to-use RESTful API. Whether you’re building web apps, mobile apps, or automations, this tool provides seamless [...]

Published Friday, 17. January 2025 16:04 • 7 hours ago

What’s the Cost of Counting MySQL Table Rows? ^{(from Percona Database Blog)}

♦What index will be used when you count all rows in a table? Well, the MySQL documentation provides a straightforward answer to this, quoting: InnoDB processes SELECT COUNT(*) statements by traversing the smallest available secondary index unless an index or optimizer hint directs the optimizer to use a different index. If a secondary index is […] [...]

Published Friday, 17. January 2025 15:19 • 8 hours ago

Introducing MariaDB MaxScale 25.01 GA ^{(from MariaDB Corporation Blog)}

As part of the MariaDB Enterprise Platform 2025 launch, we are happy to announce that MariaDB MaxScale 25.01 is also … Continued [...]

Published Thursday, 16. January 2025 16:14 • a day ago

Introducing Vector Search With the Latest Version of MariaDB Enterprise Platform ^{(from MariaDB Corporation Blog)}

We are excited to announce the launch of a new version of MariaDB Enterprise Server that features native support for … Continued [...]

Published Thursday, 16. January 2025 16:14 • a day ago

Announcing New Release of MariaDB Enterprise Platform ^{(from MariaDB Corporation Blog)}

Building on our history of delivering enterprise database solutions, we are launching a new iteration of the MariaDB Enterprise Platform. … Continued [...]

Published Thursday, 16. January 2025 16:14 • a day ago

Percona Everest: An Open Source Solution for MongoDB Sharding and Backups ^{(from Percona Database Blog)}

♦The increase of cloud-native technologies is transforming how we manage databases. Since I stepped into the world of databases and cloud-native technologies, I have encountered several initiatives aimed at developing and optimizing database operations in the cloud, and Kubernetes plays a crucial role in this shift through Operators. While the core concepts and techniques of […] [...]

Published Thursday, 16. January 2025 14:45 • a day ago

ProxySQL Performance Tuning: Unlocking Optimal Database Performance ^{(from ProxySQL Blog)}

pOptimizing database interactions is critical to maintaining operational efficiency. According to Gartner, the global Database Management Systems (DBMS) market is projected to reach $203 billion by 2027, emphasizing the growing need for efficient database management solutions. A McKinsey report further highlights that organizations effectively managing their data can see 20% to 25% productivity gai [...]

Published Thursday, 16. January 2025 07:57 • a day ago

Announcing Vector Indexes ^{(from DoltHub Blog)}

Back in September, we announced that we were looking at adding support for Vectors and Vector Indexes to Dolt. It seems like every SQL… [...]

Published Thursday, 16. January 2025 00:00 • 2 days ago

2024 Recap: Key Innovations and Enhancements in HeatWave MySQL ^{(from The Oracle MySQL Blog)}

2024 was a productive year for HeatWave MySQL product line with many important enhancements in several areas. We achieved critical milestones in areas of availability, disaster recovery, performance, system management, operations and productivity. Let’s take a look some of the key features. [...]

Published Wednesday, 15. January 2025 19:54 • 2 days ago

How MySQL Enterprise Edition Can Help Your Organization Achieve DORA Compliance ^{(from The Oracle MySQL Blog)}

The financial services industry is facing a new regulation: the Digital Operational Resilience Act (DORA). One of the key requirements of DORA is that financial institutions must have a robust riskmanagement framework in place. This framework must identify, assess, and mitigate ICT risks. MySQL Enterprise Edition can help organizations achieve DORA compliance byproviding a number of features that [...]

Published Wednesday, 15. January 2025 19:14 • 2 days ago

Using Azure Automation PowerShell runbooks with MySQL flexible servers ^{(from Azure for MySQL Blog)}

pYou can use Azure Automation PowerShell runbooks to automate several operations on Azure Database for MySQL flexible servers, which can help to optimize costs and streamline resource management and data management. By leveraging runbooks, you can schedule these operations to occur during off-peak hours or trigger them based on events. Using automation eliminates the need for manual intervention an [...]

Published Wednesday, 15. January 2025 18:31 • 2 days ago

On the results from the replication poll ^{(from MariaDB Foundation Blog)}

pHere are the results of a recent poll on LinkedIn and mariadb.org about the popularity of a few of the major replication features (I aggregated the results from the two sites):br What is your favorite MariaDB replication feature? … /p pContinue reading \"On the results from the replication poll\"/p pThe post On the results from the replication poll appeared first on MariaDB.org./p [...]

Published Wednesday, 15. January 2025 16:16 • 2 days ago

MySQL cloud services cost comparison: who provides the best value? ^{(from The Oracle MySQL Blog)}

This blog shows how HeatWave MySQL delivers substantially more value than the MySQL cloud services offered by AWS, Google Cloud, and Azure. Furthermore, not only can you power your OLTP applications using HeatWave MySQL but you also get built-in lakehouse-scale analytics, generative AI, and machine learning at no additional cost [...]

Published Tuesday, 14. January 2025 23:41 • 3 days ago

TiDB’s Chat2Query: Instant Business Insights, No SQL Required ^{(from PingCAP Blog)}

pWhat if you could interact with your data just like you would with a colleague? No need for complicated SQL queries or advanced data analysis tools—just ask your data a question and get an immediate, clear answer. Sounds like magic, right? Well, it’s not. It’s TiDB’s Chat2Query, and it’s changing the game in how businesses […]/p pThe post TiDB’s Chat2Query: Instant Business Insights, N [...]

Published Tuesday, 14. January 2025 22:48 • 3 days ago

It’s all about the attitude ^{(from The consistent voice)}

pMy professional journey in an MLM network has been a transformative experience, deepening my understanding of soft skills, personal growth, and leadership. Through this path, I’ve gained valuable insights from figures like Michael Jordan, John Maxwell, Tony Robbins, and Richard Branson. Their teachings on resilience, communication, and intentional leadership have shaped my approach to leadership — [...]

Published Tuesday, 14. January 2025 19:00 • 3 days ago

Automating cherry-picks between OSS and private forks ^{(from PlanetScale Blog)}

Learn how PlanetScale keeps its private fork of Vitess up-to-date with OSS [...]

Published Tuesday, 14. January 2025 00:00 • 4 days ago

Dissecting an Extreme Sparse MySQL Table Using ibdNinja ^{(from Zhao Song's Blog)}

I previously wrote a blog post to introduce the concept of MySQL B+ Tree splits and explained how to deliberately construct a highly sparse table by hacking the current rules. Then in the next post, I introduced ibdNinja, a tool I developed to parse the MySQL data file. In this follow-up post, I demonstrate how to use ibdNinja to analyze and verify this table’s data file. [...]

Published Tuesday, 14. January 2025 00:00 • 4 days ago

Evaluating vector indexes in MariaDB and pgvector: part 2 ^{(from Small Datum)}

pThis post has results from the ann-benchmarks with the fashion-mnist-784-euclidean dataset for MariaDB and Postgres (pgvector) with concurrent queries (--batch). My previous post has results when not using concurrent queries. This work was done by Small Datum LLC and sponsored by the MariaDB Corporation./ppI compare MariaDB with pgvector because I respect the work that the Postgres commu [...]

Published Monday, 13. January 2025 23:47 • 4 days ago | Updated Monday, 13. January 2025 23:59 • 4 days ago

Evaluating vector indexes in MariaDB and pgvector: part 1 ^{(from Small Datum)}

pThis post has results for vector index support in MariaDB and Postgres. I am new to vector indexes so I will start small and over time add more results. This work was done by Small Datum LLC and sponsored by the MariaDB Corporation.brbrI compare MariaDB with pgvector because I respect the work that the Postgres community has done to support vector search workloads. And I am happy to report t [...]

Published Sunday, 12. January 2025 23:59 • 5 days ago | Updated Monday, 13. January 2025 23:59 • 4 days ago

Using Airbyte to migrate data to Oracle HeatWave on OCI ^{(from The Oracle MySQL Blog)}

Explore open source ETL tool, Airbyte to synchronise data from various data sources such as cloud database (AWS, Azure, GCP) or on-premises databases (MySQL, PostgreSQL, etc) to Oracle HeatWave on OCI. [...]

Published Monday, 13. January 2025 23:36 • 4 days ago

How can you implement Inline view in MariaDB? ^{(from MinervaDB Blog)}

pAn inline view in MariaDB is implemented as a subquery in the FROM clause that acts as a virtual table. The key requirement is that every inline view must have an alias. Basic Syntax Key [...]/p pThe post How can you implement Inline view in MariaDB? appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB, MongoDB and ClickHouse./p [...]

Published Monday, 13. January 2025 20:05 • 4 days ago

The Power of MySQL: What Makes It the World’s Favorite Database? ^{(from The Oracle MySQL Blog)}

The 2024 JetBrains Developer Ecosystem Report reaffirms what millions of developers already know—MySQL is the #1 database. According to the report, "MySQL continues to be the most widely used database, favored by developers across various domains for its reliability and ease of use. [...]

Published Monday, 13. January 2025 17:28 • 4 days ago

Recap of the MySQL Community Advent Calendar 2024 Posts ^{(from The Oracle MySQL Blog)}

Advent Calendar Recap 2024 [...]

Published Monday, 13. January 2025 14:56 • 4 days ago

Scaling Database Connections ^{(from WeSQL Blog)}

Have you ever wonder why do databases limit the maximum number of connections? [...]

Published Monday, 13. January 2025 00:00 • 5 days ago

Gaining Actionable Insights: Complex Data Analysis Made Simple with TiInsight ^{(from PingCAP Blog)}

pIn today’s fast-paced business world, quick, data-driven decisions are crucial. However, for many, data analysis can seem daunting, especially without the technical skills to navigate complex databases. That’s where TiInsight shines: an intuitive and innovative platform built with the Chat2Query OpenAPI, designed to allow you to gain clear, actionable insights from complex data. An open-source [&# [...]

Published Friday, 10. January 2025 19:05 • 7 days ago

Amazon RDS for MariaDB supports Innovation Release 11.7 in Amazon RDS Database Preview Environment ^{(from AWS What's New)}

pAmazon RDS for MariaDB now supports MariaDB Innovation Release 11.7 in the Amazon RDS Database Preview Environment, allowing you to evaluate the latest Innovation Release on Amazon RDS for MariaDB. You can deploy MariaDB 11.7 in the Amazon RDS Database Preview Environment that has the benefits of a fully managed database, making it simpler to set up, operate, and monitor databases.br br MariaDB 11 [...]

Published Friday, 10. January 2025 18:00 • 7 days ago

Indexing to optimize Data Ingestion in MongoDB ^{(from MinervaDB Blog)}

pWhat are the best indexing strategies for improving data ingestion speed in MongoDB? To improve data ingestion speed in MongoDB, it’s essential to implement carefully considered indexing strategies that balance write performance with query efficiency. [...]/p pThe post Indexing to optimize Data Ingestion in MongoDB appeared first on The WebScale Database Infrastructure Operations Experts in [...]

Published Friday, 10. January 2025 17:57 • 7 days ago

Sysbench performance over time for InnoDB and MyRocks: part 4 ^{(from Small Datum)}

pThis is part 4 in my (possibly) final series on performance regressions in MySQL using cached sysbench as the workload. For previous posts, see part 1, part 2 and part 3. This post covers performance differences between InnoDB in upstream MySQL 8.0.32, InnoDB in FB MySQL 8.0.32 and MyRocks in FB MySQL 8.0.32 using a server with 32 cores and 128G of RAM.brbrI don't claim that th [...]

Published Friday, 10. January 2025 00:33 • 8 days ago | Updated Friday, 10. January 2025 17:19 • 7 days ago

Kickstart Your Distributed SQL Journey: Setting Up TiDB Locally with TiUP Playground ^{(from PingCAP Blog)}

pTiDB is a powerful, open-source distributed SQL database built for handling both transactional and analytical workloads. With its MySQL compatibility, horizontal scalability, and real-time HTAP capabilities, it’s designed for modern, cloud-native architectures. In this distributed SQL tutorial, we’ll walk you through setting up a local TiDB cluster for development and testing in just a few [ [...]

Published Friday, 10. January 2025 16:31 • 7 days ago

Oracle to PostgreSQL Migration Series – NoValidate and Parallel Constraints in PostgreSQL ^{(from MinervaDB Blog)}

pCan you implement NoValidate and Parallel Constraints in PostgreSQL? Oracle to PostgreSQL Migration Blog series PostgreSQL does not have a direct equivalent to Oracle’s NOVALIDATE option for constraints. However, there are some strategies to achieve [...]/p pThe post Oracle to PostgreSQL Migration Series – NoValidate and Parallel Constraints in PostgreSQL appeared first on The WebScale [...]

Published Friday, 10. January 2025 08:36 • 8 days ago

Sysbench performance over time for InnoDB and MyRocks: part 3 ^{(from Small Datum)}

pThis is part 3 in my (possibly) final series on performance regressions in MySQL using cached sysbench as the workload. For previous posts, see part 1 and part 2. This post covers performance differences between InnoDB in upstream MySQL 8.0.32, InnoDB in FB MySQL 8.0.32 and MyRocks in FB MySQL 8.0.32 using a server with 24 cores and 64G of RAM.brbrI don't claim that the MyRocks CPU overhead i [...]

Published Thursday, 09. January 2025 23:57 • 8 days ago | Updated Friday, 10. January 2025 02:02 • 8 days ago

Sysbench performance over time for InnoDB and MyRocks: part 2 ^{(from Small Datum)}

pThis is part 2 in my (possibly) final series on performance regressions in MySQL using cached sysbench as the workload. Part 1 of this series is here. Part 1 documents performance regressions from MySQL 5.6 to 8.0. This post and the ones that follow cover performance differences between InnoDB in upstream MySQL 8.0.32, InnoDB in FB MySQL 8.0.32 and MyRocks in FB MySQL 8.0.32./ppI don't claim that [...]

Published Thursday, 09. January 2025 20:24 • 8 days ago | Updated Friday, 10. January 2025 00:02 • 8 days ago

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 [...]

Published Thursday, 09. January 2025 19:45 • 8 days ago

Vacasa’s migration to Amazon Aurora for a more efficient Property Management System ^{(from AWS Database Blog)}

Vacasa is North America’s leading vacation rental management platform, revolutionizing the rental experience with advanced technology and expert teams. In the competitive short-term vacation property management industry, efficient systems are critical. To maintain its edge and continue providing top-notch service, Vacasa needed to modernize its primary transactional database to improve performance, [...]

Published Thursday, 09. January 2025 19:12 • 8 days ago

PCI DSS 4.0 Compliance and MySQL ^{(from The Oracle MySQL Blog)}

PCI DSS 4.0 Compliance and MySQL [...]

Published Thursday, 09. January 2025 17:58 • 8 days ago

Embrace simplicity ^{(from The consistent voice)}

pThe evolution of software architecture has seen a significant shift from traditional spaghetti monoliths to more distributed and flexible approaches. Initial tightly-coupled monolithic systems, often characterized by complex interdependencies were rather difficult to maintain and a nightmare to scale. This lack of flexibility and fault isolation prompted the development of Service-Oriented Archite [...]

Published Thursday, 09. January 2025 16:48 • 8 days ago

How To Detect Account Intruders Using AWS CloudTrail ^{(from Continuent Blog)}

Securing your cloud environment is now more critical than ever. As organizations increasingly rely on cloud platforms like Amazon Web Services (AWS), the potential for security breaches and unauthorized access becomes a pressing concern. AWS CloudTrail is a powerful tool that can help you monitor and detect suspicious activities in your AWS account. This blog post will guide you through the process [...]

Published Thursday, 09. January 2025 13:15 • 8 days ago

preFOSDEM MySQL Belgian Days 2025 – Agenda ^{(from lefred's blog)}

The preFOSDEM MySQL Belgian Days 2025 will occur at the usual place (ICAB Incubator, Belgium, 1040 Bruxelles) on Thursday, January 30th, and Friday, January 31st, just before FOSDEM. Again this year, we will have the chance to have incredible sessions from our Community and the opportunity to meet some MySQL Engineers from Oracle. DimK will […] [...]

Published Thursday, 09. January 2025 08:49 • 9 days ago

preFOSDEM MySQL Belgian Days 2025 - Agenda ^{(from The Oracle MySQL Blog)}

This is the agenda of the preFOSDEM MySQL Belgian Days 2025, an Oracle MySQL technical event managed by the MySQL Community Team for customers, partners & community users. [...]

Published Thursday, 09. January 2025 08:30 • 9 days ago

Sysbench performance over time for InnoDB and MyRocks: part 1 ^{(from Small Datum)}

pI spent much time in 2024 documenting performance regressions from old to new versions of MySQL with InnoDB and MyRocks. More posts will be published in 2025, including this sequence of posts, but my work on that is winding down. Most of the problems are from many small regressions rather than a few big ones and it is very expensive to find and fix regressions long after they arrive.brbrHopefully [...]

Published Thursday, 09. January 2025 03:03 • 9 days ago | Updated Thursday, 09. January 2025 03:03 • 9 days ago

Database Sharding ^{(from PlanetScale Blog)}

Learn about the database sharding scaling pattern in this interactive blog. [...]

Published Thursday, 09. January 2025 00:00 • 9 days ago

Attaching a Percona Monitoring and Management Graph Image Along with an Alerting Notification ^{(from Percona Database Blog)}

♦This article will be helpful if you use the Percona Monitoring and Management (PMM) instance and alert notifications, as it is nice to capture the image of the graph when you receive the alert. We will see how to capture and attach the image of the graph when receiving the alert notification (email, telegram, Slack, […] [...]

Published Wednesday, 08. January 2025 14:38 • 9 days ago

Best 7 DBVisualizer Alternatives ^{(from Devart MySQL Tool Blog)}

pDiscover why dbForge Edge is the top DBVisualizer or DBeaver alternative for database management. Learn how dbForge Edge surpasses DBVisualizer and DBeaver in functionality and efficiency./p pThe post Best 7 DBVisualizer Alternatives appeared first on Devart Blog./p [...]

Published Wednesday, 08. January 2025 10:27 • 10 days ago

Tracking MySQL Query Plans Part I and Rebooting This Blog ^{(from PHP With MySQL)}

pDid you ever need to determine the performance of a query over time? One of the problems with database query optimizations is that the underlying data is always churning. Add in an increase in the number of users, expanding server demand use, and other items that impact your query. What was optimized is no longer performing as expected./ppMySQL added a JSON format option to the output of the EXPLA [...]

Published Monday, 06. January 2025 15:51 • 11 days ago | Updated Tuesday, 07. January 2025 20:51 • 10 days ago

Easier Oracle to MariaDB Migrations with sql_mode and DBeaver ^{(from MariaDB Corporation Blog)}

If you’re considering migrating from Oracle to MariaDB, you need to know the sql_mode configuration property in MariaDB as well … Continued [...]

Published Tuesday, 07. January 2025 16:50 • 10 days ago

MySQL with Diagrams Part Two: How KILL Works ^{(from Percona Database Blog)}

♦Here is part two of my MySQL with Diagrams series (Here’s part one – MySQL with Diagrams Part One: Replication Architecture). We are going to explore how MySQL handles thread termination using the KILL command, as visualized in the provided diagram, and provide sample demonstrations to help you better understand. Many people think they know […] [...]

Published Tuesday, 07. January 2025 14:23 • 10 days ago

December Product Update ^{(from Readyset Blog)}

Discover Readyset's December highlights: MySQL demo launch, product updates, AWS re:Invent recap, and upcoming events to kick off 2025! [...]

Published Monday, 06. January 2025 18:00 • 11 days ago

MySQL 8.4.3 and 9.1.0: Major Performance Gains Revealed ^{(from Percona Database Blog)}

♦At Percona, we’ve always prioritized performance, and recent trends in MySQL’s development have been a point of concern for us. In particular, the performance deterioration in the MySQL 8.4.x and 9.y versions caught our attention, as highlighted in Marco Tusa’s insightful blog post, Sakila, Where Are You Going? We’re pleased to report that the latest […] [...]

Published Monday, 06. January 2025 15:17 • 11 days ago

MySQL 8.4 Support in Percona Toolkit 3.7.0 ^{(from Percona Community Blog)}

Percona Toolkit 3.7.0 has been released on Dec 23, 2024. The main feature of this release is MySQL 8.4 support. In this blog, I will explain what has been changed. A full list of improvements and bug fixes can be found in the release notes. TLDR; Replication statements in 8.4 are fully supported by the Percona Toolkit pt-slave-delay has been deprecated. pt-slave-find has been renamed to pt-replica- [...]

Published Monday, 06. January 2025 00:00 • 12 days ago

ibdNinja: A powerful tool for parsing and analyzing MySQL 8.0 (.ibd) data files ^{(from Zhao Song's Blog)}

MySQL 8.0 introduced instant add column and instant drop column operations, allowing multiple data formats to exist within the same table. This added complexity makes developing external tools for record-level parsing and analysis of MySQL .ibd files more complex compared to versions 5.6 and 5.7. Additionally, MySQL Server lacks robust mechanisms for detailed table usage statistics, such as accurat [...]

Published Monday, 06. January 2025 00:00 • 12 days ago

Mastering Transaction Management in InnoDB: Optimizing COMMIT, ROLLBACK, and SAVEPOINT for Performance and Integrity ^{(from MinervaDB Blog)}

pImplementing COMMIT, ROLLBACK, and SAVEPOINT in InnoDB for Optimal Performance Transaction management is a fundamental aspect of relational database systems, and InnoDB provides robust support for transactions. Effective use of COMMIT, ROLLBACK, and SAVEPOINT can significantly improve data integrity [...]/p pThe post Mastering Transaction Management in InnoDB: Optimizing COMMIT [...]

Published Friday, 03. January 2025 19:41 • 14 days ago

Querying and writing to MySQL and MariaDB from Amazon Aurora and Amazon RDS for PostgreSQL using the mysql_fdw extension, Part 2: Handling foreign objects ^{(from AWS Database Blog)}

In this post, we focus on working with the features of mysql_fdw PostgreSQL extension on Amazon RDS for PostgreSQL to help manage a large set of data that on an external database scenarios. It enables you to interact with your MySQL database for importing individual/large/selectively number of objects at the schema level and simplifying how we get information about the MySQL/MariaDB schema, to make [...]

Published Thursday, 02. January 2025 19:48 • 15 days ago

Reflections on a year of biking for 2024 ^{(from Jeremy Cole)}

Since shortly after moving to Seattle in July 2022, I have not driven a car. I’ve gotten around by bike and public transit. During 2023, I stayed mostly in the Seattle region, with the exception of a trip to Victoria BC for Tour de Victoria and back to Seattle by bike. In the fall of […] [...]

Published Thursday, 02. January 2025 02:00 • 16 days ago

Dolt MySQL Differences ^{(from DoltHub Blog)}

Here at DoltHub, we tell users "Dolt is a drop in replacement for MySQL". We're also quick to remind users that "There is no MySQL code in… [...]

Published Thursday, 02. January 2025 00:00 • 16 days ago

MariaDB highlights in 2024: Vectors, K1, and contributions ^{(from MariaDB Foundation Blog)}

pNew Year’s Eve is when everyone takes stock of the year that has passed. At MariaDB Foundation, we’re no different.br The technical highlight: MariaDB Vectorbr It’s not hard to pick the technical MariaDB highlight of the year: It’s MariaDB Vector. … /p pContinue reading \"MariaDB highlights in 2024: Vectors, K1, and contributions\"/p pThe post MariaDB highlights in 20 [...]

Published Tuesday, 31. December 2024 11:01 • 18 days ago

What we’ve developed in 2024 ^{(from MariaDB Foundation Blog)}

pAs Chief Development Officer of the MariaDB Foundation, I’ve worked to ensure that our development efforts focus where they matter most. On this final day of 2024, I want to reflect on the significant technical achievements we’ve accomplished and the collaborative processes that made them possible. … /p pContinue reading \"What we’ve developed in 2024\"/p pThe post What we’ve dev [...]

Published Tuesday, 31. December 2024 09:52 • 18 days ago

A Beginner’s Guide to Database Sharding: How to Scale Your Database Effectively ^{(from ProxySQL Blog)}

pAs businesses grow, so do their data needs. A small application that once handled a few users can quickly evolve into a system that supports thousands—or even millions—of transactions daily. According to IDC, the global volume of data is predicted to reach 175 zettabytes by 2025, putting immense pressure on database systems to manage [...]/p pThe post A Beginner’s Guide to Database Sharding: How [...]

Published Monday, 30. December 2024 17:52 • 18 days ago

Multitenant data management with TiDB ^{(from InfoWorld)}

pIn a previous article, we explored various approaches to managing data for multitenant applications. We examined the benefits, compromises and limitations of different deployment models, including share-nothing, share-everything, and hybrid. We discussed the needs and challenges of each approach, from ensuring data isolation and scalability to managing customized tenant requ [...]

Published Monday, 30. December 2024 09:00 • 19 days ago

MySQLTuner for Windows: Common Issues and Better Alternatives ^{(from Releem Blog)}

In this article, we'll cover the specific hurdles you might encounter with MySQLTuner on Windows, explore some viable alternatives for optimizing your database performance with ease. [...]

Published Monday, 30. December 2024 01:59 • 19 days ago

Dolt Wrapped 2024: A Year in Review ^{(from DoltHub Blog)}

Spotify Wrapped popularized a version of the "year in review" format. Now everything is "wrapped". Why can't Dolt be wrapped too? Turns out… [...]

Published Monday, 30. December 2024 00:00 • 19 days ago

Speedb vs RocksDB on a large server ^{(from Small Datum)}

pI am happy to read about storage engines that claim to be faster than RocksDB. Sometimes the claims are true and might lead to ideas for making RocksDB better. I am wary about evaluating such claims because that takes a lot of time and when the claim is bogus I am reluctant to blog about that because I don't want to punch down on a startup.brbrHere I share results from the RocksDB benchmark script [...]

Published Friday, 27. December 2024 01:14 • 22 days ago | Updated Sunday, 29. December 2024 19:58 • 19 days ago

Monitoring Multi-threaded Replication Lag With Performance Schema ^{(from Hack MySQL)}

pUsed to be that replication lag was as simple as codeSeconds_Behind_Master/code (renamed to codeSeconds_Behind_Source/code). But with multi-threaded replication (MTR) this is no longer the case. It’s time to relearn replication lag monitoring using Performance Schema tables./p [...]

Published Sunday, 29. December 2024 01:07 • 20 days ago

Preventing MySQL Binary Log Sequence Number Exhaustion ^{(from Mydbops Blog)}

Manage MySQL binary log sequence numbers to prevent outages. This blog discusses the importance of binary logs, risks of sequence number exhaustion, and monitoring strategies to keep your database running. [...]

Published Saturday, 28. December 2024 17:44 • 20 days ago

What do you expect from vector storage in databases? ^{(from MariaDB Foundation Blog)}

pWe’re no mind readers, so from time to time, we like to do polls. Polls are quantitative in nature, so coming up with the right question is not enough – … /p pContinue reading \"What do you expect from vector storage in databases?\"/p pThe post What do you expect from vector storage in databases? appeared first on MariaDB.org./p [...]

Published Saturday, 28. December 2024 11:33 • 20 days ago

IBM upgrading Gold to Platinum ^{(from MariaDB Foundation Blog)}

pGood news: IBM is upgrading their Gold sponsorship to Platinum!br Our trinity: Adoption, Openness, Continuitybr The three pillars of MariaDB Foundation are Adoption, Openness, and Continuity. … /p pContinue reading \"IBM upgrading Gold to Platinum\"/p pThe post IBM upgrading Gold to Platinum appeared first on MariaDB.org./p [...]

Published Friday, 27. December 2024 13:13 • 21 days ago

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

Dolt is a drop in-replacement for MySQL, which means it can be used with any MySQL-compatible tool. One such tool is Dolphie, a real-time… [...]

Published Friday, 27. December 2024 00:00 • 22 days ago

Thoughts on ScyllaDB License Change ^{(from Peter Zaitsev)}

pAs you may have heard, ScyllaDB is moving to a Source Available License. Seeing this move from so many companies from MongoDB to Redis should not surprise everyone. This is what happens to “corporate-owned” Open Source Software these days. Yet it is interesting to explore ScyllaDB’s situation in more detail. First, I think ScyllaDB’s license […]/p pThe post Thoughts on ScyllaDB License Chang [...]

Published Thursday, 26. December 2024 08:15 • 23 days ago

Host Database Serverlessly On AWS Fargate - Just Like Your Applications ^{(from WeSQL Blog)}

Running a database in the cloud often means paying for idle capacity and dealing with persistent storage overhead. AWS ECS + Fargate changes that equation by letting you pay only for actual compute time and seamlessly integrate with S3 for storage, effectively separating compute from data. This guide shows you how to host a MySQL-compatible database (WeSQL) using Fargate’s pay-as-you-go model while [...]

Published Thursday, 26. December 2024 00:00 • 23 days ago

A Message From the Community Team ^{(from The Oracle MySQL Blog)}

For the final day of our Advent Calendar of Content, we bring you a message from the Community Team. [...]

Published Tuesday, 24. December 2024 05:00 • 25 days ago

MySQL enters a new decade! ^{(from The Oracle MySQL Blog)}

For this penultimate article before Christmas, let's announce the 30th anniversary of MySQL! [...]

Published Monday, 23. December 2024 09:00 • 26 days ago

Resolving MySQL Binlog Errors and Reclaiming Disk Space ^{(from Mydbops Blog)}

Learn how to troubleshoot and resolve MySQL binlog errors like 'Target log not found in binlog index' to free up valuable disk space. [...]

Published Monday, 23. December 2024 08:57 • 26 days ago

10% Slower Than MySQL ^{(from DoltHub Blog)}

Four years ago DoltDB was about 15x slower than MySQL. At the time, we faced skepticism regarding Prolly-tree performance and scalability… [...]

Published Monday, 23. December 2024 00:00 • 26 days ago

Troubleshooting and Resolving AUTO_INCREMENT Max Value Issues in MySQL and MariaDB ^{(from MinervaDB Blog)}

pTroubleshooting and Resolving AUTO_INCREMENT Max Value Issues in MySQL and MariaDB Troubleshooting AUTO_INCREMENT Max Value Problems in MySQL and MariaDB involves addressing issues related to hitting the maximum value of an AUTO_INCREMENT column. This can [...]/p pThe post Troubleshooting and Resolving AUTO_INCREMENT Max Value Issues in MySQL and MariaDB appeared first on The WebScale Database Inf [...]

Published Sunday, 22. December 2024 19:10 • 26 days ago

Resource Semaphore Mechanisms in InnoDB ^{(from MinervaDB Blog)}

pInnoDB Synchronization Mechanisms: Understanding Semaphore-Like Constructs for Concurrency Management InnoDB employs various synchronization mechanisms to manage concurrency and resource allocation, which function similarly to resource semaphores. While the term "resource semaphore" is not explicitly used [...]/p pThe post Resource Semaphore Mechanisms in InnoDB appeared first on The WebScale Data [...]

Published Sunday, 22. December 2024 18:52 • 26 days ago

MySQL Blog Revisited - OCI TypeScript SDK ^{(from The Oracle MySQL Blog)}

For the 22nd day of our Advent Calendar of Content, we bring you a summary of all the MySQL Blog posts that demonstrate using the OCI TypeScript SDK [...]

Published Sunday, 22. December 2024 05:00 • 27 days ago

MySQL Shorts Revisited - DBA Goodies ^{(from The Oracle MySQL Blog)}

For the 21st day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are focussed on topics that would interest DBAs. [...]

Published Saturday, 21. December 2024 05:00 • 28 days ago

Resolving MySQL Error 1412 and Understanding Transaction Isolation Levels ^{(from MinervaDB Blog)}

pResolving MySQL Error 1412 and Understanding Transaction Isolation Levels Understanding MySQL Transaction Error 1412 and Isolation Levels Error 1412: "Table definition has changed, please retry transaction" MySQL Error 1412 occurs when a transaction attempts to [...]/p pThe post Resolving MySQL Error 1412 and Understanding Transaction Isolation Levels appeared first on The WebScale Database Infras [...]

Published Friday, 20. December 2024 18:59 • 28 days ago

Amazon RDS for MariaDB supports minors 11.4.4, 10.11.10, 10.6.20, 10.5.27 ^{(from AWS What's New)}

pAmazon Relational Database Service (Amazon RDS) for MariaDB now supports MariaDB minor versions 11.4.4, 10.11.10, 10.6.20, and 10.5.27. 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 [...]

Published Friday, 20. December 2024 18:00 • 28 days ago

MariaDB Day Sat 1 Feb 2025 in Brussels ^{(from MariaDB Foundation Blog)}

pWe have the date, we have the place , we have the theme! So we ask you to save the date.br Date: Saturday 1 Feb 2025 (10:00-17:00)br Place: Brussels, SQ Lily-Rose, Avenue Arnaud Fraiteur 15-23, close to FOSDEMbr Theme: Vectors, RAG and all things new in MariaDB Serverbr Registration: Please register here with Meetupbr With the Open Source community convening for FOSDEM, we have noted Brussels duri [...]

Published Friday, 20. December 2024 17:15 • 28 days ago

MySQL Transaction ERROR 1412 and Isolation Levels ^{(from Percona Database Blog)}

♦This blog post explains the cause of “ERROR 1412 (HY000): Table definition has changed, please retry transaction” with the specific Isolation level settings. Background As per the MySQL documentation, this error should occur for “operations that make a temporary copy of the original table and delete the original table when the temporary copy is built.” […] [...]

Published Friday, 20. December 2024 14:09 • 28 days ago

Revolutionizing Loyalty Programs: Rakuten’s Journey to Distributed SQL ^{(from PingCAP Blog)}

pAchieving a balance between scalability and operational efficiency has become a defining challenge for data-driven businesses. At HTAP Summit 2024, Alex Bai, Engineering Manager at Rakuten, and Tim Liu, Engineering Lead, shared their journey of overcoming the limitations of traditional databases like Apache Cassandra and MySQL to meet the demands of high-traffic platforms and critical […]/p [...]

Published Friday, 20. December 2024 11:19 • 28 days ago

MySQL Retrospective - ISAM & MySAM Log ^{(from The Oracle MySQL Blog)}

Let's stay a bit longer with MySQL 3.2x to advance the MySQL Retrospective in anticipation of the 30th Anniversary. [...]

Published Friday, 20. December 2024 10:00 • 29 days ago

MySQL Retrospective – ISAM & MyISAM Log ^{(from lefred's blog)}

Let’s stay a bit longer with MySQL 3.2x to advance the MySQL Retrospective in anticipation of the 30th Anniversary. The idea of this article was suggested to me by Daniël van Eeden. Did you know that in the early days, and therefore still in MySQL 3.20, MySQL used the ISAM storage format? IBM introduced the […] [...]

Published Friday, 20. December 2024 09:04 • 29 days ago

Transition from AWS DMS to zero-ETL to simplify real-time data integration with Amazon Redshift ^{(from AWS Database Blog)}

The zero-ETL integrations for Amazon Redshift are designed to automate data movement into Amazon Redshift, eliminating the need for traditional ETL pipelines. With zero-ETL integrations, you can reduce operational overhead, lower costs, and accelerate your data-driven initiatives. This enables organizations to focus more on deriving actionable insights and less on managing the complexities of data [...]

Published Thursday, 19. December 2024 20:16 • 29 days ago

RDS Performance Insights Alternative for MySQL Monitoring ^{(from Releem Blog)}

Looking for RDS Performance Insights alternative? Compare Releem and RDS Performance Insights for monitoring and tuning MySQL [...]

Published Thursday, 19. December 2024 18:49 • 29 days ago

Amazon RDS Proxy announces caching_sha2_password authentication support for MySQL on Aurora and RDS ^{(from AWS What's New)}

pAmazon RDS Proxy announces caching_sha2_password authentication plugin support for client to proxy connections on MySQL on Aurora and RDS.br br Customers need to use plugins to perform authentication between databases and clients while using RDS Proxy. Starting with MySQL 8.4, community MySQL uses caching_sha2_password plugin as the default, which is more secure than the previous default plugins. [...]

Published Thursday, 19. December 2024 18:00 • 29 days ago

Percona XtraBackup 101: Decompress and Decrypt or Decrypt and Decompress? ^{(from Percona Database Blog)}

♦This blog is not intended to offer anything extraordinary; instead, consider it an anecdote, a lesson, or simply a proper way of doing things without the need to run a test when in doubt. That said, I must emphasize that, as always, testing everything before deploying to production is essential. Let’s dive into the story: […] [...]

Published Thursday, 19. December 2024 17:00 • 29 days ago

Building for Scale: The Blueprint for Distributed SQL Databases That Meet Modern Demands ^{(from PingCAP Blog)}

pWelcome to the Distributed SQL Era: What AWS’s Entry Means for You Modern applications are pushing the boundaries of what databases can handle. As businesses expand, they face unprecedented demands—hyper-scaling applications, global deployments, and real-time responsiveness—that traditional databases simply weren’t designed to meet. Distributed SQL databases have emerged as a blueprint for success [...]

Published Thursday, 19. December 2024 15:18 • 29 days ago

Indexing code at scale with Glean ^{(from Engineering at Meta)}

pWe’re sharing details about Glean, Meta’s open source system for collecting, deriving, and working with facts about source code. In this blog post we’ll talk about why a system like Glean is important, explain the rationale for Glean’s design, and run through some of the ways we’re using Glean to supercharge our developer tooling at [...]/p pRead More.../p pThe post Indexing code at scale with Gle [...]

Published Thursday, 19. December 2024 14:00 • 29 days ago

MariaDB Galera Cluster with MariaDB MaxScale – Getting Started with Read Write Split ^{(from Galera Blog)}

MariaDB Galera Cluster is a synchronous multi-master database cluster solution that provides MariaDB high availability and data consistency. MariaDB MaxScale is a database proxy that can be used to improve the performance, scalability, and security of MariaDB Galera Cluster. Codership (the makers of Galera Cluster) have a long term partnership with MariaDB Corporation, including joint […] [...]

Published Thursday, 19. December 2024 09:47 • 30 days ago

Inside MySQL: Sakila Speaks - Season 2 Begins ^{(from The Oracle MySQL Blog)}

The second season of the podcast Inside MySQL: Sakila Speaks has begun. In the first episode, Fred and Scott discuss how they got started with MySQL and some of their favorite features. [...]

Published Thursday, 19. December 2024 05:00 • 30 days ago

Navigating Business Growth: How TiDB Scales Petabyte-Level Data Volumes ^{(from PingCAP Blog)}

pBusiness growth is an exciting milestone, bringing more users, transactions, and opportunities to innovate. However, with growth comes significant technical challenges, such as: In this blog, we’ll explore how TiDB, an open-source distributed SQL database, addresses these business growth challenges. We’ll also walk through real-world examples from companies such as Bolt and Flipkart. B [...]

Published Wednesday, 18. December 2024 22:01 • 1 months ago

Amazon RDS for MySQL supports Innovation Release version 9.1 in Amazon RDS Database Preview Environment ^{(from AWS What's New)}

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

Published Wednesday, 18. December 2024 19:55 • 1 months ago

MySQL Telemetry: OpenTelemetry Logging ^{(from The Oracle MySQL Blog)}

OpenTelemetry provides a standard for transferring observability data. MySQL has already added support for OpenTelemetry Traces and OpenTelemetry Metrics. We recently added support for OpenTelemetry Logging. [...]

Published Wednesday, 18. December 2024 19:06 • 1 months ago

Optimize Amazon RDS performance with io2 Block Express storage for production workloads ^{(from AWS Database Blog)}

Choosing the right storage configuration that meets performance requirements is a common challenge when creating and managing database instances. In this post, we provide an end-to-end guide for what storage class to choose depending on your use case. In addition, we compare the performance of different storage volumes on open source engines supported by Amazon RDS, to validate them from a database [...]

Published Wednesday, 18. December 2024 17:42 • 1 months ago

How To Deal with a AUTO_INCREMENT Max Value Problem in MySQL and MariaDB ^{(from Percona Database Blog)}

♦An application down due to not being able to write into a table anymore due to a maximum allowed auto-increment value may be one of the worst nightmares of a DBA. Typical errors related to this problem in MySQL will look like this: [crayon-678aa23b5d018759576525/] or [crayon-678aa23b5d023727778186/] While the solution could be easy and fairly quick […] [...]

Published Wednesday, 18. December 2024 14:10 • 1 months ago

MySQL Retrospective - MySQL 3.20 ^{(from The Oracle MySQL Blog)}

Let's do a move into the past for the MySQL Advent Calendar before the 30th Anniversary and talk about MySQL 3.20 [...]

Published Wednesday, 18. December 2024 10:51 • 1 months ago

TOP 10 MySQL GUI Tools for Efficient Database Management on Windows [2025] ^{(from Devart MySQL Tool Blog)}

pSelecting the ideal GUI tool for MySQL and MariaDB databases can be challenging. This article provides a summary of the top functional and user-friendly GUI options for these widely-used database systems. It outlines their advantages and disadvantages and offers extra guidance to assist you in making an informed decision./p pThe post TOP 10 MySQL GUI Tools for Efficient Database Management on Wind [...]

Published Wednesday, 18. December 2024 10:13 • 1 months ago

MySQL Retrospective – MySQL 3.20 ^{(from lefred's blog)}

To further advance the MySQL Retrospective in anticipation of the 30th Anniversary, today, let’s discuss the very first version of MySQL that became availble to a wide audient though the popular InfoMagic distribution: MySQL 3.20! In 1997, InfoMagic incorporated MySQL 3.20 as part of the RedHat Contrib CD-ROM (MySQL 3.20.25). Additionally, version 3.20.13-beta was also […] [...]

Published Wednesday, 18. December 2024 09:45 • 1 months ago

Dublin MySQL Meetup, Thu, January 16, 20254pm GMT (UTC+0) ^{(from ODBMS.org)}

Place: Oracle office, Oracle EMEA Liimted, East Point Business Park, Fairview, Dublin 3 Agenda: 4:00 – 4:30 pm Welcome and Welcome Coffee 4:30 – 5:15 pm – MySQL replication topologies for availability and scale by Stuart... [...]

Published Tuesday, 17. December 2024 16:24 • 1 months ago

Belfast MySQL Meetup,Wed. January 15, 2025 6pm GMT (UTC+0) ^{(from ODBMS.org)}

Place: The Woodworkers, United Kingdom, BT7 1RS Agenda: 6:00 – 6:30 pm Welcome and Welcome Coffee 6:30 – 7:15 pm – MySQL replication topologies for availability and scale by Stuart Davey, the MySQL HW Data Architect... [...]

Published Tuesday, 17. December 2024 16:19 • 1 months ago

How Mercari Scaled Its SaaS Platform with Distributed SQL ^{(from PingCAP Blog)}

pAt HTAP Summit 2024, Takashi Honda, a Database Reliability Engineer at Mercari, shared insights into why distributed SQL has become indispensable for SaaS platforms. Drawing from his extensive experience optimizing large-scale infrastructures, Honda illustrated how traditional databases like MySQL and PostgreSQL often reach their limits in performance, scalability, and operational inefficienc [...]

Published Tuesday, 17. December 2024 15:34 • 1 months ago

MySQL Shorts Episode 80 Is Available ^{(from The Oracle MySQL Blog)}

The latest episode of MySQL Shorts is now available. [...]

Published Tuesday, 17. December 2024 14:29 • 1 months ago

January MySQL Meetups - Belfast & Dublin, Ireland ^{(from The Oracle MySQL Blog)}

Belfast & Dublin Meetups [...]

Published Tuesday, 17. December 2024 13:23 • 1 months ago

JavaScript is still number one – JetBrains report ^{(from InfoWorld)}

pJavaScript is the most-used programming language, according to JetBrains’ State of Developer Ecosystem Report 2024. But the languages with the most promising growth prospects are TypeScript, Rust, and Python, the report says. /p pThis year’s report found that JavaScript, with 61% of developers worldwide using it to create web pages, remains the most popular programming la [...]

Published Tuesday, 17. December 2024 02:42 • 1 months ago

WeSQL Outperforms AWS RDS MySQL Single AZ -- 4-6x the Speed, 1/2 the cost ^{(from WeSQL Blog)}

When people hear "S3" and "OLTP database" in the same sentence, skepticism is a common reaction. [...]

Published Tuesday, 17. December 2024 00:00 • 1 months ago

Shrink storage volumes for your RDS databases and optimize your infrastructure costs ^{(from AWS Database Blog)}

Recently, Amazon RDS launched the ability to shrink storage volumes using Amazon RDS Blue/Green Deployments – a nice addition to the list of new use cases that Blue/Green Deployments now supports. In this post, we cover how to use the new storage volume shrink feature in Amazon RDS Blue/Green Deployments to minimize the downtime required to perform the storage size reduction operation. We also revi [...]

Published Monday, 16. December 2024 20:49 • 1 months ago

Best practices for creating a VPC for Amazon RDS for Db2 ^{(from AWS Database Blog)}

You can create an Amazon RDS for Db2 instance by using the AWS Management Console, AWS Command Line Interface (AWS CLI), AWS CloudFormation, Terraform by Hashicorp, AWS Lambda functions, or other methods. One of the prerequisites for creating an RDS for Db2 instance is to configure the virtual private cloud (VPC) appropriately. This post shows how to create a VPC with best practices for any Amazon [...]

Published Monday, 16. December 2024 20:43 • 1 months ago

MariaDB Point In Time Recovery ^{(from MariaDB Corporation Blog)}

Database backup and restore are arguably the most important tasks of the database administrator (DBA). Once in a while, the … Continued [...]

Published Monday, 16. December 2024 19:06 • 1 months ago

Rapyd Enhances Performance and Security by Migrating from Amazon RDS to MySQL Enterprise Edition ^{(from The Oracle MySQL Blog)}

By migrating to MySQL Enterprise Edition, Rapyd has strengthened its competitive edge, improved service reliability, and enhanced database performance. Read the full blog. [...]

Published Monday, 16. December 2024 18:45 • 1 months ago

Best practices for safely performing schema changes in Azure Database for MySQL ^{(from Azure for MySQL Blog)}

pAzure Database for MySQL - Flexible Server is built on the open-source MySQL database engine, and the service supports MySQL 8.0 and newer versions. This means that users can take advantage of the flexibility and advanced capabilities of MySQL’s latest features while benefitting from a fully managed database service./p pWhile newer versions and features can provide a lot of value, the recent issue [...]

Published Monday, 16. December 2024 17:42 • 1 months ago

MySQL Blog Revisited - MySQL Shell ^{(from The Oracle MySQL Blog)}

For the 16th day of our Advent Calendar of Content, we bring you a summary of all the MySQL Blog posts that discuss handy features of MySQL Shell. [...]

Published Monday, 16. December 2024 05:00 • 1 months ago

DBAs not dead ( punk ) ! ^{(from The consistent voice)}

DBAs not dead ( punk ) !♦pToday’s post has been inspired ( fueled ? ) by this linkedin post about what devops should worry about. And the analogy to DBA just triggered me given that amount of failures and bullshit i keep witnessing on a daily basis in my professional life. So here’s my opinion on the matter ( the DBA that is, since devops is none of my business so far )./pplet’s quote the DBA secti [...]

Published Sunday, 15. December 2024 18:08 • 1 months ago

EverSQL Alternative for SQL Query Optimization ^{(from Releem Blog)}

Discover the EverSQL alternative for SQL query optimization. Compare Releem and EverSQL. [...]

Published Sunday, 15. December 2024 17:17 • 1 months ago

MySQL Shorts Revisited - SQL Commands ^{(from The Oracle MySQL Blog)}

For the 15th day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are focussed on how to use various SQL commands. [...]

Published Sunday, 15. December 2024 05:00 • 1 months ago

AWS re:Invent2024 Aurora 发布了啥 – DSQL 篇 ^{(from Chen Zongzhi's GitHub blog)}

这个是前年AWS re:Invent 2022 的内容, 有兴趣可以看这个链接: Aurora re:Invent 2022 [...]

Published Sunday, 15. December 2024 00:00 • 1 months ago

MySQL Retrospective - Certifications ^{(from The Oracle MySQL Blog)}

This post is a brief retrospective on MySQL certification over the years and versions. [...]

Published Saturday, 14. December 2024 11:16 • 1 months ago

Ma Madeleine de Proust ^{(from The consistent voice)}

pA more personal story/ppThe “madeleine de Proust” is a powerful literary and cultural concept that originates from Marcel Proust’s renowned novel “À la recherche du temps perdu” (In Search of Lost Time), specifically from the first volume “Du côté de chez Swann” (Swann’s Way), published in 1913 In this work, Proust describes a pivotal moment where the narrator tastes a madeleine cake dipped in tea [...]

Published Friday, 13. December 2024 18:38 • 1 months ago

HeatWave Japan User Group. Q&A with Masataka Narita and Tatsuya Naito ^{(from ODBMS.org)}

Q1. We hear about GenAI every day. How can we leverage HeatWave GenAI specifically? What makes HeatWave GenAI unique? The big difference is that the entire GenAI process can be completed within customer’s HeatWave. There are... [...]

Published Friday, 13. December 2024 14:36 • 1 months ago

The Mystery of ProxySQL Galera Writer Switchover! ^{(from Vettabase)}

Writer switchover issues with ProxySQL and Galera can feel like an unsolved puzzle. Recently, I encountered two strange behaviors that revealed underlying issues in how ProxySQL interacts with Galera clusters. In this post, I’ll walk through the unexpected behaviors I faced, and the troubleshooting approaches that helped me address these challenges, and workarounds to avoid them. ProxySQL is one of [...]

Published Friday, 13. December 2024 12:03 • 1 months ago

Running Drupal using Always Free Resources in Oracle Cloud ^{(from The Oracle MySQL Blog)}

With the introduction of the Always Free tier of HeatWave MySQL, we can now run a Drupal site at no cost by using Always Free Compute and an Always Free HeatWave MySQL instance. Check out this post to find out how. [...]

Published Friday, 13. December 2024 05:00 • 1 months ago

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

Dolt is a drop in-replacement for MySQL, which means it can be used with any MySQL-compatible tool. One such tool is Mydumper and its… [...]

Published Friday, 13. December 2024 00:00 • 1 months ago

Defining a Scalable System: What It Really Means to Be “Future Proof” ^{(from PingCAP Blog)}

pBuilding a scalable system that’s also future proof has become a critical factor for organizations who want to maintain a competitive edge. At HTAP Summit 2024, PingCAP Software Architect Sunny Bains uncovered the challenges and solutions associated with scaling such complex systems. He highlighted the importance of robust, flexible architectures and showcased how TiDB, an […]/p pThe p [...]

Published Thursday, 12. December 2024 16:47 • 1 months ago

MySQL with Diagrams Part One: Replication Architecture ^{(from Percona Database Blog)}

♦In this series, “MySQL with Diagrams,” I’ll use diagrams to explain internals, architectures, and structures as detailed as possible. In basic terms, here’s how replication works: the transactions are written into a binary log on the source side, carried into the replica, and applied. The replica’s connection metadata repository contains information that the replication receiver [̷ [...]

Published Thursday, 12. December 2024 14:35 • 1 months ago

MySQL Rockstar 2013: Q&A with Sveta Smirnova. ^{(from ODBMS.org)}

Q1. You work at work Percona as Principal Support Engineer for MySQL, its forks and utilities. What are your responsibilities? My title is Principal Support Engineering Coordinator and my responsibility is to ensure that... [...]

Published Thursday, 12. December 2024 10:24 • 1 months ago

MySQL Blog Revisited - Regular Expressions ^{(from The Oracle MySQL Blog)}

For the 12th day of our Advent Calendar of Content, we bring you a summary of all the MySQL Blog posts that discuss regular expressions and how they can be used in MySQL. [...]

Published Thursday, 12. December 2024 05:00 • 1 months ago

Run Database in GitHub Actions, Persisting Data to S3, and Access it Publicly ^{(from WeSQL Blog)}

When it comes to running a database for development, testing, demos, or short-lived workloads, cost and complexity can be big headaches. Traditional database hosting—like a VPS, a cloud VM, or a managed service—comes with ongoing costs, storage expenses, and configuration overhead. You often end up paying for resources even when you're not using them. [...]

Published Thursday, 12. December 2024 00:00 • 1 months ago

Transforming Databases for the AI Era: The Vector Revolution ^{(from MariaDB Corporation Blog)}

I recently joined MariaDB as VP of Product Management, coming from a background in Artificial Intelligence (AI) Engineering and Product … Continued [...]

Published Wednesday, 11. December 2024 21:33 • 1 months ago

Some MySQL Router 8.4.3 read-write splitting quips ^{(from MySQL-Med)}

Naughty Router read-write split port! After some testing, I was quite surprised when... Continue reading → [...]

Published Wednesday, 11. December 2024 18:34 • 1 months ago

MariaDB spinout SkySQL secures seed funding to ‘bring conversational AI to databases’ ^{(from TechCrunch)}

pAnyone who’s followed the fortunes of MySQL and MariaDB these past 15 years will probably remember SkySQL, another brand that once existed within that same database ecosystem and, a year ago, became a stand-alone company once more. That company today announced it has raised its first outside funding — a $6.6 million seed round — […]/p p© 2024 TechCrunch. All rights reserved [...]

Published Wednesday, 11. December 2024 17:00 • 1 months ago

CodeQL zero to hero part 4: Gradio framework case study ^{(from The GitHub Blog)}

pLearn how I discovered 11 new vulnerabilities by writing CodeQL models for Gradio framework and how you can do it, too./p pThe post CodeQL zero to hero part 4: Gradio framework case study appeared first on The GitHub Blog./p [...]

Published Wednesday, 11. December 2024 15:00 • 1 months ago

Optimizing Tungsten Node Availability Checks: Balancing Recovery and Aggressiveness for Cluster Stability ^{(from Continuent Blog)}

Tungsten Clustering ensures high availability with robust failover capabilities, driven by the Tungsten Manager's health checks and predefined rules. In this blog post, we explore key processes like handling heartbeat gaps, network partitions, and availability checks. We also provide tips for tuning parameters to optimize performance and maintain a resilient database cluster.Tags: tungsten clu [...]

Published Wednesday, 11. December 2024 09:42 • 1 months ago

MySQL Shorts Revisited - Working with JSON ^{(from The Oracle MySQL Blog)}

For the 11th day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are focussed on making working with JSON easier. [...]

Published Wednesday, 11. December 2024 05:00 • 1 months ago

America First Credit Union: Streamlining Member Onboarding with MySQL Enterprise Edition ^{(from The Oracle MySQL Blog)}

This blog covers how America First Credit Union adoption of MySQL Enterprise Edition has transformed its membership onboarding process, reducing complexity, improving system performance, and boosting member satisfaction. [...]

Published Wednesday, 11. December 2024 01:26 • 1 months ago

MySQL-9.0, Dolt, and Caching SHA-2 Auth Support ^{(from DoltHub Blog)}

Lately, we've seen customers install the latest innovation release of MySQL (i.e. MySQL-9.0) and then have problems connecting to a Dolt SQL… [...]

Published Wednesday, 11. December 2024 00:00 • 1 months ago

MariaDB Enterprise Server Q4 2024 Maintenance Releases with Backported Features ^{(from MariaDB Corporation Blog)}

New maintenance releases for MariaDB Enterprise Server 10.6.20-16 and 10.5.27-21 are now available. These releases include new backported features. Download … Continued [...]

Published Tuesday, 10. December 2024 17:56 • 1 months ago

Simplifying AI Development: A Practical Guide to HeatWave GenAI’s RAG & Vector Store Features ^{(from MySQL expert Diary)}

pThis tutorial explores HeatWave GenAI, a cloud service that simplifies interacting with unstructured data using natural language. It combines large language models, vector stores, and SQL queries to enable tasks like content generation, chatbot, and retrieval-augmented generation (RAG). The focus is on RAG and how HeatWave GenAI’s architecture helps users gain insights from their data./p The post [...]

Published Tuesday, 10. December 2024 09:26 • 1 months ago

Running WordPress using Always Free Resources in Oracle Cloud ^{(from The Oracle MySQL Blog)}

With the introduction of the Always Free tier of HeatWave MySQL, we can now run a WordPress site at no cost by using Always Free Compute and an Always Free HeatWave MySQL instance. Check out this post to find out how. [...]

Published Tuesday, 10. December 2024 05:00 • 1 months ago

A Tour of config.yaml ^{(from DoltHub Blog)}

Hot on the heels of my overview of Dolt configuration, I'm going to do a deep dive on , the configuration file for a Dolt SQL Server. As I… [...]

Published Tuesday, 10. December 2024 00:00 • 1 months ago

Index Usage For EXTRACT(YEAR FROM …), YEAR(…) etc. ^{(from Use The Index, Luke)}

Automatic Rewrite of Date and Time RangespThe following chart shows which DBMS rewrites codewhere/code clause expressions that access the year part of a codedate/code or codetimestamp/code (or the like) into a range expression such as codets >= DATE'2024-01-01' AND ts < DATE'2025-01-01'/code. This enables the use of a sort-based index on the codets/code column./p♦olliUnconditionally rewritten [...]

Published Tuesday, 10. December 2024 00:00 • 1 months ago

Enhancing MariaDB’s Capabilities part 2 ^{(from The consistent voice)}

pStill running after Stonebraker’s prediction about database engine convergence/pWhat is OQGRAPH?pOQGRAPH, or the Open Query GRAPH engine, is a specialized storage engine designed for handling hierarchical and complex graph data within relational database management systems (RDBMS) like MariaDB. It allows users to access and manipulate data as graphs, which is particularly useful for storing and qu [...]

Published Monday, 09. December 2024 13:54 • 1 months ago

Killer Blog for MySQL Administrators ^{(from Kedar MySQL Blog)}

pThis is by far the most killer MySQL blog that I wanted to write for really long as a part of a Killer DBA series. Time is hard to find,…/p The post Killer Blog for MySQL Administrators first appeared on Change Is Inevitable. [...]

Published Monday, 09. December 2024 07:00 • 1 months ago

MySQL Shorts Revisited - Functions Galore ^{(from The Oracle MySQL Blog)}

For the ninth day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are focussed on internal MySQL functions. [...]

Published Monday, 09. December 2024 05:00 • 1 months ago

Decentralized Wikipedia Update ^{(from DoltHub Blog)}

Dolt is a decentralized database. In the past ten years or so decentralization has gone through a few hype cycles. I think we're in a pro… [...]

Published Monday, 09. December 2024 00:00 • 1 months ago

MySQL Retrospective - The Middle 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 middle years. [...]

Published Sunday, 08. December 2024 05:00 • 1 months ago

How to tune Redis for High Traffic Applications? ^{(from MinervaDB Blog)}

pRedis Optimization Guide for High-Traffic Applications Tuning Redis for high-traffic applications requires careful optimization of configuration, hardware, data structures, and monitoring. Here's a comprehensive guide to ensure Redis handles high traffic efficiently: 1. Redis Optimization [...]/p pThe post How to tune Redis for High Traffic Applications? appeared first on The WebScale Database Inf [...]

Published Saturday, 07. December 2024 19:39 • 1 months ago

MySQL Shorts Revisited - MySQL Shell ^{(from The Oracle MySQL Blog)}

For the seventh day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are focussed on MySQL Shell. [...]

Published Saturday, 07. December 2024 05:00 • 1 months ago

KB Kookmin Bank: Pioneering Open-Source Banking with MySQL Enterprise Edition ^{(from The Oracle MySQL Blog)}

KB Kookmin Bank thoroughly evaluated multiple options, including PostgreSQL, MariaDB, and MongoDB. Ultimately, it chose MySQL Enterprise Edition for its proven stability, robust technical support, cost-effectiveness, and comprehensive enterprise features, such as advanced replication and secure backup solutions. Read the full blog. [...]

Published Saturday, 07. December 2024 04:31 • 1 months ago

From caching to real-time analytics: Essential use cases for Amazon ElastiCache for Valkey ^{(from AWS Database Blog)}

Valkey is an open-source, distributed, in-memory key-value data store that offers high-performance data retrieval and storage capabilities, making it an ideal choice for scalable, low-latency modern application development. Originating as a fork of Redis OSS following recent licensing changes, Valkey maintains full compatibility with its predecessor while providing high performance alternative for [...]

Published Friday, 06. December 2024 20:59 • 1 months ago

Automate pre-checks for your Amazon RDS for MySQL major version upgrade ^{(from AWS Database Blog)}

Amazon Relational Database Service (Amazon RDS) for MySQL currently supports a variety of Community MySQL major versions including 5.7, 8.0, and 8.4 which present many different features and bug fixes. Upgrading from one major version to another requires careful consideration and planning. For a complete list of compatible major versions, see Supported MySQL major versions […] [...]

Published Friday, 06. December 2024 20:54 • 1 months ago

Why Pinterest Modernized Its Graph Service with Distributed SQL ^{(from PingCAP Blog)}

pPinterest, one of the world’s leading visual search and discovery platforms, recently undertook a significant overhaul of its graph storage service. At the HTAP Summit 2024, Pinterest Senior Software Engineer Ke Chen discussed the company’s transition from its legacy Zen system to a new architecture built on top of TiDB, an advanced distributed SQL database. […]/p pThe post Why P [...]

Published Friday, 06. December 2024 20:50 • 1 months ago

MySQL High Availability and Disaster Recovery: Navigating the Top Solutions and Their Challenges ^{(from Continuent Blog)}

This article explores some of the leading MySQL — also including MySQL variants MariaDB and Percona Server — high availability (HA) and disaster recovery (DR) solutions – in alphabetical order, including AWS Aurora, Continuent Tungsten, DIY MySQL clusters, Galera Cluster, and MySQL InnoDB Cluster.Tags: MySQLHigh AvailabilityDisaster Recoverysolution comparisonAWS AuroraGalerainnodb clustertung [...]

Published Friday, 06. December 2024 12:11 • 1 months ago

MySQL Retrospective - Forgotten Functions ^{(from The Oracle MySQL Blog)}

For our MySQL Advent Calendar before the 30th Anniversary Year, let's have a look at some MySQL Retrospective [...]

Published Friday, 06. December 2024 11:00 • 1 months ago

Doltgres System Tables Update ^{(from DoltHub Blog)}

We've been hard at work getting Doltgres, a Postgres-flavored version of Dolt, ready for its beta release in Q1. This includes making sure… [...]

Published Friday, 06. December 2024 00:00 • 1 months ago

Release of RonDB 22.10.7 ^{(from Mikael Ronstrom)}

pToday we released a new release of the stable series of RonDB. This version RonDB 22.10.7 is mostly a bug fix release, but also contains a few new features that were required for the Kubernetes integration of RonDB./ppThe major development in RonDB is currently around RonDB 24.10 which is aimed for a first release in 1-2 months./ppRonDB 22.10.7 contains the following new features:/pRONDB-789: Find [...]

Published Thursday, 05. December 2024 19:46 • 1 months ago | Updated Thursday, 05. December 2024 19:46 • 1 months ago

Complete Guide to MariaDB Logs: Audit, Configuration, and More ^{(from Releem Blog)}

In this guide, we’ll walk through the various types of MariaDB logs, where to find them, and how to make the most of the insights they hold. With the right strategies, you can turn your logs into a powerful tool for maintaining and optimizing your database. [...]

Published Thursday, 05. December 2024 14:54 • 1 months ago

Clustercontrol adds Percona Server Pro, and support for MySQL v8.4, Elasticsearch v8.15, Valkey v8.0 in latest release ^{(from Severalnines Blog)}

pClustercontrol (CC) v2.3.0 is now live, featuring new enterprise binaries support for Percona Server Pro clusters and support for MySQL v8.4, Elasticsearch v8.15, and Valkey v8.0. Let’s dive into these key updates and discover what’s new! New enterprise binaries with compatibility for Percona Server Pro We have upgraded our enterprise binaries with Percona Server Pro […]/p pThe post Clusterc [...]

Published Thursday, 05. December 2024 13:25 • 1 months ago

MySQL HeatWave: Real-Time Analytics and High-Performance Data Processing ^{(from Devart MySQL Tool Blog)}

pMySQL HeatWave, an Oracle Cloud service, delivers high-performance query processing, efficiently manages large data volumes, and combines transactional and analytical processing within the same system. This article highlights its key features and benefits./p pThe post MySQL HeatWave: Real-Time Analytics and High-Performance Data Processing appeared first on Devart Blog./p [...]

Published Thursday, 05. December 2024 10:25 • 1 months ago

MySQL Shorts Revisited - MySQL Document Store ^{(from The Oracle MySQL Blog)}

For the fourth day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are discussed MySQL Document Store. [...]

Published Thursday, 05. December 2024 05:00 • 1 months ago

Using Connector Failover for MariaDB MaxScale Resiliency ^{(from MariaDB Corporation Blog)}

MariaDB MaxScale is an excellent solution for making your MariaDB Server database deployments highly available… but how do you make … Continued [...]

Published Wednesday, 04. December 2024 16:30 • 1 months ago

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 [...]

Published Wednesday, 04. December 2024 15:31 • 1 months ago

The Evolution of Stateful Applications in Kubernetes ^{(from Percona Database Blog)}

♦Recently I listened to Lenny Rachitsky’s podcast, where he invited Shreyas Doshi for the second time. The session was titled “4 questions Shreyas Doshi wishes he’d asked himself sooner”. One of the questions Shreyas brought up was, “Do I actually have a good taste?”. This is an interesting question to ask for an experienced product […] [...]

Published Wednesday, 04. December 2024 14:29 • 1 months ago

Optimise your database before scaling ^{(from Vettabase)}

Nowadays, there is a common misconceptions that we don’t need to optimise the technologies we use, because we can just scale out or scale up. Whereas scaling out means to add one or more instances of a technology, and scaling up means to run the technology on better servers. Both these options are made easy by the cloud. But trying to scale a database that needs optimisation has many drawback [...]

Published Wednesday, 04. December 2024 12:02 • 1 months ago

MySQL Retrospective - The Logo ^{(from The Oracle MySQL Blog)}

MySQL Advent Calendar Restrospective [...]

Published Wednesday, 04. December 2024 11:02 • 1 months ago

MySQL High Availability: Techniques to Ensure Uptime in Critical Systems ^{(from ProxySQL Blog)}

pA single hour of downtime costs companies an average of $300,000, with critical systems like databases bearing the brunt of this risk. MySQL, widely used for managing essential data, requires high availability (HA) solutions to maintain smooth uptime and avoid disruptions that can lead to financial loss or reputational damage. Ensuring the continuous availability [...]/p pThe post MySQL High Avai [...]

Published Wednesday, 04. December 2024 10:25 • 1 months ago

You like LEGOs ? so do I ^{(from The consistent voice)}

You like LEGOs ? so do Ialso that why i like MariadB so much !pLego has long been celebrated as a powerful tool for creativity and imagination, allowing builders of all ages to construct anything they can envision within the constraints set by the building blocks. Each Lego piece serves as a fundamental component, offering a unique shape, color, and function that can be combined in countless ways. [...]

Published Wednesday, 04. December 2024 10:09 • 1 months ago

Dolt Configuration ^{(from DoltHub Blog)}

Dolt configuration is a bit of a mess. To start, it's a union of Git and MySQL styles of configuration. Then, Dolt specific configuration is… [...]

Published Wednesday, 04. December 2024 00:00 • 1 months ago

Enabling Read-Write splitting for automatic query distribution – all with MySQL Router ^{(from MySQL-Med)}

I'm just trying out the v8.4 Read-Write configuration for MySQL Router, that comes default in the community edition and, as they say, TL;DR "it's default upon bootstrap". Continue reading → [...]

Published Tuesday, 03. December 2024 19:18 • 2 months ago

How to Rename a MySQL Database ^{(from Devart MySQL Tool Blog)}

pWhen working with MySQL databases, you may encounter the need to change a database name. However, MySQL no longer supports a direct renaming option. The RENAME DATABASE command, available in earlier versions, was removed due to the risk of data loss. Despite this, renaming a database in MySQL is still possible. This article explores the […]/p pThe post How to Rename a MySQL Database appeared [...]

Published Tuesday, 03. December 2024 17:10 • 2 months ago

Who Ate My MySQL Table Rows? ^{(from Percona Database Blog)}

♦TL;DR ALTER TABLE and OPTIMIZE TABLE on an InnoDB table, which rebuilds the table without blocking concurrent changes to it (i.e., executed using INPLACE algorithm) and concurrent DML or purge activity on the table can occasionally lead to two significant problems: ALTER/OPTIMIZE TABLE failing with an unnecessary duplicate key error (even though there are no […] [...]

Published Tuesday, 03. December 2024 16:07 • 2 months ago

Building a Restaurant Management System with Azure Database for MySQL ^{(from Azure for MySQL Blog)}

What we'll build ul liA restaurant database system that manages:/li ul liMenu items and categories/li liCustomer orders and reservations/li liStaff scheduling/li liInventory tracking/li /ul /ul Prerequisites pTo get the most out of this blog post, you should have a basic understanding of database concepts and familiarity with using SQL. In addition, before getting started, it’s important to ensure [...]

Published Tuesday, 03. December 2024 16:01 • 2 months ago

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 [...]

Published Tuesday, 26. November 2024 15:44 • 2 months ago | Updated Tuesday, 03. December 2024 15:52 • 2 months ago

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 [...]

Published Tuesday, 19. November 2024 16:53 • 2 months ago | Updated Tuesday, 03. December 2024 15:52 • 2 months ago

InnoDB Tablespace Duplicate Check Threads (and EBS Volumes for 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 five posts on the subject, they are listed below. In this post, I use the knowledge we gained in the previous two posts to show the interest of tuning InnoDB Tablespace Duplicate Check Threads, making startup 30% in one case (2:28 vs. 3:33) and 5% in [...]

Published Tuesday, 03. December 2024 15:29 • 2 months ago | Updated Tuesday, 03. December 2024 15:38 • 2 months ago

Galera Cluster for MySQL 8.0.40-26.21, and MySQL 8.4.3-26.21 released ^{(from Galera Blog)}

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.40-26.21 (release notes, download), with Galera replication library 4.21 (release notes, download) implementing wsrep API version 26. It also includes Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.3-26.21 (release notes, download), our [...]

Published Tuesday, 03. December 2024 15:26 • 2 months ago

Problematic Improved Offline Mode Error in MySQL 9 ^{(from J-F Gagné's MySQL Blog)}

I am writing this quick post to share what I think is a problematic new behavior of Offline Mode in MySQL 9. Basically, the new default behavior in MySQL 9 is to write the username of the user which set offline_mode to ON. I think this behavior has not been considered from a security point of view because it leaks a root username in the error message presented to the users. My [...]

Published Monday, 02. December 2024 19:03 • 2 months ago | Updated Tuesday, 03. December 2024 14:31 • 2 months ago

AWS Database Migration Service gets gen AI-powered schema conversion ^{(from InfoWorld)}

pAmazon Web Services (AWS) has updated its Database Migration Service’s schema conversion feature with a new generative AI-powered capability that automates schema conversion to a great extent./p pThe schema conversion feature, announced at the ongoing annual re:Invent conference, helps enterprises convert the source database schema and procedures to the target database s [...]

Published Tuesday, 03. December 2024 10:05 • 2 months ago

MySQL Shorts Revisited - HeatWave MySQL ^{(from The Oracle MySQL Blog)}

For the third day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are focussed on HeatWave MySQL [...]

Published Tuesday, 03. December 2024 05:00 • 2 months ago

Dolt SSL Authentication ^{(from DoltHub Blog)}

Dolt is the world's first and only version controlled SQL database. Dolt is fully MySQL-compatible. You connect to it with any MySQL client… [...]

Published Tuesday, 03. December 2024 00:00 • 2 months ago

Lina One Enhances Telemarketing Productivity with MySQL Enterprise Edition ^{(from The Oracle MySQL Blog)}

With the successful deployment of MySQL Enterprise Edition, Lina One has improved telemarketing productivity across its call centers and set a new standard for efficiency and security in the insurance industry. Read the blog. [...]

Published Monday, 02. December 2024 21:50 • 2 months ago

Leveraging Cost Tags to enhance Cost Governance for HeatWave MySQL ^{(from The Oracle MySQL Blog)}

Tagging is an essential practice in managing and organizing cloud resources. In Oracle Cloud Infrastructure (OCI), tagging is an integral part of the OCI Identity and Access Management service(IAM) which provides a systematic way to categorize and manage resources effectively, such as cost tracking, cloud resource searching, filtering and logical organization. In this blog post, we will explore h [...]

Published Monday, 02. December 2024 21:44 • 2 months ago

MySQL GTID tags and binlog events ^{(from Daniël's Database Blog)}

pMySQL 8.4 and newer have extended the Global Transaction ID (GTID) functionality with a new “tag” option./p Refresher on GTID pA GTID is a unique ID that is assigned to a transaction. This is used if codegtid_mode/code is set to codeON/code. The benefit of this is that a transaction can be uniquely identified in a MySQL replication setup with multiple levels. Among others this makes it easier to r [...]

Published Monday, 02. December 2024 19:43 • 2 months ago | Updated Monday, 02. December 2024 19:43 • 2 months ago

MySQL Shorts Episode 79 is Available ^{(from The Oracle MySQL Blog)}

The latest episode of MySQL Shorts is now available. [...]

Published Monday, 02. December 2024 17:00 • 2 months ago

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 [...]

Published Monday, 02. December 2024 16:55 • 2 months ago

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 [...]

Published Monday, 02. December 2024 00:00 • 2 months ago

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. [...]

Published Sunday, 01. December 2024 05:00 • 2 months ago

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 […] [...]

Published Saturday, 30. November 2024 22:09 • 2 months ago

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 [...]

Published Saturday, 30. November 2024 01:54 • 2 months ago | Updated Saturday, 30. November 2024 01:54 • 2 months ago

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... [...]

Published Friday, 29. November 2024 12:13 • 2 months ago

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... [...]

Published Friday, 29. November 2024 11:35 • 2 months ago

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… [...]

Published Friday, 29. November 2024 00:00 • 2 months ago

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. [...]

Published Thursday, 28. November 2024 14:18 • 2 months ago

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 [...]

Published Thursday, 28. November 2024 07:44 • 2 months ago

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. [...]

Published Thursday, 28. November 2024 06:30 • 2 months ago

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 […] [...]

Published Wednesday, 27. November 2024 16:12 • 2 months ago

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 [...]

Published Wednesday, 27. November 2024 13:17 • 2 months ago

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

Published Wednesday, 27. November 2024 10:48 • 2 months ago

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… [...]

Published Wednesday, 27. November 2024 00:00 • 2 months ago

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 [...]

Published Tuesday, 26. November 2024 23:13 • 2 months ago

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 [...]

Published Tuesday, 03. September 2024 15:39 • 5 months ago | Updated Tuesday, 26. November 2024 15:48 • 2 months ago

Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

Friday, 17. January 2025

Json2SQL : a simple RESTful API for MariaDB (from The consistent voice)

What’s the Cost of Counting MySQL Table Rows? (from Percona Database Blog)

Thursday, 16. January 2025

Introducing MariaDB MaxScale 25.01 GA (from MariaDB Corporation Blog)

Introducing Vector Search With the Latest Version of MariaDB Enterprise Platform (from MariaDB Corporation Blog)

Announcing New Release of MariaDB Enterprise Platform (from MariaDB Corporation Blog)

Percona Everest: An Open Source Solution for MongoDB Sharding and Backups (from Percona Database Blog)

ProxySQL Performance Tuning: Unlocking Optimal Database Performance (from ProxySQL Blog)

Announcing Vector Indexes (from DoltHub Blog)

Wednesday, 15. January 2025

2024 Recap: Key Innovations and Enhancements in HeatWave MySQL (from The Oracle MySQL Blog)

How MySQL Enterprise Edition Can Help Your Organization Achieve DORA Compliance (from The Oracle MySQL Blog)

Using Azure Automation PowerShell runbooks with MySQL flexible servers (from Azure for MySQL Blog)

On the results from the replication poll (from MariaDB Foundation Blog)

Tuesday, 14. January 2025

MySQL cloud services cost comparison: who provides the best value? (from The Oracle MySQL Blog)

TiDB’s Chat2Query: Instant Business Insights, No SQL Required (from PingCAP Blog)

It’s all about the attitude (from The consistent voice)

Automating cherry-picks between OSS and private forks (from PlanetScale Blog)

Dissecting an Extreme Sparse MySQL Table Using ibdNinja (from Zhao Song's Blog)

Monday, 13. January 2025

Evaluating vector indexes in MariaDB and pgvector: part 2 (from Small Datum)

Evaluating vector indexes in MariaDB and pgvector: part 1 (from Small Datum)

Using Airbyte to migrate data to Oracle HeatWave on OCI (from The Oracle MySQL Blog)

How can you implement Inline view in MariaDB? (from MinervaDB Blog)

The Power of MySQL: What Makes It the World’s Favorite Database? (from The Oracle MySQL Blog)

Recap of the MySQL Community Advent Calendar 2024 Posts (from The Oracle MySQL Blog)

Scaling Database Connections (from WeSQL Blog)

Friday, 10. January 2025

Gaining Actionable Insights: Complex Data Analysis Made Simple with TiInsight (from PingCAP Blog)

Amazon RDS for MariaDB supports Innovation Release 11.7 in Amazon RDS Database Preview Environment (from AWS What's New)

Indexing to optimize Data Ingestion in MongoDB (from MinervaDB Blog)

Sysbench performance over time for InnoDB and MyRocks: part 4 (from Small Datum)

Kickstart Your Distributed SQL Journey: Setting Up TiDB Locally with TiUP Playground (from PingCAP Blog)

Oracle to PostgreSQL Migration Series – NoValidate and Parallel Constraints in PostgreSQL (from MinervaDB Blog)

Sysbench performance over time for InnoDB and MyRocks: part 3 (from Small Datum)

Sysbench performance over time for InnoDB and MyRocks: part 2 (from Small Datum)

Thursday, 09. January 2025

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

Vacasa’s migration to Amazon Aurora for a more efficient Property Management System (from AWS Database Blog)

PCI DSS 4.0 Compliance and MySQL (from The Oracle MySQL Blog)

Embrace simplicity (from The consistent voice)

How To Detect Account Intruders Using AWS CloudTrail (from Continuent Blog)

preFOSDEM MySQL Belgian Days 2025 – Agenda (from lefred's blog)

preFOSDEM MySQL Belgian Days 2025 - Agenda (from The Oracle MySQL Blog)

Sysbench performance over time for InnoDB and MyRocks: part 1 (from Small Datum)

Database Sharding (from PlanetScale Blog)

Wednesday, 08. January 2025

Attaching a Percona Monitoring and Management Graph Image Along with an Alerting Notification (from Percona Database Blog)

Best 7 DBVisualizer Alternatives (from Devart MySQL Tool Blog)

Tuesday, 07. January 2025

Tracking MySQL Query Plans Part I and Rebooting This Blog (from PHP With MySQL)

Easier Oracle to MariaDB Migrations with sql_mode and DBeaver (from MariaDB Corporation Blog)

MySQL with Diagrams Part Two: How KILL Works (from Percona Database Blog)

Monday, 06. January 2025

December Product Update (from Readyset Blog)

MySQL 8.4.3 and 9.1.0: Major Performance Gains Revealed (from Percona Database Blog)

MySQL 8.4 Support in Percona Toolkit 3.7.0 (from Percona Community Blog)

ibdNinja: A powerful tool for parsing and analyzing MySQL 8.0 (.ibd) data files (from Zhao Song's Blog)

Friday, 03. January 2025

Mastering Transaction Management in InnoDB: Optimizing COMMIT, ROLLBACK, and SAVEPOINT for Performance and Integrity (from MinervaDB Blog)

Thursday, 02. January 2025

Querying and writing to MySQL and MariaDB from Amazon Aurora and Amazon RDS for PostgreSQL using the mysql_fdw extension, Part 2: Handling foreign objects (from AWS Database Blog)

Reflections on a year of biking for 2024 (from Jeremy Cole)

Dolt MySQL Differences (from DoltHub Blog)

Tuesday, 31. December 2024

MariaDB highlights in 2024: Vectors, K1, and contributions (from MariaDB Foundation Blog)

What we’ve developed in 2024 (from MariaDB Foundation Blog)

Monday, 30. December 2024

A Beginner’s Guide to Database Sharding: How to Scale Your Database Effectively (from ProxySQL Blog)

Multitenant data management with TiDB (from InfoWorld)

MySQLTuner for Windows: Common Issues and Better Alternatives (from Releem Blog)

Dolt Wrapped 2024: A Year in Review (from DoltHub Blog)

Sunday, 29. December 2024

Speedb vs RocksDB on a large server (from Small Datum)

Monitoring Multi-threaded Replication Lag With Performance Schema (from Hack MySQL)

Saturday, 28. December 2024

Json2SQL : a simple RESTful API for MariaDB ^{(from The consistent voice)}

What’s the Cost of Counting MySQL Table Rows? ^{(from Percona Database Blog)}

Introducing MariaDB MaxScale 25.01 GA ^{(from MariaDB Corporation Blog)}

Introducing Vector Search With the Latest Version of MariaDB Enterprise Platform ^{(from MariaDB Corporation Blog)}

Announcing New Release of MariaDB Enterprise Platform ^{(from MariaDB Corporation Blog)}

Percona Everest: An Open Source Solution for MongoDB Sharding and Backups ^{(from Percona Database Blog)}

ProxySQL Performance Tuning: Unlocking Optimal Database Performance ^{(from ProxySQL Blog)}

Announcing Vector Indexes ^{(from DoltHub Blog)}

2024 Recap: Key Innovations and Enhancements in HeatWave MySQL ^{(from The Oracle MySQL Blog)}

How MySQL Enterprise Edition Can Help Your Organization Achieve DORA Compliance ^{(from The Oracle MySQL Blog)}

Using Azure Automation PowerShell runbooks with MySQL flexible servers ^{(from Azure for MySQL Blog)}

On the results from the replication poll ^{(from MariaDB Foundation Blog)}

MySQL cloud services cost comparison: who provides the best value? ^{(from The Oracle MySQL Blog)}

TiDB’s Chat2Query: Instant Business Insights, No SQL Required ^{(from PingCAP Blog)}

It’s all about the attitude ^{(from The consistent voice)}

Automating cherry-picks between OSS and private forks ^{(from PlanetScale Blog)}

Dissecting an Extreme Sparse MySQL Table Using ibdNinja ^{(from Zhao Song's Blog)}

Evaluating vector indexes in MariaDB and pgvector: part 2 ^{(from Small Datum)}

Evaluating vector indexes in MariaDB and pgvector: part 1 ^{(from Small Datum)}

Using Airbyte to migrate data to Oracle HeatWave on OCI ^{(from The Oracle MySQL Blog)}

How can you implement Inline view in MariaDB? ^{(from MinervaDB Blog)}

The Power of MySQL: What Makes It the World’s Favorite Database? ^{(from The Oracle MySQL Blog)}

Recap of the MySQL Community Advent Calendar 2024 Posts ^{(from The Oracle MySQL Blog)}

Scaling Database Connections ^{(from WeSQL Blog)}

Gaining Actionable Insights: Complex Data Analysis Made Simple with TiInsight ^{(from PingCAP Blog)}

Amazon RDS for MariaDB supports Innovation Release 11.7 in Amazon RDS Database Preview Environment ^{(from AWS What's New)}

Indexing to optimize Data Ingestion in MongoDB ^{(from MinervaDB Blog)}

Sysbench performance over time for InnoDB and MyRocks: part 4 ^{(from Small Datum)}

Kickstart Your Distributed SQL Journey: Setting Up TiDB Locally with TiUP Playground ^{(from PingCAP Blog)}

Oracle to PostgreSQL Migration Series – NoValidate and Parallel Constraints in PostgreSQL ^{(from MinervaDB Blog)}

Sysbench performance over time for InnoDB and MyRocks: part 3 ^{(from Small Datum)}

Sysbench performance over time for InnoDB and MyRocks: part 2 ^{(from Small Datum)}

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

Vacasa’s migration to Amazon Aurora for a more efficient Property Management System ^{(from AWS Database Blog)}

PCI DSS 4.0 Compliance and MySQL ^{(from The Oracle MySQL Blog)}

Embrace simplicity ^{(from The consistent voice)}

How To Detect Account Intruders Using AWS CloudTrail ^{(from Continuent Blog)}

preFOSDEM MySQL Belgian Days 2025 – Agenda ^{(from lefred's blog)}

preFOSDEM MySQL Belgian Days 2025 - Agenda ^{(from The Oracle MySQL Blog)}

Sysbench performance over time for InnoDB and MyRocks: part 1 ^{(from Small Datum)}

Database Sharding ^{(from PlanetScale Blog)}

Attaching a Percona Monitoring and Management Graph Image Along with an Alerting Notification ^{(from Percona Database Blog)}

Best 7 DBVisualizer Alternatives ^{(from Devart MySQL Tool Blog)}

Tracking MySQL Query Plans Part I and Rebooting This Blog ^{(from PHP With MySQL)}

Easier Oracle to MariaDB Migrations with sql_mode and DBeaver ^{(from MariaDB Corporation Blog)}

MySQL with Diagrams Part Two: How KILL Works ^{(from Percona Database Blog)}

December Product Update ^{(from Readyset Blog)}

MySQL 8.4.3 and 9.1.0: Major Performance Gains Revealed ^{(from Percona Database Blog)}

MySQL 8.4 Support in Percona Toolkit 3.7.0 ^{(from Percona Community Blog)}

ibdNinja: A powerful tool for parsing and analyzing MySQL 8.0 (.ibd) data files ^{(from Zhao Song's Blog)}

Mastering Transaction Management in InnoDB: Optimizing COMMIT, ROLLBACK, and SAVEPOINT for Performance and Integrity ^{(from MinervaDB Blog)}

Querying and writing to MySQL and MariaDB from Amazon Aurora and Amazon RDS for PostgreSQL using the mysql_fdw extension, Part 2: Handling foreign objects ^{(from AWS Database Blog)}

Reflections on a year of biking for 2024 ^{(from Jeremy Cole)}

Dolt MySQL Differences ^{(from DoltHub Blog)}

MariaDB highlights in 2024: Vectors, K1, and contributions ^{(from MariaDB Foundation Blog)}

What we’ve developed in 2024 ^{(from MariaDB Foundation Blog)}

A Beginner’s Guide to Database Sharding: How to Scale Your Database Effectively ^{(from ProxySQL Blog)}

Multitenant data management with TiDB ^{(from InfoWorld)}

MySQLTuner for Windows: Common Issues and Better Alternatives ^{(from Releem Blog)}

Dolt Wrapped 2024: A Year in Review ^{(from DoltHub Blog)}

Speedb vs RocksDB on a large server ^{(from Small Datum)}

Monitoring Multi-threaded Replication Lag With Performance Schema ^{(from Hack MySQL)}

Preventing MySQL Binary Log Sequence Number Exhaustion ^{(from Mydbops Blog)}

What do you expect from vector storage in databases? ^{(from MariaDB Foundation Blog)}

IBM upgrading Gold to Platinum ^{(from MariaDB Foundation Blog)}

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

Thoughts on ScyllaDB License Change ^{(from Peter Zaitsev)}

Host Database Serverlessly On AWS Fargate - Just Like Your Applications ^{(from WeSQL Blog)}

A Message From the Community Team ^{(from The Oracle MySQL Blog)}

MySQL enters a new decade! ^{(from The Oracle MySQL Blog)}

Resolving MySQL Binlog Errors and Reclaiming Disk Space ^{(from Mydbops Blog)}

10% Slower Than MySQL ^{(from DoltHub Blog)}

Troubleshooting and Resolving AUTO_INCREMENT Max Value Issues in MySQL and MariaDB ^{(from MinervaDB Blog)}

Resource Semaphore Mechanisms in InnoDB ^{(from MinervaDB Blog)}

MySQL Blog Revisited - OCI TypeScript SDK ^{(from The Oracle MySQL Blog)}

MySQL Shorts Revisited - DBA Goodies ^{(from The Oracle MySQL Blog)}

Resolving MySQL Error 1412 and Understanding Transaction Isolation Levels ^{(from MinervaDB Blog)}

Amazon RDS for MariaDB supports minors 11.4.4, 10.11.10, 10.6.20, 10.5.27 ^{(from AWS What's New)}

MariaDB Day Sat 1 Feb 2025 in Brussels ^{(from MariaDB Foundation Blog)}

MySQL Transaction ERROR 1412 and Isolation Levels ^{(from Percona Database Blog)}