​   Introduction In our previous blog post, we introduced the concept of Bring Your Own Certificate (BYOC) for HeatWave MySQL, highlighting its benefits and implementation. In this follow-up, we delve deeper into the critical policy and security requirements necessary to leverage this feature effectively. Ensuring robust security and compliance, BYOC allows users to select their own certificates for […]

This post guides the user through the essential steps to set up BYOC related policies, including configuring dynamic groups, activating resource principals, and crafting the necessary policies within the Oracle Cloud Infrastructure (OCI) Certificates Service, to securely integrate user-defined certificates into your HeatWave MySQL environment.

Collecting comprehensive diagnostic information can be daunting. Knowing what queries to run to get the needed data is more of an art form than anything else. Fortunately, for those not that artistically inclined, MySQL Shell makes it easier to get this information. Let’s take a look. The Setup Before we can get started, we need to connect […]

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss how we can gather a plethora of diagnostic data with a single command.

The usage of MySQL Router as a Middleware/Proxy/Router has increased along with the rise in MySQL InnoDB Cluster usage. While it is still relatively easy to use in production, monitoring it to stay informed about its current status is essential. This blog post will cover how to check and monitor MySQL routers, routes, and other […]

Generative artificial intelligence (GenAI) is reshaping the content creation landscape. By training on vast datasets, these "intelligent" systems can produce new, human-quality content across a multitude of domains.

Oracle's HeatWave GenAI (starting with version 9.0.1) is at the forefront of this revolution, offering an integrated platform that combines in-database large language models (LLMs), vector stores, and scale-out vector processing to streamline content generation.
This article explores how HeatWave GenAI is empowering businesses to produce high-quality content rapidly and effectively, making it an indispensable tool for industries demanding speed, accuracy, and security.

The post HeatWave GenAI: Your AI-Powered Content Creation Partner first appeared on …

Using MySQL Shell, we can quickly and easily create an InnoDB replica set. With as little as two commands, we can create a replica set, add a secondary instance, and clone data from our primary instance to a secondary instance. In this post, we will demonstrate how to accomplish this. The Setup Before building this example, […]

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss how we can create an InnoDB replica set with a few as two commands.

Introduction Welcome to a new issue of the High-Performance Java Persistence Newsletter in which we share articles, videos, workshops, and StackOverflow answers that are very relevant to any developer who interacts with a database system using Java. Articles The pick of this week is this article about various online schema migration options that are available in MySQL. Another great read was this one about scaling the One Million Checkboxes website. There are many lessons you can learn from this experiment. One lesson is about the cost of running a high-traffic website. Using... Read More

The post High-Performance Java Persistence Newsletter, Issue 65 appeared first on …

Codership is pleased to announce a new beta preview release of the multi-master Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.2-26.20 (release notes, download), with Galera replication library 4.20 (release notes, download) implementing wsrep API version 26. This release incorporates all changes to MySQL 8.4.2, adding a synchronous option for your MySQL High Availability solutions.

One will notice that MySQL-wsrep 8.4.2-26.20 uses …