Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
MySQL Shell Table Export Utility
We already discussed how we can use MySQL Shell to dump and load data using a multithreaded process. In this post, we will discuss ways we can export data from a table into different formats. Table Export Utility In the global util object in MySQL Shell, there is a method we can use to export table data to various formats (tab-delimited, comma-delimited, etc.). […]
RegEx Backreferences in MySQL
In my last regular expressions post, we discussed subexpressions and how to isolate specific parts of our pattern match. We can then use those subexpressions to replace parts of our pattern with other text. This post will discuss backreferences and how we can use them as part of our pattern match. Backreferences? In regular expressions, backreferences […]
A Quick Introduction to JavaScript Stored Programs in MySQL
Recently MySQL added the ability to write Stored Programs in JavaScript. This allows developers to leverage JavaScript capabilities for complex data processing and business logic within the database server. We think this is really cool. Here’s why. Why JavaScript? It is ubiquitous It has multiple runtimes It has a huge development eco-system What’s great about […]
Using RegEx Subexpressions in MySQL
As I have discussed, regular expressions can be a powerful tool for developers. When we use regular expressions to match a pattern and need to replace part of that pattern, subexpressions make it much easier. Subexpressions are specific parts of a pattern that we can reference elsewhere in the process. The Requirement The requirement for […]
A Different RegEx Solution in MySQL
In my last post about regular expressions (regex), I offered up a solution to requirements to extract text a substring from a larger blob of text. Over the weekend, I was thinking about this solution and wanted to know if it was possible to meet the requirements using a solution based solely on a regular expression. It […]
In-database vector store in Heatwave: Industry’s first automated solution
In-database vector store in Heatwave: Industry’s first automated solution Generative AI has been reshaping the enterprise landscape since it holds the promise of revolutionizing various aspects of business operations, from streamlining processes to fostering creativity and personalization. Enterprises store vast amounts of proprietary unstructured data in object storage and data lakes, and Generative AI […]
HeatWave GenAI for e-Commerce Applications
Oracle HeatWave has announced a very exciting new feature – HeatWave GenAI which brings LLMs right to the database. Because the LLM is available right in the database developers can seamlessly apply GenAI capabilities to structured and unstructured data with just a simple SQL query. In this blog we review the e-commerce demo created to […]
What do I need to know about the HeatWave maintenance window?
Introduction Regular patching and maintenance of your cloud databases is crucial for maintaining robust security and optimal performance. By promptly applying patches, you address known vulnerabilities, fix software bugs, and enhance system stability. This proactive approach significantly reduces the risk of data breaches, and service disruptions, ensuring your data remains secure and your operations run smoothly. […]
Simple bash scripts to upload multiple directories of files to an Object Storage bucket for use with Oracle HeatWave Lakehouse
MySQL is the world’s most popular, open-source database. MySQL is easy-to-use, super-fast and is great for transactional applications – but it isn’t great for running analytics. Oracle HeatWave MySQL Database Service gives you automated and integrated generative AI and auto machine learning (ML) in one cloud service for transactions and lakehouse-scale analytics – without the need […]
More Regular Expressions in MySQL
Regular expressions are used to match patterns in a given block of text. In a previous post, I discussed some regular expression features of MySQL. The examples I provided allowed us to return rows based on a pattern match and replace instances of our pattern with another substring. In this post, I will discuss some other […]