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, 05. October 2024

MySQL to Amazon Redshift Replication. (from Mydbops Blog)

In our work, We used to get a lot of requirements for replicating data from one data source to another. Our team provided solutions to replicate data from MySQL to Vertica, Amazon Redshift, Hadoop. Ou [...]

Open Source is in Our DNA: Reaffirming TiDB’s Commitment (from PingCAP Blog)

pWhen we first set out to build TiDB, we didn’t just want to create another database—we wanted to build a community-driven, open-source project that developers worldwide could trust and contribute to. From day one, TiDB has been an open-source project under the Apache 2.0 license, and it remains so today. Open source isn’t just a […]/p pThe post Open Source is in Our DNA: Reaffirming TiDB’s C [...]

Friday, 04. October 2024

How to tune Linux Threads for MongoDB IOPS Performance? (from MinervaDB Blog)

pHow to tune Linux Threads for MongoDB IOPS Performance? To optimize Linux threads for enhanced MongoDB IOPS performance, it is crucial to implement a comprehensive and meticulously crafted tuning strategy. This approach encompasses a series [...]/p pThe post How to tune Linux Threads for MongoDB IOPS Performance? appeared first on The WebScale Database Infrastructure Operations Experts in PostgreS [...]

Quick guide: Setting up HeatWave MySQL alarms and notifications in minutes (from The Oracle MySQL Blog)

The alarm definitions feature eases the process of creating and managing alarms to monitor HeatWave MySQL DB Systems. It enables you to create Oracle-recommended alarms by making use of the standardized set of rules and thresholds, across multiple databases. [...]

Early design choices for RonDB and InnoDB (from Mikael Ronstrom)

p I have had many interesting discussions with Zhao Song about RonDB and its internals. Since both Zhao and myself also worked on MySQL/InnoDB features as well, it becomes natural that we sometimes compare the features of RonDB  with the features in InnoDB./ppIn this blog I will discuss what is the basis for the very different solutions that we have in RonDB compared to what we find in In [...]

Galera Cluster for MySQL Helm Chart for Kubernetes (from Galera Blog)

Codership, the makers of Galera Cluster, are pleased to announce the availability of Helm charts for Galera Cluster for MySQL 8.0.39. It is available on our GitHub releases page, for convenience. You are encouraged to send feature requests at our GitHub issues. Helm charts help you manage your Kubernetes applications, to install and upgrade any […] [...]

Securing MySQL Connections with SSL/TLS Encryption (from Mydbops Blog)

Author: Maha Lakshmi MySQL, revered as one of the world's most popular open-source relational database systems, takes the responsibility of safeguarding sensitive data seriously. It accomplishes this [...]

Hack MySQL: Create an Extremely Sparse InnoDB Table (B+Tree) (from Zhao Song's Blog)

1. Experiment By running this script, you can generate an extremely sparse B+Tree in an InnoDB table with just simple INSERT statements: ``` #!/bin/bash Define the MySQL command path MYSQL_CMD=”/PATH/TO/mysql -h127.0.0.1 -P3306 -uroot” [...]

Thursday, 03. October 2024

Using MariaDB MaxScale for Schema Sharding With Galera (from MariaDB Corporation Blog)

Schema Sharding is a useful means of distributing the load over multiple MariaDB Enterprise Server instances when you have multiple … Continued [...]

Generating Flexible Random data in MySQL (from Mydbops Blog)

Benchmarking MySQL compression methods often requires a realistic dataset that mimics real-world production workloads. I was about to benchmark the various compression methods in MySQL ( Via Engines ) [...]

Awards and Endorsements Recap: Discover the Best dbForge Products of Q2 and Q3 2024 (from Devart MySQL Tool Blog)

pThroughout the second and third quarters of 2024, the Devart team achieved multiple awards for the dbForge product line, winning gold and silver for the DBTA Readers’ Choice Awards 2024 nominations, as well as getting badges from Crozdesk, Sourceforge, G2, and SoftwareSuggest listings.  Let's check them out./p pThe post Awards and Endorsements Recap: Discover the Best dbForge Products of Q2 and Q3 [...]

Wednesday, 02. October 2024

Announcing Tungsten Cluster & Tungsten Replicator v7.1.4 (from Continuent Blog)

Explore the latest release of Tungsten Clustering & Tungsten Replicator! This new version v7.1.4 brings critical improvements, new features, and bug fixes, ensuring enhanced performance, stability, and functionality for your database management.Tags: tungsten clusteringtungsten replicatorMySQLMariaDBreleases [...]

MySQL Upcoming Meetups Worldwide (from The Oracle MySQL Blog)

MySQL Metups, Sep-Nov 2024 [...]

Exploring Aurora serverlessV2 for MySQL Part 2 – Migration (from Mydbops Blog)

Author: Kabilesh P R Greetings everyone!!!!! Let’s begin the phase II of our blog on Aurora serverless-V2. Part 1 – www.mydbops.com/blog/exploring-aurora-serverless-v2-for-mysql/ Here, I h [...]

Tuesday, 01. October 2024

Transition from VNET integration to public access or Private Link using the Azure CLI (from Azure for MySQL Blog)

pYou can transition an Azure Database for MySQL flexible server from using VNET integration (Private Access) to using Public Access or Private Link seamlessly, without the need to alter the server name or migrate data, which simplifies the process for customers. However, after you make the transition, you cannot reverse it. The transition involves approximately 5-10 minutes of downtime fo [...]

Optimizing PostgreSQL Failover in AWS Using Elastic IPs and DNS Route Failover (from MinervaDB Blog)

pOptimizing PostgreSQL Failover in AWS Using Elastic IPs and DNS Route Failover Utilizing Elastic IPs and DNS Route Failover for PostgreSQL in AWS When deploying PostgreSQL in AWS, one effective approach to ensure high availability [...]/p pThe post Optimizing PostgreSQL Failover in AWS Using Elastic IPs and DNS Route Failover appeared first on The WebScale Database Infrastructure Operations Expert [...]

Dumpling – Logical backup tool for TiDB (from Mydbops Blog)

TiDB, developed by PingCAP, stands out as a distributed SQL database known for its exceptional scalability and strong consistency. To harness its full potential, effective data export tools are essent [...]

Monday, 30. September 2024

Amazon Aurora MySQL now supports RDS Data API (from AWS What's New)

pAmazon Aurora MySQL-Compatible Edition now supports a redesigned RDS Data API for Aurora Serverless v2 and Aurora provisioned database instances. You can now access these Aurora clusters via a secure HTTP endpoint and run SQL statements without the use of database drivers and without managing connections. This follows the launch of Data API for Amazon Aurora PostgreSQL-Compatible Edition for Auror [...]

ProxySQL Expands Database Support to PostgreSQL in Version 3.0.0-Alpha (from ProxySQL Blog)

pThe reigning champion of MySQL proxies, ProxySQL, has set its sights to conquer new territory. Today marks the dawn of a new era as ProxySQL unveils its 3.0.0-Alpha release, bringing PostgreSQL - the darling of developers, and the titan of open source databases - under its formidable umbrella. A Game Changing Expansion Long respected [...]/p pThe post ProxySQL Expands Database Support to PostgreSQ [...]

Announcing the first MariaDB Hackathon – in India! (from MariaDB Foundation Blog)

pOn the 24th – 25th October 2024 we will be hosting our first-ever Hackathon as part of our larger MariaDB Foundation presence around Open Source India. … /p pContinue reading \"Announcing the first MariaDB Hackathon – in India!\"/p pThe post Announcing the first MariaDB Hackathon – in India! appeared first on MariaDB.org./p [...]

Crescendo makes AI boring—and profitable (from InfoWorld)

pThere’s money in AI, but not where you think. Sure, Nvidia and the clouds are cleaning up, but they’re primarily selling to enterprises that are mostly kicking tires, not running mission-critical AI applications. Some, like the Financial Times, suggest that AI startups are cleaning up but, again, this could simply be a matter of reselling GPUs, as Chris Gaun points out./p [...]

Friday, 27. September 2024

Troubleshoot Amazon RDS for MySQL and Amazon RDS for MariaDB Errors (from AWS Database Blog)

In this post, we discuss MySQL or MariaDB errors seen in error logs and application logs related to database, their possible root cause and how to effectively troubleshoot them on Amazon Relational Database Service(Amazon RDS) for MySQL or Amazon Relational Database Service(Amazon RDS) for MariaDB. [...]

InnoDB code bloat in MySQL 8.0 makes me sad (from Small Datum)

pInnoDB uses a lot more CPU per query in MySQL 8.0 which makes it a lot slower for low-concurrency workloads that are CPU-bound. That is offset by improvements which reduce mutex contention which means it might not be slower for high-concurrency workloads?brbrIt would be great to get the reduction in mutex contention without the increase in CPU overhead. Alas, I don't think that is ever going to ha [...]

MariaDB Replication – slave_parallel_mode Difference (from Shattered Silicon OSDB Blog)

pMariaDB's optimistic parallel replication doesn't often make a significant difference over conservative, but in some cases the improvement can be huge./p pThe post MariaDB Replication – slave_parallel_mode Difference appeared first on Shattered Silicon./p [...]

Celebrating the TiDB Future App Hackathon 2024 (from PingCAP Blog)

pDuring the recent HTAP Summit, I had the honor of celebrating another successful TiDB Future App Hackathon and announcing our winners. This year, we had close to 2,100 participants–about 40% increase from 2023–joining us from 80+ countries. If you visit the Hackathon project gallery, you will be able to see the winners and all other […]/p pThe post Celebrating the TiDB Future App Hackathon 2 [...]

How to Restore a MySQL Database with Command Line or Restore Tools (from Devart MySQL Tool Blog)

pThe article gives a deep insight into how to restore MySQL database from a backup file using the mysqldump utility and third-party backup and restore tools, such as dbForge Studio for MySQL, MySQL Workbench, and phpMyAdmin.   Contents There may be situations when data gets lost or corrupted, for example, when users accidentally deleted or […]/p pThe post How to Restore a MySQL Database [...]

Thursday, 26. September 2024

MariaDB ColumnStore SQL limitations (from Vettabase)

MariaDB ColumnStore is an extremely fast and scalable solution for analytics built on MariaDB, which Vettabase supports. MariaDB ColumnStore inherits the MariaDB SQL dialect, and many MariaDB features. However, numerous MariaDB features are not available for the ColumnStore storage engine. In some cases the reason is that they don’t apply to a columnar storage. Some features were not yet impl [...]

Clustercontrol adds Valkey in latest release (from Severalnines Blog)

pClustercontrol (CC) v2.2.0 is now live, offering a new Redis alternative in response to recent licensing changes, along with improved support for MariaDB 11.4 and Ubuntu 24.04. Let’s explore the key updates and see what’s new in Clustercontrol v2.2.0! Redis shifts to source-available licensing Beginning with v7.4, Redis will adopt a dual-licensing model under the […]/p pThe post Clustercontr [...]

How to Enable, Configure, and Use MySQL Query Logging (from Devart MySQL Tool Blog)

pIn this article, we will address questions such as the purpose of query logging in MySQL, why it is important, how to enable and configure it, and more. You’ll find a detailed guide on how to use mysqldumpslow to analyze slow query logs, along with tips on harnessing convenient GUI tools like dbForge Studio for MySQL to your advantage./p pThe post How to Enable, Configure, and Use MySQL Query Logg [...]

Wednesday, 25. September 2024

Time to Empower Yourself With the Newly Updated dbForge Tools for MySQL 10.1 (from Devart MySQL Tool Blog)

pThere's nothing quite like delivering regular feature-packed updates to our dear users—and we've got one for you today. dbForge tools for MySQL have been updated to version 10.1 with extended connectivity and quite a few new tricks to make your work easier and faster. To top it off, you get convenient CLI-powered generation of comparison reports./p pThe post Time to Empower Yourself With the Newly [...]

Intro to Node’s built-in SQLite module (from InfoWorld)

pNode 22.5.0 now bundles SQLite, a lightweight, in-process relational database that requires no additional infrastructure but packs considerable capability. Let’s get to know this handy new built-in feature in Node.js./p What is SQLite? pRelational databases are a key component of the software landscape. SQLite is a simple but versatile implementation with a variety of [...]

Configuration options that make writes faster or slower with MySQL and Postgres (from Small Datum)

pThis post is inspired by a comment about a recent blog post I shared. While I don't focus on MySQL vs Postgres comparisons, sometimes I share them and in my benchmarks with CPU-bound workloads, and fsync disabled (even more CPU-bound) the general result was that insert throughput was much better with Postgres than MySQL+InnoDB.brbrThe commenter stated that Postgres and MySQL+InnoDB get similar ins [...]

The size of the mysqld binary as a proxy for innovation (from Small Datum)

pI have been documenting performance regressions over time in MySQL. The regressions mean that some workloads get less throughput because the server uses more CPU per SQL operation. From perf stat I see there is more instruction cache and TLB activity per query. I also see that it takes more instructions per query. A recent blog post from me has more details.brbrThis is bloat if you are a pess [...]

Deep Dive into MySQL - Transaction lock - PART 2 (from Zhao Song's Blog)

In my previous blog post, I introduced MySQL’s transaction locking implementation, focusing on InnoDB’s locking process during an INSERT operation. This post will cover the locking processes for SELECT... FOR SHARE/UPDATE, UPDATE, and DELETE operations in InnoDB. [...]

Tuesday, 24. September 2024

MariaDB 11.7.0 preview release available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 11.7.0, a preview of the MariaDB 11.7 series. MariaDB 11.7 will be a rolling release. … /p pContinue reading \"MariaDB 11.7.0 preview release available\"/p pThe post MariaDB 11.7.0 preview release available appeared first on MariaDB.org./p [...]

Prevent and Detect Rapid Fire Password Attacks on MySQL (from The Oracle MySQL Blog)

Using “failed login” policies, dbas can prevent brute force rapid fire attacks on MySQL user’s passwords. This uses a technique know as “login throttling”. This method affectively thwarts these “rapid fire” login attempt attacks by increasing delays for each failed attempt. These policies are simple and straightforward to put in place and define. Enabling defense and detection of rapid fire and o [...]

Monday, 23. September 2024

Why do table scans get slower with MySQL from 5.6 to 8.0? (from Small Datum)

pAs I search to explain why MySQL is getting (too much) slower over time I collect a lot of data from many servers and then get overwhelmed trying to summarize it. Here I focus on one microbenchmark (table scan) on one server (ax162-s from Hetzner) using upstream MySQL with InnoDB and FB MyRocks.brbrWhile my primary goal is to explain the regressions in MyRocks, many of them are inherited from upst [...]

Understanding MySQL Indexes: Types, Benefits, and Best Practices (from Percona Database Blog)

♦When it comes to MySQL databases, performance is everything. As more activities move online and data volumes grow exponentially, ensuring efficient data retrieval and query execution becomes crucial. Database indexing plays a significant role in this by providing powerful tools to optimize operations in MySQL. Without an index, MySQL must perform a full table scan, […] [...]

Troubleshooting MySQL: Encryption can’t find Master Key (from Kedar MySQL Blog)

pIf you’ve encountered the “Encryption can’t find master key” error while starting MySQL, you’re likely facing issues with the keyring plugin. I recently faced a similar issue on my server,…/p The post Troubleshooting MySQL: Encryption can’t find Master Key first appeared on Change Is Inevitable. [...]

Get started with HeatWave (from The Oracle MySQL Blog)

Get started with HeatWave [...]

JSON Showdown: Dolt vs Postgres (from DoltHub Blog)

Dolt is the first truly version controlled database. It's "Git, but for SQL data." But it's not just Git for SQL data. The same techniques… [...]

Sunday, 22. September 2024

Query Optimisation Effect – Before and After (from Shattered Silicon OSDB Blog)

pOptimising even just one single query on a poorly performing database system can sometimes have a big overall impact. Here we explore a client success story arising from optimising just one query on a client's system./p pThe post Query Optimisation Effect – Before and After appeared first on Shattered Silicon./p [...]

How to Reduce MariaDB / MySQL Storage Costs by 4x (from Shattered Silicon OSDB Blog)

pHow to reduce InnoDB storage costs for MySQL or MariaDB by 4x without major re-architecting of database structures./p pThe post How to Reduce MariaDB / MySQL Storage Costs by 4x appeared first on Shattered Silicon./p [...]

Saturday, 21. September 2024

Sailing Through Three Decades of Database Administration: Lessons in Resilience and Innovation (from AskDba)

Databases are the backbone of every data-driven application, a crucial element that fuels everything from simple web apps to complex enterprise systems. For over three decades, I have navigated the tumultuous waters of database administration, balancing technical intricacies with the often challenging dynamics of workplaces. My journey is not just one of keeping systems running […] [...]

Friday, 20. September 2024

Ubuntu 22.04, Linux kernels and me (from Small Datum)

pThis is a summary of interesting performance issues I have had with the HWE kernels (6.5.x) on Ubuntu 22.04, mostly this year. This is mostly a note to my future self./pp/pulliUse ext4 instead of XFS/liulliI have used XFS since pre-2010 because it avoided a few perf problems that show up in the ext family. But I finally found a reason to switch to ext4. The problem is that with 6.5 kernels (when H [...]

Scaling to the Cloud: TiDB Serverless vs. PlanetScale (from PingCAP Blog)

pToday, it’s normal for apps to be available at any time of day, no matter where you are in the world. But to meet that expectation, you need to make sure your infrastructure can scale to match demand, work around failure, and maintain consistent performance. The good news is that several database platforms promise to […]/p pThe post Scaling to the Cloud: TiDB Serverless vs. PlanetScale appea [...]

Getting Started: Flutter and Dolt (from DoltHub Blog)

We're on a mission to show that Dolt works with all your favorite tools in all your favorite languages. Today we show you how to build a… [...]

Deep Dive into MySQL - Transaction lock - PART 1 (from Zhao Song's Blog)

I plan to start writing a series of MySQL blogs that will dive deep into MySQL’s design and implementation from the perspective of its underlying code. The prefix of this series will be called “Deep Dive into MySQL.” Through this series, I aim to review and organize my knowledges of MySQL implementation through blogging, while also helping those who want to know about and understand the inner worki [...]

Thursday, 19. September 2024

Dolt SQL Shell (from DoltHub Blog)

Dolt is a SQL Database which allows for the full branching and merging of tabular data. Being SQL based, we can interoperate with many… [...]

Wednesday, 18. September 2024

Tuning Out MariaDB’s Furious Flushing in 10.5+ (from Shattered Silicon OSDB Blog)

pHow to tune out furious flushing of the redo log and sawtooth pattern checkpoint age on MariaDB 10.5+ and achieve smooth performance./p pThe post Tuning Out MariaDB’s Furious Flushing in 10.5+ appeared first on Shattered Silicon./p [...]

DBA’s Inconceivable Tales: The Optimizer Anomaly (from Shattered Silicon OSDB Blog)

pOne of our MySQL support engineers encountered a peculiar problem during work on a data migration for a client that was moving their membership survey system from MariaDB 10.3 to MySQL 8. A query that returned data in 5ms on MariaDB 10.3 was going away for minutes on MySQL 8. The query itself didn’t look […]/p pThe post DBA’s Inconceivable Tales: The Optimizer Anomaly appeared fi [...]

Updated MariaDB R2DBC and Node.js Connectors now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Connector/R2DBC 1.2.2, and Connector/Node.js 3.3.2. Download Now Release Notes and … Continued [...]

Taking Galera Cluster Enterprise Edition (EE) Non-Blocking Operations (NBO) for a spin (from Galera Blog)

Galera Cluster Enterprise Edition (EE) has had support for Non-Blocking Operations (NBO) schema upgradesever since the first release of Galera Cluster Enterprise Edition (EE). It is reasonably well documented, and we think more people will benefit from using it, of course. Schema changes tend to always remain a daunting task when you have large databases […] [...]

Top 10 Ways to Optimize MySQL Performance with ProxySQL (from ProxySQL Blog)

pMySQL is a widely used database management tool; however, as your application grows, maintaining optimal performance may become more challenging.  Thankfully, ProxySQL provides many features that can help optimize MySQL performance and functions as a high-performance MySQL proxy. Let us understand the scope of improvement and how you can optimize MySQL performance using the [...]/p pThe post Top 1 [...]

Oracle CloudWorld 2024: 10 key takeaways from the big annual event (from InfoWorld)

pAs competition heats up among cloud service providers, especially on the generative AI front, Oracle is focusing its energies on providing IT infrastructure that can help developers and enterprises take advantage of generative AI in their operations./p pShifting gears from his standpoint last year, Oracle Chairman and CTO Larry Ellison took to the stage last week to unvei [...]

So you Want Database Branches? (from DoltHub Blog)

Here at DoltHub, we've published a series of "So you want..." articles to help people find Dolt, the world's first version controlled SQL… [...]

Tuesday, 17. September 2024

Azure Database for MySQL - August 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 September 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 e [...]

Learn how Presence migrated off a monolithic Amazon RDS for MySQL instance, with near-zero downtime, using replication filters (from AWS Database Blog)

Presence is a leading provider of live therapy and evaluation services for PreK-12 schools throughout the United States. Amazon RDS for MySQL has been a core part of Presence’s data architecture for many years. Presence used RDS read replicas, with replication filtering, to migrate applications from their centralized RDS for MySQL DB instance to dedicated DB instances. This approach allowed them to [...]

MySQL 8.0 vs. 5.7: Are the Newer Versions More Problematic? (from Percona Database Blog)

♦There has been much discussion recently about the stability and performance of the latest MySQL releases. Many database professionals are voicing concerns, especially after encountering several issues in the newer versions. Issues with MySQL 8.0.38 Let’s start with some important news from Marco Tusa. In one of his blog posts, Marco strongly advised against upgrading […] [...]

Monday, 16. September 2024

Understanding ProxySQL: The Ultimate Database Proxy Solution (from ProxySQL Blog)

pAre you tired of MySQL bottlenecks slowing down your application? Then, it's time your organization uses a database proxy.  ProxySQL is a high-performance open-source SQL proxy that is important in optimizing MySQL-based database infrastructures. It acts as a mediator between database clients and servers and offers a comprehensive suite of features that enhance performance, [...]/p pThe post Under [...]

Announcing the MySQL Implementation Oracle Certified Associate Exam (from The Oracle MySQL Blog)

MySQL Implementation Oracle Certified Associate Exam [...]

Introducing RHEL9-Certified Builds for Percona MySQL: Ensure Maximum Compatibility and Compliance (from Percona Database Blog)

♦Historically, Percona has been providing our customers with enterprise-grade solutions for MySQL that meet the highest standards of compatibility and compliance. To follow this commitment, Percona now offers RHEL9-certified builds for the users of Percona software for MySQL. These builds have been rigorously tested and are available as rpm packages, ensuring seamless integration with your [… [...]

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

pOracle CloudWorld is one of the tech industry’s signature events. The event, known as Oracle OpenWorld until 2020, is a significant gathering for IT professionals, developers, and business leaders looking to explore the latest advancements in cloud computing. /p pOracle CloudWorld 2024 began September 9th and ended September 12th. As expected, Oracle Chairman and CTO Larr [...]

Sunday, 15. September 2024

Using User-Level Locks in InnoDB to Prevent Deadlocks and Improve Performance (from MinervaDB Blog)

pUsing User-Level Locks in InnoDB to Prevent Deadlocks and Improve Performance User-level locks in InnoDB provide a mechanism for application-level synchronization, allowing developers to manually control locks within their MySQL transactions. These locks are managed [...]/p pThe post Using User-Level Locks in InnoDB to Prevent Deadlocks and Improve Performance appeared first on The WebScale Databa [...]

Saturday, 14. September 2024

MySQL and Postgres vs the Insert Benchmark on a large server (from Small Datum)

pThis has benchmark results for MySQL and Postgres vs the Insert Benchmark on a large server. My intent is to document how performance changes over time more so than start a Postgres vs MySQL argument./ppMySQL has accumulated large regressions from 5.6 to 8.0 that are obvious on low-concurrency benchmarks. While they are less obvious on high-concurrency benchmarks, and there have been significant i [...]

Friday, 13. September 2024

All UUID Functions in Percona Server for MySQL: RFC 9562 Implemented (from Percona Database Blog)

♦The release of Percona Server for MySQL 8.4.0 includes the new UUID_VX component, which implements UUID versions 1, 3, 4, 5, 6, and 7 according to recently published RFC 9562. UUIDs (Universally Unique Identifiers) are unique identifiers that can be generated independently without a central authority or coordination with other parties. Unlike sequential integer identifiers, which […] [...]

How to do HeatWave Audit Archive and dump to Object Storage (from The Oracle MySQL Blog)

Sharing an example of how to do audit log archiving to table and thereafter to dump the archived table to Object Storage using MySQL Shell utility [...]

Creating and Connecting to A HeatWave MySQL Always Free Instance (from The Oracle MySQL Blog)

The 'Always Free' tier of Oracle Cloud has a new offering - HeatWave MySQL. In this post, we will discuss how to spin up a new always-free HeatWave MySQL instance and connect to it via an alway-free compute instance. [...]

What’s in the cards for MariaDB? (from InfoWorld)

pK1 Investment Management, the new owner of MariaDB, sent a strong hint about what its future plans for the company may entail with the appointment of Rohit de Souza as the organization’s new CEO. While he now has the challenge of overseeing product development, of note is what his specialty was in the past./p pAccording to his LinkedIn profile, de Souza’s last three jobs [...]

HTAP benchmarks: trying out HATrick with MySQL (from Small Datum)

pFor a few years I have only used sysbench and the Insert Benchmark for work but now I need an HTAP benchmark. There are several to choose from but I will start with HATrick. The source is here. It uses C++ and ODBC. I prefer Java (and JDBC), golang or Python but lets see how this goes.brbrMy current OS is Ubuntu 22.04 and I install MySQL in custom locations so I assume that I need to install MySQL [...]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Optimizing MySQL Replication Lag with Parallel Replication and Writeset-based Dependency Tracking (from Airtable Engineering Blog)

pBy: Kun Zhou, Matthew Jin/pIntroductionpAt Airtable, MySQL replication plays a crucial role in scaling our reads and achieving our long-term vision for high availability. Having low-lag replicas allows us to offload a significant chunk of read traffic to replicas and eases the operational burden of performing lag-sensitive tasks such as failovers and blue-green deployment switchover./ppOur largest [...]

HeatWaveJP meetup "HeatWave AutoML and HeatWave GenAI" - Recap. (from The Oracle MySQL Blog)

Report from HWJP meetup, Aug 28, 2024 [...]

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

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

JSON Showdown: Dolt vs MySQL (from DoltHub Blog)

UPDATE: The original version of this post accidentally used an outdated SQL client when benchmarking Dolt, which introduced additional… [...]

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

【MySQL】如何给MySQL实现TTL (from Zhao Song's Blog)

最近在给MySQL支持TTL(Time To Live),刚实现一版,有一些有意思的设计和实现问题值得记录一下。 [...]