Overview MySQL HeatWave on AWS is a fully managed database service, powered by the integrated HeatWave in-memory query accelerator. It’s the only cloud database service that combines transactions, analytics, and machine learning services across data stored in MySQL and data lake, delivering real-time, secure analytics without the complexity, latency, and cost of extract, transform, and […]

Support for MySQL FIDO authentication in Java was introduced in MySQL Connector/J 8.0.28 with the implementation of the client-side authentication plugin authentication_fido_client. This implementation is FIDO compliant but we quickly realized we were also interested in supporting some newer FIDO2 features as well. Unfortunately, the original implementation couldn’t be extended and we needed to come […]

Not long ago, multifactor authentication and support for FIDO were added to MySQL. Although the original FIDO authentication has now been deprecated in favor of an improved, FIDO2 authentication mechanism—the Web Authentication (WebAuthn); both share the premise that a user must possess an authentication device and use it to certify that the person is who they claim to be. Connector/J supports both and in this post I will show how the WebAuthn authentication can be used.

We are excited to launch the Independent Software Vendor (ISV) Catalog for MySQL HeatWave.  This catalog will enable both customers and partners to easily find 3rd party ISV products and services for MySQL HeatWave.     MySQL HeatWave is a fully managed database service for transactions, real- time analytics across data warehouses and data lakes, […]

This Independent Software Vendor (ISV) Catalog for MySQL HeatWave will enable both customers and partners to easily find 3rd party ISV products and services for MySQL HeatWave.    

A comprehensive continuous integration (CI) and continuous deployment (CP) process should include automated testing of code. In this post, we will discuss how to use GitHub Actions to run tests for Node.js code that interacts with a MySQL database.

Recently, I have been talking about how to write and run tests for Node.js code that interacts with a MySQL database. These posts have included details on how to use third-party libraries such as Testcontainers to run the tests in a clean database and Knex to manage database changes. Today, I will discuss how to automate running these tests using GitHub Actions when […]

Transparent Huge Pages (THP) is a memory management feature in Linux operating systems that aims to enhance system performance. While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. In this post, we will explore THP, its impact on database servers, and how to disable it for optimal performance and stability.

What are Transparent Huge Pages?

In order to understand THP, we should first start with a brief description of Linux HugePages. The concept of HugePages in Linux has existed for many years, first introduced in 2007. By default, the majority of widely used Linux distributions employ a virtual memory page size of 4KB. However, the inclusion of the HugePages feature allows the Linux kernel to efficiently handle substantial memory pages alongside the standard 4KB size.

In order for an application to utilize HugePages, however, it must explicitly include an …

As previously announced on Aug 15, 2023, you can find the MySQL team at following conferences in October 2023: Please mark your calendars and we look forward to speaking with you!        

Where can you find MySQL team in October 2023