Percona Server for MySQL 8.0.28-20 introduces a new keyring component, component_keyring_kms, which allows using the AWS Key Management Service as a keyring. The component is also included in Percona XtraBackup 8.0.28, allowing backing up databases encrypted with this component.

The feature is similar to the AWS keyring plugin included in MySQL Enterprise, but it is implemented as a component instead, and because of that, it requires a different configuration.

Configuring AWS KMS

The component uses a single Master Key on KMS, which has to be created manually before configuring the component. This key can also be changed later, and existing keys using the old key will remain usable, as long as the key still exists …

In this article I will show you how to properly configure Apache Zeppelin in order to take advantage of the Analytics and Machine Learning capabilities of MySQL HeatWave the MySQL in-memory query accelerator.

The post Interactively explore & visualize your MySQL HeatWave data with Apache Zeppelin first appeared on dasini.net - Diary of a MySQL expert.

The publication is growing and we are sharing the good stuff in this OpenLampTech newsletter issue. Developer interviews, a curated WordPress resource, and the LAMP stack coverage you expect are all coming at ya in issue #33…

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

In OpenLampTech issue #33, we have great content covering:

• Symfony components
• Is SQL Programming?
• WordPress FSE vs dynamic templating
• CakePHP CRUD
• Linux command-line practice articles
• And, much much more…

Shows how Estuda.com sustain phenomenal growth and 85% TCO savings using MySQL HeatWave on Oracle Cloud.

A blog post covering the Genius Sonority use case of MySQL HeatWave

This article explains how to install and configure the ODBC Driver Manager on Windows, macOS, and Linux. Also, it shows how to configure the ODBC data source name. Contents What is ODBC Driver Manager? How to Install ODBC Driver Manager Installing and Configuring an ODBC Driver Manager on Windows Installing and Configuring an ODBC Driver […]

The post Configuring an ODBC Driver Manager on Windows, macOS, and Linux appeared first on Devart Blog.

 Yes, SCaLE, or the Southern California Linux Expo is back. Friday is the MySQL track with eight presentations. A big thanks to all the presenters and we hope to see you at the LAX Hilton July 29th!

MySQL 8.0 New Features

• Dave Stokes
• Audience:Everyone
• Topic:MySQL
• MySQL now features quarterly releases that come with new features.  So if you do not know about hash joins, replica set, JSON document validation, or other new features then you need to be in this presentation.!
• Room:
• Carmel
• Time:
• Friday, July 29, 2022 - 10:00 to 11:00

State of MySQL Security in 2022

• Alexander Rubin
• Audience:Developer
• Topic:MySQL
• In this talk we will look into …

Imagine you need to design an online system for storing documents on a per-user basis where nobody, including database administrators, would be able to change the content of those documents without being noticed by document owners.

In Percona Server for MySQL 8.0.28-20, we added a new component called Encryption UDFs – an open-source alternative to MySQL Enterprise Encryption that allows users to access a number of low-level OpenSSL encryption primitives directly from MySQL. This includes calculating digests (with a great variety of hash functions), asymmetric key generation (RSA, …

Sure, wait event times in any database will include some CPU time, though ideally it should be minimal. Waits should be instrumented as close to the off CPU wait event as possible, i.e. if I’m doing an IO, then I want the wait to cover just the read call:

start_wait('my_read_wait');
pread( ... );
end_wait('my_read_wait');

So my function that sets up the read will do some CPU that could get caught under the cover of the wait itself and the call to pread will use some CPU but most of the time should be waiting for the actual I/O if the I/O is coming from storage.

start_wait('my_lock');
semtimedop(...);
end_wait('my_lock');

On MySQL I’ve noticed that average active sessions on CPU are often well below what the host reports as CPU utilization. For example if I have one connection on CPU a 100% of the time on a 2 vCPU host then CPU Utilization should be around 50%.  There might be …

I’m sharing another tip for anyone who wants to learn more about MySQL and how to use it. This post covers an example of the differences in columns specified in the WHERE clause but not the SELECT clause and vice-versa.

Image by Drizzt_Do_Urden from Pixabay 

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the …