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.

Wednesday, 22. May 2024

Where can you find MySQL during June - August 2024 (from The Oracle MySQL Blog)

Where is MySQL, 6-9, 2024 [...]

Why you should use SQLite (from InfoWorld)

pLift the hood on most business applications, and you’ll find they have some way to store and use structured data. Whether it’s a client-side app, an app with a web front end, or an edge-device app, chances are a business application needs a database. In many cases, an embedded database will do. Embedded databases are lightweight, compact, and portable—and for some applications, they are a bette [...]

Making my MySQL InnoDB Cluster safe from naughtiness (from MySQL-Med)

Protecting InnoDB Cluster from naughty DBA's and Dev's: Make sure everything has a PK and is in InnoDB... Continue reading → [...]

Using Oracle Analytics Cloud with MySQL HeatWave (from The Oracle MySQL Blog)

In this article, we will see how to connect OAC to MySQL HeatWave in OCI. [...]

Using Oracle Analytics Cloud with MySQL HeatWave (from lefred's blog)

MySQL HeatWave is the MySQL DBaaS provided by Oracle in OCI and some other clouds. Compared to the vanilla MySQL, one of the key features of the service is that it allows you to run analytics queries (aka OLAP) very quickly using the HeatWave cluster. You can also run such queries on files using LakeHouse. […] [...]

Master Read-Write Splitting with MySQL Router 8.2 (from Mydbops Blog)

The Need for Load Balancing Efficient load balancing among servers is crucial to ensure that all servers contribute to serving application traffic. Without proper load distribution, a single server m [...]

Tuesday, 21. May 2024

Public Preview: Microsoft Copilot now offers supportability in Azure Database for MySQL (from Azure Updates)

Microsoft Copilot in Azure extends capabilities to Azure Database for MySQL. [...]

Generally Available: Accelerated logs in Azure Database for MySQL - Flexible Server (from Azure Updates)

Gain a performance boost in the Business Critical service tier of Azure Database for MySQL - Flexible Server with accelerated logs. [...]

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

Build 2024: Unveiling performance and AI innovations in Azure Database for MySQL (from Azure for MySQL Blog)

pToday, we're thrilled to announce a suite of new features for Azure Database for MySQL that focus on performance enhancements, enterprise capabilities, and cutting-edge AI functionality designed to revolutionize your database management experience and efficiency. Read on to see how these innovations can elevate your workflows!/p p /p p♦/p   Microsoft Copilot in Azure: Unlock the benefits [...]

Private equity offer for MariaDB gets thumbsup from shareholders (from The Register)

From SPAC and back as 68% say yes pMariaDB shareholders have backed a private equity takeover offer for the troubled database vendor.…/p [...]

High Availability: Choosing the Right Option for Your Percona Monitoring and Management (from Percona Database Blog)

♦Ensuring your monitoring system stays up and running is vital. High availability (HA) minimizes downtime for Percona Monitoring and Management (PMM) during hardware failures, in times of disaster recovery, or increased usage of the tool. It’s not just about extra storage, RAM, or CPU but rather having redundant systems ready to take over seamlessly, like […] [...]

MariaDB Enterprise Server Available on Nutanix Database Service (from MariaDB Corporation Blog)

Today at the Nutanix .NEXT conference in Barcelona, Spain, we announced the upcoming general availability of MariaDB Enterprise Server on … Continued [...]

Debugging JavaScript Stored Functions in MySQL (from The Oracle MySQL Blog)

MySQL Enterprise and MySQL HeatWave now support writing stored functions and procedures using JavaScript. In this post we show how to debug JavaScript code used to create stored functions. [...]

Monday, 20. May 2024

Releasing ProxySQL v2.6.3! (from ProxySQL Blog)

pWe are proud to announce the latest release of ProxySQL version 2.6.3 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.3! appeared [...]

Can We Set up a Replicate Filter Within the Percona XtraDB Cluster? (from Percona Database Blog)

♦If you were to ask me the question, “Would it be possible to set up a replicate filter within the Percona XtraDB Cluster?” my immediate response would be to question you right back. Why would you even want the cluster nodes to have different data when you’re using a synchronous replication cluster? That’s because, instinctively, […] [...]

SkySQL is our new Silver sponsor! (from MariaDB Foundation Blog)

pWe’re excited to announce that SkySQL has joined the MariaDB Foundation as a Silver sponsor.br SkySQL is the first and only database service designed, built and optimised specifically for MariaDB Server. … /p pContinue reading \"SkySQL is our new Silver sponsor!\"/p pThe post SkySQL is our new Silver sponsor! appeared first on MariaDB.org./p [...]

Friday, 17. May 2024

Binary logging optimizations in Amazon Aurora MySQL version 3 (from AWS Database Blog)

The binary log (binlog) in MySQL is used to capture database modifications on a MySQL server in a logical format known as “events”. These database modifications can include DCL statements (such as CREATE USER or GRANT), DDL statements (CREATE TABLE, ALTER TABLE) and DML statements (INSERT, UPDATE, DELETE). When such a modification is committed in […] [...]

What’s new in MariaDB Connector/J 3.4 (from MariaDB Corporation Blog)

We are pleased to announce the general availability (GA) of MariaDB Connector/J 3.4. MariaDB Connector/J 3.4 is the newest version … Continued [...]

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

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

MariaDB Dump File Compatibility Change (from MariaDB Foundation Blog)

pBoth MariaDB and MySQL have been around a long time now, and there is always a difficult balance between maintaining compatibility whilst also solving security issues that arise. … /p pContinue reading \"MariaDB Dump File Compatibility Change\"/p pThe post MariaDB Dump File Compatibility Change appeared first on MariaDB.org./p [...]

Better CRUDs with REPLACE INTO in MariaDB and MySQL (from Programming Brain)

Many applications have dozens and sometimes even thousands of CRUD screens (Create, Read, Update, and Delete). [...]

MariaDB Vector at Intel Vision – AI Everywhere (from MariaDB Foundation Blog)

pAI was everywhere at Intel Vision this week in London. Nearly every keynote and breakout presentation was centred around AI. I had the honour of being interviewed by Intel’s jovial Chief Commercial Officer Christoph Schell, who is just about as stereotypically German as his former neighbour from Stuttgart Jürgen Klopp (whom he referenced on-stage), namely: not at all. … /p pContin [...]

Demystifying DBaaS Costs: Towards Clearer Pricing (from PingCAP Blog)

pServerless has been one of the biggest productivity boosts for software engineering. And that’s because it lets us focus on business logic while someone else takes care of the infrastructure. But there’s a potential tradeoff. While serverless should mean we can sleep easier knowing that the ops side is taken care of, some serverless products […]/p pThe post Demystifying DBaaS Cos [...]

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

Learn about the two different strategies for setting up multi-primary bidirectional replication between MySQL NDB clusters. This functionality is commonly used for highly available (HA) clusters that requires continuous online operation and disaster protection. [...]

Thursday, 16. May 2024

Outbound Replication from MySQL HeatWave DB System to On-premises MySQL Server (from The Oracle MySQL Blog)

This blog demonstrates how to replicate your data from your MySQL HeatWave DB system to your on-premises MySQL Server. [...]

Replicating from One MySQL HeatWave DB System to Another (from The Oracle MySQL Blog)

This blog demonstrates how to replicate data from one DB system to another using the built-in replication channel feature. [...]

Exploring MariaDB Performance Schema (from MariaDB Corporation Blog)

MariaDB Performance Schema is a powerful tool designed to monitor and analyze the performance of your MariaDB server. It provides … Continued [...]

MariaDB 11.2.4, 11.1.5, 11.0.6, 10.11.8, 10.6.18, 10.5.25, 10.4.34 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 10.11.8, MariaDB 10.6.18, MariaDB 10.5.25 and MariaDB 10.4.34, the latest stable releases in their respective long-term series (maintained for five years from their first stable release dates), as well as MariaDB 11.2.4, MariaDB 11.1.5 and MariaDB 11.0.6, the latest stable releases in their respective short-term series (main [...]

Configuring MySQL HeatWave Inbound Replication Without Global Transaction Identifiers (GTIDs) (from The Oracle MySQL Blog)

This blog explains how you can set up inbound replication without using global transaction identifiers on the source. [...]

Getting started with Django, PostgreSQL, and Readyset (from Readyset Blog)

In this guide, you will explore how to set up a Django application integrated with Readyset using Docker. [...]

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

Learn about the two different strategies for setting up multi-primary bidirectional replication between MySQL NDB clusters. This functionality is commonly used for highly available (HA) clusters that requires continuous online operation and disaster protection. [...]

Choosing the Right Database: Comparing MariaDB vs. MySQL, PostgreSQL, and MongoDB (from Percona Database Blog)

♦Selecting the appropriate database technology for your needs is crucial for ensuring compatibility with existing applications and infrastructure, optimizing application performance, and reducing costs. With so many different choices available, it can be difficult to make such a decision!This blog post provides a head-to-head comparison of MariaDB vs. PostgreSQL, MongoDB, and MySQL, highlighting th [...]

Sorting JSON Arrays in MySQL with JavaScript (from The Oracle MySQL Blog)

MySQL Enterprise and MySQL HeatWave now support writing stored functions and procedures using JavaScript. In this post we show how to sort JSON array data using JavaScript in MySQL. [...]

Wednesday, 15. May 2024

Observing InnoDB Cluster: A different approach for specific info extraction (from MySQL-Med)

A quick 'n' simple look into some MySQL InnoDB Cluster monitoring... Continue reading → [...]

Amazon RDS for PostgreSQL announces Extended Support minor 11.22-RDS.20240418 (from AWS What's New)

Amazon Relational Database Service (RDS) for PostgreSQL announces Amazon RDS Extended Support minor version 11.22-RDS.20240418. We recommend that you upgrade to this version to fix known security vulnerabilities and bugs in prior versions of PostgreSQL. Amazon RDS Extended Support provides you more time, up to three years, to upgrade to a new major version to help you meet your business requirement [...]

Tuesday, 14. May 2024

Running ANALYZE in MySQL (from Another Boring Tech Blog)

pIntroduction In database management, keeping your database running smoothly is essential. ANALYZE is a command in MySQL that helps update statistics for table indexes. These statistics help the query optimizer choose the most efficient way to execute queries. How to Use the ANALYZE Command Here’s how you can use the ANALYZE command to improve your database’s.../p pO post Running ANALYZ [...]

Five Surprises in MySQL 8.4 LTS (from Skeema Blog)

pMySQL’s new long-term support (LTS) version series, MySQL 8.4, had its first release at the end of April. In this post, we’ll review a few unexpected developments in this latest server version./p [...]

The Insert Benchmark: MariaDB, MySQL, new small server, cached workload, some concurrency (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 and see whether they get better or worse over time. The results here are from the newest small servers in my test cluster -- an ASUS PN53./ppThis work was done by Small Datum LLC and sponsored by the MariaDB Foundation./ppThe workload here has low co [...]

Buffer pool performance parameters for Azure Database for MySQL (from Azure for MySQL Blog)

pInnoDB is a storage engine for the MySQL database management system. InnoDB manages a buffer pool, which is a dedicated storage zone that’s used to cache data and indexes within memory. Because the data remains readily available in memory, this approach significantly accelerates retrieval of frequently accessed information, easily surpassing the time required for disk-based retrieval. /p p&nb [...]

Towards a healthy ecosystem (from MariaDB Foundation Blog)

pA healthy ecosystem around MariaDB Server involves an active community. Lots of happy code contributors cause fast development of new functionality, as well as increased adoption by users. … /p pContinue reading \"Towards a healthy ecosystem\"/p pThe post Towards a healthy ecosystem appeared first on MariaDB.org./p [...]

Devart dbForge Product Line and SecureBridge Join the 2024 DBTA Readers’ Choice Awards Contest (from Devart MySQL Tool Blog)

pThe Devart team works non-stop to provide you with the best-in-class products, and we look forward to seeing them win this year. Check the list of our solutions and make sure to support them!/p pThe post Devart dbForge Product Line and SecureBridge Join the 2024 DBTA Readers’ Choice Awards Contest appeared first on Devart Blog./p [...]

More JavaScript in MySQL (from The Oracle MySQL Blog)

MySQL Enterprise and MySQL HeatWave now support writing stored functions and procedures using JavaScript. In this post we show how to implement more complex logic in a MySQL stored function using JavaScript. [...]

Shenzhen CLOU Electronics Strengthens its Data Security and Regulatory Compliance with MySQL Enterprise Edition (from The Oracle MySQL Blog)

This is a case study for the use of MySQL Enterprise Edition at Shenzhen CLOU Electronics. MySQL Enterprise Edition stood out as a robust solution for organizations seeking to safeguard their sensitive data. [...]

Monday, 13. May 2024

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

Episode #62 of MySQL Shorts in now available! [...]

Seamless Table Modifications: Leveraging pt-online-schema-change for Online Alterations (from Percona Database Blog)

♦Table modifications are a routine task for database administrators. The blog post Using Percona Toolkit to Alter Database Tables Online: A Controlled Approach provides insights into the process of altering tables online in a controlled manner, ensuring uninterrupted access for application users and preventing application downtime. We will focus here on utilizing the powerful “pt-online-schem [...]

Top 9 Database Documentation Tools of 2024 — Free and Paid Options Unwrapped (from Devart MySQL Tool Blog)

pOur guide compares dbForge Edge, dbdocs.io, Dataedo, ApexSQL Doc & Redgate SQL Doc to help you choose the right one for your database documentation./p pThe post Top 9 Database Documentation Tools of 2024 — Free and Paid Options Unwrapped appeared first on Devart Blog./p [...]

Conquer Complex Queries: Highlights from Mydbops MyWebinar Edition 32 (from Mydbops Blog)

Did you struggle with sluggish MySQL queries? Mydbops MyWebinar Edition 32 tackled the art of efficient MySQL indexing and unveiled the latest features in MySQL Explain. This blog post dives into the [...]

Saturday, 11. May 2024

Azure Database for MySQL - April 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 announcements from last month, as well as the latest roadmap of upcoming features!/p p /p May 2024 Live webinar p /p pThese updates and the latest roadmap are also covered in our Monthly Live Webinar on YouTube (Click here to subscribe to our YouTube channel!), which streams the second Wednesday of every m [...]

Friday, 10. May 2024

Integrate Amazon Aurora MySQL and Amazon Bedrock using SQL (from AWS Database Blog)

Because organizations store a large amount of their data in relational databases, there is a clear impetus to augment these datasets using generative artificial intelligence (AI) foundation models to elevate end-user experiences. In this post, we explore how to integrate Amazon Aurora MySQL-Compatible Edition with a generative AI model using Amazon Aurora Machine Learning. We walk […] [...]

MariaDB is soon a vector database, too (from MariaDB Foundation Blog)

pWe say: Put your AI vectors into your RDBMS …br Relational databases are where AI data belongs. Users need their vectors along with the rest of their data, in a standard database which offers performance, scalability, and all the other traditional virtues, such as ACID compliance. … /p pContinue reading \"MariaDB is soon a vector database, too\"/p pThe post MariaDB is soon a vector dat [...]

Thursday, 09. May 2024

[PT-BR] Desativar o Transparent Huge Pages(THP) no Ubuntu 22.04 (from Another Boring Tech Blog)

pDesativar as Transparent Huge Pages (THP) de forma permanente no Ubuntu 22.04 exige a modificação dos arquivos de configuração do sistema para que a alteração seja aplicada durante o boot. Existem diversas maneiras de fazer isso, mas um método comum é utilizar o rc.local ou criar um serviço systemd personalizado, já que o Ubuntu pode.../p pO post [PT-BR] Desativar o Transparent Huge Pages(THP) no [...]

MySQL 8.4 - What is new? (from Readyset Blog)

On April 30th 2024, the first Long Term Support release (MySQL 8.4) was announced. Let’s have a look at what is new in comparison to 8.0. [...]

Securing Your MySQL Database: Essential Best Practices (from Percona Database Blog)

♦Have you ever read a news story about a major company experiencing a data breach that exposed millions of customer records? These breaches can be devastating, causing significant financial losses, reputational damage, and even legal repercussions. Unfortunately, MySQL databases, one of the most popular relational database management systems, is at the heart of many critical […] [...]

Using the Global `Intl` JavaScript Object in MySQL (from The Oracle MySQL Blog)

MySQL Enterprise and MySQL HeatWave now support writing stored functions and procedures using JavaScript. In this post we show how to the global Intl object in a MySQl stored function. [...]

Wednesday, 08. May 2024

Use Kerberos authentication with Amazon Aurora MySQL (from AWS Database Blog)

Amazon Aurora MySQL-Compatible Edition offers multiple authentication methods to securely authenticate database user access and meet different security needs. The most common method of authentication is using a user name and password. This can create additional overhead for both users and database administrators to manage and rotate these credentials; it also requires additional investments in […] [...]

Troubleshooting PostgreSQL on Kubernetes With Coroot (from Percona Database Blog)

♦Coroot, an open source observability tool powered by eBPF, went generally available with version 1.0 last week. As this tool is cloud-native, we were curious to know how it can help troubleshoot databases on Kubernetes.In this blog post, we will see how to quickly debug PostgreSQL with Coroot and Percona Operator for PostgreSQL.PrepareInstall CorootThe easiest […] [...]

Building and testing MySQL 8.0.37 & 8.4.0 on macOS (from Laurynas Biveinis' blog)

p The first MySQL LTS release, 8.4.0, is out, together with 8.0.37! Which means it's time for me to build and test them in my main work environment, continuing the series (8.3.0/8.0.36, 8.2.0/8.0.35). /p p The first surprise is that both these releases do not build with the current XCode (15.3 at the time of writing), because the LLVM 17 compilation failure I previously reported (#113123: Compilat [...]

Mastering Database Monitoring: Running PMM in High Availability Mode (from Percona Database Blog)

♦Percona Monitoring and Management (PMM) has become a valuable tool for database professionals, providing comprehensive insights into database health and performance. A recent update (version 2.41.0) introduced a significant enhancement: the ability to run PMM in high availability (HA) mode. This feature, currently in technical preview, offers exciting possibilities for ensuring the reliability and [...]

Using eBPF to Troubleshoot Process Contention in PostgreSQL: A Guide to Monitoring Locks, CPU, and I/O Performance (from MinervaDB Blog)

pPostgreSQL Performance Troubleshooting Whitepaper – Using eBPF to Troubleshoot Process Contention in PostgreSQL To use eBPF for troubleshooting process contention in PostgreSQL, we focus on understanding how processes are interacting with each other, particularly in [...]/p pThe post Using eBPF to Troubleshoot Process Contention in PostgreSQL: A Guide to Monitoring Locks, CPU, and I/O Perfor [...]

Tuesday, 07. May 2024

MySQL April 2024 GA Releases Now Available (from The Oracle MySQL Blog)

MySQL Server 8.4.0 LTS and 8.0.37 are now available for download and in the MySQL HeatWave Service. These are the latest General Availability (GA) releases as of April 30, 2024. [...]

Hello World… Hello Valkey! Let’s Get Started! (from Percona Database Blog)

♦Welcome Valkey to the Percona family! We are excited to have you join our team of MySQL, PostgreSQL, and MongoDB database experts.Hang on. What is Valkey? In short, Valkey is a fork of Redis which maintains the original open source BSD license[1]. If you’re new to Redis/Valkey, then this ‘getting started’ post is just for […] [...]

MySQL 5.7 EOL: The End of MySQL Query Cache (from Readyset Blog)

Learn why the MySQL Query Cache is being removed, explore alternative caching solutions, and discover how Readyset can be a drop-in replacement. [...]

TiDB's Co-Processor: Distributed SQL with a Boost (from Mydbops Blog)

TiDB, a distributed SQL database, is renowned for its horizontal scalability, MySQL compatibility, and support for hybrid transactional and analytical processing workloads. One of the key components t [...]

MySQL Protocol: Collations (from Daniël's Database Blog)

pThis story starts with a pull request for go-mysql to allow setting the collation in auth handshake that I was reviewing. The reason why the author wanted to do this is to speedup the connection setup as he has a latency sensitive application and a lot of connection setups and tear downs./p pWhile looking at this I noticed that the collation would be stored in a single byte. However the list of su [...]

Filtering JSON Arrays with JavaScript in MySQL (from The Oracle MySQL Blog)

MySQL Enterprise and MySQL HeatWave now support writing stored functions and procedures using JavaScript. In this post we show how to tap into the power of JavaScript to filter an array of objects based on the value of one of the properties of the object. [...]

Monday, 06. May 2024

Managing ProxySQL Admin Credentials: A Guide to admin-admin_credentials (from ProxySQL Blog)

pIntroduction Admin credentials serve as the gateway to ProxySQL's configuration, granting users unparalleled control over its functionalities. However, the improper handling of these credentials can expose organizations to significant security risks, including unauthorized access, data breaches, and service disruptions. Recognizing this challenge, the ProxySQL development team introduced a robust [...]

AWS Amplify Gen 2 is now generally available (from AWS What's New)

AWS Amplify Gen 2, the code-first developer experience for building full-stack apps using TypeScript, is now generally available. Amplify Gen 2 enables developers to express app requirements like the data models, business logic, and authorization rules in TypeScript. The necessary cloud infrastructure is then automatically provisioned, without needing explicit infrastructure definitions. This strea [...]

Sunday, 05. May 2024

Exploring MySQL Group Replication Communication Stack: XCom vs MySQL (from Mydbops Blog)

MySQL Group Replication is a powerful feature that enables multi-master replication in MySQL, allowing for high availability and data consistency in database systems. At the heart of MySQL Group Repli [...]

Friday, 03. May 2024

Optimizing Database Performance with ProxySQL Query Rewrite (from ProxySQL Blog)

pIn the realm of database management, optimizing performance is paramount to ensuring smooth operations and preventing potential disruptions. One tool that has emerged as a valuable asset in this endeavor is ProxySQL, particularly its Query Rewrite feature. This article delves into the essence of ProxySQL Query Rewrite and its significance in optimizing database performance. Understanding [...]/p p [...]

Galera Cluster for MySQL 8.0.36-26.18 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-26.18 (release notes, download). There is no change to the 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 […] [...]

Thursday, 02. May 2024

MySQL NDB Cluster replication: Dual-channel replication for redundancy (from The Oracle MySQL Blog)

Learn how to setup MySQL NDB Cluster replication using redundancy to continuously replicate data and be fully online during upgrade and maintenance. [...]

Introducing support for keyring component to plugin migration (from The Oracle MySQL Blog)

Now you can also perform keyring migration from a keyring component to a keyring plugin using a migration server. [...]

Using the Oracle Cloud Infrastructure Vault Keyring Component in MySQL Heatwave (from The Oracle MySQL Blog)

The component_keyring_oci keyring component is advanced, flexible and have fewer restrictions than the keyring_oci plugin. It can be loaded using the manifest and configuration file. [...]

Using the component_keyring_encrypted_file Encrypted File-Based Keyring Component in MySQL (from The Oracle MySQL Blog)

The component_keyring_encrypted_file keyring component is advanced, flexible and have fewer restrictions than the keyring_encrypted_file plugin. It can be loaded using the manifest and configuration file. [...]

Using the component_keyring_file File-Based Keyring Component in MySQL (from The Oracle MySQL Blog)

The component_keyring_file keyring component is advanced, flexible and have fewer restrictions than the keyring_file plugin. It can be loaded using the manifest and configuration file. [...]

Introducing Keyring Components in MySQL (from The Oracle MySQL Blog)

The keyring components are advanced, flexible and have fewer restrictions than the keyring plugins. And all it requires is a few simple steps to switch. [...]

Using Temporary Tables in MariaDB (from Programming Brain)

Let’s explore how temporary tables work in MariaDB. First, we have to connect to the server. [...]

Using JavaScript to Search JSON Arrays in MySQL (from The Oracle MySQL Blog)

MySQL Enterprise and MySQl HeatWave now support writing stored functions and procedures using JavaScript. In this post we show how to tap into the power of JavaScript to easily search an array for a particular value. [...]

How to Provision a MongoDB Cluster in Kubernetes with Percona Everest Summary (from Percona Community Blog)

Kubernetes continues evolving, and the complexity of deploying and managing databases within the ecosystem is a topic of considerable discussion and importance these days. This article summarizes a detailed discussion between Piotr Szczepaniak and Diogo Recharte, who offer insights and live demonstrations to simplify database operations on Kubernetes with a new technology for cloud-native applicati [...]

Wednesday, 01. May 2024

April Product Updates (from Readyset Blog)

♦pApril is officially over and it’s time for an update on what we’ve been shipping at Readyset! Let’s take a look at what’s changed since March:/pPartner with ReadysetpReadyset is looking for design partners to build out additional MySQL and PostgreSQL/p [...]

MySQL 8.4 First Peek (from Percona Database Blog)

♦MySQL 8.4 has now been officially released, and this is a quick review of what is in the release notes. This is momentous as it is designated a Long-Term Support (LTS) release. Various 8.0 releases introduced material changes that impacted speed and stability, causing hair-pulling and swearing among those affected. Please note this is a […] [...]

MySQL 8.4 LTS – new production-ready defaults for InnoDB (from lefred's blog)

Yesterday, MySQL 8.4, the very first LTS version of MySQL was released. A lot of deprecations have finally been removed, and several InnoDB variable default values have been modified to match current workloads and hardware specifications. The default value of 20 InnoDB variables has been modified! Let’s have a look at those variables and explain […] [...]

Using ProxySQL Query Mirroring to test query performance on a new cluster (from Percona Community Blog)

ProxySQL is an SQL aware proxy, which gives DBA’s fine grained control over clients’ access to the MySQL cluster. A key part of our DBA team’s process in testing and preparing for major MySQL version upgrades is comparing query plans using ProxySQL query mirroring. This feature allows us to mirror queries to another cluster / host, by configuring query rules. What makes mirroring particularly [...]

Tuesday, 30. April 2024

Redis, Valkey, and Percona’s Ongoing Support of Open Source (from Percona Database Blog)

♦For me, the Redis story starts with…  Memcached.   Back in the early 2000s, “Web 2.0” was being built following the aftermath of the dot-com crash.  The open source  LAMP (Linux-Apache-MySQL-PHP/Perl/Python) stack was all the rage.  We needed to scale fast but also very efficiently, and caching became one of the core technologies to achieve […] [...]

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

Amazon RDS for MySQL now supports MySQL Innovation Release 8.3 in the Amazon RDS Database Preview Environment, allowing you to evaluate the latest Innovation Release on Amazon RDS for MySQL. You can deploy MySQL 8.3 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. MySQL 8.3 is the latest In [...]

Master MySQL Indexing & Explain Plan in Mydbops MyWebinar Edition 32 (from Mydbops Blog)

In today's data-driven world, ensuring optimal database performance is no longer a luxury, it's a necessity. Mydbops MyWebinar Edition 32 empowers you to take control by equipping you with the knowled [...]

Viewing MySQL Document Store Queries in HeatWave Using Database Management (from The Oracle MySQL Blog)

Using the new support for MySQL HeatWave in Oracle Cloud Database Management, we can see what queries are executed when we run commands using MySQL Document Store. Keep reading to find out how. [...]

Monday, 29. April 2024

In-Database Machine Learning Model Development using Oracle’s MySQL Heatwave (from The Oracle MySQL Blog)

This blog post illustrates how to use AutoML on MySQL Heatwave to train an optimized machine learning model to forecast crime [...]

FromDual Ops Center 1.2.2 for MariaDB and MySQL databases has been released (from Shinguz's Blog)

pFromDual is pleased to announce the release of the new version 1.2.2 of the popular FromDual Ops Center focmm, a Graphical User Interface (GUI) for MariaDB, MySQL and compatible databases./p pThe FromDual Ops Center for MariaDB and MySQL (focmm) helps DBAs and system administrators to better manage their MariaDB and MySQL databases and Galera Cluster farms. Ops Center makes life easier for DBAs a [...]

CodeQL zero to hero part 3: Security research with CodeQL (from The GitHub Blog)

pLearn how to use CodeQL for security research and improve your security research workflow./p pThe post CodeQL zero to hero part 3: Security research with CodeQL appeared first on The GitHub Blog./p [...]

Amazon Aurora supports PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 (from AWS What's New)

Amazon Aurora PostgreSQL-Compatible Edition now supports PostgreSQL versions 16.2, 15.6, 14.11, 13.14, and 12.18. These releases contain product improvements and bug fixes made by the PostgreSQL community, along with Aurora-specific improvements. These releases also offer improved performance through faster COPY operations (for PostgreSQL 16.2), Query Plan Management enhancements for queries with a [...]

Real Savings, Real Stories: Slash 30%-80% Database Costs with TiDB Serverless (from PingCAP Blog)

pIntroduction: A Tale of Two Bills We frequently receive feedback from TiDB Serverless users, and their insights are a driving force behind our ongoing improvements. And increasingly, we hear about significant cost savings from users who have migrated to our platform. Such testimonials are quickly becoming a norm, prompting us to share some user stories […]/p pThe post Real Savings, Real Stor [...]

Achieving data consistency with the consistent lookup Vindex (from PlanetScale Blog)

How we implemented a consistent lookup Vindex in Vitess to ensure data consistency without using 2PC [...]

Consistent Lookup Vindex: Achieving Data Consistency without 2PC (from Vitess)

Vindex # Vitess uses Vindexes (short for Vitess Index) to associate rows in a table with a designated address known as Keyspace ID. This allows Vitess to direct a row to its intended destination, typically a shard within the cluster. Vindexes play a dual role: enabling data sharding through Primary Vindexes and facilitating global indexing via Secondary Vindexes. Through this mechanism, Vindexes se [...]

Sunday, 28. April 2024

Releem: MySQL Performance Tool (from Another Boring Tech Blog)

pWho wouldn’t love a reliable database free from issues and allowing us to sleep peacefully? That’s what Roman Agabekov, the CEO of Releem, aims to provide. As a tool specializing in MySQL Performance Tuning, Releem helps developers and database administrators by automating MySQL tuning, enhancing application performance, and reducing server costs. In this blog post,.../p pO post Releem [...]

Friday, 26. April 2024

Benchmarking MongoDB Performance on Kubernetes (from Percona Database Blog)

♦Cloud-native databases are becoming the norm, and containerized databases are a common trend (see the report from Dynatrace and Figure 1). Kubernetes—the de facto standard for platform engineers—and operators simplify database deployment and management. But what are the performance implications of running databases in Kubernetes? To answer this question, we compared the perfo [...]

dbstat for MariaDB after one month of productive use (from Shinguz's Blog)

Table of contents ul liReview/li liOne month later/li liSize of the tables/li liProcess list/li liGlobal variables/li liMetadata Lock and InnoDB Transaction Lock/li liGlobal status/li /ulbr Review pAfter we introduced codedbstat/code for MariaDB (and MySQL) a good 5 weeks ago, we naturally also rolled it out on our systems to test the behaviour in daily use (eat your own dog food) [...]

Creating a MySQL HeatWave Replication Channel 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 MySQL HeatWave inbound replication channel. [...]

Thursday, 25. April 2024

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

Amazon Relational Database Service (Amazon RDS) for PostgreSQL, MySQL, and MariaDB now supports AWS Graviton2-based M6gd database instances in Asia Pacific (Hyderabad), Europe (Spain, Zurich), and Middle East (UAE) regions. With this regional expansion, M6gd instances are now available for Amazon RDS for PostgreSQL, MySQL, and MariaDB in 25 regions: US East (Ohio, N. Virginia), US West (Oregon), As [...]