Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Query and Transaction size in MySQL
Some times it’s important to know the size of a transaction, especially when you plan to migrate to a HA solution where by default transactions have a limited size to guarantee an optimal behavior of the cluster. Today we will see the different possibilities to have an idea of the size of transactions. First we […]
MySQL HeatWave on AWS is now available in AWS Asia Pacific (Tokyo) region
MySQL HeatWave on AWS is now available in AWS Asia Pacific (Tokyo) region MySQL HeatWave on AWS is now available in Japan Tokyo region. The new region enables customers with applications deployed in the Tokyo region to: Minimize network latency between the application and database, enhancing the user experience on the application Reduce the high […]
How to get client’s IP address when using MySQL Router ?
When you connect to a server (or cluster) using a TCP proxy level 7, also referred to as an application-level or Layer 7 proxy (highest level of the OSI model), the application doesn’t connect directly to the back-end server(s). The proxy usually understands the protocol used and can eventually take some decisions or even change […]
MySQL Heatwave: Authenticate using OCI IAM Security Token
Overview OCI MySQL Heatwave allows customers to use OCI user accounts to authenticate using authentication_oci plugin. Up to MySQL 8.0.32, this required an API Key pair. Starting with MySQL 8.0.33, the plugin also supports the IAM Security token generated using the OCI CLI. Since only local and provisioned users have access to the API Key-Pair, […]
Quick Tour of MySQL HeatWave on AWS
Quick Tour of MySQL HeatWave on AWS MySQL HeatWave on AWS is a fully managed MySQL database service running on Amazon Web Services (AWS). It is built on the Enterprise Edition of the MySQL Database and is the only MySQL service with a scalable, integrated, real-time query accelerator with machine learning-based automation (MySQL Autopilot), […]
Announcing MySQL Server 8.0.33
On April 18 2023, MySQL Server 8.0.33 was released. It is the latest release of our MySQL 8.0 General Availability Release. The new release introduces a few new features alongside with some deprecations, as well as bugfixes and security fixes. New MySQL Enterprise Edition Data Masking Component MySQL Enterprise Edition now provides data masking and de-identification capabilities […]
Announcing MySQL InnoDB ReplicaSet/Cluster/ClusterSet & MySQL Shell 8.0.33
MySQL Shell 8.0.33 was released last week. Apart from several bugfixes, there are some new, important, and long-desired features related to security, concurrency control, and performance settings. Passwordless authentication (certificate-based authentication) The AdminAPI enables an easy set-up and maintenance of MySQL deployments, either for High Availability or Disaster Recovery. Security is crucial and InnoDB Cluster has support for […]
Connecting to a MySQL HeatWave Database Instance Using OpenVPN
MySQL HeatWave Database is a fully managed service on Oracle Cloud Infrastructure (OCI) that is developed, managed, and supported by the MySQL team at Oracle. When you provision a new MySQL instance under OCI, you can only connect to the database from inside the OCI network. While this is a great security feature for production services hosted in […]
MySQL 8.0.33: thank you for the contributions
The latest MySQL release has been published on April 18th, 2023. This new version of MySQL brings a new service that I’m excited to play with: Performance Schema Server Telemetry Traces Service. MySQL 8.0.33 contains bug fixes and contributions from our great MySQL community. I would like to thank all contributors on behalf of the […]
Introducing JSON/Relational Duality for MySQL REST Service
JSON/Relational Duality for MySQL REST Service The MySQL REST SERVICE (MRS) now adds full support for JSON/Relational Duality to combine the benefits of both relational tables and JSON documents, without the tradeoffs of either model. MySQL Shell for VS Code offers full SQL support for JSON/Relational Duality REST views and an intuitive, easy-to-use JSON/Relational Duality […]