Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
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.
How to Provision a MongoDB Cluster in Kubernetes with Percona Everest Summary
Kubernetes continues evolving, and the complexity of deploying and managing databases within the ecosystem is a topic of considerable discussion and importance these days. This article summarizes a detailed discussion between Piotr Szczepaniak and Diogo Recharte, who offer insights and live demonstrations to simplify database operations on Kubernetes with a new technology for cloud-native applications: Percona Everest. If you want to watch the full video, check out How to Provision a MongoDB Clu
Using ProxySQL Query Mirroring to test query performance on a new cluster
ProxySQL is an SQL aware proxy, which gives DBA’s fine grained control over clients’ access to the MySQL cluster. A key part of our DBA team’s process in testing and preparing for major MySQL version upgrades is comparing query plans using ProxySQL query mirroring. This feature allows us to mirror queries to another cluster / host, by configuring query rules. What makes mirroring particularly useful is the ability to selectively mirror queries based on the query digest, or client user.
Viewing MySQL Document Store Queries in HeatWave Using Database Management
Using the new support for MySQL HeatWave in Oracle Cloud Database Management, we can see what queries are executed when we run commands using MySQL Document Store. Keep reading to find out how.
Release Roundup April 30, 2024
Percona software releases and updates April 17 - April 30, 2024.
Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability.
Our Release Roundups showcase the latest Percona software
In-Database Machine Learning Model Development using Oracle’s MySQL Heatwave
This blog post illustrates how to use AutoML on MySQL Heatwave to train an optimized machine learning model to forecast crime
Percona Monthly Bug Report: February/March 2024
At Percona, we operate on the premise that full transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form, report back on any issues or bugs you might encounter along the way.
We constantly update our bug reports and monitor other boards to ensure we have the latest information, but we wanted to make it a little easier for you to keep trac
Pages
Sources:
MySQL expert Diary