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.

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 [...]
Published Saturday, 11. May 2024 00:04 • 12 hours ago

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 […] [...]
Published Friday, 10. May 2024 16:43 • 19 hours ago

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 [...]
Published Friday, 10. May 2024 10:58 • a day ago

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 [...]
Published Thursday, 09. May 2024 15:15 • 2 days ago

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. [...]
Published Thursday, 09. May 2024 13:43 • 2 days ago

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 […] [...]
Published Thursday, 09. May 2024 13:02 • 2 days ago

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. [...]
Published Thursday, 09. May 2024 04:00 • 2 days ago

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 […] [...]
Published Wednesday, 08. May 2024 18:21 • 3 days ago

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 […] [...]
Published Wednesday, 08. May 2024 18:11 • 3 days ago

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 [...]
Published Wednesday, 08. May 2024 13:52 • 3 days ago | Updated Wednesday, 08. May 2024 14:37 • 3 days ago

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 [...]
Published Wednesday, 08. May 2024 13:25 • 3 days ago

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 [...]
Published Wednesday, 08. May 2024 08:15 • 3 days ago

Tuesday, 07. May 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 […] [...]
Published Tuesday, 07. May 2024 13:17 • 4 days ago

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. [...]
Published Tuesday, 07. May 2024 13:14 • 4 days ago

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 [...]
Published Tuesday, 07. May 2024 12:22 • 4 days ago

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 [...]
Published Monday, 06. May 2024 15:27 • 5 days ago | Updated Tuesday, 07. May 2024 08:15 • 4 days ago

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. [...]
Published Tuesday, 07. May 2024 04:00 • 4 days ago

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 [...]
Published Monday, 06. May 2024 14:27 • 5 days ago

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 [...]
Published Monday, 06. May 2024 07:00 • 5 days ago

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 [...]
Published Sunday, 05. May 2024 09:33 • 6 days ago

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 [...]
Published Friday, 03. May 2024 11:16 • 8 days ago

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 […] [...]
Published Friday, 03. May 2024 03:27 • 8 days ago

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. [...]
Published Thursday, 02. May 2024 14:51 • 9 days ago

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. [...]
Published Thursday, 02. May 2024 12:40 • 9 days ago

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. [...]
Published Thursday, 02. May 2024 12:34 • 9 days ago

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. [...]
Published Thursday, 02. May 2024 12:33 • 9 days ago

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. [...]
Published Thursday, 02. May 2024 12:32 • 9 days ago

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. [...]
Published Thursday, 02. May 2024 12:31 • 9 days ago

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. [...]
Published Thursday, 02. May 2024 04:00 • 9 days ago

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 [...]
Published Thursday, 02. May 2024 00:00 • 9 days ago

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 [...]
Published Wednesday, 01. May 2024 21:21 • 10 days ago

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 […] [...]
Published Wednesday, 01. May 2024 13:13 • 10 days ago

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 […] [...]
Published Wednesday, 01. May 2024 07:33 • 10 days ago

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 [...]
Published Wednesday, 01. May 2024 00:00 • 10 days ago

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 […] [...]
Published Tuesday, 30. April 2024 13:29 • 11 days ago

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 [...]
Published Tuesday, 30. April 2024 07:00 • 11 days ago

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 [...]
Published Tuesday, 30. April 2024 06:50 • 11 days ago

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. [...]
Published Tuesday, 30. April 2024 04:00 • 11 days ago

Monday, 29. April 2024

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 [...]
Published Monday, 29. April 2024 15:41 • 12 days ago

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 [...]
Published Monday, 29. April 2024 08:00 • 12 days ago

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 [...]
Published Monday, 29. April 2024 07:00 • 12 days ago

Real Savings, Real Stories: Slash 30%-80% Database Costs with TiDB Serverless (from TiDB and TiKV 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 [...]
Published Monday, 29. April 2024 04:22 • 12 days ago

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 [...]
Published Monday, 29. April 2024 00:00 • 12 days ago

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 [...]
Published Monday, 29. April 2024 00:00 • 12 days ago

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 [...]
Published Sunday, 28. April 2024 22:55 • 13 days ago

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 [...]
Published Friday, 26. April 2024 12:46 • 15 days ago

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) [...]
Published Friday, 26. April 2024 12:13 • 15 days ago

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. [...]
Published Friday, 26. April 2024 04:00 • 15 days ago

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 [...]
Published Thursday, 25. April 2024 12:00 • 16 days ago

Understanding Flashback in TiDB (from Mydbops Blog)

Author: Kabilesh PR What would be your reaction when your junior comes and says that i have dropped the wrong table or accidentally dropped the entire DB in prod instead of doing it in a test environ [...]
Published Thursday, 25. April 2024 03:49 • 16 days ago

Wednesday, 24. April 2024

MariaDB Enterprise Server 10.6.17-13 maintenance release (from MariaDB Corporation Blog)

We are pleased to inform you that a new maintenance release of MariaDB Enterprise Server 10.6 is available. This is … Continued [...]
Published Wednesday, 24. April 2024 20:24 • 17 days ago

Bringing Percona Experts to a City Near You (from Percona Database Blog)

♦Percona.connect, a series of free events hosted by Percona database performance experts, is coming to a city near you!  This amazing learning opportunity spans six cities — across two continents — and includes educational sessions, customer testimonials, networking activities, and more. Don’t miss your chance to talk with technical evangelists, MySQL, PostgreSQL, and Mo [...]
Published Wednesday, 24. April 2024 13:14 • 17 days ago

Tungsten Replicator: Understanding Latency Calculations (from Continuent Blog)

This blog post discusses the Tungsten Replicator and how latency is calculated when extracting events on a Primary, and when applying events to the Replicas. We also examine what latency is, and the two different types of latency that we track - how to interpret them and how they differ.Tags: tungsten replicatorLatencyApplied LatencyRelative Latency [...]
Published Wednesday, 24. April 2024 09:50 • 17 days ago

The MySQL adaptive hash index (from PlanetScale Blog)

The adaptive hash index help to improve performance of the already-fast B-tree lookups [...]
Published Wednesday, 24. April 2024 00:00 • 17 days ago

Tuesday, 23. April 2024

Reduce Amazon Aurora MySQL backup costs using MySQL Shell and Amazon S3 (from AWS Database Blog)

Amazon Aurora backs up cluster volumes automatically and retains restore data for the length of the backup retention period. Aurora automated backups are continuous and incremental, so you can restore to any point within the backup retention period from 1–35 days. If you need to retain backups for more than 35 days, you can take manual snapshots […] [...]
Published Tuesday, 23. April 2024 19:38 • 18 days ago

Upgrade to Azure Database for MySQL – Flexible Server for better performance with easy migration (from Azure for MySQL Blog)

pWith the retirement of Azure Database for MySQL – Single Server scheduled for this September, it’s time to move to Azure Database for MySQL – Flexible Server. The move improves performance, offers better value, and is supported by an easy migration process for your high-performance online transaction processing (OLTP) applications according to a recent study by Principled Technologies. Overall, Fl [...]
Published Tuesday, 23. April 2024 18:53 • 18 days ago

Short note re Progress and NuSphere (from SQL And Its Sequels (Ocelot Blog))

Progress Software on 2024-04-19 said more about “considering” an offer for MariaDB plc (the company not the foundation). They own NuSphere which had a dispute with MySQL AB which was settled in 2002. My happy history as a MySQL employee biases me but I thought that NuSphere was not acting angelically. I think it won’t… Continue Reading Short note re Progress and NuSphere [...]
Published Tuesday, 23. April 2024 17:45 • 18 days ago

Why MariaDB Is “Better” Than MySQL (from Percona Database Blog)

♦Apples or oranges?Tea or coffee?Books or eBooks?Each of these comparisons has very similar features and serves many of the same purposes, but in the end, they are different choices people make. Do you know what else belongs on this list?MariaDB or MySQL?It’s time we discuss the age-old debate of MariaDB versus MySQL and see if […] [...]
Published Tuesday, 23. April 2024 15:36 • 18 days ago

From Standalone to High Availability: Convert Your PostgreSQL Database to a Patroni Cluster (from Mydbops Blog)

In Database Management, achieving High Availability(HA) is very important, particularly for systems handling critical data and applications. In a Production Environment, any downtime can translate int [...]
Published Tuesday, 23. April 2024 10:52 • 18 days ago

Monday, 22. April 2024

Database Testing – Unveiling the Latest Best Practices and Innovations in 2024 (from Devart MySQL Tool Blog)

pDatabases are invaluable for any application that relies on them. Thus, database testing is a critical aspect of ensuring optimal database performance. This article will delve into various types of database testing, methodologies, and practical applications. /p pThe post Database Testing – Unveiling the Latest Best Practices and Innovations in 2024 appeared first on Devart Blog./p [...]
Published Monday, 22. April 2024 09:15 • 19 days ago

Sunday, 21. April 2024

The Insert Benchmark: MariaDB, MySQL, 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./ppThis work was done by Small Datum LLC and sponsored by the MariaDB Foundation./ppThe workload here has some concurrency (4 clients) and the database is cached. The results might be different when the workload is IO-bound or has more concurrency. R [...]
Published Sunday, 21. April 2024 22:43 • 20 days ago | Updated Sunday, 21. April 2024 22:43 • 20 days ago

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 • 28 days ago | Updated Sunday, 21. April 2024 22:43 • 20 days ago

MySQL: Latency and IOPS (from Die wunderbare Welt von Isotopp)

pWhen talking about storage performance, we often hear three terms that are important in describing storage performance. They are/p ul libandwidth/li lilatency/li liI/O operations per second (IOPS)/li /ul pWhen you talk to storage vendors and cloud providers, they will gladly provide you with numbers on bandwidth and IOPS, but latency numbers will be hard to come by. To evaluate storage, especially [...]
Published Sunday, 21. April 2024 05:06 • 20 days ago

Friday, 19. April 2024

Deploying Percona Everest on GCP with Kubectl for Windows 11 Users (from Percona Community Blog)

Welcome to this blog post! Today, our primary goal is to guide you through deploying Percona Everest on GCP using Kubectl, specifically for users on Windows 11. It’s been some time since I last used Windows, so this will be an excellent opportunity to do it from scratch. Let me tell you a little bit about Percona Everest. You may have already heard it recently. It is the new open source tool [...]
Published Friday, 19. April 2024 00:00 • 22 days ago

Thursday, 18. April 2024

Explain Hypothetical Scenario: The Application Rolls Back the Transaction in MySQL (from MinervaDB Blog)

pIn a hypothetical scenario where an application rolls back a transaction in MySQL, especially when using the InnoDB storage engine, several key processes and implications come into play. This scenario can serve as an instructive [...]/p pThe post Explain Hypothetical Scenario: The Application Rolls Back the Transaction in MySQL appeared first on The WebScale Database Infrastructure Operations Expe [...]
Published Thursday, 18. April 2024 19:45 • 23 days ago

Handle tables without primary keys while creating Amazon Aurora MySQL or Amazon RDS for MySQL zero-ETL integrations with Amazon Redshift (from AWS Database Blog)

At AWS, we have been making steady progress towards bringing our zero-ETL vision to life. With Amazon Aurora zero-ETL integration to Amazon Redshift, you can bring together the transactional data of Amazon Aurora with the analytics capabilities of Amazon Redshift. The integration helps you derive holistic insights across many applications, break data silos in your […] [...]
Published Thursday, 18. April 2024 15:59 • 23 days ago

Handle tables without primary keys while creating Amazon Aurora PostgreSQL zero-ETL integrations with Amazon Redshift (from AWS Database Blog)

At Amazon Web Services (AWS), we have been making steady progress towards bringing our zero-extract, transform, and load (ETL) vision to life. With Amazon Aurora zero-ETL integration to Amazon Redshift, you can bring together the transactional data of Amazon Aurora with the analytics capabilities of Amazon Redshift. The integration helps you derive holistic insights across […] [...]
Published Thursday, 18. April 2024 15:59 • 23 days ago

Should You Deploy Your Databases on Kubernetes? And What Makes StatefulSet Worthwhile? (from Percona Database Blog)

♦Why do cloud-native databases matter?Kubernetes makes it easier to run applications. It’s like having a magic wand for managing everything from small tasks to significant operations. However, despite the popularity of Kubernetes, there are many cases when it might not be the best solution for your database needs.Kubernetes wasn’t built with the needs of databases […] [...]
Published Thursday, 18. April 2024 15:21 • 23 days ago

MySQL NDB Cluster replication: Single-channel replication (from The Oracle MySQL Blog)

This is the second article in our blog series about MySQL NDB Cluster replication, it describes the basic concept and functional parts of a single-channel replication which is used for replicating data between clusters. [...]
Published Thursday, 18. April 2024 14:39 • 23 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 Thursday, 18. April 2024 08:58 • 23 days ago

How to Add, Show, and Drop MySQL Foreign Keys (from Devart MySQL Tool Blog)

pA key is typically defined as a column or a group of columns that are used to uniquely locate table records in relational databases (including MySQL, of course). And now that we've covered MySQL primary keys on our blog, it's time to give you a similarly handy guide on foreign keys./p pThe post How to Add, Show, and Drop MySQL Foreign Keys appeared first on Devart Blog./p [...]
Published Thursday, 18. April 2024 07:26 • 23 days ago

Creating a MySQL HeatWave Configuration 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 configuration that can be specified when creating a new instance. [...]
Published Thursday, 18. April 2024 04:00 • 23 days ago

Wednesday, 17. April 2024

Programmatic approach to optimize the cost of Amazon RDS snapshots (from AWS Database Blog)

One of the key benefits of Amazon Relational Database Service (Amazon RDS) is that it creates an automated storage volume snapshot of the database instance, backing up the database host at the instance. Amazon RDS saves the automated backups of databases according to the specified backup retention period. The flexibility of creating manual snapshots helps […] [...]
Published Wednesday, 17. April 2024 20:27 • 24 days ago

When COMMIT Is the Slowest Query (from Hack MySQL)

pWhen codeCOMMIT/code is the slowest query, it means your storage is slow. Let’s look at an example./p [...]
Published Wednesday, 17. April 2024 20:06 • 24 days ago

How MariaDB and MySQL performance changed over releases (from MariaDB Foundation Blog)

pIs performance important for you, along with the latest features and long-term support? Go with MariaDB 11.4. But don’t take our word for it. We asked well known benchmarking expert Mark Callaghan to check out a number of MariaDB and MySQL releases, hit them hard with a tool of his choice, and share his findings. … /p pContinue reading \"How MariaDB and MySQL performance changed over r [...]
Published Wednesday, 17. April 2024 17:02 • 24 days ago

Online migration from Single Server to Flexible Server using MySQL Import and Data-In Replication (from Azure for MySQL Blog)

pAzure Database for MySQL – Flexible Server is the flagship Platform as a Service running on Linux, offering of the popular open-source software relational database management system MySQL. It is a go-to platform for web applications such as WordPress, Magento, Moodle in the LAMP stack, e-commerce, OLTP, and gaming on the Microsoft Azure Cloud./p p /p pSince the announcement of deprecation of [...]
Published Wednesday, 17. April 2024 16:58 • 24 days ago

Introducing global replica credentials (from PlanetScale Blog)

With global replica credentials, you can now automatically route reads to the closest replica. [...]
Published Wednesday, 17. April 2024 16:01 • 24 days ago

Switch PostgreSQL Environments Across AWS, GCP, and k3d Using Kubernetes Contexts (from Percona Database Blog)

♦This article explains how to install the Percona Distribution for PostgreSQL on Kubernetes using “context”. We will show you how to set up this distribution on Kubernetes clusters in AWS, Google Cloud, and locally with k3d. You’ll also learn how to switch between these setups to test them effectively.In Kubernetes, a context is a profile […] [...]
Published Wednesday, 17. April 2024 13:25 • 24 days ago

Intel, RedHat, and others join hands for Open Platform for Enterprise AI (from InfoWorld)

pIn a move that could redefine how generative AI can be used by enterprises sans the present ambiguity over its ability to scale and interoperable across business systems, the LF AI & Data Foundation has announced the launch of the Open Platform for Enterprise AI (OPEA) in collaboration with several technology companies./ppThe objective is to spearhead the development of open, robust, multi- [...]
Published Wednesday, 17. April 2024 12:31 • 24 days ago

Tungsten Dashboard Via Docker: Now Available! (from Continuent Blog)

In this blog post, we explore the new support for running Tungsten Dashboard via Docker containers. This method allows for a rapid configuration of the GUI. We describe the docker method of installing the Tungsten Dashboard using a pre-defined Docker container provided by Continuent containing Apache, PHP, HAProxy and the Dashboard.Tags: tungsten dashboardDashboard via DockerTungsten Dashboard [...]
Published Wednesday, 17. April 2024 07:57 • 24 days ago

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 • 25 days 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 • 25 days 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 • 25 days 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 • 25 days 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 • 25 days 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 • 25 days 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 • 25 days 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 • 25 days 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 • 26 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 • 28 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 • 29 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 • 29 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 • 29 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 • 29 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 • 1 months ago | Updated Friday, 12. April 2024 00:51 • 29 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 • 29 days ago | Updated Friday, 12. April 2024 00:40 • 29 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 • 30 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 • 1 months 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 • 1 months 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 • 1 months ago