Showing entries 21 to 30 of 43579
« 10 Newer Entries | 10 Older Entries »
Filtering JSON Arrays with JavaScript in MySQL

MySQL Enterprise and MySQL HeatWave now support writing stored functions and procedures using JavaScript. In this post we show how to tap into the power of JavaScript to filter an array of objects based on the value of one of the properties of the object.

Galera Cluster for MySQL 8.0.36-26.18 released

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.36-26.18 (release notes, download). There is no change to the Galera replication library 4.18 (release notes, download) implementing wsrep API version 26. This release incorporates all changes to MySQL 8.0.36, adding a synchronous option for your MySQL High Availability solutions.

This is a …

[Read more]
MySQL NDB Cluster replication: Dual-channel replication for redundancy

Learn how to setup MySQL NDB Cluster replication using redundancy to continuously replicate data and be fully online during upgrade and maintenance.

Using the Oracle Cloud Infrastructure Vault Keyring Component in MySQL Heatwave

The component_keyring_oci keyring component is advanced, flexible and have fewer restrictions than the keyring_oci plugin. It can be loaded using the manifest and configuration file.

Using the component_keyring_encrypted_file Encrypted File-Based Keyring Component in MySQL

The component_keyring_encrypted_file keyring component is advanced, flexible and have fewer restrictions than the keyring_encrypted_file plugin. It can be loaded using the manifest and configuration file.

Using the component_keyring_file File-Based Keyring Component in MySQL

The component_keyring_file keyring component is advanced, flexible and have fewer restrictions than the keyring_file plugin. It can be loaded using the manifest and configuration file.

Introducing Keyring Components in MySQL

The keyring components are advanced, flexible and have fewer restrictions than the keyring plugins. And all it requires is a few simple steps to switch.

Using JavaScript to Search JSON Arrays in MySQL

MySQL Enterprise and MySQl HeatWave now support writing stored functions and procedures using JavaScript. In this post we show how to tap into the power of JavaScript to easily search an array for a particular value.

MySQL 8.4 First Peek

MySQL 8.4 has now been officially released, and this is a quick review of what is in the release notes. This is momentous as it is designated a Long-Term Support (LTS) release. Various 8.0 releases introduced material changes that impacted speed and stability, causing hair-pulling and swearing among those affected. Please note this is a […]

MySQL 8.4 LTS – new production-ready defaults for InnoDB

Yesterday, MySQL 8.4, the very first LTS version of MySQL was released.

A lot of deprecations have finally been removed, and several InnoDB variable default values have been modified to match current workloads and hardware specifications.

The default value of 20 InnoDB variables has been modified!

Let’s have a look at those variables and explain the reason for such modification:

innodb_buffer_pool_in_core_file

Previous Value: ON
New Value (8.4 LTS): OFF if MADV_DONTDUMP is supported
else ON

MADV_DONTDUMP is a macro supported in Linux 3.4 and later, (“sys/mman.h” header file is present and contains the symbol MADV_DONTDUMP, a …

[Read more]
Showing entries 21 to 30 of 43579
« 10 Newer Entries | 10 Older Entries »