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, 12. September 2024

MySQL + InnoDB vs sysbench on a large server (from Small Datum)

pThis has benchmark results for MySQL 5.6.51, 5.7.44 and 8.0.39 using sysbench on a large server. I also add a few results comparing Postgres 17rc1 with MySQL 8.0.39. My goal with that is to highlight things that can be made better in MySQL (and in Postgres).brbrOne of the responses to my claims that MySQL is getting too many performance regressions over time is that this is true for low-concurrenc [...]
Published Thursday, 12. September 2024 18:48 • an hour ago | Updated Thursday, 12. September 2024 18:48 • an hour ago

HeatWave – new capabilities for OLAP workloads (from The Oracle MySQL Blog)

HeatWave has added new capabilities on both OCI and AWS platforms. Here is the list of features introduced in 9.0 and 9.0.1-u1 for HeatWave and HeatWave Lakehouse. [...]
Published Thursday, 12. September 2024 16:42 • 3 hours ago

Rate limits and Quotas in RonDB (from Mikael Ronstrom)

Hopsworks-RonDB Background pOne of the services that Hopsworks provides is a free service to run Hopsworks workloads in a managed cloud. This service has been used by many thousands of individuals and companies wanting to experiment with AI Lakehouse applications of various sorts such as predicting weather in your location and other experimental machine learning applications./ppThis Hopsworks [...]
Published Wednesday, 11. September 2024 20:12 • 24 hours ago | Updated Thursday, 12. September 2024 16:15 • 4 hours ago

MySQL/HeatWave Audit Archive and Dump to Object Storage (from MySQLHK)

pAuditing is one of the key concerns with Security & Compliance for many organizations.   /ppThis article is written to share a tutorial how to do audit log archiving by reading the audit log.  The audit archiving process is to read the audit log using audit_log_read function provided to access to the audit.   The data once is archived to Table "audit_archive.audit_data" and [...]
Published Thursday, 12. September 2024 10:31 • 10 hours ago | Updated Thursday, 12. September 2024 15:12 • 5 hours ago

HeatWave GenAI for e-Commerce Applications: Part 2 (from The Oracle MySQL Blog)

With the new capabilities added in HeatWave GenAI such as HeatWave GenAI native JavaScript support and multi-lingual support, we extend the E-Commerce application introduced in Part 1 to further improve user purchasing experience. [...]
Published Thursday, 12. September 2024 12:43 • 7 hours ago

New Features in HeatWave GenAI (from The Oracle MySQL Blog)

We recently announced the general availability of HeatWave GenAI – industry’s first in-database LLMs,  an automated, in-database vector store,  scale-out vector processing,  and the ability to have contextual conversations in natural language. [...]
Published Thursday, 12. September 2024 11:19 • 9 hours ago

Oracle CloudWorld 2024: Latest news and insights (from InfoWorld)

pOracle CloudWorld, one of the tech industry’s signature events, began September 9th. The event, known as OpenWorld until 2020,  is a significant gathering for IT professionals, developers, and business leaders looking to explore the latest advancements in cloud computing. /p pHere are a few things to watch for at Oracle CloudWorld 2024:/p ul liExpect a heavy dose of AI [...]
Published Thursday, 12. September 2024 08:15 • 12 hours ago

InnoDB, compiler options and sysbench (from Small Datum)

pIn this post I have more results on the impact of compile-time options for MySQL, InnoDB and sysbench. I previously wrote about the impact of PGO and LTO on MySQL performance./pptl;dr/pp/pulliThere is no silver bullet to undo the performance regressions/liliYou can improve QPS by 10% to 20% with -O3, LTO and disabling most of the perf schema at compile time but I am reluctant to suggest running in [...]
Published Thursday, 12. September 2024 01:00 • 19 hours ago | Updated Thursday, 12. September 2024 01:00 • 19 hours ago

Percona Monitoring and Management 2.43.0 Preview Release (from Percona Community Blog)

Percona Monitoring and Management 2.43.0 Tech Preview Release Hello everyone! Percona Monitoring and Management (PMM) 2.43.0 is now available as a Tech Preview Release. We encourage you to try this PMM preview release in testing environments only, as these packages and images are not fully production-ready. The final version is expected to be released through the standard channels in the coming wee [...]
Published Thursday, 12. September 2024 00:00 • 20 hours ago

Wednesday, 11. September 2024

HeatWave Chat: How to Create Your Personal Chatbot (from The Oracle MySQL Blog)

HeatWave Chat: How to Create Your Personal Chatbot. [...]
Published Wednesday, 11. September 2024 17:45 • a day ago

HeatWave on AWS: New enhancements announced at Oracle CloudWorld 2024 (from The Oracle MySQL Blog)

HeatWave on AWS runs natively on AWS infrastructure. All components, including the service console, control plane, and data plane, are built and optimized for AWS. This native integration with AWS enables customers with applications already deployed in AWS to benefit from HeatWave without incurring the latency associated with accessing a database service running outside of AWS. [...]
Published Wednesday, 11. September 2024 16:03 • a day ago

Fixing Replication Lag due to Large Scale Data Processing (from Shattered Silicon OSDB Blog)

pHow we fixed replication lag caused by large scale data processing. Excluding intermediate processing tables can make a big difference/p pThe post Fixing Replication Lag due to Large Scale Data Processing appeared first on Shattered Silicon./p [...]
Published Wednesday, 11. September 2024 15:36 • a day ago

Tuesday, 10. September 2024

Introducing HeatWave Always Free (from The Oracle MySQL Blog)

We are excited to introduce HeatWave Always Free as part of OCI Always Free tier. All OCI accounts get access to a HeatWave Always Free instance in their OCI home region for an unlimited time. This allows organizations to experience the latest HeatWave features first-hand free-of charge. [...]
Published Tuesday, 10. September 2024 17:00 • 2 days ago

HeatWave MySQL – New Capabilities for OLTP Workloads (from The Oracle MySQL Blog)

On the cusp of Oracle Cloud World 2024, we’d like to call attention to some recent enhancements that are now available for Heatwave MySQL. These enhancements deliver improvements in availability, disaster recovery, performance, manageability and operability, and developer productivity. [...]
Published Tuesday, 10. September 2024 16:59 • 2 days ago

Private equity commits MariaDB takeover transaction (from The Register)

Post-IPO chapter ends after SQL biz shed jobs, products in bid to find buyer pA private equity biz has succeeded in its takeover of MariaDB 18 months after its disastrous IPO.…/p [...]
Published Tuesday, 10. September 2024 16:02 • 2 days ago

MariaDB Foundation assisting multiple vendors (from MariaDB Foundation Blog)

pI recently helped two of our sponsors simultaneously, DBS Bank and MariaDB Plc, with a recent issue they were experiencing. This actually helped us add support for an extra cloud vendor. … /p pContinue reading \"MariaDB Foundation assisting multiple vendors\"/p pThe post MariaDB Foundation assisting multiple vendors appeared first on MariaDB.org./p [...]
Published Tuesday, 10. September 2024 15:51 • 2 days ago

Monitoring and Optimizing Fragmented Tables in MySQL (from Another Boring Tech Blog)

pRandom insertions or deletions in a secondary index can lead to fragmentation, where the physical order of index pages on disk no longer aligns with the logical order of records. A common sign of fragmentation is that a table occupies more space than expected, though determining the exact amount is challenging. InnoDB stores data and.../p pO post Monitoring and Optimizing Fragmented Tables in MySQ [...]
Published Tuesday, 10. September 2024 15:19 • 2 days ago

How to Migrate a Production Database to Percona Everest (MySQL) Using Clone (from Percona Database Blog)

♦This long article aims to provide you with the instructions and tools to migrate your production database from your current environment to a solution based on Percona Everest (MySQL). Nice. You decided to test Percona Everest and found that it is the tool you were looking for to manage your private DBaaS. The easiest part […] [...]
Published Tuesday, 10. September 2024 13:45 • 2 days ago

MariaDB goes private with new CEO as K1 closes acquisition (from TechCrunch)

pMariaDB‘s short-lived tenure as a public company is all but over, as the struggling database business is now fully under the auspices of K1 Investment Management. MariaDB also announced a new CEO in former Micro Focus executive Rohit de Souza, who replaces Paul O’Brien after just 16 months in the hot seat in preparation for […]/p p© 2024 TechCrunch. All rights reserved. For perso [...]
Published Tuesday, 10. September 2024 13:15 • 2 days ago

Oracle’s HeatWave data analytics service gets new gen AI features (from InfoWorld)

pOracle released new generative AI features among other updates to its managed data analytics and database service, Oracle HeatWave at its CloudWorld 2024 conference./p pOracle HeatWave encompasses several modules including HeatWave Lakehouse, HeatWave on AWS, HeatWave AutoML, HeatWave Gen AI, and MySQL HeatWave./p p[ Related: Oracle CloudWorld 2024 coverage ]/p pThe [...]
Published Tuesday, 10. September 2024 13:00 • 2 days ago

Installing MariaDB ColumnStore on Ubuntu, for production (from Vettabase)

Let’s see how to install MariaDB ColumnStore (single node) on Ubuntu. Let’s also prepare the system to run ColumnStore with good performance, as we should always do in production. The following steps should work on any modern Ubuntu version up to and including 24.04 LTS. Installing and configuring MariaDB and ColumnStore First, let’s configure the server parameters: Also, change t [...]
Published Tuesday, 10. September 2024 09:09 • 2 days ago

HeatWave GenAI: Sentiment Analysis Made Easy-Peasy (from MySQL expert Diary)

pThis new AI tech, called generative AI (or GenAI), can dive deep into what people are saying and tell us if they’re feeling positive, negative, or neutral.br Let’s see how HeatWave GenAI, can help you to enhance your understanding of customer sentiment, improve decision-making, and drive business success./p The post HeatWave GenAI: Sentiment Analysis Made Easy-Peasy first appeared on dasini.net - [...]
Published Tuesday, 10. September 2024 08:57 • 2 days ago

Monday, 09. September 2024

MariaDB Enterprise Server Q3 2024 Maintenance Releases with Backported Features (from MariaDB Corporation Blog)

New maintenance releases for MariaDB Enterprise Server 10.6.19-15 and 10.5.26-20 are now available. These releases include new backported features. Download … Continued [...]
Published Monday, 09. September 2024 21:28 • 3 days ago

Amazon Aurora now supports R7g Graviton3-based instance family in 15 additional regions (from AWS What's New)

pAWS Graviton3-based R7g database instances are now generally available for Amazon Aurora with PostgreSQL compatibility and Amazon Aurora with MySQL compatibility in 15 additional regions, including US West (N. California), Canada (Central), South America (Sao Paulo), Europe (Stockholm), Europe (Frankfurt), Europe (London), Europe (Milan), Europe (Spain), Asia Pacific (Mumbai), Asia Pacific (Hydera [...]
Published Monday, 09. September 2024 20:35 • 3 days ago

Improving Performance for Tungsten Replication to MySQL (from Continuent Blog)

What are some strategies for improving performance when applying to a MySQL target database with Tungsten Replicator?Tags: MySQLreplicationperformanceTuning [...]
Published Monday, 09. September 2024 09:21 • 3 days ago

Oracle Unveils HeatWave Innovations Across Generative AI, Lakehouse, MySQL, AutoML, and Multicloud (from The Oracle MySQL Blog)

Oracle HeatWave provides automated, integrated, and secure generative AI and machine learning in one fully managed cloud service for transactions and lakehouse-scale analytics. New features are available across the HeatWave portfolio—on both OCI and AWS. [...]
Published Monday, 09. September 2024 06:08 • 4 days ago

JSON Showdown: Dolt vs MySQL (from DoltHub Blog)

Dolt is a SQL database designed as a drop in replacement for MySQL, but with extra features. Dolt's biggest feature is its Git-like version… [...]
Published Monday, 09. September 2024 00:00 • 4 days ago

B-trees and database indexes (from PlanetScale Blog)

B-trees are used by many modern DBMSs. Learn how they work, how databases use them, and how your choice of primary key can affect index performance. [...]
Published Monday, 09. September 2024 00:00 • 4 days ago

Friday, 06. September 2024

General Availability of Flexible Maintenance for Azure Database for MySQL - Flexible Server (from Azure for MySQL Blog)

pWe're excited to announce that Flexible Maintenance for Azure Database for MySQL - Flexible Server is now Generally Available (GA)! This new feature enables greater control over the timing of the maintenance activities performed on database instances, so that customers can align maintenance schedules with their operational needs./p p /p pDuring public preview, we received extensive feedback t [...]
Published Friday, 06. September 2024 19:42 • 6 days ago

Trying out a dedicated server from Hetzner (from Small Datum)

pI am trying out a dedicated server from Hetzner for my performance work. I am trying the ax162-s that has 48 cores (96 vCPU), 128G of RAM and ~4TB of NVMe storage (2 devices, RAID 1)./ppThe reasons to try it are:/pp/pulliA similar server on GCP or AWS will cost ~10X more assuming list prices. The difference on GCP drops to ~5X if I commit to 3 years of usage./liliIt has access to hardware counters [...]
Published Tuesday, 03. September 2024 19:54 • 9 days ago | Updated Friday, 06. September 2024 17:18 • 6 days ago

Amazon RDS for MariaDB supports minors 10.11.9, 10.6.19, 10.5.26 (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for MariaDB now supports MariaDB minor versions 10.11.9, 10.6.19, and 10.5.26. We recommend that you upgrade to the latest minor versions to fix known security vulnerabilities in prior versions of MariaDB, and to benefit from the bug fixes, performance improvements, and new functionality added by the MariaDB community.br br You can leverage automatic [...]
Published Friday, 06. September 2024 17:00 • 6 days ago

Running Perl-using MTR tests for fb-mysql under macOS (from Laurynas Biveinis' blog)

The headline is slightly misleading. Oracle MySQL has several Perl-using MTR tests, the whole MTR framework is Perl-based, and those tests run fine out of the box (with an occasional bug). However, fb-mysql has additional tests that call the Random Query Generator under the hood, and these tests don't work out of the box under macOS. /p p Here's what I had to do to get them working: /p pre # mysql [...]
Published Friday, 06. September 2024 14:09 • 6 days ago | Updated Friday, 06. September 2024 14:09 • 6 days ago

MySQL Error Log: Got packets out of order (from lefred's blog)

Some users, myself included, have noticed that their MySQL error log contains many lines like this one: Where does that error come from? The error MY-010914 is part of the Server Network issues like: Those are usually more problematic than the ones we are covering today. The list is not exhaustive and in the source […] [...]
Published Friday, 06. September 2024 10:29 • 6 days ago

Mask and De-identify Data in MySQL Enterprise Edition (from The Oracle MySQL Blog)

MySQL Enterprise Edition has the ability to mask and de-identify data. Find out how to use it in this article! [...]
Published Friday, 06. September 2024 06:05 • 7 days ago

LFX Mentorship Journey (from Vitess)

Introduction # This summer, I had the incredible opportunity to participate in the LFX Mentorship program, where I contributed to Vitess, a CNCF graduated project. Vitess is a cloud-native database designed for horizontal scaling of MySQL. My specific focus during this mentorship was on the "Arewefastyet" subproject, an essential benchmarking platform for Vitess. "Arewefastyet" [...]
Published Friday, 06. September 2024 00:00 • 7 days ago

Thursday, 05. September 2024

RocksDB benchmarks: cached database (from Small Datum)

pThis has results from the db_bench benchmarks for RocksDB on both a small and medium server using a database that is cached by RocksDB. Previous posts are here and here with results for RocksDB 6.0 to 9.3. This has results up to version 9.6./pptl;dr/pp/pulliBug 12038 arrived in RocksDB 8.6 and has yet to be fixed, but a fix arrives soon. This effects results on servers when the workload is IO [...]
Published Thursday, 05. September 2024 23:53 • 7 days ago | Updated Thursday, 05. September 2024 23:56 • 7 days ago

Azure Database for MySQL - Single Server retirement by 16 Sep 2024 - Migrate to Flexible Server now! (from Azure for MySQL Blog)

pAzure Database for MySQL - Single Server is scheduled for retirement by September 16, 2024./p p /p pOver the past two years, we've sent recurring notifications (via public channels such as Azure Update and blog posts as well as direct outreach through customer emails, product pages, and Azure Portal banners) about the need to complete migration to Azure Database for MySQL - Flexible Serv [...]
Published Thursday, 05. September 2024 23:21 • 7 days ago

MySQL B-tree Height Issues in Large Single Tables (from Chen Zongzhi's blog)

pSome older DBAs may remember that in the past, it was recommended that a MySQL table should not exceed 5 million rows. Many DBAs worry that as tables grow larger, the B-tree height will increase dramatically, thus affecting performance./ppIn reality, the B-tree is a very flat structure. Most B-trees do not exceed 4 levels. Let’s examine this with an example of a common sysbench table:/ppreCREATE T [...]
Published Thursday, 05. September 2024 17:38 • 7 days ago

How to Upgrade a Kubernetes Cluster (from Percona Database Blog)

♦I still remember upgrading a Kubernetes cluster for the first time. Despite taking great care and following all the documentation, I managed to break some applications. Luckily, the impact was minimal, and the issue was solved quickly. The most interesting part is that the same set of steps worked perfectly in upgrading non-production clusters, but […] [...]
Published Thursday, 05. September 2024 13:14 • 7 days ago

Join Database Administration for Galera Cluster online training course in September (from Galera Blog)

Codership, the developers of Galera Cluster and Galera Manager, have new dates for the online DBA for Galera Cluster Training. There are two sets of times for our EMEA and American attendees.  American happening on September 23rd  and 24th, starting starting 9 AM EST and EMEA happening on September 25th  and 25th, starting 9 AM EST.​​​​​ This is […] [...]
Published Thursday, 05. September 2024 13:05 • 7 days ago

Codership at DOAG Nürnberg 19-22 Nov, German articles about Galera Cluster from Ordix (from Galera Blog)

Codership will be a sponsor at DOAG 2024 in Nuremberg, Germany. There will also be 2 Galera Cluster related talks to attend: Building a Global, High-Availability Database with Galera Cluster: A Live Demo Colin Charles Codership Safe Harbor! Wie der Galera Cluster ihre MySQL Datenbanken „unsinkbar“ macht. Matthias Jung Ordix There are also a few […] [...]
Published Thursday, 05. September 2024 07:14 • 8 days ago

Dolt Rebase Conflict Resolution (from DoltHub Blog)

Dolt is the world's first SQL database with Git-style version control. You can branch, merge, diff, and even rebase your relational data, in… [...]
Published Thursday, 05. September 2024 00:00 • 8 days ago

Wednesday, 04. September 2024

SQL Fiddles updated to MariaDB 11.4 (from MariaDB Foundation Blog)

pThere are a number of SQL Fiddles, web interfaces to databases for testing / learning SQL. Recently we noticed the versions on these falling behind and not presenting users with updates that would deliver the latest MariaDB features and bug fixes. … /p pContinue reading \"SQL Fiddles updated to MariaDB 11.4\"/p pThe post SQL Fiddles updated to MariaDB 11.4 appeared first on MariaDB.org./p [...]
Published Wednesday, 04. September 2024 22:56 • 8 days ago

Instant deploy requests (from PlanetScale Blog)

PlanetScale now supports instant DDL. Where eligible, you can run deploy requests that complete near-instantly. [...]
Published Wednesday, 04. September 2024 16:01 • 8 days ago

Percona In-Product Telemetry: Updates, Findings, and News (from Percona Database Blog)

♦This article is, in fact, two topics merged into one publication. Both are related to anonymous statistical data collection within Percona releases of database engines: MySQL, MongoDB, and PostgreSQL. In the first part of this article, I will share some of our findings and observations and discuss the various conclusions we have drawn from them. […] [...]
Published Wednesday, 04. September 2024 14:18 • 8 days ago

Introducing Tungsten Dashboard v1.0.16: A Quick Fix for a Smooth Experience (from Continuent Blog)

Tungsten Dashboard v1.0.16 is now available, featuring a crucial bug fix that resolves a regression in the configuration processing function. This update ensures smoother and more reliable performance, helping you maintain seamless workflows. Update today to benefit from the enhanced stability of your dashboard experience.Tags: tungsten dashboardbug fixReleaseperformance [...]
Published Wednesday, 04. September 2024 11:02 • 8 days ago

Releasing ProxySQL v2.7.0! (from ProxySQL Blog)

pAnnouncing the Release of ProxySQL Version 2.7.0! We are thrilled to announce the release of ProxySQL v2.7.0, a significant upgrade that introduces a powerful new feature designed to enhance your MySQL deployments. This release brings exciting capabilities for network load balancing, security, and improved debugging. What's New in ProxySQL 2.7.0? ProxySQL v2.7.0 is a major [...]/p pThe post Releas [...]
Published Wednesday, 04. September 2024 10:39 • 8 days ago

PostgreSQL tutorial: Get started with PostgreSQL 16 (from InfoWorld)

pFor years now, PostgreSQL has been one of the best-kept secrets of enterprise software and open source alike—a powerful, robust, expertly maintained relational database. MySQL may be better known, but PostgreSQL offers many features MySQL has only started to provide./p pIn this article, I’ll walk through the steps to set up and get running a basic PostgreSQL installation. [...]
Published Wednesday, 04. September 2024 09:00 • 8 days ago

Transaction Isolation Levels in Galera Cluster (from Galera Blog)

By now you must have read our documentation on isolation levels and also our Support for Transaction Isolation Levels. It is worth noting that the default transaction isolation level in MySQL 8 is REPEATABLE READ. Here is a simple example of this, in action (you can test this on two different nodes, even across a […] [...]
Published Wednesday, 04. September 2024 06:54 • 9 days ago

How We Count Faster Than MySQL (from DoltHub Blog)

Dolt is the first version controlled database with Git semantics. We often compare ourselves to MySQL because that was the first wire… [...]
Published Wednesday, 04. September 2024 00:00 • 9 days ago

Tuesday, 03. September 2024

MySQL Inside: Using the PS error_log table for a quick peak! (from MySQL-Med)

Just thought I'd share a script I use daily and helps me redirect my attention if needed. Continue reading → [...]
Published Tuesday, 03. September 2024 18:09 • 9 days ago

Faster MySQL Startup with Many Tables (1M+) (from J-F Gagné's MySQL Blog)

I have been scratching my head about MySQL startup for some time.  There is much to say about this, and many other posts will probably follow.  For now, it is enough to know that with many tables (millions) the startup of MySQL 8.0+ (including 8.0, 8.4 and 9.0) is suboptimal (to say the least).  With very little changes, I was able to speed it up, from 2:39 to 1:09 (one minute and [...]
Published Tuesday, 03. September 2024 15:39 • 9 days ago | Updated Tuesday, 03. September 2024 17:51 • 9 days ago

What are Kubernetes Pods? A Deep Dive (from Percona Database Blog)

♦You might have driven a car, but have you ever wondered how the engine works? Similarly if you have used Kubernetes and if you are interested to know how a pod works, this blog post is the right place to start with. Pods are the smallest deployable units of computing that you can create and […] [...]
Published Tuesday, 03. September 2024 14:15 • 9 days ago

Couchbase Capella gets columnar support on AWS (from InfoWorld)

pNoSQL document-oriented database provider Couchbase is adding columnar support to its managed database-as-a-service (DBaaS), Capella, on AWS./p pHere columnar support refers to the columnar database management system, which is typically NoSQL in nature and is implemented for complex analytical tasks and queries./p pIn contrast to relational databases, columnar database [...]
Published Tuesday, 03. September 2024 13:00 • 9 days ago

An overview of running your databases on and with Kubernetes (from Severalnines Blog)

pWhile Kubernetes (K8s) was originally designed for stateless workloads, advancements over the years, including enhanced support for Persistent Volumes, StatefulSets, and Operators, have made it possible to run stateful applications on Kubernetes.  These new features and Kubernetes’ inherent scalability and resilience have made it an attractive platform for deploying databases. As a resu [...]
Published Tuesday, 03. September 2024 09:00 • 9 days ago

Monday, 02. September 2024

How to migrate a production database to Percona Everest (MySQL) using Clone (from TusaCentral - MySQL Blogs)

pThe aim of this long article is to give you the instructions and tools to migrate your production database, from your current environment to a solution based on Percona Everest (MySQL)./p pNice, you decided to test Percona Everest, and you found that it is the tool you were looking for to manage your private DBaaS. For sure the easiest part will be to run new environments to get better understandi [...]
Published Monday, 02. September 2024 13:47 • 10 days ago

The future of Kubernetes and cloud infrastructure (from InfoWorld)

pFor the past decade, Kubernetes has been the dominant force in cloud-native computing and in enterprise software generally, as cloud providers and their customers have turned toward running their applications and services in clusters of containers instead of in tiers of virtual machines. And yet, the Cloud Native Computing Foundation’s 2023 annual survey (conducted from Augu [...]
Published Monday, 02. September 2024 09:00 • 10 days ago

Saturday, 31. August 2024

Comprehensive Guide for Database Architects: Preventing Deadlocks and Optimizing Transactions in MySQL (from MinervaDB Blog)

pComprehensive Guide for Database Architects: Preventing Deadlocks and Optimizing Transactions in MySQL Deadlocks in MySQL occur when two or more transactions are waiting for each other to release locks, leading to a standstill. For database [...]/p pThe post Comprehensive Guide for Database Architects: Preventing Deadlocks and Optimizing Transactions in MySQL appeared first on The WebScale Databas [...]
Published Saturday, 31. August 2024 18:59 • 12 days ago

MariaDB MaxScale 21.06 now released as GPL (from MariaDB Corporation Blog)

The major new things related to versions and licensing are: MaxScale 21.06, formally known as MaxScale 6.4, is now released … Continued [...]
Published Saturday, 31. August 2024 01:38 • 13 days ago

Friday, 30. August 2024

Intel improving the performance of MariaDB Vector (from MariaDB Foundation Blog)

pAs you have probably seen in earlier posts, the preview version of MariaDB Vector is out and ready for you to play with. We have had input from several different places during the development of this feature. … /p pContinue reading \"Intel improving the performance of MariaDB Vector\"/p pThe post Intel improving the performance of MariaDB Vector appeared first on MariaDB.org./p [...]
Published Friday, 30. August 2024 14:46 • 13 days ago

When Warnings Deceive: The Curious Case of InnoDB’s Row Size Limitation (from Percona Database Blog)

♦Mysterious warning Recently, I was involved in an investigation whose goal was to find out the reason for a warning message like this: [crayon-66e30e584d3f6867663104/] The message looks clear, isn’t it? Well, the problem was that this particular table had not been changed for years, and so no DDL (ALTER) query was involved here. Moreover, there […] [...]
Published Friday, 30. August 2024 14:10 • 13 days ago

Dolt runs on Diesel (from DoltHub Blog)

Hello Rustaceans, welcome to the world of Dolt and Diesel! Dolt is a version controlled database that is a drop-in MySQL replacement. We've… [...]
Published Friday, 30. August 2024 00:00 • 14 days ago

Thursday, 29. August 2024

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

pAmazon Relational Database Service (RDS) for MySQL announces Amazon RDS Extended Support minor version 5.7.44-RDS.20240808. We recommend that you upgrade to this version to fix known security vulnerabilities and bugs in prior versions of MySQL. Learn more about the bug fixes and patches in this version in the Amazon RDS User Guide.br br Amazon RDS Extended Support provides you more time, up to thr [...]
Published Thursday, 29. August 2024 21:50 • 14 days ago

Troubleshooting MySQL HeatWave Via The Error Log Table And Audit Log (from The Oracle MySQL Blog)

This post will explain how to troubleshoot MySQL HeatWave by accessing information in the MySQL error log table and the HeatWave audit log. [...]
Published Thursday, 29. August 2024 20:45 • 14 days ago

MariaDB Server is “main” by default (from MariaDB Foundation Blog)

pWe recently had a public vote on whether “main” or a version branch should be the default. The results in favour of “main” were very clear. … /p pContinue reading \"MariaDB Server is “main” by default\"/p pThe post MariaDB Server is “main” by default appeared first on MariaDB.org./p [...]
Published Thursday, 29. August 2024 10:43 • 14 days ago

MariaDB ServerFest Berlin 17 Sep 2024 (from MariaDB Foundation Blog)

pCome join us in Berlin, on Tue 17 Sep 2024! It’s time for our next MariaDB Server Fest, which we invite you to enjoy in person or virtually. … /p pContinue reading \"MariaDB ServerFest Berlin 17 Sep 2024\"/p pThe post MariaDB ServerFest Berlin 17 Sep 2024 appeared first on MariaDB.org./p [...]
Published Thursday, 29. August 2024 07:34 • 15 days ago

Extending MySQL Shell with Plugins (from The Oracle MySQL Blog)

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss how we can add custom functionality to MySQL Shell using startup scripts. [...]
Published Thursday, 29. August 2024 04:00 • 15 days ago

Anatomy of a Throttler, part 1 (from PlanetScale Blog)

Learn about some design considerations for implementing a database throttler. [...]
Published Thursday, 29. August 2024 00:00 • 15 days ago

Wednesday, 28. August 2024

How to determine whether a MySQL server is an LTS release (from The Oracle MySQL Blog)

This blog post will explain how to tell whether a given MySQL server is an LTS release or not. The features described are implemented in MySQL 8.4.0 (the mysql_upgrade_history file) and 8.4.1 (the INFO_SRC extension). The features are available in on-premise as well as cloud releases. [...]
Published Wednesday, 28. August 2024 11:23 • 15 days ago

Playing with MariaDB Vector for initial AI tests (from Shinguz's Blog)

pArtificial intelligence (AI) and vector databases are on everyone's lips these days. Since MariaDB will soon be coming onto the market with vector database functionality, as a database consultant I thought it was about time I got to grips with the subject so that I have at least a hint of what it's all about.../p pSince I'm not so much of a theoretician but rather like to do something practical, [...]
Published Wednesday, 28. August 2024 08:51 • 15 days ago

Dolt for Data Engineers (from DoltHub Blog)

Dolt is MySQL-compatible. When data engineers hear "MySQL", they think "this is not for me". Data engineers work with "Big Data" in… [...]
Published Wednesday, 28. August 2024 00:00 • 16 days ago

Tuesday, 27. August 2024

MariaDB C++ Connector 1.1.5 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/C++ 1.1.5 release. Download Now Release Notes MariaDB Connector/C++ … Continued [...]
Published Tuesday, 27. August 2024 17:53 • 16 days ago

MySQL Router quick’n’simple troubleshooting (from MySQL-Med)

MySQL Router monitoring: Something to get you started... Continue reading → [...]
Published Tuesday, 27. August 2024 16:30 • 16 days ago

Important Notice: Update Process for Percona Monitoring and Management 2.38 and Earlier (from Percona Database Blog)

♦We’ve received numerous reports about issues occurring with Percona Monitoring and Management (PMM) when updating to the latest version (currently 2.42.0), or updating to any version from an old version (2.37.1 and before) using the update button on the UI.  Symptoms PMM won’t show any notifications on the UI about new available versions if: You’ve […] [...]
Published Tuesday, 27. August 2024 13:21 • 16 days ago

Releasing ProxySQL v2.6.4! (from ProxySQL Blog)

pAnnouncing the Release of ProxySQL Version 2.6.4! We are excited to announce the release of ProxySQL v2.6.4, the latest stable version of our high-performance, high-availability, protocol-aware proxy for MySQL. Available under the GNU GPL v3.0 license, ProxySQL is designed to enhance MySQL performance, scalability, and reliability. You can download ProxySQL from our official repository [...]/p pTh [...]
Published Tuesday, 27. August 2024 12:38 • 16 days ago

Enhancing Index Support (from DoltHub Blog)

We're continuing to make progress on DoltgreSQL, which is a version of Dolt built to be a drop-in replacement for PostgreSQL. For those that… [...]
Published Tuesday, 27. August 2024 00:00 • 17 days ago

Vitess User Survey (from Vitess)

We recently conducted a survey of how Vitess is being used by the community. This blog post summarizes what we learned. "Vitess solves an existential threat for services which outgrow a single MySQL database." "Horizontal sharding helps us scale quickly, and the new generation execution plan, Gen4, enables us to support more SQL queries." "Vitess has allowed us to scale and [...]
Published Tuesday, 27. August 2024 00:00 • 17 days ago

Monday, 26. August 2024

HeatWave Sessions Featuring Customers at Oracle ClouldWorld (from The Oracle MySQL Blog)

At Oracle CloudWorld, several HeatWave sessions feature customers who will share their experience using HeatWave MySQL, HeatWave GenAI, HeatWave AutoML, or running HeatWave on AWS. Check out the sessions and add them to your schedule. [...]
Published Monday, 26. August 2024 19:49 • 17 days ago

MariaDB ODBC Connector 3.2.3 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/ODBC 3.2.3 release. Download Now Release Notes MariaDB Connector/ODBC … Continued [...]
Published Monday, 26. August 2024 15:53 • 17 days ago

Percona Server for MySQL Performance Improvements – August 2024 (from Percona Database Blog)

♦At Percona, we have always prioritized database performance as a critical factor in selecting database technologies. Recently, we have observed a concerning trend in the community edition of MySQL, where performance appears to be declining across major releases, specifically MySQL versions 5.7, 8.0, and 8.4. If you’re interested in learning more about these observations, we […] [...]
Published Monday, 26. August 2024 14:59 • 17 days ago

Welcome MySQL 9.0, a review of Oracle's stewardship in 8.0 (from The Oracle MySQL Blog)

Stewardship of a community is easy for new and emerging technology. After 29 years, MySQL has become one of the most-used and trusted open-source databases by millions of users worldwide. [...]
Published Monday, 26. August 2024 07:51 • 18 days ago

Sunday, 25. August 2024

The Ultimate Guide to Database Proxies: What They Are and Why You Need One (from ProxySQL Blog)

pThe internet surrounds us in today’s digital world, so much so that not a single task is complete without a simple Google search. We lean on the internet for various tasks, from looking for a simple recipe to researching a highly technical topic you may be writing about. But do you know how these [...]/p pThe post The Ultimate Guide to Database Proxies: What They Are and Why You Need One appeared [...]
Published Sunday, 25. August 2024 09:30 • 18 days ago

Friday, 23. August 2024

Minimizing Performance Impact: Best Practices for PostgreSQL Tracing and Monitoring (from MinervaDB Blog)

pWhen tracing or monitoring tools are enabled in PostgreSQL, it can introduce some overhead and potentially slow down database performance. This is because tracing mechanisms such as logging, detailed monitoring, or execution profiling require additional [...]/p pThe post Minimizing Performance Impact: Best Practices for PostgreSQL Tracing and Monitoring appeared first on The WebScale Database Infr [...]
Published Friday, 23. August 2024 19:03 • 20 days ago

Extending MySQL Shell with Startup Scripts (from The Oracle MySQL Blog)

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss how we can add custom functionality to MySQL Shell using startup scripts. [...]
Published Friday, 23. August 2024 16:07 • 20 days ago

Start And Stop Your MySQL HeatWave And Compute Instances From The Command Line Using Oracle's Command Line Interface (from The Oracle MySQL Blog)

This post will explain how you can start and stop your MySQL Heatwave and compute instances from the command line using Oracle's Command Line Interface tool. [...]
Published Friday, 23. August 2024 14:20 • 20 days ago

A README for my MySQL development tooling (from Laurynas Biveinis' blog)

pOver the years I have written and borrowed various bits of scripts and configuration files to make MySQL development easier by configuring and automating things. Having written patch2testlist a few months ago, I figured that now I have at least one thing that should work not only on my machine. Thus I put together a README for MySQL-related stuff in my dotfiles, also included below./p My MySQL Dev [...]
Published Friday, 23. August 2024 13:01 • 20 days ago | Updated Friday, 23. August 2024 13:01 • 20 days ago

Vitess Now Supports Recursive CTEs: A Step Closer to Full MySQL Compatibility (from Vitess)

We are excited to announce that Vitess now supports recursive Common Table Expressions (CTEs), marking another significant step in our journey to fully align with MySQL’s capabilities. Recursive CTEs, often a critical feature for complex query handling, allow for the execution of recursive queries within a single CTE. This addition brings more flexibility and power to developers using Vitess, espec [...]
Published Friday, 23. August 2024 00:00 • 21 days ago

Thursday, 22. August 2024

How to partition tables with foreign keys in MySQL HeatWave (with a Work-Around) (from The Oracle MySQL Blog)

A work-around for partitioning MySQL tables with foreign keys is described in this article. [...]
Published Thursday, 22. August 2024 20:09 • 21 days ago

16 Best MySQL GUI Clients for macOS (from Devart MySQL Tool Blog)

pTake a look at the most convenient and user-friendly MySQL GUI tools (clients) that help you tackle a variety of database development, management, and administration tasks on macOS./p pThe post 16 Best MySQL GUI Clients for macOS appeared first on Devart Blog./p [...]
Published Thursday, 22. August 2024 17:28 • 21 days ago

Migrating from AWS QLDB to Dolt: a sorta example (from DoltHub Blog)

Recently AWS announced that it was deprecating the Quantum Ledger Database (QLDB) service by July 2025, and provided a guide for existing… [...]
Published Thursday, 22. August 2024 00:00 • 22 days ago

Wednesday, 21. August 2024

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

pWe're excited 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 August 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 ever [...]
Published Wednesday, 21. August 2024 19:14 • 22 days ago

MySQL Telemetry Metrics with OCI Monitoring Metrics Exporter (from The Oracle MySQL Blog)

OpenTelemetry Metrics provided by MySQL Telemetry provides insight into the performance, behavior, and health of your MySQL database - exposing up to 400 unique MySQL internal metrics [...]
Published Wednesday, 21. August 2024 17:37 • 22 days ago

How To Use The Oracle Cloud Shell To Access MySQL HeatWave (from The Oracle MySQL Blog)

This is a quick guide on how to use the Oracle Cloud Shell on the Oracle Cloud Infrastructure console to access MySQL HeatWave via MySQL Shell. [...]
Published Wednesday, 21. August 2024 14:26 • 22 days ago

MySQL Upcoming Meetups Worldwide (from The Oracle MySQL Blog)

MySQL Metups, Sep-Nov 2024 [...]
Published Wednesday, 21. August 2024 12:00 • 22 days ago

Announcing Hosted Dolt Private Deployments (from DoltHub Blog)

Almost a month ago, we announced that Private Deployments were on their way. With the final development and testing completed, we're excited… [...]
Published Wednesday, 21. August 2024 00:00 • 23 days ago

Tuesday, 20. August 2024

Quick And Easy Guide For Getting Started With HeatWave GenAI on Oracle Cloud Infrastructure (from The Oracle MySQL Blog)

The following post shows you how easy it is to get started using HeatWave GenAI. [...]
Published Tuesday, 20. August 2024 18:31 • 23 days ago

Oracle ClouldWorld Keynote: Build Generative AI Applications—Integrated and Automated with HeatWave GenAI (from The Oracle MySQL Blog)

At Oracle CloudWorld, Oracle’s Chief Corporate Architect Edward Screven will present a solution keynote entitled “Build Generative AI Applications—Integrated and Automated with HeatWave GenAI”. Attend the keynote to understand how HeatWave GenAI can help you reduce application complexity, improve data security, increase performance, and lower costs. [...]
Published Tuesday, 20. August 2024 16:17 • 23 days ago

How to Run Percona Toolkit in Kubernetes (from Percona Database Blog)

♦Percona Operator for MySQL, based on Percona XtraDB Cluster (PXC), provides configuration to expose the ProxySQL, HAProxy, and the PXC instances themselves so that you can use Percona Toolkit to connect to MySQL from these endpoints externally. However, you can also create Kubernetes pods to run Percona Toolkit operations there instead if you do not […] [...]
Published Tuesday, 20. August 2024 14:54 • 23 days ago

MySQL INT (INTEGER) Data Types with Different Examples (from Devart MySQL Tool Blog)

pThis article explains the SIGNED and UNSIGNED integer data types in MySQL and provides examples to illustrate when and how to use these integer data types effectively./p pThe post MySQL INT (INTEGER) Data Types with Different Examples appeared first on Devart Blog./p [...]
Published Tuesday, 20. August 2024 13:24 • 23 days ago

DoltHub On The Road (from DoltHub Blog)

"I was surprised, as always, by how easy the act of leaving was, and how good it felt. The world was suddenly rich with possibility… [...]
Published Tuesday, 20. August 2024 00:00 • 24 days ago