Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

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

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

Tuesday, 16. April 2024

MariaDB Completes Nutanix Ready Certification for AI and Data-Driven Hybrid and Multicloud Applications (from MariaDB Corporation Blog)

In the fast-paced world of enterprise databases, reliability, scalability, and performance are paramount. Cloud deployment flexibility is critically important to … Continued [...]
Published Tuesday, 16. April 2024 16:30 • 4 hours ago

MySQL Shorts - Episode #60 is Released (from The Oracle MySQL Blog)

Episode #60 of MySQL Shorts in now available! [...]
Published Tuesday, 16. April 2024 15:04 • 5 hours ago

A Guide to Better Understanding MySQL Charset Levels (from Percona Database Blog)

♦We usually receive and see some questions regarding the charset levels in MySQL, especially after the deprecation of utf8mb3 and the new default uf8mb4. If you understand how the charset works on MySQL but have some questions regarding this change, please check out Migrating to utf8mb4: Things to Consider by Sveta Smirnova.Some of the questions […] [...]
Published Tuesday, 16. April 2024 13:24 • 7 hours ago

MariaDB Contribution Statistics, April 2024 (from MariaDB Foundation Blog)

pWith the first quarter of 2024 out of the way, we can take a look at the contribution statistics for the last three months. For the Foundation, this has been a very busy quarter, we have had a few big events to prepare for and attend. … /p pContinue reading \"MariaDB Contribution Statistics, April 2024\"/p pThe post MariaDB Contribution Statistics, April 2024 appeared first on MariaDB.org./p [...]
Published Tuesday, 16. April 2024 09:04 • 11 hours ago

EMEA MySQL Meetups in April & May 2024! - UPDATED! (from The Oracle MySQL Blog)

MySQL Meetups EMEA in April [...]
Published Tuesday, 16. April 2024 08:56 • 11 hours ago

A short tale about troubleshooting improbable bug – part deux (from Szymon Skorupinski Blog)

Last month I hoped that we have valid workaround for the bug described in A short tale about troubleshooting improbable bug. Unfortunately, it appeared that it is not working for all cases. As the fix for the bug was still missing, I tried to find something more reliable. Knowing the contents of the stack trace reported … Continue reading "A short tale about troubleshooting improbable bug  [...]
Published Tuesday, 16. April 2024 08:54 • 11 hours ago

Scale Your Database Traffic with Read/Write Splitting using MySQL Router: A Mydbops Webinar Recap (from Mydbops Blog)

Ever struggle with managing high database traffic? Mydbops, a leading database management and consultancy provider, recently hosted a webinar to shed light on how MySQL Router can help. Presented by V [...]
Published Tuesday, 16. April 2024 04:07 • 16 hours ago

Creating a MySQL HeatWave Read Replica with the OCI CLI (from The Oracle MySQL Blog)

The Oracle Cloud Infrastructure (OCI) command line interface (CLI) allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to create a read replica of a MySQL HeatWave instance. [...]
Published Tuesday, 16. April 2024 04:00 • 16 hours ago

Monday, 15. April 2024

Why SELECT COUNT(*) FROM TABLE Is Sometimes Very Slow in MySQL or MariaDB (from Percona Database Blog)

♦If you have enough experience with MySQL, it is very possible that you stumbled upon an unusually slow SELECT COUNT(*) FROM TABLE; query execution, at least occasionally.Recently, I had a chance to investigate some of these cases closer, and it stunned me what huge differences there can be depending on the circumstance given the very […] [...]
Published Monday, 15. April 2024 13:02 • a day ago

Saturday, 13. April 2024

The Insert Benchmark: MariaDB, MySQL, small server, cached workload (from Small Datum)

pThis post has results for the Insert Benchmark on a small server with a cached workload. The goal is to compare MariaDB and MySQL./ppThis work was done by Small Datum LLC and sponsored by the MariaDB Foundation./ppThe workload here has low concurrency and the database is cached. The results might be different when the workload is IO-bound or has more concurrency.brbrtl;dr/pp/pulliModern [...]
Published Saturday, 13. April 2024 18:18 • 3 days ago | Updated Saturday, 13. April 2024 18:18 • 3 days ago

Friday, 12. April 2024

How to query a REST API with MariaDB CONNECT engine (from Vettabase)

Querying a remote REST API directly from the database: does it sound like pure madness? Some people will surely answer that yes, it does. So, first of all, let me spend a paragraph to show some great benefits of doing so. Then I’ll show you how to query a REST API with MariaDB CONNECT storage engine. I will explore a practical use case with Hashicorp Releases API. The benefits of querying a R [...]
Published Friday, 12. April 2024 23:52 • 4 days ago

Microsoft Defender for Cloud support for Azure Database for MySQL - Flexible Server - GA (from Azure for MySQL Blog)

pWe’re excited to announce general availability of Microsoft Defender for Cloud support for Azure Database for MySQL - Flexible Server. Defender for Cloud provides Advanced Threat Protection (ATP) as part of the Microsoft Defender for open-source relational databases plan and simplifies security management of your MySQL flexible server by enabling effortless threat prevention, detection, and mitiga [...]
Published Friday, 12. April 2024 20:45 • 4 days ago

Azure Database for MySQL - March 2024 updates and latest feature roadmap (from Azure for MySQL Blog)

pWe're pleased to share a summary of the Azure Database for MySQL - Flexible Server feature updates and announcements from last month, as well as the latest roadmap of upcoming features!/p p /p April 2024 Live webinar p /p pThese feature updates are also covered in our Monthly Live Webinar on YouTube (Click here to subscribe to our YouTube channel!), which streams the second Wednesday of [...]
Published Friday, 12. April 2024 17:49 • 4 days ago

Access Amazon RDS across AWS accounts using AWS PrivateLink, Network Load Balancer, and Amazon RDS Proxy (from AWS Database Blog)

Amazon RDS Proxy is a fully managed, highly available database proxy for Amazon Relational Database Service (Amazon RDS) and Amazon Aurora that makes applications more scalable, secure, and resilient to database failures. With RDS Proxy, you can handle unpredictable surges in database traffic that might otherwise cause issues due to using all available connections or creating new connections at a f [...]
Published Friday, 12. April 2024 15:43 • 4 days ago

Partially Rolling Back a Transaction in MySQL or PostgreSQL (from Percona Database Blog)

♦This short write-up focuses on a different transaction control behavior of databases. Though this is not unusual, I decided to write an article on rolling back transactions to a particular point. I selected this topic because I found many people are not aware of this feature in databases.DescriptionEvery ACID-compliant RDBMS follows the “All or None” […] [...]
Published Friday, 12. April 2024 13:36 • 4 days ago

Backing up and Restoring a MySQL HeatWave Instance with the OCI CLI (from The Oracle MySQL Blog)

The Oracle Cloud Infrastructure (OCI) command line interface (CLI) allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to create a backup of a MySQl HeatWave instance and then restore that back up to a new HeatWave instance. [...]
Published Friday, 12. April 2024 04:00 • 5 days ago

Sysbench on a small server: MariaDB and MySQL (from Small Datum)

pThis has results from the sysbench benchmark for MariaDB and MySQL on a small server with a cached and low-concurrency workload. For MariaDB I tested LTS releases from 10.2 through 11.4. For MySQL I tested 5.6, 5.7 and 8.0. The results from MySQL here are a good reason to use changepoint detection to spot regressions early, like that provided by Nyrkiö./ppThis work was done by Small Datu [...]
Published Thursday, 04. April 2024 20:58 • 12 days ago | Updated Friday, 12. April 2024 00:51 • 5 days ago

Sysbench on a (less) small server: MariaDB and MySQL (from Small Datum)

pThis has results from the sysbench benchmark for MariaDB and MySQL on a (less) small server with a cached and low-concurrency workload. For MariaDB I tested LTS releases from 10.2 through 11.4. For MySQL I tested 5.6, 5.7 and 8.0. The results from MySQL here are a good reason to use changepoint detection to spot regressions early, like that provided by Nyrkiö./ppThis work was done by&nbs [...]
Published Friday, 12. April 2024 00:40 • 5 days ago | Updated Friday, 12. April 2024 00:40 • 5 days ago

Thursday, 11. April 2024

How to Replicate and Rename a Database in MariaDB (from Percona Database Blog)

♦MySQL/MariaDB replication filter is an important feature when we need to replicate only certain databases or tables. Having this configuration option change dynamically is really convenient, but in this article, we’ll note that some replication filters are not dynamic, and you should be aware of that.The use case here is to replicate one database from […] [...]
Published Thursday, 11. April 2024 13:14 • 5 days ago

MySQL at OSC (Open Source Conference) Japan 2023 - Recap. (from The Oracle MySQL Blog)

OSC Japan 2023 recap [...]
Published Thursday, 11. April 2024 11:12 • 5 days ago

Improving Database Performance with ReadySet: A MySQL Caching Solution (from Another Boring Tech Blog)

pMany developers face the challenge of achieving performance without compromising on real-time application functionality in database management. This brings us to today’s spotlight technology: ReadySet. What is ReadySet? According to its GitHub repository, ReadySet is designed to enhance the performance of real-time applications by providing a powerful SQL caching engine that requires no chan [...]
Published Thursday, 11. April 2024 01:52 • 6 days ago

Profiling memory usage in MySQL (from PlanetScale Blog)

Learn how to visualize the memory usage of a MySQL connection [...]
Published Thursday, 11. April 2024 00:00 • 6 days ago

Wednesday, 10. April 2024

Load Test Emulation for Azure Database for MySQL - Flexible Server using mysqlslap (from Azure for MySQL Blog)

pGuidance for using mysqlslap to simulate client load and measure performance/p p /p Introduction pMysqlslap is a diagnostic program included with the MySQL server binary that you can use to emulate client load for a MySQL server and report the timing of each stage. Mysqlslap works as if multiple clients are accessing the server simultaneously./p p /p pIn this post, I’ll show you how to u [...]
Published Wednesday, 10. April 2024 22:09 • 6 days ago

GitHub Availability Report: March 2024 (from The GitHub Blog)

pIn March, we experienced two incidents that resulted in degraded performance across GitHub services. /p pThe post GitHub Availability Report: March 2024 appeared first on The GitHub Blog./p [...]
Published Wednesday, 10. April 2024 20:15 • 6 days ago

Generally available: Defender for Cloud supports Azure Database for MySQL - Flexible Server (from Azure Updates)

You can now protect Azure Database for MySQL - Flexible Server with Microsoft Defender for Cloud. [...]
Published Wednesday, 10. April 2024 16:00 • 6 days ago

17 Years of Insecure MySQL Client ! (from J-F Gagné's MySQL Blog)

Yes, this is a catchy title, but it is true, and it got you reading this post :-).  Another title could have been “Please load this mysql-dump: what could go wrong ?”.  As you guessed, loading a dump is not a risk-free operation.  In this post, I explain how the insecure MySQL client makes this operation risky and how to protect against it. And if you think this post is not [...]
Published Wednesday, 10. April 2024 14:42 • 6 days ago | Updated Wednesday, 10. April 2024 14:42 • 6 days ago

Percona Monitoring and Management Setup on Kubernetes with NGINX Ingress for External Databases (from Percona Database Blog)

♦It’s a common scenario to have a Percona Monitoring and Management (PMM) server running on Kubernetes and also desire to monitor databases that are running outside the Kubernetes cluster. The Ingress NGINX Controller is one of the most popular choices for managing the inbound traffic to K8s. It acts as a reverse proxy and load […] [...]
Published Wednesday, 10. April 2024 12:49 • 6 days ago

Install Tungsten Clustering Version 7 Securely in 10 Easy Steps (from Continuent Blog)

In this blog post, we explore the 10 basic steps for doing a secure Tungsten Clustering deployment. A fresh Tungsten version 7 installation is secure by default. We also cover the various tungsten.ini options that impact an install.Tags: tungsten clustersecuritysslhow to [...]
Published Wednesday, 10. April 2024 10:30 • 6 days ago

Listing and Updating MySQL HeatWave Instances with the OCI CLI (from The Oracle MySQL Blog)

The Oracle Cloud Infrastructure (OCI) command line interface (CLI) allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to retrieve a list of MySQL HeatWave instances, retrieve more detailed information for a specific instance, and update properties of that instance. [...]
Published Wednesday, 10. April 2024 04:00 • 7 days ago

Top 5 Reasons To Attend MySQL and HeatWave Summit 2024 (from The Oracle MySQL Blog)

Join us at MySQL and HeatWave Summit 2024, on May 1, 2024 in Redwood Shores, California. Free, unperson event, open to all. Learn about Generative AI and Machine Learning. Get One-on-One Help and Feature Demos. Hear from Leading Companies like NVIDIA, Meta, LY Corp, CERN, Panasonic Avionics. And Network with the MySQL Community. [...]
Published Wednesday, 10. April 2024 03:44 • 7 days ago

Tuesday, 09. April 2024

Amazon RDS for MySQL supports rds_superuser_role for easier implementation of role based privileges (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for MySQL now supports rds_superuser_role to simplify implementation of role-based privileges on MySQL 8.0. The rds_superuser_role is granted by default to the primary administrative user, and has privileges including, CREATE ROLE, CREATE USER, and DROP ROLE, for all database objects. For a complete list of rds_superuser_role privileges, refer to the [...]
Published Tuesday, 09. April 2024 17:02 • 7 days ago

Ask Me Anything About MySQL 5.7 to 8.0 Post EOL (from Percona Database Blog)

♦We met with Vinicius Grippa, a Senior Support Engineer at Percona. He is also active in the open source community and was recognized as a MySQL Rock Star in 2023.In the previous interview with Vinicius, we discussed the upcoming End of Life (EOL) for MySQL 5.7. Now that MySQL 5.7 has reached EOL, MySQL 8 […] [...]
Published Tuesday, 09. April 2024 16:02 • 7 days ago

Why Top Spanish Business School Esade Migrated from MySQL to MariaDB Enterprise Server (from MariaDB Corporation Blog)

Esade Ramon Llull University is a top business school located in Barcelona, Spain. They are committed to nurturing the next … Continued [...]
Published Tuesday, 09. April 2024 16:00 • 7 days ago

Accelerate database development in Amazon RDS and Amazon Aurora with Amazon CodeWhisperer (from AWS Database Blog)

As organizations continue to scale applications, the need for database developers to quickly pick up new skills becomes increasingly important. Amazon CodeWhisperer is an AI-powered productivity tool for the integrated development environment (IDE) and command line that helps improve developer productivity by generating code recommendations based on your comments in natural language and code in […] [...]
Published Tuesday, 09. April 2024 15:48 • 7 days ago

MariaDB Joins Forces with Google Cloud to Enhance Support Operations on Google Distributed Cloud (from MariaDB Corporation Blog)

In an era where the cloud is omnipresent, yet the needs for data sovereignty, security, and localized performance are paramount, … Continued [...]
Published Tuesday, 09. April 2024 12:00 • 7 days ago

Google adds Gemini to databases to aid faster code development, migration (from InfoWorld)

pGoogle Cloud is adding capabilities driven by its proprietary large language model, Gemini to its database offerings, which include Bigtable, Spanner, Memorystore for Redis, Firestore, CloudSQL for MySQL, and AlloyDB for PostgreSQL, the company announced at its annual Next conference./ppThe Gemini-driven capabilities, which are currently in public preview, include SQL generation, and AI assista [...]
Published Tuesday, 09. April 2024 12:00 • 7 days ago

MariaDB's parallel replication to catch up (from Shinguz's Blog)

pDue to an application error, our replication stopped for 5 days (over Easter). After the problem was solved, the replication was supposed to catch up, which turned out to be very slow. All the usual tricks (codeinnodb_flush_log_at_trx_commit/code, codesync_binlog/code, etc.) had already been exhausted. So we tried our hand at parallel replication of the MariaDB server./p pParallel replication is [...]
Published Tuesday, 09. April 2024 08:53 • 7 days ago

Leverage TiDB's Automated TTL Feature for Efficient Data Management (from Mydbops Blog)

Modern applications generate a tidal wave of data. But what happens to all that information as it accumulates? Just like a cluttered attic, a database overflowing with old data can lead to sluggish pe [...]
Published Tuesday, 09. April 2024 04:49 • 8 days ago

Summer 2023: Fuzzing Vitess at PlanetScale (from PlanetScale Blog)

My experience working as an intern in the Vitess query serving team for PlanetScale. [...]
Published Tuesday, 09. April 2024 00:00 • 8 days ago

Monday, 08. April 2024

Creating a MySQL HeatWave Instance With the OCI CLI (from The Oracle MySQL Blog)

The Oracle Cloud Infrastructure (OCI) command line interface (CLI) allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to retrieve reference data and create a new MySQL HeatWave instance. [...]
Published Monday, 08. April 2024 04:00 • 9 days ago

Summer 2023: Fuzzing Vitess at PlanetScale (from Vitess)

My name is Arvind Murty, and from May to July of 2023, I worked on Vitess via an internship with PlanetScale. I was first introduced to Vitess when I was in high school as a potential open-source project for me to work on. I had been interested in working on one because they’re a relatively easy way to get some real-world experience in large-scale software development. Vitess seemed like an good pl [...]
Published Monday, 08. April 2024 00:00 • 9 days ago

Saturday, 06. April 2024

Calling All Open-Source Database Experts: Share Your Knowledge at Mydbops Meetup 16! (from Mydbops Blog)

Mark your calendars, database enthusiasts! The Mydbops Open Source Database Meetup 16 is happening on June 8th, 2024, and we're seeking passionate experts like YOU to share your insights with the comm [...]
Published Saturday, 06. April 2024 12:33 • 10 days ago

Friday, 05. April 2024

Querying Percona Operator for MongoDB Logs Using LogCLI (from Percona Database Blog)

♦With all the convenience Kubernetes operators provide in managing resources, it can still be a challenge to conveniently store, query, manage, and download the database logs from the pods. Since the pod logs are rotated after a certain period or size depending on the configuration and workload, it’s necessary to collect them to analyze for […] [...]
Published Friday, 05. April 2024 15:08 • 11 days ago

Japan: Special MySQL Meetup on April 11! (from The Oracle MySQL Blog)

HWJP meetup Apr 2024 [...]
Published Friday, 05. April 2024 11:08 • 11 days ago

Building MariaDB Server from the sources (from Shinguz's Blog)

pRecently I had to test a new MariaDB feature that was developed at our request (MDEV-33782). To test this feature I had to build the MariaDB server myself from source, which I have not done for a long time. So a new challenge, especially with codeCMake/code.../p pI followed the MariaDB documentation Get, Build and Test Latest MariaDB the Lazy Way to build the server./p pOn Ubuntu 22.04 it did no [...]
Published Friday, 05. April 2024 06:47 • 12 days ago

dbdeployer Tutorial on Mac (from J-F Gagné's MySQL Blog)

Not very long ago (well, maybe a little longer, this post is in draft for more than a year), in the spawn of less than 5 days, I suggested many colleagues to reproduce a problem they had with MySQL in a "more simple environment".  Such more simple environment can be created with dbdeployer.  dbdeployer is a tool to create "MySQL Sandboxes" on a Mac (laptop or desktop) or on Linux (vm, [...]
Published Friday, 05. April 2024 00:55 • 12 days ago | Updated Friday, 05. April 2024 02:08 • 12 days ago

Thursday, 04. April 2024

Perf regressions in MySQL from 5.6.21 to 8.0.36 using sysbench and a small server (from Small Datum)

pThis has results for sysbench vs upstream MySQL on a small server. I have results for some 5.6, 5.7 and 8.0 releases up to 8.0.36. My last report stopped at 8.0.34. The goal is to document where things get faster or slower over time for a low-concurrency and CPU-bound workload. The focus is on CPU regressions. /ppMy results here aren't universal. /pp/pulliThe microbenchmarks here mostly [...]
Published Saturday, 17. February 2024 03:52 • 2 months ago | Updated Thursday, 04. April 2024 20:00 • 12 days ago

Amazon RDS now supports M6gd database instances in six additional AWS regions (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for PostgreSQL, MySQL, and MariaDB now supports AWS Graviton2-based M6gd database instances in Asia Pacific (Hong Kong, Melbourne, Seoul), Canada (Central), Europe (Milan), and Middle East (Bahrain) regions./p [...]
Published Thursday, 04. April 2024 17:01 • 12 days ago

Automatic MySQL Query Cache with Readyset and ProxySQL (from Readyset Blog)

Learn how to use a dedicated scheduler for integrating Readyset with ProxySQL to automatic inspect your workload and cache problematic queries. [...]
Published Thursday, 04. April 2024 15:38 • 12 days ago

MySQL NDB Cluster replication: Introduction (from The Oracle MySQL Blog)

Learn more about basic single-channel replication setup as well as the high-end active-active circular or merge replication setups. In this series we will describe how it works both on high level as well as the detailed technical level. [...]
Published Thursday, 04. April 2024 14:39 • 12 days ago

ClusterControl Terraform provider now available (from Severalnines Blog)

pWe’re pleased to announce that ClusterControl (CC) now integrates with the widely-used Infrastructure as Code (IaC) tool – Terraform. With our Terraform Provider, users can build provisioning workflows into the deployment sequences of their ClusterControl-managed databases. For DevOps teams using ClusterControl and Terraform, this will further reduce the daily operational load and comp [...]
Published Thursday, 04. April 2024 09:45 • 12 days ago

How PlanetScale makes schema changes (from PlanetScale Blog)

Learn how PlanetScale uses GitHub Actions and PlanetScale to automate schema changes on our own application. [...]
Published Thursday, 04. April 2024 09:00 • 12 days ago

MaxScale configuration synchronisation (from Shinguz's Blog)

Table of contents ul liOverview/li liPreparations/li liActivate MaxScale configuration synchronisation/li liChange MaxScale parameters/li liAdd new slave and make MaxScale known/li liRemove old slave and make MaxScale known/li liHow is the configuration synchronised?/li liWhat happens in the event of a conflict?/li liTests/li liDeactivating MaxScale configuration synchronisatio [...]
Published Thursday, 04. April 2024 07:53 • 13 days ago

Introducing Tungsten Cluster & Tungsten Replicator v7.1.2 (from Continuent Blog)

Discover the latest enhancements, new features, and critical bug fixes in Tungsten Cluster and Tungsten Replicator version 7.1.2. Explore behavior changes affecting installation and deployment, learn about the introduction of the tungsten_mysql_ssl_setup command-line tool and critical bug fixes addressing issues such as data source monitoring and cluster switch failures.Tags: tungsten clusteri [...]
Published Thursday, 04. April 2024 07:39 • 13 days ago

Using the Oracle Cloud TypeScript SDK Part 7 - Retrieving Reference Lists (from The Oracle MySQL Blog)

Oracle offers a variety of SDKs for interacting with Oracle Cloud Infrastructure resources. In this post we discuss how to retrieve reference data that can be used to configure MySQL HeatWave instances. [...]
Published Thursday, 04. April 2024 04:00 • 13 days ago

Wednesday, 03. April 2024

Azure Database for MariaDB retirement - Key updates and migration information (from Azure for MySQL Blog)

pAzure Database for MariaDB is scheduled for retirement by September 19, 2025/p p /p pIn alignment with the Azure Database for MariaDB retirement announcement, we stopped support for creating MariaDB instances via the Azure portal or CLI as of March 19, 2024. If you still need to create MariaDB instances to address business continuity requirements, please raise an Azure support ticket./p [...]
Published Wednesday, 03. April 2024 00:41 • 14 days ago

Tuesday, 02. April 2024

PostgreSQL for MySQL DBAs Second Edition Is Now Available (from Percona Database Blog)

♦Many years ago, when I was the Certification Manager for MySQL AB, I would be in contact with hiring managers looking for talent. One frustrated individual informed me that while it was hard to find a qualified MySQL DBA, it was impossible to find a qualified PostgreSQL DBA. Years later, that same sentiment is still […] [...]
Published Tuesday, 02. April 2024 17:24 • 14 days ago

Amazon Aurora zero-ETL integration with Amazon Redshift now in additional regions (from AWS What's New)

pAmazon Aurora MySQL zero-ETL integration with Amazon Redshift is now supported in 11 additional regions, enabling near real-time analytics and machine learning (ML) using Amazon Redshift. Based on your analytics needs, you can include or exclude specific databases and tables from an existing or a new zero-ETL integration and selectively bring data into Amazon Redshift./p [...]
Published Tuesday, 02. April 2024 17:04 • 14 days ago

Releasing ProxySQL v2.6.2! (from ProxySQL Blog)

pWe are proud to announce the latest release of ProxySQL version 2.6.2 ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded from the ProxySQL Repository (instructions here) or for a Docker image check out the Official ProxySQL Docker Repository. ProxySQL is freely usable and [...]/p pThe post Releasing ProxySQL v2.6.2! appeared [...]
Published Tuesday, 02. April 2024 16:49 • 14 days ago

Achieve faster switchover for Amazon RDS Blue/Green Deployments with large number of connections (from AWS Database Blog)

In this post, we show you a recent improvement for Amazon RDS Blue/Green Deployment switchovers to reduce your overall downtime when you have a large number of connections to your database. Blue/Green Deployments enforce safety measures to make sure that the switchover from your blue environment to the green environment maintains data consistency. For reference, […] [...]
Published Tuesday, 02. April 2024 15:45 • 14 days ago

Integrating Readyset with ProxySQL for MySQL workloads (from Readyset Blog)

Learn the step-by-step process of configuring ProxySQL with Readyset for optimized MySQL performance today, including advanced connection management techniques. [...]
Published Tuesday, 02. April 2024 14:13 • 14 days ago

MariaDB Community Server 11.4 LTS: What This Means For Customers (from MariaDB Corporation Blog)

MariaDB Community Server 11.4 will be a long-term maintenance (LTS) release. Version 11.4 is currently in RC and will be … Continued [...]
Published Tuesday, 02. April 2024 12:00 • 14 days ago

MariaDB Server 11.4 will be LTS (from MariaDB Foundation Blog)

pMariaDB Server 11.4 will be a long-term support release, on top of our current plan.br Early February, we announced that we were adjusting the MariaDB Server release model. … /p pContinue reading \"MariaDB Server 11.4 will be LTS\"/p pThe post MariaDB Server 11.4 will be LTS appeared first on MariaDB.org./p [...]
Published Tuesday, 02. April 2024 09:33 • 14 days ago

Using the Oracle Cloud TypeScript SDK Part 6 - Updating a MySQL HeatWave Backup (from The Oracle MySQL Blog)

Oracle offers a variety of SDKs for interacting with Oracle Cloud Infrastructure resources. In this post we discuss how to update some propertied of a backup of a MySQL HeatWave instance. [...]
Published Tuesday, 02. April 2024 04:00 • 15 days ago

Monday, 01. April 2024

March Product Updates (from Readyset Blog)

Check out Readyset's product updates for March 2024, including added support for new MySQL commands, the ability to cache multiple queries, and more. [...]
Published Monday, 01. April 2024 22:40 • 15 days ago

Database Management Now Monitors MySQL HeatWave Clusters and Lakehouse (from The Oracle MySQL Blog)

The initial release focused on MySQL OLTP observability. Building upon the existing foundation, we are pleased to announce an extension of its monitoring capabilities encompassing MySQL HeatWave clusters and Lakehouse-enabled DB Systems. With this enhancement, the Database Management service empowers data professionals with deeper insights and provides proactive monitoring opportunities, ensuring r [...]
Published Monday, 01. April 2024 17:46 • 15 days ago

caching_sha2_password Support for ProxySQL Is Finally Available! (from Percona Database Blog)

♦ProxySQL recently released version 2.6.0, and going through the release notes, I focused on the following:Added support for caching_sha2_password!This is great news for the community! The caching_sha2_password authentication method for frontend connections is now available. This has been a long-awaited feature …Why?Because in MySQL 8, caching_sha2_password has been the default authentication [...]
Published Monday, 01. April 2024 17:11 • 15 days ago

Public preview: Azure Backup supports long term retention for backup of Azure Database for MySQL– Flexible Server (from Azure Updates)

Now you can retain backups for up to 10 years by defining your own backup and retention policy for MySQL- Flexible server. [...]
Published Monday, 01. April 2024 16:00 • 15 days ago

Unleash Peak Database Performance with TiDB's Smart Engine Selection (from Mydbops Blog)

TiDB, the distributed SQL database, is renowned for its horizontal scalability, strong consistency, and compatibility with MySQL. One of the standout features that enhance its performance and flexibil [...]
Published Monday, 01. April 2024 12:23 • 15 days ago

Learning SQL Exercise (from MacLochlainns Weblog)

I’ve been using Alan Beaulieu’s Learning SQL to teach my SQL Development class with MySQL 8. It’s a great book overall but Chapter 12 lacks a complete exercise. Here’s all that the author provides to the reader. This is inadequate for most readers to work with to solve the concept of a transaction. Exercise 12-1 […] [...]
Published Monday, 01. April 2024 06:32 • 16 days ago

Sunday, 31. March 2024

TOP 10 IDEs for SQL Database Management & Administration [2024] (from Devart MySQL Tool Blog)

pIDEs are comprehensive software products equipped with specialized tools for software development. This article explores the most popular and powerful database-related IDEs, their functionality, advantages, pricing models, and other crucial factors./p pThe post TOP 10 IDEs for SQL Database Management & Administration [2024] appeared first on Devart Blog./p [...]
Published Sunday, 31. March 2024 07:09 • 17 days ago

Friday, 29. March 2024

Web3Bench: A New HTAP Benchmark for Web3 Workloads (from TiDB and TiKV Blog)

pThis blog introduces Web3Bench, a hybrid transaction/analytical processing (HTAP) benchmark that addresses earlier limitations. Web3Bench is based on real-world Web3 use cases that utilize HTAP. Our data model is a simplified version of the decentralized blockchain Ethereum. We leverage a sample data set from Ethereum to build a scale factor-based data generator. The workload in […]/p pThe p [...]
Published Friday, 29. March 2024 20:44 • 18 days ago

A MyLoader Error You Might Face When Restoring Databases (from Percona Database Blog)

♦At Percona Managed Services, we manage Percona for MySQL, MySQL Community, MariaDB, and other software. Sometimes we might need to use mydumper/myloader to restore one or more databases from the production environment to the lower environment for testing. The automated restore process ran well until one day, we got the error below.0. The error we face […] [...]
Published Friday, 29. March 2024 12:56 • 18 days ago

MySQL HeatWave Faster Point-in-time Recovery (from The Oracle MySQL Blog)

MySQL HeatWave Faster Point-in-time Recovery [...]
Published Friday, 29. March 2024 00:47 • 19 days ago

Identifying and profiling problematic MySQL queries (from PlanetScale Blog)

MySQL has built-in functionality for collecting statistics on and profiling your MySQL queries. Learn how to leverage these features to identify problems. [...]
Published Friday, 29. March 2024 00:00 • 19 days ago

Thursday, 28. March 2024

How to Connect to a MySQL Database on a DigitalOcean Droplet Using dbForge Studio (from Devart MySQL Tool Blog)

pToday, accessing and managing databases remotely is a fundamental skill for developers, system administrators, and anyone working with data-driven applications. In this article, we will demonstrate how to establish an SSH connection to a MySQL database on a DigitalOcean Droplet—a virtual private server that can host various applications and databases./p pThe post How to Connect to a MySQL Database [...]
Published Thursday, 28. March 2024 15:28 • 19 days ago

Galera Manager March 2024 Release now includes UI improvements and a SSH console tab (from Galera Blog)

Codership is please to announce a new release of Galera Manager. This brings the installer to version 1.13.0 (you can check this by typing: ./gm-installer version which will report gm-installer version 1.13.0 (linux/amd64)) and the actual Galera Manager GUI to 1.8.4. Users will notice many usability improvements, and multiple fixes for issues filed at the […] [...]
Published Thursday, 28. March 2024 13:40 • 19 days ago

MySQL Shorts - Episode #59 is Released (from The Oracle MySQL Blog)

Episode #59 of MySQL Shorts in now available! [...]
Published Thursday, 28. March 2024 13:15 • 19 days ago

Progress outbids private equity in offer for MariaDB plc (from The Register)

MySQL sibling saga continues as 40-year-old infrastructure software firm enters the fray pProgress Software has made a bid for MariaDB, offering a price that is less than a tenth of the beleaguered company's value at its IPO launch.…/p [...]
Published Thursday, 28. March 2024 11:00 • 19 days ago

How to Remove Duplicate Rows in MySQL (from Devart MySQL Tool Blog)

pDuplicates pose an ongoing risk to the data consistency and the overall database efficiency. This article will explore the issue of duplicate records, including their origins, the effects they have on databases, and strategies for swiftly detecting and permanently removing duplicates./p pThe post How to Remove Duplicate Rows in MySQL appeared first on Devart Blog./p [...]
Published Thursday, 28. March 2024 10:20 • 19 days ago

Wednesday, 27. March 2024

MariaDB Wins at the CloudFest Hackathon (from MariaDB Foundation Blog)

pOK, MariaDB Server didn’t specifically win, but a project around the MariaDB Catalogs feature won and the team behind it was led by me. In this post, I shall dig into what the CloudFest Hackathon is, what we did there and why it is a big deal. … /p pContinue reading \"MariaDB Wins at the CloudFest Hackathon\"/p pThe post MariaDB Wins at the CloudFest Hackathon appeared first on MariaDB [...]
Published Wednesday, 27. March 2024 18:06 • 20 days ago

Enhancing PostgreSQL Insights with Percona Monitoring and Management: A Closer Look at Recent Updates (from Percona Database Blog)

♦Database monitoring tools play a crucial role in ensuring the smooth operation and performance optimization of database systems, and Percona Monitoring and Management (PMM) has been a go-to choice for many organizations seeking robust monitoring solutions for their open source databases. Recently, two significant enhancements have been made to PMM and the postgres_exporter to make […] [...]
Published Wednesday, 27. March 2024 16:02 • 20 days ago

How Platform Engineers Can Automate Postgres Maintenance (from Readyset Blog)

Discover how to automate Postgres maintenance for optimal database performance. Learn autovacuum tuning and VACUUM strategies. [...]
Published Wednesday, 27. March 2024 16:00 • 20 days ago

Creating a Standby Cluster With the Percona Operator for PostgreSQL (from Percona Community Blog)

In this video, Nickolay Ihalainen, a Senior Scaling Specialist at Percona Global Services, explains how to set up replication with standby clusters for Kubernetes databases using Percona’s open-source tools, including the Percona Operator for PostgreSQL A Standby Cluster is a backup version of your main database. It’s there to keep your data safe and make sure your database can keep run [...]
Published Wednesday, 27. March 2024 00:00 • 21 days ago

… IS JSON [ARRAY|OBJECT|SCALAR] (from Modern SQL)

code… Is Json [Array|Object|Scalar]/code: Test for Valid JSON, Distinguish between Arrays, Objects and Scalars♦olli⚡Does not recognize JSON scalars as valid JSON/liliNo type constraints: code… is json [value|array|object|scalar]/code/liliSee Alternatives/liliAccepts unquoted object keys: code{a: 1}/code/li/olpcodeIs json/code is a predicate, similar to codeis null/code, to test something for valid [...]
Published Wednesday, 27. March 2024 00:00 • 21 days ago

Tuesday, 26. March 2024

Copying Alert Rules From One Percona Monitoring and Management Server to Another (from Percona Database Blog)

♦Since Percona Monitoring and Management (PMM) 2.40.0, Grafana uses PostgreSQL instead of SQLite database to store users, dashboards, and other persistent data. This aids in getting some useful information related to [configured alerts] directly via querying from the Postgres backend.Sometimes we need to migrate only alert rules from one PMM server to another for some […] [...]
Published Tuesday, 26. March 2024 16:08 • 21 days ago

Galera Cluster for MySQL 8.0.36 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.36 (release notes, download), with Galera replication library 4.18 (release notes, download) implementing wsrep API version 26. This release incorporates all changes to MySQL 8.0.36, adding a synchronous option for your MySQL High […] [...]
Published Tuesday, 26. March 2024 14:13 • 21 days ago

Why Your Next MySQL Database Should Not Be a MySQL Database (from Percona Database Blog)

♦MySQL is a very popular database and a good choice for new projects. But is it the best choice?Luckily you have several options for this choice.MySQL Community vs. Enterprise EditionsTraditionally, the MySQL Community Edition has been a mainstay in the open source community for decades, and it is available for free. Originally, MariaDB was a […] [...]
Published Tuesday, 26. March 2024 13:03 • 21 days ago

Enhancing Database Security with ProxySQL 2.6.0: caching_sha2_password (from ProxySQL Blog)

pEnhancing Database Security with ProxySQL 2.6.0: Introducing caching_sha2_password Authentication In the digital age, where data breaches are increasingly common, securing database connections is paramount for organizations of all sizes. At ProxySQL LLC, we understand the criticality of robust security measures, which is why we are excited to announce a significant update in ProxySQL 2.6.0: the [. [...]
Published Tuesday, 26. March 2024 11:00 • 21 days ago

Monday, 25. March 2024

Demystifying AWS Backup for Amazon RDS for Oracle (from AWS Database Blog)

Customers prefer to host their relational database workloads in a managed service such as Amazon Relational Database Service (Amazon RDS) because of the benefits offered by managed services. Although Amazon RDS offers automatic backups as a native feature, your data retention policies may require longer retention periods than the retention policy supported by Amazon RDS. […] [...]
Published Monday, 25. March 2024 14:26 • 22 days ago

How To Interpret "Broken Pipe" Tungsten Connector Log Errors (from Continuent Blog)

In this blog post, we examine the “Broken Pipe” log message from the Tungsten Connector. We describe possible causes, and discuss the differences between Bridge and Proxy mode authentication methods.Tags: ConnectorerrorsLogsBridgeProxyauthenticationbroken pipe [...]
Published Monday, 25. March 2024 12:17 • 22 days ago

Beyond the “Hobby” plan: A guide to choosing your next free DBaaS (from TiDB and TiKV Blog)

pWhy TiDB Serverless is the right long-term choice if you’re migrating from your former provider’s free plan. Change is constant in the world of developer toolkits. It’s beneficial because it enables us to deliver more value, faster. New technologies, products, and open-source projects propel this dynamic progress. But it’s a different story when someone else’s […]/p p [...]
Published Monday, 25. March 2024 09:28 • 22 days ago

The Impact of Log File Synchronization on InnoDB Performance and Durability (from MinervaDB Blog)

pLog file synchronization plays a crucial role in the performance and reliability of MySQL’s InnoDB storage engine. The efficiency and speed of log file synchronization directly impact database throughput, latency, and durability. Here’s how this [...]/p pThe post The Impact of Log File Synchronization on InnoDB Performance and Durability appeared first on The WebScale Database Infrastr [...]
Published Monday, 25. March 2024 07:47 • 23 days ago

Demystifying TiDB's Write Path: A Guide to Scalable Data Management (from Mydbops Blog)

Struggling with slow databases as your data keeps growing? Regular databases can get overloaded when lots of users try to write information at once. This can make your application sluggish and risk lo [...]
Published Monday, 25. March 2024 04:49 • 23 days ago

Preventing Broken Foreign Keys in PostgreSQL: Causes and Solutions (from MinervaDB Blog)

pBroken foreign keys in PostgreSQL, or in any relational database system, refer to a situation where a foreign key value in one table does not have a corresponding primary key value in another table. This [...]/p pThe post Preventing Broken Foreign Keys in PostgreSQL: Causes and Solutions appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and Cli [...]
Published Monday, 25. March 2024 04:01 • 23 days ago

Sunday, 24. March 2024

MySQL: Identifying Tables Not Using InnoDB (from Another Boring Tech Blog)

pThis blog post aims to spotlight tables within a MySQL database that do not employ the InnoDB storage engine. The essence of the query is to filter out tables that do not utilize the InnoDB engine, thereby enabling a focused analysis or migration plan for database optimization. Below is the query: [crayon-66186b95393bb513395621/] Let’s dissect the.../p pO post MySQL: Identifying Tables Not Using I [...]
Published Sunday, 24. March 2024 23:05 • 23 days ago

Friday, 22. March 2024

Building an AI-Powered Crypto ETF Insights App with GPTs and TiDB Cloud Data Service (from TiDB and TiKV Blog)

pTo navigate the dynamic cryptocurrency market, investors always look for a sophisticated crypto ETF insights app that provide them with the necessary insights. Traditional price-tracking websites like CoinMarketCap offer a snapshot of the market. Yet, they often present challenges, particularly when investors seek deeper, personalized insights from an overwhelming volume of data.   This [...]
Published Friday, 22. March 2024 19:11 • 25 days ago

Releasing ProxySQL v2.6.1! (from ProxySQL Blog)

pWe are proud to announce the latest release of ProxySQL version 2.6.1 ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded from the ProxySQL Repository (instructions here) or for a Docker image check out the Official ProxySQL Docker Repository. ProxySQL is freely usable and [...]/p pThe post Releasing ProxySQL v2.6.1! appeared [...]
Published Friday, 22. March 2024 14:39 • 25 days ago

New LTS version of RonDB, RonDB 22.10.2 (from Mikael Ronstrom)

p After a very thorough development and test period we are proud to announce the general availability of the RonDB 22.10 LTS serie with the release of RonDB 22.10.2 today. There is also a new version of the old LTS version RonDB 21.04.16 released today./ppA complete list of the new features is provided in the RonDB Documentation./ppThe most important new feature is the support of variable size [...]
Published Friday, 22. March 2024 11:15 • 25 days ago | Updated Friday, 22. March 2024 11:15 • 25 days ago

Thursday, 21. March 2024

Amazon RDS Multi-AZ deployments with readable standby instances now support C6gd database instances (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) now supports C6gd database (DB) instances in RDS for PostgreSQL and MySQL Multi-AZ deployments with two readable standbys. These compute optimized DB instances are available in sizes ranging from 1 vCPU up to 64 vCPU (medium up to 16xlarge sizes). C6gd DB instances are the only instances that support medium size instances for Multi-AZ deployment [...]
Published Thursday, 21. March 2024 21:52 • 26 days ago