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, 02. March 2024

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

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

Friday, 01. March 2024

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

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

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

pPrimary keys are the backbone of efficient data access and maintaining data consistency in your MySQL databases. However, altering them requires careful planning and execution, as incorrect procedures can lead…/p The post How to avoid data loss in MySQL Primary Key change first appeared on Change Is Inevitable. [...]

Parametric Queries (from MacLochlainns Weblog)

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

MySQL Keyring Component Installation for TDE (from MySQLHK)

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

Thursday, 29. February 2024

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

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

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

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

Amazon RDS for PostgreSQL, MySQL, and MariaDB support M7g and R7g database instances in additional regions (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for PostgreSQL, MySQL, and MariaDB now support AWS Graviton3-based M7g and R7g database instances in US West (N. California), Asia Pacific (Hyderabad, Seoul), Canada (Central), Europe (London, Spain), and Middle East (Bahrain). Graviton3-based instances provide up to a 30% performance improvement and up to a 27% price/performance improvement (based o [...]

Notable optimizer fixes released in February, 2024 (from Sergei Petrunia's blog)

MariaDB has made new releases of stable versions in February. Like with previous release batch, I want to list notable changes in the query optimizer: MDEV-32958: Unusable key notes do not get reported for some operations This is a follow-up to MDEV-32203 I’ve covered for the previous release: MariaDB now emits a warning for conditions […] [...]

Introduction to the New Percona Everest Beta (from Another Boring Tech Blog)

pIn the rapidly evolving world of technology, database management remains a crucial, albeit challenging, aspect for many organizations. Percona, a leading provider of open-source database solutions, comes with its latest product, which is now in its beta phase: Percona Everest. This post aims to shed light on what Percona Everest is, how it works, and.../p pO post Introduction to the New Percona Ev [...]

Wednesday, 28. February 2024

Azure Database for MySQL Import supports Percona XtraBackup for migrations to Flexible Server (from Azure for MySQL Blog)

pOur flagship offering, Azure Database for MySQL – Flexible Server, is well-positioned to serve as the best platform for hosting your MySQL workloads, offering maximum control and flexibility to run your MySQL servers. To facilitate seamless migration to Azure Database for MySQL - Flexible Server, we’re pleased to announce Public Preview of Azure Database for MySQL Import supporting Percona Xt [...]

Perform cross-account major version upgrades from Amazon RDS for MySQL 5.7 to Amazon Aurora 3.04.x with minimum downtime (from AWS Database Blog)

As businesses continue to scale, the need for highly performant, scalable, and reliable databases becomes paramount. Amazon Aurora, with its advanced features and cloud-native architecture, offers an attractive solution for organizations seeking to upgrade their databases. For mission-critical, large, and complex databases, it is challenging to upgrade databases with near-zero downtime for cutover. [...]

MySQL 5.7 to 8: Schema and DDL Changes (from Skeema Blog)

pMySQL 5.7 reached its end-of-life in October 2023, and managed database products such as Amazon RDS are starting to transition to expensive “extended support” pricing for 5.7 users. Before you jump on a last-minute MySQL 8 upgrade, it is essential to understand the major functional differences between these database versions. In this post, we’ll provide a deep-dive on the upgrade [...]

MariaDB/MySQL Environment MyEnv 2.1.0 has been released (from Shinguz's Blog)

pFromDual has the pleasure to announce the release of the new version 2.1.0 of its popular MariaDB, Galera Cluster and MySQL multi-instance environment MyEnv./p pThe new MyEnv can be downloaded here. How to install MyEnv is described in the MyEnv Installation Guide./p pIn the inconceivable case that you find a bug in the MyEnv please report it to the FromDual bug tracker./p pAny feedback, statem [...]

First Row of Many Similar Ones (from SQL for Devs)

SQL is a straightforward and expressive language, but it sometimes lacks constructs for writing queries in a simple way. It's more complicated than it should be to write a query to get, e.g., only the most expensive order for every customer of the current fiscal year. You can use PostgreSQL's vendor-specific DISTINCT ON feature or window functions for every o [...]

Introducing schema recommendations (from PlanetScale Blog)

Automatically receive recommendations to improve database performance, reduce memory and storage, and improve your schema based on production database traffic. [...]

The most noteworthy improvements in MariaDB 10.11 (from Severalnines Blog)

pImproving on its predecessor, MariaDB 10.6, MariaDB 10.11 is the latest long-term stable series. It was released in February 2023 with ClusterControl support introduced in August of the same year. So what’s new? We’ll take a look at updates in 5 key areas: security, the InnoDB engine, temporal tables, general performance optimizations, and system variables. […]/p pThe post The mo [...]

Webinar recording: Mastering Galera Cluster, Best Practices and New Features (from Galera Blog)

This exclusive webinar is tailored for database administrators and IT professionals aiming to enhance their systems’ efficiency and reliability using Galera Cluster. This session focuses on practical best practices, showcases new features, and provides an extended platform for your queries. What You Will Learn: * Core Best Practices: Dive into essential practices, from employing primary […] [...]

Upgrade Now to Avoid Increased Costs for Your RDS MySQL 5.7 (from Mydbops Blog)

Author: Vinoth Kanna Hi RDS MySQL folks, Today, we're discussing the cost-saving opportunities associated with the lifecycle of MySQL 5.7 and AWS RDS, focusing on end-of-life dates, extended support [...]

Tuesday, 27. February 2024

Trigger an AWS Lambda function from Amazon RDS for MySQL or Amazon RDS for MariaDB using audit logs and Amazon CloudWatch (from AWS Database Blog)

AWS Lambda is a serverless compute offering that helps you design event-driven architectures. It provides direct integration with multiple AWS services, including Amazon Aurora MySQL-Compatible Edition. In this post, we show you how to invoke Lambda functions from Amazon Relational Databases Service (Amazon RDS) for MySQL and Amazon RDS for MariaDB using Amazon CloudWatch and […] [...]

The ANY_VALUE(…) Aggregate Function (from Modern SQL)

The codeANY_VALUE(…)/code Aggregate Function: New in SQL:2023 — and a better feature from 1999♦olli⚡Might return codenull/code even if there are non-codenull/code values/lili⚡Not an aggregate function/liliWithout codefilter/code clause/liliNot as window function (codeover/code clause)/li/olpThe aggregate function codeany_value/code takes a non-codenull/code value from a group of rows./pprecodeSELEC [...]

Monday, 26. February 2024

Amazon RDS for MariaDB supports minors 10.11.7, 10.6.17, 10.5.24, 10.4.33 (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for MariaDB now supports MariaDB minor versions 10.11.7, 10.6.17, 10.5.24, and 10.4.33. 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./p [...]

2nd Round MySQL Workshop at HK Association for Computer Education (HKACE) - Recap. (from The Oracle MySQL Blog)

Teachers workshop HK, Feb 2024 [...]

Using the Oracle Cloud TypeScript SDK Part 4 - Listing MySQL HeatWave Backups (from The Oracle MySQL Blog)

Oracle offers a variety of SKDs for interacting with Oracle Cloud Infrastructure resources. In this post we discuss how to list the backups of MySQL HeatWave instances in a given compartment. [...]

Sunday, 25. February 2024

MariaDB Encryption ( data at rest ) (from Another MySQL DBA)

pHere is a simple example showing a couple options for MariaDB Encryption. /ppYou have to consider what you want to encrypt . The data communication (data in transit) or the data on the instance (data at rest). /ppThis post is going to focus on the data at rest option using a AWS free tier node running on Amazon Linux. I will be using the world database on 2 different instances to show up [...]

Saturday, 24. February 2024

MySQL Shell for VS Code – Bastion Host & Invalid fingerprint detected (from lefred's blog)

If you use MySQL Shell for Visual Studio Code, using a bastion host is the easiest method to connect to a MySQL HeatWave DB Instance on OCI. If you already have a connection setup using a bastion to host, you may experience the same problem as me, MySQL Shell complains about an invalid fingerprint detected: […] [...]

How to resolve DNS issues with Azure Database for MySQL (from Azure for MySQL Blog)

pIf you’re using Azure Database for MySQL and have encountered issues with name resolution or the Domain Name System (DNS) when attempting to connect to your server from different sources and networks, then this blog post is for you! In the next sections, I’ll explain the causes of these types of issues and what you need to do to resolve them. /p p /p What are DNS issues?  [...]

Friday, 23. February 2024

Announcing MariaDB Connector/R2DBC 1.2 (from MariaDB Corporation Blog)

We are pleased to announce MariaDB Connector/R2DBC 1.2 as GA (Generally Available). MariaDB Connector/R2DBC 1.2 now implements the R2DBC 1.0.0 … Continued [...]

Disabling Transparent Huge Pages (THP) permanently on Ubuntu 22.04 (from Another Boring Tech Blog)

pDisabling Transparent Huge Pages (THP) permanently on Ubuntu 22.04 requires editing system configuration files to apply the change at boot time. There are a few methods to achieve this, but one common approach is to use rc.local or a custom systemd service since Ubuntu may not have rc.local enabled by default in newer versions. Here,.../p pO post Disabling Transparent Huge Pages (THP) permanently [...]

Lender threatens to sweep MariaDB accounts over private equity bid (from The Register)

Publicity around offer breaches loan agreement, or so SEC filing alleges pMariaDB has been warned by a bank lender that it may "sweep" its accounts in retaliation for the publication of a private equity bid for the troubled database company.…/p [...]

MariaDB plc – looking forward to business as usual (from MariaDB Foundation Blog)

pFrom near and from far, the same thing – in this case MariaDB plc – can look quite different. It’s all doom and gloom in an Infoworld article on MariaDB plc Can MariaDB’s enterprise business be saved? … /p pContinue reading \"MariaDB plc – looking forward to business as usual\"/p pThe post MariaDB plc – looking forward to business as usual appeared first [...]

Thursday, 22. February 2024

MariaDB Python Connector 1.1.10 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Python 1.1.10 release. Download Now Release Notes MariaDB Connector/Python … Continued [...]

Post-mortem: PHP and MariaDB Docker issue (from MariaDB Foundation Blog)

pYears ago, I watched a film with my children (now adults themselves) called Meet the Robinsons. A running theme from the film is that it is OK to make mistakes because it is from those mistakes we can learn and “keep moving forward”. … /p pContinue reading \"Post-mortem: PHP and MariaDB Docker issue\"/p pThe post Post-mortem: PHP and MariaDB Docker issue appeared first on MariaDB [...]

Get Started with MariaDB in Kubernetes and mariadb-operator (from MariaDB Corporation Blog)

MariaDB users and customers alike have been exploring ways to run MariaDB in  Kubernetes (K8s). At MariaDB, we’re investing in … Continued [...]

Backing up and Restoring to AWS S3 With Percona Kubernetes Operators (from Percona Database Blog)

♦In our last post, we looked into the lifecycle of applications in Kubernetes. We see that Kubernetes doesn’t handle database backups itself. This is where Kubernetes Operators come into action. They add additional functions to Kubernetes, enabling it to set up, configure, and manage complex applications like databases within a Kubernetes environment for the user.In […] [...]

The benefits of MariaDB ColumnStore (from Vettabase)

Last week Richard announced our projects on MariaDB ColumnStore. Take a look at his great post, if you didn’t already. Since then, I’ve got some questions from customers, colleagues and friends: why did you guys decide to robustly invest into ColumnStore, and offer your ColumnStore services? After all, it’s not a new or trendy technology. So, why ColumnStore and not, for example, [...]

Wednesday, 21. February 2024

Can MariaDB’s enterprise business be saved? (from InfoWorld)

pA non-binding proposal to acquire MariaDB, the provider of the relational database management system (RDBMS) of the same name—a fork of the open-source MySQL database, has sparked speculations about the company’s future and what the acquisition would mean for its enterprise customers.  /ppThe proposal was for MariaDB PLC, the firm that provides database services and SaaS offerings built on the [...]

Creating SSH Keys (from Another Boring Tech Blog)

pAn SSH key consists of a pair of files: the private key and the public key. The private key is confidential and should never be shared, while the public key enables you to log into the servers, containers, and VMs you set up. When creating these keys using the ssh-keygen command, the keys are stored.../p pO post Creating SSH Keys apareceu primeiro em Another Boring Tech Blog./p [...]

Announcing General Availability of MariaDB Connector/C++1.1 (from MariaDB Corporation Blog)

We are pleased to announce the general availability of a new release series of MariaDB Connector/C++. MariaDB Connector/C++ delivers an … Continued [...]

MySQL HeatWave Day in Zurich (from The Oracle MySQL Blog)

MySQL Day in Zurich [...]

Securing Percona Everest with Ingress and Cert-Manager (from Percona Database Blog)

♦According to CNCF surveys, security is always among the top concerns for Kubernetes practitioners and platform engineers. Percona Everest — an open source cloud-native database platform –  is now in Alpha stage, but it is important to set it up properly from day 0. In this blog post, we will explain how to run Everest UI […] [...]

MariaDB Java Connector 3.3.3 and 2.7.12 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Java 3.3.3 and 2.7.12 releases. Download Now Release Notes … Continued [...]

Tuesday, 20. February 2024

MariaDB 11.4.1, 11.3.2 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 11.4.1, the first Release Candidate in the MariaDB 11.4 series, and MariaDB 11.3.2, the first and final stable release in the MariaDB 11.3 series. … /p pContinue reading \"MariaDB 11.4.1, 11.3.2 now available\"/p pThe post MariaDB 11.4.1, 11.3.2 now available appeared first on MariaDB.org./p [...]

Graal Cloud Native adds Google Cloud Platform support (from InfoWorld)

pOracle has introduced Graal Cloud Native 4.2.1, a curated, Oracle-supported build of the open source Micronaut framework, which provides a full-stack JVM platform for developing modular microservices and serverless applications./ppGraal Cloud Native 4.2.1 was unveiled January 30. Offering out-of-the-box support for native compilation, Graal Cloud Native modules have integrated APIs and librarie [...]

MariaDB’s potential take-private deal is an indictment of 2021’s SPAC mania (from TechCrunch)

pThe potential sale of MariaDB to K1 Investment Management for $37 million is a capstone on the failed era of SPAC mergers./p p© 2024 TechCrunch. All rights reserved. For personal use only./p [...]

Understand and optimize replication for Amazon Redshift with AWS DMS (from AWS Database Blog)

In this post, we deep dive into using AWS Database Migration Service (AWS DMS) to load data to Amazon Redshift and discuss how to optimize data loading. In a world where data is always growing and larger datasets need to be processed, it’s important to use the right tool for the right job. Amazon Redshift […] [...]

MariaDB receives offer to go private more than year after disastrous IPO (from The Register)

$37.3M bid significantly down from SPAC flotation valued at $672M pMariaDB has confirmed a possible offer of $37.3 million from private equity company K1 Investment Management to take the recently troubled database company private.…/p [...]

Perf regressions in Postgres from 9.0 to 16 with sysbench and a small server (from Small Datum)

pThis has results for sysbench vs Postgres on a small server. I have results for versions from 9.0 through 16. My last report only went back to Postgres 11. The goal is to document where things get faster or slower over time for a low-concurrency and CPU-bound workload. The focus is on CPU regressions. /ppMy results here aren't universal, but you have to start somewhere:/pp/pulliThe [...]

Where can you find MySQL during March - May 2024 (from The Oracle MySQL Blog)

List of Events Mar-May 2024 [...]

Exploring the Kubernetes Application Lifecycle With Percona (from Percona Database Blog)

♦This post was originally published on the Percona Community blog.If you are in the world of application development, you know that every application has a lifecycle. An application lifecycle refers to the stages that our application goes through, from initial planning, building, deployment, monitoring, and maintenance in different environments where our application can be executed.On […] [...]

Better Business Banking: How Aiven Helps Lili to Expand and Keep Impressing Customers (from Aiven Blog - MySQL)

EverSQL by Aiven enables fast-growing Lili to optimize databases, pre-empting performance issues and saving valuable developer time [...]

Codership shines with other EIC-funded companies at Mobile World Congress Barcelona 2024 (from Galera Blog)

Codership is honored to be part of a distinguished group of 15 EIC-funded companies to present Galera Cluster with their groundbreaking products and services at the European Innovation Council Pavilion during Mobile World Congress  Barcelona, 26-29 February 2024. Join us at EIC Pavilion-4YFN-booth 8.1A20 [...]

MySQL Benchmarking and error in my_thread_global_end() (from Kedar MySQL Blog)

pI encountered this error, “Error in my_thread_global_end(): xx threads didn’t exit“, while working on MySQL benchmarking using sysbench. In this blog I’ll share my experience, reveal the fix, and help…/p The post MySQL Benchmarking and error in my_thread_global_end() first appeared on Change Is Inevitable. [...]

Monday, 19. February 2024

Perf regressions in MySQL from 5.6.21 to 8.0.36 using sysbench and a small server (from Small Datum)

pThis has results for sysbench vs upstream MySQL on a small server. I have results for some 5.6, 5.7 and 8.0 releases up to 8.0.36. My last report stopped at 8.0.34. The goal is to document where things get faster or slower over time for a low-concurrency and CPU-bound workload. The focus is on CPU regressions. /ppMy results here aren't universal. /pp/pulliThe microbenchmarks here mostly [...]

Migrate tables from Microsoft Access to Amazon RDS for MySQL (from AWS Database Blog)

Microsoft Access can fulfill your small-scale database needs, but you may encounter limitations related to scalability, reliability, security, and performance as the data grows. For instance, state and local government entities often employ Microsoft Access for tasks like inventory management and timesheet maintenance. As data volume expands, you might consider transitioning to a more robust […] [...]

Struggling database company MariaDB could be taken private in $37M deal (from TechCrunch)

pMariaDB is the subject of another potential takeover bid, as the company behind the eponymous open source relational database management system (RDBMS) confirmed it had received a provisional offer from California-based K1 Investment Management. K1 quietly revealed on Friday that it had tabled what is known as an “unsolicited non-binding indicative proposal” for MariaDB, which [… [...]

SQL Optimization: a comprehensive developer’s guide (from EverSQL Blog)

pA SQL optimization guide for developers. With best practices, warnings, pro tips to speed up your SQL optimization./p pThe post SQL Optimization: a comprehensive developer’s guide appeared first on EverSQL./p [...]

Using the Oracle Cloud TypeScript SDK Part 3 - Waiters (from The Oracle MySQL Blog)

Oracle offers a variety of SKDs for interacting with Oracle Cloud Infrastructure resources. In this post we discuss how to use waiters to asynchronously handle when the state MySQl HeatWave instance changes. [...]

Sunday, 18. February 2024

How to implement Parallel Redo Logging in InnoDB? (from MinervaDB Blog)

pImplementing parallel redo logging in InnoDB involves optimizing the InnoDB storage engine's configuration to enhance the parallel writing of redo logs, which is crucial for improving the performance of write-heavy database workloads. While the term [...]/p pThe post How to implement Parallel Redo Logging in InnoDB? appeared first on The WebScale Database Infrastructure Operations Experts in Postg [...]

One year on the Giant Explore E+ 2 with a Rohloff Speedhub 500/14 (from Jeremy Cole)

I thought since it’s been exactly a year since I upgraded my Giant Explore E+ to a Rohloff Speedhub 500/14 internal gear hub, that it’s a good time for an update. As for stats: I have put 5,180+ miles on this bike since the conversion. A custom 3D-printed speed sensor mount One of the items […] [...]

Saturday, 17. February 2024

It wasn't a performance regression in Postgres 14 (from Small Datum)

pWith help from a Postgres expert (Peter Geoghegan) I was able to confirm there wasn't a performance regression for Postgres 14 in a few of the benchmark steps with the Insert Benchmark as I started to report on in a previous blog post. The results here are from a small server for both cached and IO-bound workloads and replace my previous blog posts (cached, IO-bound)./ppThe reason for the false al [...]

Friday, 16. February 2024

Announcing MariaDB Community Server 11.3 GA and 11.4 RC (from MariaDB Corporation Blog)

We are pleased to announce the general availability (GA) of MariaDB Community Server 11.3 and the release candidate (RC) of … Continued [...]

MySQL HeatWave User Camp back in Bangalore (from The Oracle MySQL Blog)

MySQL HeatWave User Camp Bangalore [...]

Foreign key constraints are now generally available (from PlanetScale Blog)

You can now enable foreign key constraints to enforce referential integrity in your PlanetScale database. [...]

Installing Galera Cluster 4 with MySQL on Ubuntu 22.04 (from Galera Blog)

We have in the past covered Installing Galera Cluster 4 with MySQL 8 on Ubuntu 18.04 and also Installing Galera 4 with MySQL 8 on Ubuntu 20.04, and it would seem appropriate to also cover Ubuntu 22.04 LTS (Jammy Jellyfish). We do have excellent documentation and we also have the ability for you to automate […] [...]

Using the Oracle Cloud TypeScript SDK Part 2 - Managing MySQL HeatWave Instances (from The Oracle MySQL Blog)

In this post we will discuss how to use the OCI TypeScript/JavaScript SDK to retrieve information about a specific MySQL HeatWave instance and how to start/stop that instance programatically. [...]

Thursday, 15. February 2024

MySQL InnoDB: Primary Key always included in secondary indexes as the right-most columns… or not (from lefred's blog)

Recently during the Swedish MySQL User Group (SMUG), I presented a session dedicated to MySQL InnoDB Primary Keys. I forgot to mention a detail that many people are not aware, but Jeremy Cole has pointed out. Primary Key always included in secondary indexes at the right-most column When we define a secondary index, the secondary […] [...]

Use Amazon RDS Proxy and AWS PrivateLink to access Amazon RDS databases across AWS Organizations at American Family Insurance Group (from AWS Database Blog)

The American Family Insurance Group of companies includes American Family Insurance, CONNECT (powered by American Family Insurance), The General, Homesite, and Main Street America Insurance. It is the nation’s twelfth-largest property and casualty insurance group, ranking number 301 on the Fortune 500 list. Across these companies, the group has nearly 13,000 employees nationwide. The group […] [...]

Amazon Aurora Pricing: The many surprising costs of running an Aurora database (from PlanetScale Blog)

Amazon Aurora is pitched as a straightforward and scalable database service on AWS, but there are associated costs that you might not be aware of. [...]

Wednesday, 14. February 2024

What is Database Sharding? An Architecture Pattern for Increased Database Performance (from TiDB and TiKV Blog)

pDatabase sharding is a data architecture strategy that increases database performance by splitting up data into chunks and then spreading these chunks “intelligently” across multiple database servers (or database instances). These chunks of data are called shards, while each shard contains a subset of our data. All shards represent the entire set of data, and […]/p pThe post What is Database [...]

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

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

Using the Oracle Cloud TypeScript SDK Part 1 - Listing MySQL HeatWave Instances (from The Oracle MySQL Blog)

Oracle offers a variety of SKDs for interacting with Oracle Cloud Infrastructure resources. In this post we discuss how to list the MySQL HeatWave instances for a given compartment. [...]

Newsletter Repost – OpenLampTech issue #117 (from Digital Owl's Prose)

pTranslating database queries | WooCommerce variations meta fields | PHP shortcodes in WordPress | SQLite instead of MySQL or PostgreSQL? | Database first approach. Be sure you are subscribed to the weekly OpenLampTech newsletter so you don’t miss out on any of the content./p pThe post Newsletter Repost – OpenLampTech issue #117 appeared first on Digital Owl's P [...]

Open Source Business Models: Professional Services (from Peter Zaitsev)

pOpen Source is not a Business Model, rather it can support quite a few different Business Models. In this series of articles, I will look at some of those models with a focus on the models which work well embracing Open Source for Real. Professional Services – Consulting, Training, Custom Engineering is Perhaps one of […]/p pThe post Open Source Business Models: Professional Services appeare [...]

Let’s go, MariaDB ColumnStore at Vettabase! (from Vettabase)

I have been an avid user of Columnar based storage engines for as long as I have been a DBA. The advantage is instantly obvious once you and your teams start to write or convert queries which previously took tens of minutes, are now returning in fractions of a second. Just like when SSD’s became the standard, there was no going back to spinning rust. Having a columnar based engine built right [...]

Unveiling the Highlights: A Look Back at MySQL Belgian Days 2024 (from lefred's blog)

Our MySQL Belgian Days were a complete success. With 120 participants, the room was packed throughout the 2 days from the first to the last session. A record for this event ! The audience was made up of customers (some from very far away), users, contributors, community members and, of course, old friends. The atmosphere […] [...]

Tuesday, 13. February 2024

Unveiling the Highlights: A Look Back at MySQL Belgian Days 2024 (from The Oracle MySQL Blog)

Recap of the MySQL Belgian Days 2024 [...]

My Journey with MySQL Community and Beyond – MySQL Rockstar 2023 (from AskDba)

After the most memorable MySQL community event, #MySQLBelgianDays2024, and earning legendary recognition from the MySQL Community team, I have decided to share some thoughts about the importance of a community.  Previously in life As a former enterprise DBA, I have been part of other communities strictly focused on monetary and entitlement of accomplishments. I had […] [...]

Webinar: Mastering Galera Cluster, Best Practices and New Features 27th February (from Galera Blog)

Join us for an exclusive webinar tailored for database administrators and IT professionals aiming to enhance their systems’ efficiency and reliability using Galera Cluster. This session focuses on practical best practices, showcases new features, and provides an extended platform for your queries. What You Will Learn: * Core Best Practices: Dive into essential practices, from […] [...]

Three common MySQL database design mistakes (from PlanetScale Blog)

Learn about a few common mistakes when designing your MySQL database schema. [...]

Monday, 12. February 2024

Azure Database for MySQL - Single Server retirement - Key updates and migration tooling available (from Azure for MySQL Blog)

pAzure Database for MySQL - Single Server is scheduled for retirement by September 16, 2024./p p /p pAs part of this retirement, we stopped support for creating new Single Server instances via the Azure portal as of January 16, 2023, and beginning March 19, 2024, we’ll no longer support creating new Single Server instances via the Azure CLI. Should you still need to create Single Server instan [...]

Amazon RDS for MySQL supports new minor version 8.0.36 (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for MySQL now supports MySQL minor version 8.0.36. We recommend that you upgrade to the latest minor versions to fix known security vulnerabilities in prior versions of MySQL, and to benefit from the bug fixes, performance improvements, and new functionality added by the MySQL community. /p [...]

Tips and Tricks for reducing Leaf Block Contention happening to InnoDB (from MinervaDB Blog)

pLeaf block contention in InnoDB tables can significantly impact the performance of your MySQL database, especially under high concurrency. This situation typically occurs when multiple transactions are trying to modify or lock rows in the [...]/p pThe post Tips and Tricks for reducing Leaf Block Contention happening to InnoDB appeared first on The WebScale Database Infrastructure Operations Expert [...]

Considering Alternatives for Your MySQL Migration? Why Percona Should Be Your First Choice (from Percona Database Blog)

♦You know about MySQL; we know about MySQL. After all, it’s been the most popular database system for years now. And now that we have that out of the way, on to the more important stuff!Because MySQL is so popular, you might be considering migrating your database to MySQL Community Edition or MySQL Enterprise. If […] [...]

How to CONCAT in MySQL (from Francesco Tisiot Blog)

pOne of the most common tasks with strings is concatenation! This blog post showcases several techniques to perform it with MySQL./p [...]

Upgrading MySQL using the MySQL Configurator for Windows (from The Oracle MySQL Blog)

Getting started with MySQL Server 8.3.0, upgrades are now supported in the MySQL Configurator for Windows. [...]

Friday, 09. February 2024

Can Disk Space Be Saved in MySQL by Adding a Primary Key? (from Percona Database Blog)

♦Historically, MySQL does not require explicit primary key defined on tables, and it’s like that by default till this day (MySQL version 8.3.0). Such a requirement is imposed through two replication methods, though: Group Replication and Percona XtraDB Cluster (PXC), where using tables without a primary key is not allowed by default. There are many […] [...]

Recap of the 15th Mydbops Open Source Database Meetup: A Celebration of Collaboration (from Mydbops Blog)

The 15th Mydbops Opensource Database Meetup was not just an event; it was a convergence of minds, a celebration of innovation, and a testament to the boundless possibilities of database technology. As [...]

FOSDEM 2024 follow-up (from MariaDB Foundation Blog)

pWhat a FOSDEM weekend in Brussels! This was MariaDB Foundation’s best FOSDEM ever, although it wasn’t a FOSDEM at all. Confused? Stay tuned.br A live migration from MySQL 5.7br The highlight in several respects was the live migration of the Cantamen cluster from MySQL 5.7 to MariaDB 10.11. … /p pContinue reading \"FOSDEM 2024 follow-up\"/p pThe post FOSDEM 2024 follow-up appeared [...]

Thursday, 08. February 2024

MariaDB 11.2.3, 11.1.4, 11.0.5, 10.11.7, 10.6.17, 10.5.24, 10.4.33 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 10.11.7, MariaDB 10.6.17, MariaDB 10.5.24 and MariaDB 10.4.33, the latest stable releases in their respective long-term series (maintained for five years from their first stable release dates), as well as MariaDB 11.2.3, MariaDB 11.1.4 and MariaDB 11.0.5, the latest stable releases in their respective short-term series (main [...]

Maximizing Database High Availability with MariaDB MaxScale (from MariaDB Corporation Blog)

Depending on your application, high availability (HA) may be a requirement for your organization. If you’re running a banking system … Continued [...]

How to connect to Azure Database for MySQL – Flexible Server in a private network configuration (from Azure for MySQL Blog)

pAzure Database for MySQL is a fully managed, enterprise-ready service that provides high performance, scalability, and security for your MySQL applications. However, sometimes you might encounter connectivity issues when trying to access your database from different sources and networks. In this blog post, I’ll show you how to troubleshoot and resolve these types of issues based on three common ne [...]

Flex Your Tungsten Replicator Part 2: Another New Role (from Continuent Blog)

In this blog post, we explore how the new Tungsten Replicator thl-applier role allows a Replica node to apply THL even when the upstream source Replicator is OFFLINE. This new behavior provides for better control and performance under a variety of conditions.Tags: Transaction History Log (THL) [...]

Migration with Docker Official Images (from MariaDB Foundation Blog)

pIn this blog we will explore how to setup a docker compose file in order to migrate from MySQL 5.7 to the latest MariaDB.br In the next blog we will explain how to setup a docker compose file to migrate from MySQL 8.0 to MariaDB. … /p pContinue reading \"Migration with Docker Official Images\"/p pThe post Migration with Docker Official Images appeared first on MariaDB.org./p [...]

How to save money in AWS RDS – Upgrade to MySQL 8 (from Kedar MySQL Blog)

pMySQL 8 is around us for 5 years now. I believe you’re surely considering an upgrade. But if you’re on AWS and still on an older version of MySQL, this…/p The post How to save money in AWS RDS – Upgrade to MySQL 8 first appeared on Change Is Inevitable. [...]

Enhancing Database Stability in TiDB with Runaway Query Management (from TiDB and TiKV Blog)

pMaintaining database stability is paramount for any business, as unexpected dips in performance for critical systems can cause substantial losses. By streamlining change testing processes or employing new technologies, you can limit unforeseen incidents within a certain range. However, sudden SQL performance issues, such as drastic data volume changes, increasingly complicated queries, and partial [...]

Wednesday, 07. February 2024

Introducing Bring Your Own Certificate (BYOC) in MySQL HeatWave Service (from The Oracle MySQL Blog)

By default, all MySQL connections are secured through a MHS-defined certificate. BYOC extends the service by allowing users to select their own certificates to be used by the MySQL Server. With a few clicks, you can now set up your secured connections for MySQL HeatWave Service. The service facilitates both mutual TLS (requiring a connection wallet for the client) and one-way TLS, allowing clients [...]

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

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 11.2.3, 11.1.4, 11.0.5, 10.11.7, 10.6.17, 10.5.24, and 10.4.33 … Continued [...]

Cost optimize database migrations with AWS DMS: Part 2 (from AWS Database Blog)

In Part 1 of this series, we discussed database migration components, migration cost and its factors, and how to select right type of AWS DMS instance which determines the capacity of DMS jobs. In this post, we focus on how to regularly evaluate the AWS DMS instance size and scale up or down based on […] [...]

MySQL HeatWaveJP User Group Meetup on Feb 15 (from The Oracle MySQL Blog)

HWJP meetup 2/2024 [...]