Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Integrated MySQL Certificate-based & Password-less Authentication in MySQL InnoDB ClusterSet
Starting with MySQL Shell 8.0.33, it’s possible to fully enable SSL/TLS certificate-based authentication seamlessly across an InnoDB Cluster, ClusterSet or, ReplicaSet setup. Let’s dive into the details of the new features with complete examples of how to set up the strongest encryption configuration possible. Certificate Based Authentication For Intra-node Communication To secure and validate users for the […]
Helidon + MySQL Document Store
Written by Mitia Alexandrov We are used to working with databases through SQL. It has been this way for decades. Time has shown that in the enterprise world, we mostly keep and manage data in relational databases and use object-oriented practices in our software since most enterprise programming languages are object-oriented, including Java. Although Java […]
Moving MySQL Databases from AWS to OCI Using MySQL Shell
In previous posts, we talked about how we can use MySQL Shell to dump and load databases and how we can dump data to and from Oracle Cloud Infrastructure (OCI) buckets. In this post, we are going to show how you can use MySQL Shell to dump data from a MySQL RDS database to an S3 bucket and then load that […]
Tuning BLOB for performance in NDB [Part 1]
On MySQL Cluster, a shared-nothing cluster solution, the user has access to the full power of the SQL language to configure their own tables through the MySQL frontend. Not all the features of the NDB storage engine are exposed via SQL, and thus available solely through the NDB API. It is one of those features, […]
Apache Superset with MySQL HeatWave
Apache Superset is an open source BI, Reporting, Charting tool that competes with Tableau, Looker, etc. For a list of companies that have deployed Superset, see: https://github.com/apache/superset/blob/master/RESOURCES/INTHEWILD.md. Superset is loaded with options that make it easy for users of all skill sets to explore and visualize their data, from simple line charts to highly detailed geospatial […]
Centralize Access Management for MySQL Heatwave Databases with OCI IAM
MySQL Heatwave, a fully managed database service, not only provides customers with one database service for OLTP, OLAP, and ML, but it also supports centralized access management for these databases via integration with OCI IAM. Using Oracle Cloud Infrastructure Identity and Access Management (OCI IAM) customers can protect themselves against security threats, streamline access management, and […]
TaranovoConf Bulgaria with MySQL talk
TarnovoConf, Jun 17, 2023, Veliko Tarnovo, Bulgaria We are happy to announce the participation of MySQL in the small regional technical conference TarnovoConf. TaranovoConf is part of the IT Tour-travel conferences in Bulgaria initiated by a group of local enthusiasts and includes a series of technical conferences in major Bulgarian cities. At this one, scheduled […]
Using MySQL Shell to Dump Data To And Read Data From OCI Storage Buckets
In a previous post, we discussed how you could use MySQL Shell to dump and load data using a multithreaded process. At the end of the post, I mentioned it was possible to dump data to and load data from cloud services such as Oracle Cloud Infrastructure (OCI). In this post, I will show you how to perform these data […]
MySQL HeatWave on AWS is now available in AWS Asia Pacific (Mumbai) region
MySQL HeatWave on AWS is now available in AWS Asia Pacific (Mumbai) region Last month, we announced the availability of MySQL HeatWave on AWS in AWS Japan (Tokyo) region. We have now extended the availability to AWS India (Mumbai) region. The new region enables customers with applications deployed in AWS Asia Pacific (Mumbai) region to: […]
The New MySQL Thread Pool
Preface This blog begins by introducing an alternative and optional thread handling mechanism called MySQL Thread Pool, available in the MySQL Enterprise Edition. It then delves into the “Max Transaction Limit” feature that was added to MySQL Thread Pool in MySQL 8.0. The blog shows the recommended MySQL Thread pool configuration and proceeds to compare […]