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, 15. June 2024

Optimizing PostgreSQL Performance: Understanding and Managing Linux Page Types for Efficient Disk I/O (from MinervaDB Blog)

pDetailed Explanation of Linux Page Types and Their Influence on Disk I/O Performance in PostgreSQL Applications In Linux, memory management involves various types of pages, which are fundamental units of memory used by the operating [...]/p pThe post Optimizing PostgreSQL Performance: Understanding and Managing Linux Page Types for Efficient Disk I/O appeared first on The WebScale Database Infrast [...]

The Insert Benchmark vs MyRocks and InnoDB, small server, IO-bound database (from Small Datum)

pThis has results from the Insert Benchmark for many versions of MyRocks and MySQL (InnoDB)  on a small server with an IO-bound database and low-concurrency workload. It complements the results from the same setup but with a cached database./ppThe goal here is to document performance regressions over time for both upstream MySQL with InnoDB and FB MyRocks. If they get slower at a similar rate [...]

The Insert Benchmark vs MyRocks and InnoDB, small server, cached database (from Small Datum)

pThis has results from the Insert Benchmark for many versions of MyRocks and MySQL (InnoDB)  on a small server with a cached database and low-concurrency workload./ppThe goal here is to document performance regressions over time for both upstream MySQL with InnoDB and FB MyRocks. If they get slower at a similar rate from MySQL 5.6 to 8.0 then the culprit is code above the storage engine. Other [...]

Friday, 14. June 2024

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

pWe're pleased to share a summary of the Azure Database for MySQL - Flexible Server announcements from Microsoft Build 2024 and last month, as well as the latest roadmap of upcoming features!/p p /p June 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 s [...]

Let's take a look at Percona Everest 1.0.0 RC (from Percona Community Blog)

Hi, the Percona Everest 1.0.0-rc1 release was published on GitHub. Percona Everest is the first open source cloud-native platform for provisioning and managing PostgreSQL, MongoDB and MySQL database clusters. I want to tell you how to install it so you can try it out. RC builds aren’t meant for the general public; we don’t support upgrading from RC to stable versions. This means that th [...]

Thursday, 13. June 2024

New project: Awesome MariaDB list (from Vettabase)

At Vettabase, we’re delighted to announce our new project, sponsored by MariaDB Foundation: the Awesome MariaDB list on GitHub! We already interact with the MariaDB Foundation as Technology Partners, and this project is the newest outcome of our long-time friendship. Awsome lists are GitHub repositories that contain a curated collection of quality resources concerning a specific technology. A [...]

Sakila, Where Are You Going? (from Percona Database Blog)

♦At Percona, we monitor our users’ needs and try to accommodate them. One aspect we monitor is the MySQL version distribution/utilization. Observing that, we identified a very interesting trend: the lack of migration from 5.7 to 8.x, or better yet, the need of many to remain on 5.7.  That observation has triggered several actions from […] [...]

ClusterControl’s major version 2.0 release enhances its fit for modern workloads (from Severalnines Blog)

pWe’re thrilled to announce the release of ClusterControl (CC) v2.0! This major release introduces a host of exciting new capabilities designed to scale and enhance ClusterControl’s fit for modern workloads and applications. ClusterControl’s evolution – “Old dog with new tricks” ClusterControl v2.0 marks a significant milestone and evolution from its inception in 2011, supporting MySQL [̷ [...]

Efficient Text Search in MySQL Database with Full-Text Indexes (from Mydbops Blog)

In today's data-driven world, efficiently retrieving and managing text-based information is crucial for many applications, from search engines to content management systems. One of the powerful tools [...]

Managing MySQL Shell Configuration Options (from The Oracle MySQL Blog)

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss how to view and manage MySQL Shell configuration values. [...]

Wednesday, 12. June 2024

MyRocks and InnoDB vs sysbench on a small server (from Small Datum)

pThis has results from the sysbench benchmark for many versions of MyRocks and MySQL (InnoDB)  on a small server with a cached database and low-concurrency workload./ppThe goal here is to document performance regressions over time for both upstream MySQL with InnoDB and FB MyRocks. If they get slower at a similar rate from MySQL 5.6 to 8.0 then the culprit is code above the storage engine. Oth [...]

GCache and Record-Set Cache Encryption in Percona XtraDB Cluster – Part Two (from Percona Database Blog)

♦Keeping Your Data Safe: An Introduction to Data-at-Rest Encryption in Percona XtraDB Cluster. In the first part of this blog post, we learned how to enable GCache and Record-Set cache encryption in Percona XtraDB Cluster. This part will explore the details of the implementation to understand what happens behind the scenes. How does it work […] [...]

Tuesday, 11. June 2024

The Insert Benchmark, Postgres 17beta1, a small server and cached database (from Small Datum)

pThis post has results for the Insert Benchmark on a small server with a cached workload. The goal is to compare new Postgres releases with older ones to determine whether they get better or worse over time. The results here are from the newest small servers in my test cluster -- an ASUS PN53./ppThis work was done by Small Datum LLC./ppThe workload here has low concurrency (1 or [...]

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

New maintenance releases for MariaDB Enterprise Server 10.6.18-14, 10.5.25-19, and 10.4.34-24. These releases include a variety of fixes. Download Now … Continued [...]

How we improved push processing on GitHub (from The GitHub Blog)

pPushing code to GitHub is one of the most fundamental interactions that developers have with GitHub every day. Read how we have significantly improved the ability of our monolith to correctly and fully process pushes from our users./p pThe post How we improved push processing on GitHub appeared first on The GitHub Blog./p [...]

Introducing the Advanced Python Wrapper Driver for Amazon Aurora (from AWS Database Blog)

Building upon our work with the Advanced JDBC (Java Database Connectivity) Wrapper Driver, we are continuing to enhance the scalability and resiliency of today’s modern applications that are built with Python. The Advanced Python Wrapper Driver has been released as an open-source project under the Apache 2.0 License. You can find the project on GitHub. In this post, we provide details on how to use [...]

Early MySQL engineer questions whether Oracle is unintentionally killing off the open source database (from The Register)

Preference for proprietary features restricting open source MySQL adoption, says Peter Zaitsev pAn experienced MySQL database engineer has questioned whether Oracle might unintentionally kill off the open source database with its preference for adding features to its proprietary systems.…/p [...]

Basics of Performance in Snowflake – for Relational DBAs (from DataGeek.blog)

pI spent more than 20 years working with relational databases, gaining a deep expertise with Db2 LUW and a lesser expertise working with MySQL along with a bit of time spent on MS SQL Server, Oracle, and random other database platforms and database-adjacent tasks.… Read the rest /p [...]

Why is My Java Application Freezing Under Heavy I/O Load? (from Continuent Blog)

The Question p Recently, a customer asked us: /p blockquote p Why would heavy disk IO cause the Tungsten Manager and not MySQL to be starved of resources? /p p For example, we saw the following in the Manager log file tmsvc.log: /p/blockquoteTags: Clusterheavy loadJavaMySQLperformanceTungsten [...]

MySQL Connection Status with MySQL Shell (from The Oracle MySQL Blog)

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss how to view the details of the connection to a MySQL instance. [...]

Monday, 10. June 2024

The curse of MySQL warnings (from Ronald Bradford Blog)

MySQL warnings are an anti-pattern when it comes to maintaining data integrity. When the information retrieved from a database does not match what was entered, and this is not identified immediately, this can be permanently lost. MySQL by default for several decades until the most recent versions enabled you to insert incorrect data, or insert […] [...]

Is Oracle Finally Killing MySQL? (from Percona Database Blog)

♦Some 15 years ago, when Oracle acquired Sun, and hence MySQL, there was a lot of talk on the internet over when Oracle was going to “Kill MySQL”.  Multiple theories were circled around, ranging from killing MySQL altogether, so there is less competition to proprietary Oracle, or just killing it as an open source project, […] [...]

Friday, 07. June 2024

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

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

MySQL Tutorial (from Devart MySQL Tool Blog)

pWelcome to our MySQL Tutorial, tailored for both beginners and seasoned professionals! Participate in our MySQL training, led by industry experts, and master the art of database management. This program is your gateway to becoming a proficient and confident MySQL database professional./p pThe post MySQL Tutorial appeared first on Devart Blog./p [...]

GCache and Record-Set Cache Encryption in Percona XtraDB Cluster – Part One (from Percona Database Blog)

♦Keeping Your Data Safe: An Introduction to Data-at-Rest Encryption in Percona XtraDB Cluster. Data breaches are a major concern today. Whether you’re a business owner or value your privacy, the thought of your sensitive information being exposed is unsettling. Fortunately, data-at-rest encryption can help. Think of it as a sophisticated lock that scrambles your data, […] [...]

Scaling New Heights: Building Efficiency into Serverless Databases (from PingCAP Blog)

pServerless makes a promise. You, as a user, can focus on solving your users’ problems while someone else worries about the infrastructure. But not all parts of the tech stack are equally easy to make “serverless”. For example, it’s simple to see how stateless, short-running JavaScript in a standalone V8 instance is a prime candidate […]/p pThe post Scaling New Heights [...]

Sorting MySQL Tables by Size: Importance and How-To (from Another Boring Tech Blog)

pIntroduction Efficient database management ensures optimal performance, especially as your data grows. One important aspect of managing a MySQL database is monitoring and managing the size of your tables. Knowing which tables are the largest can help optimize queries, plan storage, and identify potential performance bottlenecks. Why Table Size Matters 1. Performance Optimization: Large tables.../p [...]

Thursday, 06. June 2024

Import Amazon RDS Enhanced Monitoring metrics into Amazon CloudWatch (from AWS Database Blog)

In this post, we show you how to import multiple Enhanced Monitoring metrics to CloudWatch and use the full capabilities of CloudWatch on those metrics. [...]

Configuring the Tungsten Connector for PCI Compliance (from Continuent Blog)

It is always a good idea to be mindful of open ports on your hosts, since they can be used by bad actors to gain access to your systems. For this reason, it is often desirable to prevent outside connections to the port whenever possible to prevent intrusions. For security purposes (and possibly PCI compliance), the Tungsten Connector proxy has the ability to bind to localhost/127.0.0.1 instead of l [...]

Server Upgrade Checks with MySQL Shell (from The Oracle MySQL Blog)

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss how to check if a database instance has any compatibility issues in upgrading to a newer versions of MySQL. [...]

Sysbench on a new small server: MariaDB vs MySQL (from Small Datum)

pThis has results from the sysbench benchmark for MariaDB and MySQL on a new, small server with a cached and low-concurrency workload. For MariaDB I tested LTS releases from 10.2 through 11.4. For MySQL I tested 5.6, 5.7 and 8.0. The results from MySQL here are a good reason to use changepoint detection to spot regressions early, like that provided by Nyrkiö./ppThis work was done by  [...]

Wednesday, 05. June 2024

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

pStarting today, Amazon Aurora MySQL 3.07 (with MySQL 8.0 compatibility) will support MySQL 8.0.36. In addition to security enhancements and bug fixes in MySQL 8.0.36, Amazon Aurora MySQL 3.07 includes several fixes and general improvements. For more details, refer to the Aurora MySQL 3 and MySQL 8.0.36.br br To upgrade, you can initiate a minor version upgrade manually by modifying your DB cluster [...]

MariaDB Node.js Connector 3.3.1 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Node.js 3.3.1 GA release. Download Now Release Notes MariaDB … Continued [...]

May Product Updates (from Readyset Blog)

May is over and it’s time for an update on what we’ve been shipping at Readyset! Let’s take a look at what’s changed. [...]

Start of Life for MariaDB 11.6 (from MariaDB Foundation Blog)

pWe normally announce releases and the end of life of releases, but today we are going to try something a little different, an announcement of “start of life”. … /p pContinue reading \"Start of Life for MariaDB 11.6\"/p pThe post Start of Life for MariaDB 11.6 appeared first on MariaDB.org./p [...]

Tuesday, 04. June 2024

Open Source Business Models: Open Core vs Crippled Core (from Peter Zaitsev)

pOpen Core is one of the very common ways to build a business around Open Source Software. It goes like this – you have an Open Source version of the software, often called “Community Edition” and there is also an extended version of the software, often called “Enterprise Edition” which is Proprietary software. These days […]/p pThe post Open Source Business Models: Open Core vs Cripple [...]

Sandboxes in MySQL Shell (from The Oracle MySQL Blog)

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss how to create and manage sandbox instances of MySQL on your local system. [...]

Monday, 03. June 2024

MySQL: Binary Log Transaction Compression (from Readyset Blog)

Learn how MySQL’s binary log transaction compression feature can save storage and reduce network usage. Explore the open source implementation. [...]

From Idea to Website: Building Your Online Platform with WordPress on Oracle Cloud Infrastructure (from The Oracle MySQL Blog)

In this blog, we introduce a Quick Start solution for deploying WordPress on Oracle Cloud Infrastructure (OCI). Discover how this solution leverages OCI's automation and MySQL HeatWave Database to effortlessly deploy a fully functional WordPress instance. [...]

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

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

Keeping an Eye on the Eye: Self-Monitoring for Percona Monitoring and Management (from Percona Database Blog)

♦Percona Monitoring and Management (PMM) is a powerful tool for keeping your databases healthy, but what about PMM itself?  While it comes pre-packaged as an appliance, PMM’s internal workings can be complex. Many users, including our internal teams, frequently ask: “How can I tell if everything inside PMM is functioning properly?” To address this need, […] [...]

2024 Continuent Tungsten Subscription Pricing (from Continuent Blog)

This blog post outlines our Continuent Tungsten pricing model for Tungsten Cluster software subscriptions and related 24/7 support.Tags: tungsten clusteringtungsten clusterMySQLmysql clusteringsubscriptionspricingopen sourcecommercial [...]

16th Mydbops Open Source Database Meetup: Dive Deep into Open-Source Tech! (from Mydbops Blog)

In the ever-evolving world of data management, open-source databases have become a cornerstone for innovation and efficiency. Mydbops stands at the forefront of this movement, fostering a vibrant comm [...]

Sunday, 02. June 2024

Optimizing Outer Joins with Aggregation in PostgreSQL: Best Practices and Examples (from MinervaDB Blog)

pPerforming optimal outer joins in PostgreSQL while doing aggregation involves understanding both the logical and performance aspects of SQL queries. Here are some best practices and examples to help you achieve this: Best Practices for [...]/p pThe post Optimizing Outer Joins with Aggregation in PostgreSQL: Best Practices and Examples appeared first on The WebScale Database Infrastructure Operatio [...]

Perl DBD MySQL for MySQL 8.0 and 8.4 LTS (from lefred's blog)

Some years ago, I wrote an article on connecting to MySQL 8.0 using the default authentication plugin (caching_sha2_password) with Perl. I also provided Perl-DBD-MySQL packages for EL7. Somebody recently left a comment as he was looking for a perl-DBD-MySQL driver compatible with the caching_sha2_password for Rocky Linux 8 (EL8 or OL8 compatible). Therefore, I build […] [...]

Take a Clone it will last longer (from Percona Community Blog)

So cloning is a great subject. I mean we clone sheep, we can clone human organs in time we might be able to clone humans, but thats a topic for scientist and philosophers. What is MySQL Replicaion: The MySQL clone plugin can be used to replicate data from a MySQL server to another MySQL server, and it supports replication. The cloning process creates a physical snapshot of the data, including table [...]

Saturday, 01. June 2024

Implementing a Custom date_bucket() Function in PostgreSQL for Timestamp Bucketing (from MinervaDB Blog)

pThe date_bucket() function in PostgreSQL is a powerful tool for time series analysis. It allows you to group timestamps into fixed-size intervals, often referred to as “buckets.” This grouping is useful for aggregating and analyzing [...]/p pThe post Implementing a Custom date_bucket() Function in PostgreSQL for Timestamp Bucketing appeared first on The WebScale Database Infrastructure Operations [...]

Friday, 31. May 2024

Why MySQL Replication Is Fast (from Hack MySQL)

pReplication being slow—replication lag—is a common complaint, but MySQL replication is actually really fast. Let’s run a controlled experiment and peek inside the Performance Schema and binary logs to see why./p [...]

Thursday, 30. May 2024

MariaDB 11.4.2 and MariaDB 11.5.1 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 11.5.1, a Release Candidate (RC) in the rolling release, and MariaDB 11.4.2, the first Generally Available (GA) release in the MariaDB 11.4 series. … /p pContinue reading \"MariaDB 11.4.2 and MariaDB 11.5.1 now available\"/p pThe post MariaDB 11.4.2 and MariaDB 11.5.1 now available appeared first on MariaDB.org./p [...]

What happened to Digital Tech Trek Digest? (from Ronald Bradford Blog)

I started 2024 with several goals. The first goal was to iterate over some weekend project ideas and actually deploy them. These were never designed to make money or have widespread value; they were an exercise in iterating over an idea in preparation for a larger project. This led to InstanceHunt, which turned out to […] [...]

Announcing MariaDB Community Server 11.5 RC (from MariaDB Corporation Blog)

We are pleased to announce the release candidate (RC) of MariaDB Community Server 11.5. Our next release series includes plenty … Continued [...]

Aurora - Rebooted without Permission! (from Continuent Blog)

AWS may reboot your Aurora database. What is the impact?Tags: AWSAurorareboot [...]

Getting Help in MySQL Shell (from The Oracle MySQL Blog)

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we talk discuss the comprehensives help system in MySQL Shell. [...]

Wednesday, 29. May 2024

MariaDB Community Server 11.4 With Improved Query Performance, Now GA With Long Term Maintenance (from MariaDB Corporation Blog)

Today, we released MariaDB Community Server 11.4 as GA. This is the first release series since MariaDB Community Server 10.11 … Continued [...]

Public Preview announcement - Azure DMS consistent snapshot without locks (from Azure for MySQL Blog)

pWe’re pleased to announce that Azure DMS now provides preview support for consistent snapshot without locks, which businesses can use to migrate databases to Azure while those databases remain operational. MySQL Consistent Snapshot without locks is a new feature that allows users to take a Consistent Snapshot of a MySQL server without losing data integrity at source./p p /p pWhen you enable t [...]

Valkey/Redis: Setting Up Replication (from Percona Database Blog)

♦In most database systems, like MySQL, PostgreSQL, and MongoDB, replication of some kind is used to create a highly available architecture. Valkey/Redis is no different in this regard. Replication is native functionality to Valkey, supporting multiple replicas, and even chains of replication. To clear up any confusion, understand that Valkey replication is a different concept […] [...]

How Intel helps MariaDB become even faster (from MariaDB Foundation Blog)

pThere are many forums in the past couple of years where I have talked about how non-code contributions are just as important to MariaDB Server and us at the MariaDB Foundation as the code contributions I typically help with. … /p pContinue reading \"How Intel helps MariaDB become even faster\"/p pThe post How Intel helps MariaDB become even faster appeared first on MariaDB.org./p [...]

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

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

MySQL New York Meetup Returns (from The Oracle MySQL Blog)

MySQL Meetup [...]

Beyond The Horizon: Mastering Percona Server for MongoDB Exposure in Kubernetes – Part Two – Istio (from Percona Database Blog)

♦This is the second part of the series of blog posts unmasking the complexity of MongoDB cluster exposure in Kubernetes with Percona Operator for MongoDB. In the first part, we focused heavily on split horizons and a single replica set.  In this part, we will expose a sharded cluster and a single replica set with […] [...]

TiDB Cloud Now Supports OAuth 2.0 for a More Secure Login Experience (from PingCAP Blog)

pTiDB Cloud is a powerful MySQL-compatible database-as-a-service (DBaaS) for diverse industries, trusted by many leading companies such as Catalyst and CAPCOM. Today, we’re thrilled to announce a major update: TiDB Cloud now supports OAuth 2.0! OAuth 2.0 is a secure authorization protocol that lets you leverage existing login credentials from platforms like Google, Microsoft, and […]/p [...]

What's New in TiDB 8.1.0, the latest LTS release? Performance, Security, & More! (from Mydbops Blog)

Author: Kabilesh PR, Founding Partner, Mydbops The wait is over! TiDB 8.1.0, the latest Long-Term Support (LTS) release, just arrived on May 24th, 2024, bringing a wave of innovation to the distribut [...]

Tuesday, 28. May 2024

Create a fallback migration plan for your self-managed MySQL database to Amazon Aurora MySQL using native bi-directional binary log replication (from AWS Database Blog)

In this post, we show you how to set up bi-directional replication between an on-premises MySQL instance and an Aurora MySQL instance. We cover how to configure and set up bi-directional replication and address important operational concepts such as monitoring, troubleshooting, and high availability. In certain use cases, native bi-directional binary log replication can either provide a simpler fal [...]

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

pUpdated May 28, 2024/p p /p 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 General Availability of Azure Databas [...]

A MySQL 8.4.0 branch with patches (from Laurynas Biveinis' blog)

pWhile writing the previous post, I noticed that I didn't have a central location for the patches that I submitted to Oracle. Some were in local branches, some were .patch files lying around. So now I pushed a tree that has all those patches applied in a single place: patched-mysql-8.4.0, and I even added a README. This tree hopefully will make it easier to rebase on future Oracle releases. I had m [...]

Simplifying database orchestration anywhere with Terraform and ClusterControl (from Severalnines Blog)

pDive into how Terraform and ClusterControl revolutionize Infrastructure as Code (IaC) for database deployment. Learn to maintain control over your infrastructure and automate both open-source and proprietary databases with our detailed guide on using ClusterControl's Terraform provider for deploying a MySQL replication cluster. Perfect for DevOps teams seeking flexibility across various environmen [...]

Beyond the Horizon: Mastering Percona Server for MongoDB Exposure in Kubernetes – Part One (from Percona Database Blog)

♦Running and managing MongoDB clusters in Kubernetes is made easy with the Percona Operator for MongoDB. Some aspects are just easy to grasp as they are well defined in the operator custom resources and documentation, but some are often considered to be a hidden craft. Network exposure in cases of sharded clusters is quite straightforward, […] [...]

Choosing the Best GUI Client for SQL Databases (from Devart MySQL Tool Blog)

pMost SQL GUI tools share common features that can enhance one’s experience working with a database. We have listed some of the most important ones, as well as made a short comparison table where we analyze the most popular SQL GUI clients and highlight what they have under the hood. /p pThe post Choosing the Best GUI Client for SQL Databases appeared first on Devart Blog./p [...]

Machine Learning with MySQL HeatWave and predictions in Grafana (from The Oracle MySQL Blog)

How to visualize predictions in Grafana using MySQL HeatWave Machine Learning [...]

Machine Learning with MySQL HeatWave and predictions in Grafana (from lefred's blog)

In MySQL HeatWave, the Database as a Service (DBaaS) offered by Oracle, Machine Learning is incorporated to provide database administrators (DBAs) and developers with an optimal experience. Those tools are the Auto ML advisors like the autopilot indexing for example. MySQL HeatWave is also an invaluable asset for Data Analysts, offering straightforward tools that streamline […] [...]

875X improvement from RonDB 21.04.17 to 22.10.4 (from Mikael Ronstrom)

pAt Hopsworks we are working on ensuring that the online feature store will be able to perform complex join operations in real-time. This means that queries that could use data from multiple tables can be easily integrated into machine learning applications./ppToday most feature stores use key-value stores like Redis and DynamoDB. These systems have no capability to issue complex join queries, if t [...]

Executing System Commands in MySQL Shell (from The Oracle MySQL Blog)

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we talk about how to execute system commands inside MySQL Shell. [...]

Friday, 24. May 2024

What's cooking in RonDB (from Mikael Ronstrom)

p Here is a short update on what is going on in the RonDB development. We recently launched the new RonDB release 22.10.2./ppWe are now working on a number of major improvements and new features./ppThe first feature we are working on is what we call Pushdown Aggregation. In the first step it will be able to perform Pushdown of aggregation on a single table. This is useful for Hopsworks Feature [...]

Export backups on-demand in Azure Database for MySQL - Flexible Server (from Azure for MySQL Blog)

pWe’re pleased to announce public preview of the On-demand backup and export feature for Azure Database for MySQL - Flexible Server, which allows you to export a physical backup of your flexible server to an Azure storage account (Azure blob storage) whenever the need. You can use these backups for data recovery and to fulfill organization auditing and compliance requirements. You can also dow [...]

Build or buy: Self-run Vitess vs Managed Vitess with PlanetScale (from PlanetScale Blog)

PlanetScale and Vitess have a close relationship. Learn what it looks like to run Vitess on your own vs using PlanetScale. We cover cost, time to implement, management, and more. [...]

Understanding THL, Events and Storage: Part 1 (from Continuent Blog)

When Tungsten Replicator extracts data, the information that has been extracted is written down into the Tungsten History Log, or THL.Tags: MySQLReplicatorTHL [...]

Space vs CPU tradeoffs with universal compaction in RocksDB (from Small Datum)

pThis post explains the impact of compression for write-heavy workloads with universal compaction in RocksDB. With an LSM you can spend on CPU to save on space. For leveled compaction I normally use no compression for L0, L1 and L2 because compressing them has a small impact on space but costs a lot in CPU and write stalls. My advice for universal compaction is similar -- don't compress everything. [...]

Thursday, 23. May 2024

New open-source AWS Advanced Python Wrapper driver now available for Amazon Aurora and Amazon RDS (from AWS What's New)

pThe Amazon Web Services (AWS) Advanced Python Wrapper driver is now generally available for use with Amazon RDS and Amazon Aurora PostgreSQL and MySQL-compatible edition database clusters. This database driver provides support for faster switchover and failover times, and authentication with AWS Secrets Manager or AWS Identity and Access Management (IAM).br br The AWS Advanced Python Wrapper drive [...]

Advancements in the Business Critical service tier for Azure Database for MySQL - Flexible Server (from Azure for MySQL Blog)

pWe are excited to announce advancements in the Business Critical service tier for Azure Database for MySQL - Flexible Server. Following our commitment to deliver the best performance and availability for your mission critical workloads, we are bringing enhancements that will elevate your database experience./p p /p Enhanced storage capabilities pIn addition to performance enhancements, we hav [...]

How to Migrate From MariaDB to MySQL (from Percona Database Blog)

♦MySQL and MariaDB are two major open source database management systems that share a common codebase and history. MariaDB started as a MySQL fork in 2009 to provide an alternate database version following Oracle’s acquisition of MySQL. While MariaDB has many features and has grown in popularity among users seeking a more open and community-driven […] [...]

Running External Scripts in MySQL Shell (from The Oracle MySQL Blog)

MySQl Shell offer many features to make life easier for DBAs and developers. In this post we talk about how to execute external JavaScript, Python, or SQL files indie MySQL Shell. [...]

Wednesday, 22. May 2024

MariaDB plc: Shareholders speak, but execs are quiet (from InfoWorld)

pThere appears to be many questions and few answers about MariaDB plc’s long-term strategy following an announcement that its shareholders have accepted an offer by California-based investment firm K1 Investment Management./ppNews that the company that provides database and SaaS services around the open-source database MariaDB had been acquired came on Monday, when it was announced that a trio o [...]

Recently a Continuent Customer Asked: How Does Tungsten Replicator Handle Transient Errors When Applying to AWS Redshift? (from Continuent Blog)

In this blog, part of a series of “Recently a Customer Asked” posts for Tungsten University, we explore the reason for the occasional Tungsten Replicator OFFLINE:ERROR state when applying to AWS Redshift, along with possible steps to compensate for the issue.Tags: MySQLMariaDBreplicationRedshift [...]

Amazon RDS Extended Support APIs are now available (from AWS What's New)

pAmazon Aurora and Amazon Relational Database Service (RDS) announce the availability of Extended Support APIs for automated database management. You can use these APIs to create new databases or restore existing snapshots, and specify whether or not they will be in Extended Support. You can also use these APIs to view the Extended Support status of your existing databases. When your databases are [...]

Microsoft Copilot in Azure - Unlock the benefits of Azure Database for MySQL with your AI companion (from Azure for MySQL Blog)

pMicrosoft Copilot in Azure (Public Preview) is an AI-powered tool to help you do more with Azure. Copilot in Azure extends capabilities to Azure Database for MySQL, allowing users to gain new insights, unlock untapped Azure functionality, and troubleshoot with ease. Copilot in Azure leverages Large Language Models (LLMs) and the Azure control plane, all of this is carried out within the framework [...]

HTAP Summit 2024 Call for Proposals (CFP) is Now Open! (from PingCAP Blog)

pHTAP Summit, the only industry-leading conference focused on Hybrid Transactional/Analytical Processing (HTAP), has officially opened its 2024 call for proposals. Now in its third year, HTAP Summit, organized by PingCAP, gathers database experts, innovators, and enthusiasts to share knowledge and experience about distributed database architecture, real-time operational intelligence and ways modern [...]

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

Where is MySQL, 6-9, 2024 [...]

Why you should use SQLite (from InfoWorld)

pLift the hood on most business applications, and you’ll find they have some way to store and use structured data. Whether it’s a client-side app, an app with a web front end, or an edge-device app, chances are a business application needs a database. In many cases, an embedded database will do. Embedded databases are lightweight, compact, and portable—and for some applications, they are a bette [...]

Making my MySQL InnoDB Cluster safe from naughtiness (from MySQL-Med)

Protecting InnoDB Cluster from naughty DBA's and Dev's: Make sure everything has a PK and is in InnoDB... Continue reading → [...]

Using Oracle Analytics Cloud with MySQL HeatWave (from The Oracle MySQL Blog)

In this article, we will see how to connect OAC to MySQL HeatWave in OCI. [...]

Using Oracle Analytics Cloud with MySQL HeatWave (from lefred's blog)

MySQL HeatWave is the MySQL DBaaS provided by Oracle in OCI and some other clouds. Compared to the vanilla MySQL, one of the key features of the service is that it allows you to run analytics queries (aka OLAP) very quickly using the HeatWave cluster. You can also run such queries on files using LakeHouse. […] [...]

MySQL Transparent Read-Write Splitting with MySQL Router 8.2 (from Mydbops Blog)

The Need for Load Balancing Efficient load balancing among servers is crucial to ensure that all servers contribute efficiently to serving application traffic. Without proper load distribution, a sin [...]

Tuesday, 21. May 2024

Public Preview: Microsoft Copilot now offers supportability in Azure Database for MySQL (from Azure Updates)

Microsoft Copilot in Azure extends capabilities to Azure Database for MySQL. [...]

Generally Available: Accelerated logs in Azure Database for MySQL - Flexible Server (from Azure Updates)

Gain a performance boost in the Business Critical service tier of Azure Database for MySQL - Flexible Server with accelerated logs. [...]

Microsoft Defender for Cloud support for Azure Database for MySQL - Flexible Server - GA (from Azure for MySQL Blog)

pWe’re excited to announce general availability of Microsoft Defender for Cloud support for Azure Database for MySQL - Flexible Server. Defender for Cloud provides Advanced Threat Protection (ATP) as part of the Microsoft Defender for open-source relational databases plan and simplifies security management of your MySQL flexible server by enabling effortless threat prevention, detection, and mitiga [...]

Build 2024: Unveiling performance and AI innovations in Azure Database for MySQL (from Azure for MySQL Blog)

pToday, we're thrilled to announce a suite of new features for Azure Database for MySQL that focus on performance enhancements, enterprise capabilities, and cutting-edge AI functionality designed to revolutionize your database management experience and efficiency. Read on to see how these innovations can elevate your workflows!/p p /p p♦/p   Microsoft Copilot in Azure: Unlock the benefits [...]

Private equity offer for MariaDB gets thumbsup from shareholders (from The Register)

From SPAC and back as 68% say yes pMariaDB shareholders have backed a private equity takeover offer for the troubled database vendor.…/p [...]

High Availability: Choosing the Right Option for Your Percona Monitoring and Management (from Percona Database Blog)

♦Ensuring your monitoring system stays up and running is vital. High availability (HA) minimizes downtime for Percona Monitoring and Management (PMM) during hardware failures, in times of disaster recovery, or increased usage of the tool. It’s not just about extra storage, RAM, or CPU but rather having redundant systems ready to take over seamlessly, like […] [...]

MariaDB Enterprise Server Available on Nutanix Database Service (from MariaDB Corporation Blog)

Today at the Nutanix .NEXT conference in Barcelona, Spain, we announced the upcoming general availability of MariaDB Enterprise Server on … Continued [...]

Debugging JavaScript Stored Functions in MySQL (from The Oracle MySQL Blog)

MySQL Enterprise and MySQL HeatWave now support writing stored functions and procedures using JavaScript. In this post we show how to debug JavaScript code used to create stored functions. [...]