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, 08. June 2023

How To Install specific version of MySQL 8 on Ubuntu (from Kedar MySQL Blog)

pThis blog post serves as a work-log detailing the process of uninstalling and installing a specific version of Percona MySQL Server on Ubuntu. The post includes instructions for installation using…/p The post How To Install specific version of MySQL 8 on Ubuntu first appeared on Change Is Inevitable. [...]
Published Thursday, 08. June 2023 04:38 • 8 hours ago

Using MySQL Shell to Dump Data To And Read Data From OCI Storage Buckets (from The Oracle MySQL Blog)

MySQL Shell is a powerful utility for managing MySQL Instances. One feature is the ability to perform multithreaded data dumps and loads. In this post we will discuss hows to dump data to, and read data from, a Storage Bucket in Oracle Cloud Infrastructure. [...]
Published Thursday, 08. June 2023 04:00 • 9 hours ago

Wednesday, 07. June 2023

Create index, MyRocks and memory (from Small Datum)

pI got OOM during index create for a few MyRocks benchmarks and I am somewhat ignorant about how MyRocks handles create index. This occurred on a server that has 16G of RAM, RocksDB block cache was 10G and mysqld RSS was ~11G so there wasn't much spare memory./ppI am still somewhat ignorant but will share what I learned./ppUpdate - this isn't ready to be shared. There are still a few things to reso [...]
Published Wednesday, 07. June 2023 21:01 • 16 hours ago | Updated Wednesday, 07. June 2023 23:00 • 14 hours ago

MySQL HeatWave on AWS is now available in AWS Asia Pacific (Mumbai) region (from The Oracle MySQL Blog)

MySQL HeatWave on AWS is now available in AWS Asia Pacific (Mumbai) region [...]
Published Wednesday, 07. June 2023 21:20 • 16 hours ago

MariaDB Community Server Q2.1 2023 maintenance releases (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 10.11.4, 10.10.5, 10.9.7, 10.6.14, 10.5.21, and 10.4.30 maintenance … Continued [...]
Published Wednesday, 07. June 2023 21:01 • 16 hours ago

MariaDB 10.11.4, 10.10.5, 10.9.7, 10.6.14, 10.5.21, 10.4.30 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 10.11.4, MariaDB 10.6.14, MariaDB 10.5.21 and MariaDB 10.4.30, the latest stable releases in their respective long-term series (maintained for five years from their first GA release dates), as well as MariaDB 10.10.5 and MariaDB 10.9.7, the latest Generally Available releases in their respective short-term series (maintained [...]
Published Wednesday, 07. June 2023 14:31 • 23 hours ago

The New MySQL Thread Pool (from The Oracle MySQL Blog)

The "Max Transaction Limit" feature added MySQL Thread Pool in MySQL 8.0 Enterprise Edition helps to prevent performance drops as load increases. [...]
Published Wednesday, 07. June 2023 13:28 • 24 hours ago

Webinar: Upgrade your MySQL 5.7 and older Galera Clusters to MySQL 8.0 with no downtime (from Galera Blog)

We are sure you’ve probably already heard that MySQL 5.7 is going to reach End of Life (EOL) by October 2023. We are here to tell you that the migration from MySQL 5.7 need not be scary — MySQL 8.0 has been Generally Available for five years, and the Galera Cluster product for it, has […] [...]
Published Wednesday, 07. June 2023 12:42 • a day ago

Conquering Mt. Elbert After Percona Live 2023 in Denver (from Percona Database Blog)

♦If you’re going to take on the second-highest peak in the lower 48 states, you might as well do it in great company. That’s precisely what we — Matthew Boehm, Michael Coburn, Péter Farkas, Jean-François Gagné, Marcin Gwóźdź, Kenny Gryp, Nando Laudares, and Alexander Rubin — decided to do. Fresh from attending Percona Live in […] [...]
Published Wednesday, 07. June 2023 12:02 • a day ago

OpenLampTech issue #81 – Substack Repost (from Digital Owl's Prose)

pI am trying something new with the OpenLampTech developer newsletter here on the blog. I will start re-sharing last week’s newsletter on the following Wednesday instead of Monday. If you want it earlier than that, you should subscribe. This won’t be permanent but does help me with some content creation as I am too thin […]/p pThe post OpenLampTech issue #81 – Substack Repos [...]
Published Wednesday, 07. June 2023 11:00 • a day ago

Using Cloud Shell with MySQL HeatWave Database Service in OCI (from lefred's blog)

Last time we tried to connect to a MySQL DB instance in OCI with Cloud Shell, we needed to use the bastion service. See here. Now, we also have the possibility to bypass the bastion host as Cloud Shell offers the possibility to change network. As you know, in Oracle Cloud Infrastructure, a MySQL DB instance is not exposed in the public subnet and doesn’t have the possibility to get a public IP. In [...]
Published Wednesday, 07. June 2023 09:07 • a day ago

Using Cloud Shell with MySQL HeatWave Database Service in OCI (from The Oracle MySQL Blog)

How to connect to a MySQL DB Instance in OCI using Cloud Shell in the browser. [...]
Published Wednesday, 07. June 2023 08:46 • a day ago

Understanding cursor implementation in MySQL (from MinervaDB Blog)

pIn MySQL, a cursor is a database object that allows you to retrieve and manipulate data row by row. It provides a mechanism for iterative processing of query results. Cursors are often used when you [...]/p pThe post Understanding cursor implementation in MySQL appeared first on The WebScale Database Infrastructure Operations Experts./p [...]
Published Wednesday, 07. June 2023 05:29 • a day ago

Using redundant conditions to unlock indexes in MySQL (from PlanetScale Blog)

Using redundant conditions as a method to unlock obfuscated indexes and improve performance in MySQL.pRead the full story/p [...]
Published Wednesday, 07. June 2023 00:03 • a day ago

Tuesday, 06. June 2023

Announcing MariaDB Community Server 11.0 GA and 11.1 RC (from MariaDB Corporation Blog)

We are pleased to announce the general availability (GA) of MariaDB Community Server 11.0 and the first release candidate (RC) of … Continued [...]
Published Tuesday, 06. June 2023 19:14 • a day ago

Announcing TiDB FutureApp Hackathon (from TiDB and TiKV Blog)

pAnnouncing TiDB FutureApp Hackathon 2023, a global community event for developers everywhere to collaborate and develop exciting applications on TiDB./p pThe post Announcing TiDB FutureApp Hackathon appeared first on PingCAP./p [...]
Published Tuesday, 06. June 2023 16:55 • 2 days ago

MariaDB 11.1.1, 11.0.2 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 11.1.1, the first Release Candidate in the MariaDB 11.1 series, and MariaDB 11.0.2, the first stable release in the MariaDB 11.0 series. … /p pContinue reading \"MariaDB 11.1.1, 11.0.2 now available\"/p pThe post MariaDB 11.1.1, 11.0.2 now available appeared first on MariaDB.org./p [...]
Published Tuesday, 06. June 2023 08:51 • 2 days ago

Adding a New Node to MySQL Group Replication from a Backup: A Step-by-Step Guide (from Mydbops Blog)

Adding a New Node to MySQL Group Replication from a Backup: A Step-by-Step Guide [...]
Published Tuesday, 06. June 2023 04:12 • 2 days ago

Monday, 05. June 2023

Spring Boot Redis integration test with Testcontainers in Kotlin (from Geeky Hacker - Coding, Tech & Linux)

pLike any other external dependency, we can write integration tests using Testcontainers for a Spring Boot application. However, unfortunately, Testcontainers does not have any library for Redis, and using Kotlin [...]/p pThe post Spring Boot Redis integration test with Testcontainers in Kotlin appeared first on Geeky Hacker./p [...]
Published Monday, 05. June 2023 18:43 • 3 days ago

PMM Authentication Bypass Vulnerability Fixed in 2.37.1 (from Percona Database Blog)

♦On May 30, Percona was notified of a possible vulnerability in Percona Monitoring and Management (PMM). After researching the report, we agreed with the reporter and began working on a fix to address the issue. Today we’re releasing PMM 2.37.1 with a fix that addresses the PMM authentication bypass vulnerability. This release contains no other […] [...]
Published Monday, 05. June 2023 17:59 • 3 days ago

Is your App continuously available with AWS RDS? (from MariaDB Corporation Blog)

Arguably, one of the key motivations for using a managed DBaaS is its availability characteristics. But, did you know that … Continued [...]
Published Monday, 05. June 2023 16:07 • 3 days ago

Presenting TiDB 7.1: Enhanced Stability and Performance for Business-Critical Applications (from TiDB and TiKV Blog)

pTiDB 7.1 LTS provides developers and infrastructure engineers with a future-proof distributed SQL database that can power a wide range of business-critical applications./p pThe post Presenting TiDB 7.1: Enhanced Stability and Performance for Business-Critical Applications appeared first on PingCAP./p [...]
Published Monday, 05. June 2023 08:14 • 3 days ago

WordPress with MySQL on OCI always Free (from lefred's blog)

I already wrote on how to deploy WordPress on OCI using MySQL HeatWave, the MySQL Database Service in Oracle Cloud Infrastructure: This time we will see the easiest way to deploy WordPress on OCI using an always free tier. We will deploy WordPress and MySQL Community Server 8.0 on an Ampere compute instance. To deploy just using one click, we will use an OCI Resource Manager Stack (Terraform module [...]
Published Monday, 05. June 2023 07:00 • 3 days ago

WordPress with MySQL on OCI always Free (from The Oracle MySQL Blog)

Fastest and easiest method to deploy WordPress and MySQL 8.0 on OCI with an always free tier. [...]
Published Monday, 05. June 2023 06:54 • 3 days ago

Vitess Security Audit Results (from Vitess)

The Vitess Maintainer team is pleased to announce the results of a recent third-party security audit of the Vitess code base. Vitess had previously been audited in 2019. Given the amount of time that has passed, and the magnitude of change during that time, the maintainer team decided to request a fresh audit. Starting in March 2023, an independent team from Ada Logics performed a full security aud [...]
Published Monday, 05. June 2023 00:00 • 4 days ago

Sunday, 04. June 2023

Reading and Writing Blocks in InnoDB (from MinervaDB Blog)

pInnoDB, the default storage engine in MySQL, uses a buffer pool to manage the reading and writing of data blocks. The buffer pool is a cache that holds frequently accessed data pages in memory, reducing [...]/p pThe post Reading and Writing Blocks in InnoDB appeared first on The WebScale Database Infrastructure Operations Experts./p [...]
Published Sunday, 04. June 2023 19:23 • 4 days ago

How to MySQL Replication setup, Master GTID & SSL Encryption (from Kedar MySQL Blog)

pSetting up replication in MySQL is a common DBA task. The replication could be traditional binary log replication or based on GTID replication. This blog is a work log and…/p The post How to MySQL Replication setup, Master GTID & SSL Encryption first appeared on Change Is Inevitable. [...]
Published Sunday, 04. June 2023 12:01 • 4 days ago

How to handle MethodArgumentNotValidException in Spring Boot (from Geeky Hacker - Coding, Tech & Linux)

pError handling in Spring Boot is simple, easy, and efficient. Yet it can be daunting sometimes as different types of validation exceptions and annotations are supported by the Spring framework. [...]/p pThe post How to handle MethodArgumentNotValidException in Spring Boot appeared first on Geeky Hacker./p [...]
Published Sunday, 04. June 2023 10:25 • 4 days ago

Saturday, 03. June 2023

The Power of Partnership: How MinervaDB Transforms Corporate Open Source Database Infrastructure Operations? (from MinervaDB Blog)

pOnce upon a time, in the fast-paced world of global corporations, a new era of data-driven decision-making was taking shape. As businesses faced increasing pressure to manage vast amounts of data, they realized the need [...]/p pThe post The Power of Partnership: How MinervaDB Transforms Corporate Open Source Database Infrastructure Operations? appeared first on The WebScale Database Infrastructur [...]
Published Saturday, 03. June 2023 18:27 • 5 days ago

Friday, 02. June 2023

Cross-account Amazon Aurora MySQL migration with Aurora cloning and binlog replication for reduced downtime (from AWS Database Blog)

Migrating your relational databases on Amazon Aurora MySQL-Compatible Edition from one AWS account to another AWS account is a common use case in scenarios when you acquire, sell, or merge operations, or if you’re reorganizing your AWS accounts and organizational structure. These migrations can be complex, especially for large workloads. It is important to perform […] [...]
Published Friday, 02. June 2023 14:52 • 6 days ago

Powering the Web: Two Decades of Open Source Publishing With WordPress and MySQL (from Percona Database Blog)

♦WordPress, the ubiquitous publishing platform that launched millions of blogs and websites, turned 20 on May 27th. While not the first open source content management system (CMS), WordPress caught on like nothing before and helped spread open source to millions.It was simple, easy to deploy, and easy to use, and WordPress had the added benefit […] [...]
Published Friday, 02. June 2023 12:15 • 6 days ago

How to modify Time Zone system variable for running MySQL database service(MDS) instance ? (from The Oracle MySQL Blog)

This blog walk through an easy way to change global system variable time_zone using OCI dashboard [...]
Published Friday, 02. June 2023 11:08 • 6 days ago

Enhancing Performance with Parallel Index Rebuild in MySQL 8.0.31 (from Mydbops Blog)

Enhancing Performance with Parallel Index Rebuild in MySQL 8.0.31 [...]
Published Friday, 02. June 2023 10:07 • 6 days ago

Question-Answering Pipelines with ChatGPT and Redis (from MORTENSI)

pLarge Language Models are the evolutionary path to resolving many problems with a new approach while permitting the development and rise of new use cases. We all have seen how easy it is to get answers from ChatGPT, and this lays the path to many new services in the area of content retrieval. Question answering […]/p pThe post Question-Answering Pipelines with ChatGPT and Redis appeared firs [...]
Published Friday, 02. June 2023 05:39 • 6 days ago

Thursday, 01. June 2023

Tuning Postgres and the new insert benchmark, round 3 (from Small Datum)

pThis has results for the insert benchmark on a medium server when Postgres caches the database. The previous post is for a similar setup except the database was cached by the OS but not by Postgres. /pptl;dr/pullithe base config I have been using is good once I tuned autovacuum to be more agressive/lilithe big improvement is from adding autovacuum_scale_factor=0.05 and autovacuum_in [...]
Published Thursday, 01. June 2023 21:22 • 7 days ago | Updated Thursday, 01. June 2023 21:22 • 7 days ago

Tuning Postgres and the new insert benchmark, round 2 (from Small Datum)

pA previous post shared results from the insert benchmark for Postgres 15.3 with a variety of configurations. This has results for even more configurations to understand the impact of several tuning variables. The goal is to understand which config options improve average throughput and/or reduce throughput variance. The focus in on the l.i1 benchmark step (inserts with secondary index maintenance) [...]
Published Thursday, 01. June 2023 00:09 • 8 days ago | Updated Thursday, 01. June 2023 21:22 • 7 days ago

Differences between let, also, run, with, and apply in Kotlin (from Geeky Hacker - Coding, Tech & Linux)

pKotlin supports different scope functions for many purposes. Some have overlapping functionalities such as let, also, and so on. In this article, we discuss the differences between let, also, run, [...]/p pThe post Differences between let, also, run, with, and apply in Kotlin appeared first on Geeky Hacker./p [...]
Published Thursday, 01. June 2023 17:38 • 7 days ago

Optimizing query planning in Vitess: a step-by-step approach (from PlanetScale Blog)

See how Vitess acts as a database proxy that creates an illusion of a single database when technically, the query is sent to multiple MySQL instances.pRead the full story/p [...]
Published Thursday, 01. June 2023 15:00 • 7 days ago

Migrating From MariaDB to Percona Server for MySQL 8: The Security Witchcraft (from Percona Database Blog)

♦Hello friends, on certain occasions, some clients, for whatever reason, ask us to migrate a supposedly “equivalent” brand of an engine in terms of belonging to the MySQL family or ecosystem.In this case, we will be analyzing the migration of MariaDB to Percona Server for MySQL 8 in particular. A comment worth clarifying is that, […] [...]
Published Thursday, 01. June 2023 12:36 • 7 days ago

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

List of shows 6-8/2023 [...]
Published Thursday, 01. June 2023 12:25 • 7 days ago

Wednesday, 31. May 2023

Delimiters in MySQL and MariaDB (from SQL And Its Sequels (Ocelot Blog))

In the SQL standard delimiters are for separating tokens; in MySQL/MariaDB they’re for ending statements, particularly compound statements as in CREATE PROCEDURE p() BEGIN VALUES (5); END; The problem is that a dumb client could stop at the first semicolon “;” in the statement (the one after VALUES (5)) instead of the one that truly… Continue Reading Delimiters in MySQL and [...]
Published Wednesday, 31. May 2023 23:44 • 8 days ago

MariaDB & IONOS: Improving performance for hosting (from MariaDB Foundation Blog)

pThe MariaDB Foundation values our partnerships with our sponsors. Our partnership with IONOS allows us to get insight into how MariaDB Server is used and the direction it should take. … /p pContinue reading \"MariaDB & IONOS: Improving performance for hosting\"/p pThe post MariaDB & IONOS: Improving performance for hosting appeared first on MariaDB.org./p [...]
Published Wednesday, 31. May 2023 13:11 • 8 days ago

Pulling back the curtain: the new database overview page (from PlanetScale Blog)

Learn about the latest updates we made to our database overview page: load balancers, shards, and more.pRead the full story/p [...]
Published Wednesday, 31. May 2023 09:00 • 8 days ago

How to modify sql_mode system variable dynamically for running MDS Instance (from The Oracle MySQL Blog)

This blog walk through an easy way to change global system variable using OCI dashboard [...]
Published Wednesday, 31. May 2023 05:35 • 8 days ago

Tuesday, 30. May 2023

Insert+delete benchmark, small server and MyRocks (from Small Datum)

pThis has results for an in-memory, low-concurrency insert benchmark on a small server. The previous report is here. This used the --delete_per_insert option so that the write-heavy steps ran for a long time while the working set remained in memory./pptl;dr/pp/pulli5.6.35 has better perf than 8.0.28 courtesy of new CPU overheads in upstream MySQL 8/liliVariance is visible, but not horrible./li/ulp/ [...]
Published Tuesday, 30. May 2023 19:13 • 9 days ago | Updated Tuesday, 30. May 2023 19:13 • 9 days ago

Updates to the insert benchmark (from Small Datum)

pThe insert benchmark can now be called the insert+delete benchmark./ppWhile I continue to work on the replacement for the insert benchmark (see insert benchmark v3) progress on that is slow. I recently enhanced the insert benchmark to let me run the write-heavy insert benchmark steps while keeping the working set in-memory and this allows me to run the write-heavy steps for much longer than a few [...]
Published Tuesday, 30. May 2023 17:37 • 9 days ago | Updated Tuesday, 30. May 2023 17:45 • 9 days ago

Differences Between Db2 and MySQL (from DataGeek.blog)

pWith a year of fairly extensive MySQL experience under my belt, and uncertainty as to which exciting direction my career will take me next, I wanted to take a moment to write about some of the differences between Db2 and MySQL at a fairly high level.… Read the rest /p [...]
Published Tuesday, 30. May 2023 12:00 • 9 days ago

CloudFest 2023 review (from MariaDB Foundation Blog)

pMariaDB Foundation’s CEO Kaj Arnö chatted to MariaDB Foundation CRO (as well as chairman of the CloudFest advisory board) Soeren von Varchmin about the the successful CloudFest 2023, which took place in Germany, from 21 to 23 March. … /p pContinue reading \"CloudFest 2023 review\"/p pThe post CloudFest 2023 review appeared first on MariaDB.org./p [...]
Published Tuesday, 30. May 2023 11:56 • 9 days ago

Install exact version of Percona Server for MySQL on CentOS (from Kedar MySQL Blog)

pThis blog post serves as a work-log detailing the process of uninstalling and installing a specific version of Percona MySQL Server on CentOS. The post includes instructions for installation using…/p The post Install exact version of Percona Server for MySQL on CentOS first appeared on Change Is Inevitable. [...]
Published Tuesday, 30. May 2023 11:01 • 9 days ago

MySQL Slow query log export and review in RDS (from Kedar MySQL Blog)

pA friend needed to analyze slow queries and for that he decides to use pt-query-digest tool. Though he got stuck at exporting slow queries from slow logs in RDS for…/p The post MySQL Slow query log export and review in RDS first appeared on Change Is Inevitable. [...]
Published Tuesday, 30. May 2023 09:05 • 9 days ago

Monday, 29. May 2023

The value of sponsoring MariaDB Foundation (from MariaDB Foundation Blog)

pWhy does Intel sponsor the MariaDB Foundation? I had the opportunity to interview Steve Shaw, Principal Engineer at Intel and a Board Member at MariaDB Foundation. … /p pContinue reading \"The value of sponsoring MariaDB Foundation\"/p pThe post The value of sponsoring MariaDB Foundation appeared first on MariaDB.org./p [...]
Published Monday, 29. May 2023 21:31 • 10 days ago

How Twilio modernized its Messaging Postflight service data store with Amazon DynamoDB (from AWS Database Blog)

Twilio is a customer engagement platform that drives real-time, personalized experiences for leading brands. Twilio has democratized communications channels like voice, text, chat, and video by virtualizing the world’s telecommunications infrastructure through APIs that are simple enough for any developer to use, yet robust enough to power the world’s most demanding applications. Twilio supports an [...]
Published Monday, 29. May 2023 13:13 • 10 days ago

How to Connect to Your Aiven Database Using dbForge GUI Tools: A Step-by-Step Guide (from Devart MySQL Tool Blog)

pThe well-known as-a-service business model has long encompassed various digital solutions presented to customers, and databases are no exception. In this article, we'll have an overview of Aiven, a nice example of a cloud service that offers, among other things, fully managed MySQL and PostgreSQL databases./p pThe post How to Connect to Your Aiven Database Using dbForge GUI Tools: A Step-by-Step G [...]
Published Monday, 29. May 2023 11:54 • 10 days ago

Updates to Percona Distributions for PostgreSQL, Percona XtraDB Cluster, Percona XtraBackup: Release Roundup May 29, 2023 (from Percona Database Blog)

♦Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in.Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights, cri [...]
Published Monday, 29. May 2023 11:19 • 10 days ago

OpenLampTech issue #80 – Substack Repost (from Digital Owl's Prose)

pIf you’re looking for your PHP, MySQL, and LAMP stack media source, you’ve found it in OpenLampTech. I have one massive – and excellent – newsletter for you this week. Check it out! OpenLampTech issue #80 is sharing content on: Don’t hesitate for one minute. Join the growing community. Grab your free subscription to OpenLampTech […]/p pThe post OpenLampTech issu [...]
Published Monday, 29. May 2023 11:00 • 10 days ago

Streaming versus blocking operators in MySQL (from MinervaDB Blog)

pIn MySQL, operators in a query execution plan can be classified as streaming or blocking based on how they process and propagate rows during query execution. Let’s explore the differences between streaming and blocking operators [...]/p pThe post Streaming versus blocking operators in MySQL appeared first on The WebScale Database Infrastructure Operations Experts./p [...]
Published Monday, 29. May 2023 03:46 • 10 days ago

Sunday, 28. May 2023

Tips and Tricks – Troubleshooting Redo Performance in InnoDB. (from MinervaDB Blog)

pTroubleshooting redo performance in InnoDB involves identifying and addressing potential bottlenecks or issues that affect the efficiency of redo log processing. The redo log plays a critical role in ensuring data durability and crash recovery [...]/p pThe post Tips and Tricks – Troubleshooting Redo Performance in InnoDB. appeared first on The WebScale Database Infrastructure Operations Expe [...]
Published Sunday, 28. May 2023 06:57 • 11 days ago

MySQL Scalar Subquery Unnesting transformation (from MinervaDB Blog)

pScalar subquery unnesting is a transformation technique used by the MySQL optimizer to optimize queries that involve scalar subqueries. Scalar subqueries are subqueries that return a single value, typically used in expressions or as part [...]/p pThe post MySQL Scalar Subquery Unnesting transformation appeared first on The WebScale Database Infrastructure Operations Experts./p [...]
Published Sunday, 28. May 2023 00:22 • 12 days ago

Postgres 16beta1 looks good vs sysbench (from Small Datum)

pThis has results for Postgres 16 beta1 using sysbench on a small server with low-concurrency and a cached database. The goal is to determine whether there are CPU regressions from Postgres 15.3 to 16-beta1./pptl;dr/pp/pulliThere were no regressions/liliA few queries are ~1.7X faster in PG 16-beta1/li/ulBenchmarkbrA description of how I run sysbench is here. The sysbench microbenchmarks were r [...]
Published Sunday, 28. May 2023 00:08 • 12 days ago | Updated Sunday, 28. May 2023 00:17 • 12 days ago

Saturday, 27. May 2023

MySQL Parallel Replication Pitfalls: Group Commit Sync Delay (from Shattered Silicon OSDB Blog)

pMySQL parallel replication is a useful feature, but there are some pitfalls to watch out for. Getting it wrong can cripple performance./p pThe post MySQL Parallel Replication Pitfalls: Group Commit Sync Delay appeared first on Shattered Silicon./p [...]
Published Saturday, 27. May 2023 15:59 • 12 days ago

Sauron says to Dumbledore and Merlin… (from MariaDB Foundation Blog)

pThis sounds like a lame cross-genre joke, but it is not. It is a lame cross-genre math problem. I have to admit, it didn’t have those names when I read about it, but I wanted to make it a bit more epic. … /p pContinue reading \"Sauron says to Dumbledore and Merlin…\"/p pThe post Sauron says to Dumbledore and Merlin… appeared first on MariaDB.org./p [...]
Published Saturday, 27. May 2023 08:00 • 12 days ago

Thursday, 25. May 2023

Connect SE JDBC table type: Accessing Tables From Another DBMS (from MariaDB Foundation Blog)

pIn this blog we will show how to access MySQL and MariaDB DBMS tables from MariaDB Server. For that we will use Connect Storage Engine (SE), which supports different table types options. … /p pContinue reading \"Connect SE JDBC table type: Accessing Tables From Another DBMS\"/p pThe post Connect SE JDBC table type: Accessing Tables From Another DBMS appeared first on MariaDB.org./p [...]
Published Thursday, 25. May 2023 22:30 • 14 days ago

Fill Tables With Large Amounts Of Test Data (from SQL for Devs)

Your tables have to be much bigger for performance tests than they are typical in your development or staging environments. Writing run-once scripts to fill a table is the most used approach to solve that problem. But either it will take very long by inserting one row after another, or the development gets more complex by implementing optimal chunked inserts. [...]
Published Thursday, 25. May 2023 14:07 • 14 days ago

Get upgrading from MySQL 5.7 to MySQL 8.0 (from Galera Blog)

An inordinate amount of our Galera Cluster customer base is still using the MySQL 5.7 variant of Galera Cluster. Besides not being able to have access to all the new features of the Galera 4 library, MySQL 5.7 is rapidly reaching End of Life (EOL) status in October 2023. This is less than six months […] [...]
Published Thursday, 25. May 2023 09:06 • 14 days ago

Announcing the Larabelles Laracon US conference giveaway, sponsored by PlanetScale (from PlanetScale Blog)

PlanetScale is sponsoring Larabelles, which will give three folks who have been historically under-represented or marginalised due to their gender a trip to Laracon US in July.pRead the full story/p [...]
Published Thursday, 25. May 2023 09:00 • 14 days ago

Wednesday, 24. May 2023

How to Handle Seasonal Database Load (from MariaDB Corporation Blog)

If your business relies on your database to support your mission-critical applications, you have probably experienced some of the pain … Continued [...]
Published Wednesday, 24. May 2023 21:58 • 15 days ago

MariaDB Enterprise 10.6.12-8 now available (from MariaDB Corporation Blog)

MariaDB Enterprise Server 10.6.12-8 is a maintenance release of MariaDB Enterprise Server 10.6. This release includes a variety of fixes. … Continued [...]
Published Wednesday, 24. May 2023 20:29 • 15 days ago

How to control MySQL execution plans with hints? (from MinervaDB Blog)

pIn MySQL, you can use query hints to provide suggestions or directives to the query optimizer about how to generate the execution plan for a specific query. Query hints allow you to have more control [...]/p pThe post How to control MySQL execution plans with hints? appeared first on The WebScale Database Infrastructure Operations Experts./p [...]
Published Wednesday, 24. May 2023 18:47 • 15 days ago

Validate database objects after migrating from IBM Db2 z/OS to Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL (from AWS Database Blog)

Customers are modernizing their mission-critical legacy on-premises IBM Db2 for z/OS databases to Amazon Relational Database Service (Amazon RDS) for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition for its scalability, performance, agility, and availability. You can use the AWS Schema Conversion Tool (AWS SCT) to simplify the schema conversion from Db2 for z/OS to Amazon RDS […] [...]
Published Wednesday, 24. May 2023 12:49 • 15 days ago

Explore the new MySQL Enterprise Data Masking and De-Identification Features (from The Oracle MySQL Blog)

The post explains how to use MySQL Enterprise Data Masking and De-Identification Features. [...]
Published Wednesday, 24. May 2023 12:39 • 15 days ago

Tuesday, 23. May 2023

Tuning Postgres and the new insert benchmark (from Small Datum)

This post explains my work in progress to tune the configurations I use for Postgres. I support a DBMS that needs some tuning, I am wary of a DBMS that needs too much tuning. I assume that Postgres is the former, and at least for me so is MyRocks/RocksDB. I wish it were possible to do tuning in two parts, but I am not aware of a DBMS that supports such an approach today:olliDescribe the HW capacity [...]
Published Tuesday, 23. May 2023 21:24 • 16 days ago | Updated Tuesday, 23. May 2023 22:25 • 16 days ago

MySQL on Ubuntu (from MacLochlainns Weblog)

Fresh install of Ubuntu on my MacBook Pro i7 because Apple said the OS X was no longer upgradable. Time to install and configure MySQL Server. These are the steps to install MySQL on the Ubuntu Desktop. Installation Update the Ubuntu OS by checking for, inspecting, and upgrading any available updates with the following commands: […] [...]
Published Tuesday, 23. May 2023 22:18 • 16 days ago

Compiling all releases of MySQL 8.0 (from Small Datum)

pThis explains my experiences compiling all GA releases from MySQL 8.0. The first GA release is 8.0.11, the latest is 8.0.33 and 8.0.29 doesn't exist. That means there are 22 point releases including 8.0.33./ppMy build platform is Ubuntu 22.04 which has gcc 11.3.0. The first challenge is OpenSSL -- MySQL 8.0.28 and prior releases need version 1, 8.0.30 and later need version 3 and Ubuntu 22.04 incl [...]
Published Tuesday, 23. May 2023 17:42 • 16 days ago | Updated Tuesday, 23. May 2023 17:42 • 16 days ago

OSS Insight’s Journey to a Serverless Database (from TiDB and TiKV Blog)

pLearn how TiDB Serverless helps OSS Insight handle massive and fluctuating data workloads with ease and efficiency while lowering costs./p pThe post OSS Insight’s Journey to a Serverless Database appeared first on PingCAP./p [...]
Published Tuesday, 23. May 2023 12:22 • 16 days ago

MariaDB is part of Google Summer of Code 2023 (from MariaDB Foundation Blog)

pWe are excited to announce that this year MariaDB has once again been accepted as a Google Summer of Code organization. With this blog post I want to showcase the projects we’re taking on and wish good luck to our mentees for the summer! … /p pContinue reading \"MariaDB is part of Google Summer of Code 2023\"/p pThe post MariaDB is part of Google Summer of Code 2023 appeared first on M [...]
Published Tuesday, 23. May 2023 07:53 • 16 days ago

MERGE: Conditional INSERT, UPDATE or DELETE (from Modern SQL)

codeMerge/code: Conditional codeInsert/code, codeUpdate/code or codeDelete/code♦olliNot all operations/lili⚡Ambiguities not always reported/liliNot all syntax variants/lili⚡Applies multiple rules/liliNo view or subqueries as source/li/olpSQL’s codemerge/code performs codeinsert/code, codeupdate/code and codedelete/code operations based on codewhen…then/code rules. It is useful for synchronizing the [...]
Published Tuesday, 23. May 2023 00:00 • 17 days ago

Monday, 22. May 2023

Introducing Amazon Aurora MySQL enhanced binary log (binlog) (from AWS Database Blog)

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud. Aurora combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open-source databases. Aurora has a history of innovating around database engines and the underlying infrastructure running the database, while maintaining compatibility. A commo [...]
Published Monday, 22. May 2023 20:28 • 17 days ago

MariaDB C Connector 3.3.5 and 3.1.21 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Connector/C 3.3.5 and 3.1.21. Download Now Release Notes and Changelog … Continued [...]
Published Monday, 22. May 2023 18:49 • 17 days ago

Avoiding a STOP SLAVE Crash with MTR in Percona Server older than 5.7.37-40 (from J-F Gagné's MySQL Blog)

I am finalizing my Percona Live talk MySQL and Vitess (and Kubernetes) at HubSpot.  In this talk, I mentioned that I like that Percona is providing better MySQL with Percona Server.  This comes with a little inconvenience though: with improvements, sometimes comes regression.  This post is about such regression and a workaround I implemented some time ago (I should have shared it earlier).  This [...]
Published Monday, 22. May 2023 13:12 • 17 days ago | Updated Monday, 22. May 2023 15:12 • 17 days ago

Amazon Aurora Global Database minor version upgrade in a headless configuration (from AWS Database Blog)

Amazon Aurora Global Database is specifically designed to meet the needs of globally distributed applications. It replicates your data across AWS Regions with no impact on database performance, enables fast local reads with low latency in each Region, and provides disaster recovery from Region-wide outages. Many organizations use Aurora Global Database in a headless configuration. […] [...]
Published Monday, 22. May 2023 14:05 • 17 days ago

OpenLampTech issue #79 – Substack Repost (from Digital Owl's Prose)

pWelcome to the OpenLampTech developer newsletter. Thank you so much for reading each week. I am bringing you the media source for PHP, MySQL, and the LAMP stack you can depend on. I am sharing so many good articles this week in OpenLampTech issue #79. Visit those that pique your interest most: Want to support […]/p pThe post OpenLampTech issue #79 – Substack Repost appeared first on Di [...]
Published Monday, 22. May 2023 11:00 • 17 days ago

PlanetScale is now available on the Google Cloud Marketplace (from PlanetScale Blog)

We’re excited to announce that PlanetScale is now available on the Google Cloud Marketplace.pRead the full story/p [...]
Published Monday, 22. May 2023 09:00 • 17 days ago

Multithreaded Data Dumps With MySQL Shell (from The Oracle MySQL Blog)

MySQL Shell offers an upgrade over legacy MySQL CLI tools. One set of features that gets a boost is dumping and loading data. MySQL Shell allows users to load and dump data using a multithreaded process and to be more granular in what data is dumped and loaded than when using mysqldump. In this post we discuss how to use these utilities to dump specific tables in a schema, specific data in specific [...]
Published Monday, 22. May 2023 04:00 • 17 days ago

Sunday, 21. May 2023

MariaDB Health Checks in WordPress (from MariaDB Foundation Blog)

pIn a previous blog post, I gave an overview of the CloudFest Hackathon. At this event my team created a plugin for WordPress which added additional health checks for MariaDB. … /p pContinue reading \"MariaDB Health Checks in WordPress\"/p pThe post MariaDB Health Checks in WordPress appeared first on MariaDB.org./p [...]
Published Sunday, 21. May 2023 20:20 • 18 days ago

Saturday, 20. May 2023

Convert SQL queries to Redis commands (from MORTENSI)

pRedis is not a relational database. But if you’re coming from the RDBMS world, in this post you will discover how to resolve query, search, and aggregation problems in Redis, and convert SQL queries to Redis commands. Redis is a good fit to perform many of the operations you would do on a RDBMS. You […]/p pThe post Convert SQL queries to Redis commands appeared first on mortensi./p [...]
Published Saturday, 20. May 2023 12:10 • 19 days ago

Friday, 19. May 2023

Implement an anti-plagiarism checker with Redis (from MORTENSI)

pI have written on the different problems that can be resolved using the powerful features of Redis as a vector database: I want to present a simple proof of concept of an anti-plagiarism software in this article. Let’s say that you want to verify if specific documents or images are copied from your website (and […]/p pThe post Implement an anti-plagiarism checker with Redis appeared fi [...]
Published Friday, 19. May 2023 13:28 • 20 days ago

Thursday, 18. May 2023

The Insert Benchmark, MySQL 5.6, 5.7, 8.0 and a big server (from Small Datum)

pThis has results for MySQL vs the insert benchmark on a big server. Results from a small server are here./ppThe goals are to look for performance changes from MySQL 5.6 to 8.0 and to determine the impact of compiler optimizations. The context here is a cached workload (reads from cache, writes to storage) with high concurrency./pptl;dr (still long but the results vary a lot):/pp/pulliIt is possibl [...]
Published Tuesday, 16. May 2023 16:36 • 23 days ago | Updated Thursday, 18. May 2023 17:52 • 21 days ago

Summary of another round of benchmarks (from Small Datum)

pThis has links for my latest round of benchmarks for MyRocks, InnoDB and Postgres. They were run on a small and big server for sysbench and the insert benchmark. The big server is a c2-standard-60 with 30 cores, hyperthreads disabled and 240G of RAM. The small server is a mini PC with 8 cores and 16G of RAM. For MyRocks I used builds from FB MySQL 5.6.35 and 8.0.28. For InnoDB I used upstream MySQ [...]
Published Thursday, 18. May 2023 17:51 • 21 days ago | Updated Thursday, 18. May 2023 17:51 • 21 days ago

The Insert Benchmark, MySQL 5.6, 5.7, 8.0 and a small server (from Small Datum)

pThis has results for MySQL vs the insert benchmark on a small server. Results from a big server are here./ppThe goals are to look for performance changes from MySQL 5.6 to 8.0 and to determine the impact of compiler optimizations. The context here is a cached workload (reads from cache, writes to storage) with low concurrency and a small server./pptl;dr/pp/pulliThe rel_native_lto build has the bes [...]
Published Thursday, 18. May 2023 17:19 • 21 days ago | Updated Thursday, 18. May 2023 17:19 • 21 days ago

Exploring Aurora serverlessV2 for MySQL Part 3 (from Mydbops Blog)

Exploring Aurora serverlessV2 for MySQL Part 3 [...]
Published Thursday, 18. May 2023 04:27 • 21 days ago

Character sets and collations in MySQL (from PlanetScale Blog)

Understanding the differences between character sets and collations in MySQL.pRead the full story/p [...]
Published Thursday, 18. May 2023 00:03 • 22 days ago

Easy Way to Start Contributing to Open Source With PMM Documentation (from Percona Community Blog)

If you are a user of Percona Monitoring and Management and noticed any typo or inaccurate information in its documentation, you can easily correct it yourself in the repository following detailed instructions in README.md. But if you are not experienced in open source contributions, you may still feel uneasy about following those steps. This post is for you! We will walk through the main steps with [...]
Published Thursday, 18. May 2023 00:00 • 22 days ago

Wednesday, 17. May 2023

Coming to a language near you! (from MariaDB Foundation Blog)

pIn a movie theater near you, expect to soon see an explanation of MariaDB Server and MariaDB Foundation in your own language! That is, providing you speak one of the good dozen of languages we have frequently encountered in the MariaDB Server ecosystem. … /p pContinue reading \"Coming to a language near you!\"/p pThe post Coming to a language near you! appeared first on MariaDB.org./p [...]
Published Wednesday, 17. May 2023 18:26 • 22 days ago

Understanding the insert benchmark results: variance and write stalls (from Small Datum)

pToday I published a report for the insert benchmark with InnoDB and a big server and then updated reports for MyRocks and Postgres. One goal is to find things that can be made better. Another goal is to understand how performance and efficiency changes when context changes where context might be the version of the DBMS (newer releases fix some things, but add CPU overhead) or it might be whether t [...]
Published Tuesday, 16. May 2023 17:57 • 23 days ago | Updated Wednesday, 17. May 2023 15:27 • 22 days ago

The insert benchmark, Postgres versions 11 to 15, a big server (from Small Datum)

pThis has results for Postgres vs the insert benchmark on a big server. My previous post had results for a small server. The goals are to look for performance changes from PG version 11 to 15 and to determine the impact of compiler optimizations. The context here is a cached workload (reads from cache, writes to storage) with high concurrency./pptl;dr/pp/pulliSee the Most Important Disclaimer here/ [...]
Published Thursday, 04. May 2023 23:34 • 1 months ago | Updated Wednesday, 17. May 2023 15:06 • 22 days ago

Motivations for migration to Amazon DynamoDB (from AWS Database Blog)

Amazon DynamoDB is a fully managed, serverless, key-value NoSQL database for single-digit millisecond performance at any scale. DynamoDB offers built-in security, continuous backups, automated multi-Region replication, 99.999% availability SLA, and data import and export tools. DynamoDB was built working backward from the needs of external customers and internally at Amazon.com to overcome the scal [...]
Published Wednesday, 17. May 2023 14:47 • 22 days ago

Understand Amazon Aurora high availability and disaster recovery from an Oracle perspective (from AWS Database Blog)

In this post, we compare the high availability (HA) and disaster recovery (DR) features of Amazon Aurora to Oracle, with a focus of the Aurora disk subsystem and how this key innovation allows Amazon Aurora Global Database to deliver performance and availability. Data today is increasingly seen [...]
Published Wednesday, 17. May 2023 14:34 • 22 days ago

Integrate Cloudflare Workers with PlanetScale (from PlanetScale Blog)

A guide on how to natively integrate your PlanetScale database into Cloudflare workers easily and securely.pRead the full story/p [...]
Published Wednesday, 17. May 2023 12:00 • 22 days ago

MySQL UNION Explained: A Tutorial with Practical Examples for All Skill Levels (from Devart MySQL Tool Blog)

pThe SQL language provides a lot of effective operators for retrieving and presenting data from databases. One popular tool is the UNION clause. In this article, we will delve into what the UNION clause is, its benefits, and how to use it effectively in MySQL./p pThe post MySQL UNION Explained: A Tutorial with Practical Examples for All Skill Levels appeared first on Devart Blog./p [...]
Published Wednesday, 17. May 2023 10:59 • 22 days ago

Tuesday, 16. May 2023

Perf regressions in MyRocks with the insert benchmark (from Small Datum)

pI used the insert benchmark to search for performance regressions from old MyRocks (5.6.35) to modern MyRocks (8.0.28) and to determine the impact of compiler optimizations because I build it from source. The context for the results is read-heavy and write-heavy, in-memory (cached by MyRocks) on a small server with low-concurrency and a big server with high-concurrency.brbrThe small server is a&nb [...]
Published Monday, 17. April 2023 23:22 • 2 months ago | Updated Tuesday, 16. May 2023 23:05 • 23 days ago