Planet MySQL HA Blog

The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.

Offline mode error improvement

Problem Your MySQL server can end up in offline (maintenance) mode, and suddenly your client connections start to get rejected with a generic error ER_SERVER_OFFLINE_MODE: “The server is currently in offline mode”.   There can be a number of reasons why this happens, for example an admin set the offline_mode system variable to put the […]

Learn More »

MySQL Enterprise Edition for Financial Services

In today’s fast-paced financial landscape, organizations must embrace digital transformation to stay competitive. MySQL Enterprise Edition has empowered over 700 financial services firms to navigate this shift effectively. With its proven performance and scalability, MySQL is uniquely positioned to support demanding applications while ensuring data protection and regulatory compliance.   Overview MySQL Enterprise Edition offers […]

Learn More »

TLS in MySQL NDB Cluster 8.4 with MCM 8.4

MySQL NDB Cluster Manager 8.4, or MCM 8.4, was recently released as part of the 8.4 LTS (Long Term Support) release series by the MySQL team. If you are unfamiliar with MCM, it is a commercial addition, available with the commercial version of MySQL NDB Cluster. MCM simplifies the creation and management of your MySQL […]

Learn More »

OpenID Connect (Oauth2 – JWT) Authentication Support in MySQL

Have you ever struggled to manage a large set of users and their authentication credentials in MySQL? Wouldn’t it be great if I could tell you that now you can outsource this to your favorite external identity provider? Yes, you read that right. Lets see how to do it with MySQL… With MySQL 9.1 we […]

Learn More »

Installing Example Databases on HeatWave Using Cloud Shell and MySQL Shell

Now that you have a new HeatWave DB system and want to experiment with it, but there is no data, and you’re not ready to upload your production data, you may want to install one of the example databases available on the MySQL Documentation site. But where do you begin, and how do you get […]

Learn More »

MySQL NDB Cluster replication: Filter replica updates

MySQL NDB Cluster is a highly available and performant database with a shared-nothing architecture powering its linear scalability. Replication with MySQL NDB Cluster provides active-active geographical replication, allowing better data locality and disaster recovery with backup sites. Thus, it can serve a large number of clients at the same time in a global Cloud environment. […]

Learn More »

HeatWave MySQL – Quick guide: Enabling Automatic storage expansion

HeatWave MySQL now supports Automatic Storage Expansion. HeatWave Automatic Storage Expansion dynamically adjusts storage capacity to accommodate increasing database workloads, ensuring continuous operation without any downtime.  In the past, for databases which were sized correctly with initial storage capacity,  you needed to manually allocate storage capacity based on application  storage needs. Insufficient provisioning could lead […]

Learn More »

MySQL October 2024 GA Releases Now Available

This October release is the third LTS release and second Innovation release since MySQL announced our move to a new LTS/Innovation release model. For more details see MySQL Releases: Innovation and LTS.  During the innovation cycle, MySQL 9.x quarterly releases will include new features, deprecations and removals, and bug fixes.    The 9.x releases also […]

Learn More »

MySQL Brazil Meetup – Recap.

As has been announced before, last Saturday, Oct 5th, we had a MySQL Meetup/Day in Sao Paulo, Brazil. This was a second edition of the full day of MySQL in Brazil. Last year the MySQL Day was hold on Dec 2nd in the same place as this year – Oracle office. First we would like […]

Learn More »

Quick guide: Setting up HeatWave MySQL alarms and notifications in minutes

With just a few clicks, you can now set up critical alarms and notifications for HeatWave MySQL DB Systems using the OCI Database Management service. There’s no need to rely on IT teams or be a monitoring expert. You can easily implement Oracle-recommended alarms with predefined rules, thresholds, and conditions to effectively monitor your databases. […]

Learn More »