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.

Thursday, 28. March 2024

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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-6600b5546bc78683949958/] Let’s dissect the.../p pO post MySQL: Identifying Tables Not Using I [...]

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

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

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

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

What’s new in MariaDB Connector/Node.js 3.3 (from MariaDB Corporation Blog)

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

Javascript support in MySQL: the UUID example (from The Oracle MySQL Blog)

Let's take a look at these examples to understand how Javascript functions inside MySQL can be used. [...]

Javascript support in MySQL: the UUID example (from lefred's blog)

You may have noticed that MySQL now supports creating functions (and store procedures) in Javascript using GraalVM. This new functionality is only available in MySQL Enterprise and MySQL HeatWave. As a developer, you can also get free access to MySQL Enterprise from Oracle Technology Network (OTN): MySQL Enterprise Download. I also recommend you look at […] [...]

MariaDB Galera Cluster – the wsrep allowlist (from Galera Blog)

If you’ve used Galera Cluster for sometime, you might have already realised that with Galera 4, you have 3 new tables in the mysql database: wsrep_cluster, wsrep_cluster_members, and wsrep_streaming_log. We document this quite well in Galera System Tables. Join us for a Webinar: Top tips to drive your MariaDB Galera Cluster performance with new features. […] [...]

Wednesday, 20. March 2024

Amazon Aurora zero-ETL integration with Amazon Redshift announces support for data filtering and CloudFormation (from AWS What's New)

pAmazon Aurora MySQL zero-ETL integration with Amazon Redshift now supports data filtering, enabling you to include or exclude specific databases and tables as part of the zero-ETL integration. Based on your analytics needs, filtering of specific databases and tables helps you selectively bring data into Amazon Redshift. In addition, you can now easily manage and automate the configuration and depl [...]

PostgreSQL Monitoring with Percona Monitoring and Management: A Redefined Summary (from Percona Database Blog)

♦When checking for how good (or bad) a PostgreSQL instance is behaving, one just wants to see everything that matters on a single-ish page. That’s what the new summary dashboard in Percona Monitoring and Management (PMM) is achieving: So, what is “everything that matters”? It goes like this: Is my database ALIVE (in other words: […] [...]

Webinar: Top tips to drive your MariaDB Galera Cluster performance with new features (from Galera Blog)

MariaDB Server has built in Galera Cluster since the 10.0 releases, and plenty of joint engineering happens between Codership and MariaDB Corporation and the MariaDB Foundation. Galera Cluster as you may already know is a synchronous multi-primary (multi-master) replication solution, that has automatic node provisioning, with parallel replication, no secondary lag, with built-in automatic conflict [...]

Digital Tech Trek Digest [#Issue 2024.12] (from Ronald Bradford Blog)

Falsehoods programmers believe about time zones If I told you there was a timezone 30 minutes past the hour, would you believe me? In a small section of Western Australia, there is. However, time zones (TZ) are way more complicated. If you have not missed a meeting due to a TZ mixup, you haven’t worked […] [...]

Coming up next, a ColumnStore webinar (from Vettabase)

The 27th is fast approaching but you can still signup to our live webinar where we will be exploring the benefits of time series data using MariaDB ColumnStore. We will be jumping into a live demo with some example data and queries simulating high volume time series workloads, and even a quick example of how ColumnStore fairs in the 1 billion row challenge.We will create some tables to help you get [...]

Best Free SQL Database Software (from Devart MySQL Tool Blog)

pModern SQL tools are highly regarded by both seasoned database professionals and casual users. Here, selecting the appropriate SQL tools is a task of critical importance. This article reviews the most popular SQL tools tailored for different database systems. /p pThe post Best Free SQL Database Software appeared first on Devart Blog./p [...]

Azure Database for MySQL - February 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 March 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 [...]

Tuesday, 19. March 2024

Make SHOW as good as SELECT even with InnoDB (from SQL And Its Sequels (Ocelot Blog))

Here’s a snippet of what I’d like SHOW ENGINE INNODB STATUS to look like: as opposed to what the server sends: ... -------- FILE I/O -------- Pending flushes (fsync): 0 295 OS file reads, 1 OS file writes, 1 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ... In my last post… Continue Reading Make SHOW as good as SELECT even with InnoDB [...]

Sharding with MariaDB MaxScale (from Shinguz's Blog)

Table of contents ul liOverview/li liPreparation of the shards (MariaDB database instances)/li ul liCreate test data/li liCreating roles and users/li liMaxScale Monitor User/li liMaxScale Admin User/li liCreate application role and accounts/li liProxy protocol/li /ul liMaxScale SchemaRouter configuration/li liStarting and stopping the MaxScale Load Balancer/li [...]

Percona Monitoring and Management Database Overview Dashboard, Simplified (from Percona Database Blog)

♦Percona Monitoring and Management (PMM) overview dashboards were always meant to be a starting point for DBAs to check the overall health of the databases. Current overview dashboards can be a little overwhelming, based on an approach of “full visibility.” Now, we present a redesigned dashboard focused on simplicity:Where is the simplicity coming from? At first, […] [...]

The problem with using a UUID primary key in MySQL (from PlanetScale Blog)

Understand the different versions of UUIDs and why using them as a primary key in MySQL can hurt database performance. [...]

MySQL InnoDB’s Instant Schema Changes: What DBAs Should Know (from The Oracle MySQL Blog)

This blog post provides some recommendations for MySQL DBAs when using Instant DDL operations. [...]

MySQL InnoDB’s Instant Schema Changes: What DBAs Should Know (from lefred's blog)

In MySQL 8.0.12, we introduced a new algorithm for DDLs that won’t block the table when changing its definition. The first instant operation was adding a column at the end of a table, this was a contribution from Tencent Games. Then in MySQL 8.0.29 we added the possibility to add (or remove) a column anywhere […] [...]

Champs Recap: Devart’s Award-Winning Products in Q1 2024 (from Devart MySQL Tool Blog)

pLast season was quite fruitful in terms of awards scored by our products on independent review platforms. And today, we've got a lot more of those to share. Without further ado, let's get started!/p pThe post Champs Recap: Devart’s Award-Winning Products in Q1 2024 appeared first on Devart Blog./p [...]

Monday, 18. March 2024

Amazon Aurora MySQL version 2 (with MySQL 5.7 compatibility) to version 3 (with MySQL 8.0 compatibility) upgrade checklist, Part 2 (from AWS Database Blog)

In the first part, we discussed the most common issues that will cause upgrade prechecks from Amazon Aurora MySQL-Compatible Edition v2 to v3 to fail. In this post, we discuss the most common causes of prolonged and unsuccessful upgrade. Cluster has XA transactions in the prepared state Amazon Aurora MySQL cancels the upgrade if it […] [...]

Amazon Aurora MySQL version 2 (with MySQL 5.7 compatibility) to version 3 (with MySQL 8.0 compatibility) upgrade checklist, Part 1 (from AWS Database Blog)

Amazon Aurora MySQL-Compatible Edition version 2 (with MySQL 5.7 compatibility) is planned to reach the end of standard support on October 31, 2024. The Amazon Aurora MySQL version 2 end of standard support timeline is discussed in our public documentation. We recommend that you upgrade your databases to the default minor version of Amazon Aurora […] [...]

MariaDB 11.5.0 preview release available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 11.5.0, a preview release in the MariaDB 11.5 series. MariaDB 11.5 is a short-term release. … /p pContinue reading \"MariaDB 11.5.0 preview release available\"/p pThe post MariaDB 11.5.0 preview release available appeared first on MariaDB.org./p [...]

Trying to tune Postgres for the Insert Benchmark: small server (from Small Datum)

pLast year I spent much time trying to tune the Postgres configs I use to improve results for the Insert Benchmark. While this was a good education for me I wasn't able to get significant improvements. After writing about another perf problem with Postgres (optimizer spends too much time on DELETE statements in a special circumstance) I revisited the tuning but didn't make things significantly bett [...]

Comparing Postgres and MySQL on the insert benchmark with a small server (from Small Datum)

pMy primary goal with the benchmarks I run has been to identify performance regressions, especially ones that can be fixed to make open source databases better. And so I focus on comparing old and new versions of one DBMS at a time to identify where things get better or worse. But here I compare Postgres with MySQL (InnoDB & MyRocks) to show that neither is the best for the Insert Benchmark -- [...]

Logarithm: A logging engine for AI training workflows and services (from Engineering at Meta)

pSystems and application logs play a key role in operations, observability, and debugging workflows at Meta. Logarithm is a hosted, serverless, multitenant service, used only internally at Meta, that consumes and indexes these logs and provides an interactive query interface to retrieve and view logs. In this post, we present the design behind Logarithm, and [...]/p pRead More.../p pThe post Logari [...]

Yet another Insert Benchmark result: MySQL, InnoDB and a small server (from Small Datum)

pWhile trying to explain a Postgres performance problem I repeated the Insert Benchmark on a small server for InnoDB from MySQL 5.6, 5.7 and 8.0. This post explains those results. Previous reports are here for cached and IO-bound workloads and the results here are similar./pptl;dr/pp/pulliDisclaimer - the low-concurrency results here are worse than the results from a bigger server with more concurr [...]

Yet another Insert Benchmark result: MyRocks, MySQL and a small server (from Small Datum)

pWhile trying to explain a Postgres performance problem I repeated the Insert Benchmark on a small server for MyRocks from MySQL 5.6 and 8.0. This post explains those results. The previous report for a cached workload is here./pptl;dr/pp/pulliDisclaimers/liulliThe low-concurrency results here are worse than the results from a bigger server with more concurrency because the result here depends more [...]

Percona XtraBackup 8.0.28 Supports Encrypted Table Backups with AWS KMS (from Percona Database Blog)

♦Percona XtraBackup (PXB) version 8.0.28 supports taking backups for the encrypted tables in your MySQL database using the AWS Key Management Service. For setting up data-at-rest encryption using AWS key management service, please see Configuring Keyring for Encryption Using AWS Key Management Service in Percona Server for MySQL.In this blog post, we will discuss how […] [...]

Updated Insert benchmark: Postgres 9.x to 16.x, small server, cached database, v3 (from Small Datum)

pI now have 4 server types at home (8 cores + 16G RAM, 8 cores + 32G RAM,  24 cores, 32 cores) and am trying to finish a round of the Insert Benchmark for each. This has results for the smallest (8 cores + 16G RAM) using a cached workload and Postgres.brbrIn previous blog posts I claimed that there are large regressions from old to new MySQL but not from old to new Postgres. And I shared resul [...]

Saturday, 16. March 2024

Identifying Performance Bottlenecks: Assessing IO Subsystem Reads in MySQL (from MinervaDB Blog)

pDetecting when the IO subsystem reads are struggling in MySQL involves observing several key performance indicators that could suggest the disk IO is becoming a bottleneck. Here are steps and methods to assess the health [...]/p pThe post Identifying Performance Bottlenecks: Assessing IO Subsystem Reads in MySQL appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQ [...]

Thursday, 14. March 2024

Continuent Announces Tungsten Clustering Version 7 for Unmatched MySQL High Availability, Disaster Recovery and Geographic Scaling (from Continuent Blog)

Continuent's flagship product, Tungsten Clustering v7, features significant improvements in usability, security, performance and connectivity for achieving seamless operational continuity of MySQL and MariaDB databases. [...]

Analysts react to MySQL HeatWave Gen AI and vector store innovations (from The Oracle MySQL Blog)

Leading industry analysts react to MySQL HeatWave’s latest vector store and generative AI new capabilities (private preview), including support for a new VECTOR data type, integration with MySQL Shell and MySQL Shell for VS Code, an automated pipeline to ingest documents into the vector store, several options to use LLMs with MySQL HeatWave, the ability to combine Gen AI with machine learning, and [...]

dbstat for MariaDB (and MySQL) (from Shinguz's Blog)

Table of contents ul liFunctionality of codedbstat/code/li liHow does codedbstat/code work/li liHow to install codedbstat/code/li liQuery codedbstat/code ul licodetable_size/code/li licodeprocesslist/code/li licodetrx_and_lck/code/li licodemetadata_lock/code/li licodeglobal_variables/code/li licodeglobal_status/code/li /ul /li liTesting/li [...]

AI-Powered Data Exploration: Unpacking the Latest Innovations in TiDB Cloud (from TiDB and TiKV Blog)

pIn early 2023, TiDB Cloud introduced Chat2Query, a new tool that leverages OpenAI’s capabilities to help explore and interact with databases through natural language. After a year of continuous improvements, we’re excited to share that Chat2Query has now become even more powerful. In this blog, we dive deeper into three major improvements to Chat2Query that […]/p pThe post AI-Powered D [...]

Wednesday, 13. March 2024

Want to become an AI developer? Here’s how with MySQL HeatWave (from The Oracle MySQL Blog)

Generative AI is arguably the most important technology trend right now. This fast-moving disruption represents tremendous opportunities for developers to play a critical role in the evolution of almost every new and existing application. MySQL HeatWave makes it easy to build upon your existing skills to become an AI developer with in-database machine learning and support for generative AI and vect [...]

Node.js MongoDB Create Collection: An Introductory Guide (from Code For Geek)

A collection with respect to MongoDB is used to store documents. It is similar to a table in a relational database.  A relational database such as MySQL database holds multiple tables to store different records similarly a MongoDB database holds multiple collections to group different documents together but unlike the relational database, it doesn’t store […] [...]

How to Install Windows on a Mac With Parallels and Run dbForge Edge (from Devart MySQL Tool Blog)

pThough dbForge Edge is Windows-native, you can make it work on macOS. One of the possible ways to do that is to use Parallels Desktop, a macOS-compatible solution that will help you create and manage a Windows environment in order to run dbForge Edge on your Mac./p pThe post How to Install Windows on a Mac With Parallels and Run dbForge Edge appeared first on Devart Blog./p [...]

Using the Oracle Cloud TypeScript SDK Part 5 - Creating 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 configure and initiate an back up of a MySQL HeatWave instance. [...]

Observability in MySQL Group Replication with Grafana (from Mydbops Blog)

Ensuring the smooth operation of your MySQL Group Replication cluster is crucial for maintaining data consistency and high availability. But how do you keep a watchful eye on its health and performanc [...]

Tuesday, 12. March 2024

MySQL Asynchronous Connectivity with MySQL Connector/Python (from The Oracle MySQL Blog)

Unleashing Asynchronous MySQL Connectivity with MySQL Connector/Python [...]

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

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

MySQL Rockstars 2023 (from The Oracle MySQL Blog)

MySQL Rockstars 2023 [...]

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

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

Replication — Position Primary Replicator (from Continuent Blog)

When external issues cause the primary extractor to go offline, we address the issue and bring the extractor back online. However, we need to make sure we start the extraction from the correct position so that the downstream replicas receive transactional data they require. Let’s determine the position and how we set it.Tags: tungsten replicatorTHLextractor positioning [...]

ClusterControl adds in-place major PostgreSQL upgrade and pgvector extension in latest release (from Severalnines Blog)

pWe’re thrilled to announce that ClusterControl (CC) version 1.9.8 is now available! This latest release brings a range of exciting features to ClusterControl users, including an in-place major version upgrade for PostgreSQL, the addition of the pgvector extension, and a minor version upgrade for MongoDB users. Let’s dive into the details to help you get […]/p pThe post ClusterControl a [...]

Monday, 11. March 2024

MariaDB Enterprise Server Q1 2024 maintenance releases (from MariaDB Corporation Blog)

New maintenance releases for MariaDB Enterprise Server 10.6.17-12, 10.5.24-18, and 10.4.33-23. These releases include a variety of fixes. Download Now … Continued [...]

Self-Hosted ServiceNow Quick Start Guide for MariaDB Enterprise Server 10.6 (from MariaDB Corporation Blog)

Architecting a self-hosted ServiceNow deployment’s database infrastructure can be intimidating. Your stakeholders are expecting your architecture to “just work like … Continued [...]

Percona Operator for MySQL Now Supports Automated Volume Expansion in Technical Preview (from Percona Database Blog)

♦Volume Expansion, a feature that became generally available since Kubernetes version 1.24, allows users to increase the capacity of their Persistent Volumes and underlying storage within Kubernetes. There is no need to use clouds’ UI or APIs to do that anymore. In our Operators, we use Stateful Sets – a Kubernetes resource that was designed for […] [...]

Saturday, 09. March 2024

MySQL vs MongoDB Comparison (from TechBeamers MySQL)

pThis article captures the comparison between MySQL vs MongoDB, the two most popular databases. It highlights the key differences between them. Also Read-MySQL vs PostgreSQL ComparisonDifference Between 3 Python SQL Libraries Data Storage Comparison The fundamental difference between MySQL and MongoDB lies in how they store data. This distinction has a significant impact on their […]/p pThe p [...]

Friday, 08. March 2024

Master MySQL Point in Time Recovery (from ScaleGrid Blog)

pData loss or corruption can be daunting. With MySQL point-in-time recovery, you can restore your database to the moment before the problem occurs. This article delivers a practical roadmap for using backups and binary logs to achieve accurate MySQL recovery, detailed steps for setting up your server, and tips for managing recovery and backups effectively.../p p<p>The post Master MySQL Point [...]

AWS announces Aurora MySQL integration with Amazon Bedrock for Generative AI (from AWS What's New)

pToday, AWS announces that Amazon Aurora ML now provides access to foundation models available in Amazon Bedrock directly through SQL in the Aurora MySQL 3.06 version./p [...]

Amazon Aurora MySQL 3.06 (compatible with MySQL 8.0.34) is generally available (from AWS What's New)

pIn addition to security enhancements, bug fixes, and improved data replication performance with binary log (binlog), this release includes new generative AI capabilities and improved cross-region resiliency for Aurora Global Database. With this release, customers can use Aurora MySQL to build scalable generative AI applications, accessing Amazon Bedrock’s foundation models directly through SQL. Th [...]

Announcing Vitess 19 (from PlanetScale Blog)

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

Thursday, 07. March 2024

The Pain of AWS EKS and Stateful Workloads (from Percona Database Blog)

♦I really like AWS and the way they build their products, I really do. But for some reason, AWS Elastic Kubernetes Service (EKS) provides one of the worst user experiences. There are a couple of huge pain points that I want to cover in this quick blog post.Cluster deploymentTooling – AWS CLIIt is just unusual […] [...]

Observability in MySQL Group Replication Monitoring with Performance_schema (from Mydbops Blog)

Spot Hiccups Before They Happen! In the context of Group Replication, a robust monitoring strategy is indispensable to ensure the health and performance of individual servers and the entire cluster. T [...]

MySQL 8 upgrade may fail using checkForServerUpgrade (from Kedar MySQL Blog)

pThese days MySQL consultants around me are busy assisting with MySQL 8 upgrades for those who couldn’t board the train before EoL.I was recently involved in one of the MySQL…/p The post MySQL 8 upgrade may fail using checkForServerUpgrade first appeared on Change Is Inevitable. [...]

Wednesday, 06. March 2024

How to Log Into Remote MySQL Server (from RoseHosting Blog)

pMySQL is the most popular database server – odds are your website is using MySQL to store its data. Sometimes ... /p pRead More/p pThe post How to Log Into Remote MySQL Server appeared first on RoseHosting./p [...]

MySQL HeatWave Inbound Replication - On-Premises to MySQL HeatWave DB System (from The Oracle MySQL Blog)

This blog explains how to setup inbound replication from an on-premises MySQL server to a MySQL HeatWave DB System. [...]

Easy Way to Provision a PostgreSQL Cluster on Kubernetes (from Percona Database Blog)

♦If you are reading this blog post, chances are you’re either curious about Kubernetes Operators, or you’ve specifically decided to install the Percona Operator for PostgreSQL, which I am glad to know!Suppose your environment isn’t set up yet. In that case, you can use this blog post, Setting Up Your Environment for Kubernetes Operators Using […] [...]

New Features to MySQL Enterprise Data Masking and De-Identification (from The Oracle MySQL Blog)

MySQL Enterprise Data Masking and De-Identification component now has new features that allow for more elastic management of masking dictionaries. [...]

PlanetScale forever (from PlanetScale Blog)

PlanetScale is committed to providing a reliable and sustainable platform for our customers, not just in the short-term, but forever. For this reason, we are prioritizing profitability. [...]

Announcing Vitess 19 (from Vitess)

Announcing Vitess 19 # We're thrilled to announce the release of Vitess 19, our latest version packed with enhancements aimed at improving scalability, performance, and usability of your database systems. With this release, we continue our commitment to providing a powerful, scalable, and reliable database clustering solution for MySQL. What's New in Vitess 19 # Dropping Support for MySQL 5.7: As O [...]

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

Help Us Improve MySQL Usability and Double Win! (from Percona Database Blog)

♦What makes a great user experience? There are probably as many answers to this question as there are users because we are talking about very subjective and personal feelings and observations.While there are multiple experts at Percona, we also believe that one should not be forced to become a database expert to be able to […] [...]

Testing of RonDB releases (from Mikael Ronstrom)

p Since RonDB is a fork of MySQL NDB Cluster it contains a lot of tests that is part of the RonDB development tree. This includes unit tests for various functionalities. It includes many hundreds of MTR test cases that takes between a few seconds to a few minutes to run. These tests are mostly test cases that use SQL commands to test the functionality of RonDB, in addition it tests backup and [...]

Mastering MySQL Group Replication Recovery: Strategies for High Availability and Data Integrity (from Mydbops Blog)

MySQL Group Replication offers high availability and data redundancy, but like any technology, it's essential to be prepared for unexpected events. In the dynamic world of database management, ensurin [...]

Mydbops Rocks PGConf India 2024 with Lightning Talk on pg_osc! (from Mydbops Blog)

Thriving PostgreSQL Community at PGConf India 2024 The energy at PGConf India 2024 was truly infectious! As your trusted PostgreSQL management partner, Mydbops was thrilled to be at the heart of this [...]

Monday, 04. March 2024

Google advances with vector search in MySQL, leapfrogging Oracle in LLM support (from The Register)

Meanwhile, only 22% of orgs are looking at GenAI strategy for databases pGoogle has introduced vector search to its MySQL database service, surpassing Oracle – custodian of the open source database – which has so far failed to add the feature deemed an advantage in executing large language models (LLMs).…/p [...]

Releasing ProxySQL v2.6.0! (from ProxySQL Blog)

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

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

A few months ago, after adding yet another DB into ProxySQL, we started to experience instance crash. The case was interesting and challenging due to following reasons: “Improbable” from the post title may be a bit of exaggeration, but as you will see what is needed to reproduce the problem, it is the most unlikely … Continue reading "A short tale about troubleshooting improbable& [...]

MySQL GTID Tags — What you need to know (from Marcelo Altmann)

MySQL GTID Tags — What you need to know♦MySQL GTID StructurepMySQL Innovate Release 8.3 introduction of GTID (Global Transaction Identifiers) tags in replication processes is a significant enhancement in MySQL management and operations. This new functionality, provides users with the ability to tag groups of transactions for easier identification. Here’s a guide into what GTID tags means, their ben [...]

What’s New in MySQL 8.3: Feature Overview (from Devart MySQL Tool Blog)

pThe latest version of MySQL Server, 8.3, has been available as a General Availability (GA) release for a while. In case you have missed it, here is a brief recap of the newly available features and enhancements./p pThe post What’s New in MySQL 8.3: Feature Overview appeared first on Devart Blog./p [...]

MySQL install ‘n’ config one-liners (from MySQL-Med)

I've been installing and configuring InnoDB Clusters and ClusterSets and thinking about the Ansible and Terraform users amongst us, maybe one-liners might help someone out there. Continue reading → [...]

Setting Up Your Environment for Kubernetes Operators Using Docker, kubectl, and k3d (from Percona Community Blog)

If you are just starting out in the world of Kubernetes operators, like me, preparing the environment for their installation should be something we do with not much difficulty. This blog will quickly guide you in setting the minimal environment. Kubernetes operators are invaluable for automating complex database operations, tasks that Kubernetes does not handle directly. Operators make it easy for [...]

Saturday, 02. March 2024

How to Change a Column Type in MySQL (from Devart MySQL Tool Blog)

pThis article will walk you through the essentials of MySQL, shedding light on the intricacies of column types, and explore scenarios where altering column types becomes a necessity, exemplified through the lens of dbForge Studio for MySQL./p pThe post How to Change a Column Type in MySQL appeared first on Devart Blog./p [...]

Friday, 01. March 2024

Using Linux perf: do we need to pass identifying info as arguments to important functions? (from Sergei Petrunia's blog)

TL;DR: Longer: Sometimes one has to analyze statement execution at a finer detail than ANALYZE FORMAT=JSON has. I was involved in such case recently: an UPDATE statement invoked a trigger which ran multiple SQL statements and invoked two stored functions. ANALYZE FORMAT=JSON showed that the top-level UPDATE statement didn’t have any issues. The issue was […] [...]

How to avoid data loss in MySQL Primary Key change (from Kedar MySQL Blog)

pLearn how to safely change primary keys in MySQL using pt-online-schema-change. This blog highlights tips to avoid data loss during online alter of primary key./p The post How to avoid data loss in MySQL Primary Key change first appeared on Change Is Inevitable. [...]

Parametric Queries (from MacLochlainns Weblog)

In 2021, I wrote a MySQL example for my class on the usefulness of Common Table Expressions (CTEs). When discussing the original post, I would comment on how you could extend the last example to build a parametric reporting table. Somebody finally asked for a concrete example. So, this explains how to build a sample […] [...]

MySQL Keyring Component Installation for TDE (from MySQLHK)

pbr/ppMySQL Plugin has been extensively used with MySQL.   It is being evolved into COMPONENT deployment.   This article is written to share the steps with MySQL Keyring Component Installation.   /ppMySQL Enterprise Edition includes encrypted file component for Keyring.    This provides a more secure way to store the master key with TDE./ppInstallation of component wit [...]

Thursday, 29. February 2024

Make SHOW as good as SELECT (from SQL And Its Sequels (Ocelot Blog))

For example, this works: SHOW AUTHORS GROUP BY `Location` INTO OUTFILE 'tmp.txt'; You’re thinking “Hold it, MySQL and MariaDB won’t allow SHOW (and similar statements like ANALYZE or CHECK or CHECKSUM or DESCRIBE or EXPLAIN or HELP) to work with the same clauses as SELECT, or in the same places.” You’re right — but they… Continue Reading Make SHOW as good a [...]

Implement advanced replication features with Amazon RDS for MySQL and Amazon Aurora MySQL using intermediate replication servers (from AWS Database Blog)

In this post, we show you how to use advanced replication features between MySQL-compatible databases such as Amazon Aurora MySQL-Compatible Edition clusters or Amazon Relational Database Service (Amazon RDS) for MySQL instances. We discuss two replication capabilities in Amazon RDS and Amazon Aurora: multi-source replication and replication filtering. Multi-source replication is supported only in [...]