Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Where can you find MySQL during September – November 2024
Since we are approaching the end of August, it’s a time to announce a list of conferences and events where you can find MySQL Community and MySQL team during September – November 2024 plus one conference at the end of August which was added on the last minute. Please find the list of events below. […]
Customizing The MySQL Shell Prompt
The style and format of the prompt in MySQL Shell can be customized to meet the desires of the person using it. We can configure the prompt to display different or trimmed-down information about our database connection and what mode we are using. This post will show how to add a visual cue to let you know […]
Deploy WordPress, Joomla, and Drupal with HeatWave Always Free DB System in Oracle Cloud Infrastructure
Whether you’re running an online business, building an application, or creating content, having a platform to interact with consumers is essential. Often, building and maintaining a website is a critical component of a successful product, and the easier these tasks are, the better. We’re excited to announce HeatWave Always Free DB system is now available in […]
Policies for Bring Your Own Certificate (BYOC) in Oracle Cloud Infrastructure HeatWave MySQL
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 […]
Using MySQL Shell to Get MySQL Diagnostic Information
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 […]
Create an InnoDB Replica Set With MySQL Shell
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, […]
Copy Data Directly To A MySQL Instance With MySQL Shell
In previous posts, I talked about how we can use MySQL Shell to dump and load data using a multithreaded process and also how to export table data in different formats that can then be imported to a new MySQL instance. This post will discuss how we can copy data directly to another MySQL instance without performing separate dump and load operations. The […]
Using Lookahead & Lookbehind in MySQL Regular Expressions
Regular expressions are powerful but often misunderstood tools for developers. In recent posts, we have discussed subexpressions and back references (which are special types of subexpressions). This post will show examples of two other special subexpressions: look ahead and look behind. The Requirement Using the same data we have used in the past, we now have a requirement to […]
MySQL Vector Datatype: create your operations (part 2)
We saw in the previous post how we can deal with data stored in the new VECTOR datatype that was released with MySQL 9.0. We implemented the 4 basic mathematical operations between two vectors. To do so we created JavaScript functions. MySQL JavaScript functions are available in MySQL HeatWave and MySQL Enterprise Edition (you can […]
MySQL Vector Datatype: create your operations (part 1)
MySQL 9.0.0 has brought the VECTOR datatype to your favorite Open Source Database. There are already some functions available to deal with those vectors: This post will show how to deal with vectors and create our own functions to create operations between vectors. We will use the MLE Component capability to create JavaScript functions. JS […]