The Stroz

Without Good Data, AI is Useless
Without Good Data, AI is Useless

Last week, we released a Episode #89 of MySQL Shorts that focussed on some machine learning features available in HeatWave. In today’s post, I will discuss some things I learned about good vs. bad data when I was training the AI models for this episode.

May 12, 2025
9 minutes
AI Features Available in HeatWave Always Free Tier
AI Features Available in HeatWave Always Free Tier

Earlier this week, we released a Episode #89 of MySQL Shorts that focussed on some machine learning features available in HeatWave. I am excited to share that features demoed in that video are also available in the Always Free tier of HeatWave!

May 08, 2025
3 minutes
Connecting a MySQL Database to an AI Client Using MCP
Connecting a MySQL Database to an AI Client Using MCP

For quite some time, AI has been all the rage. Last year, we saw the introduction of the Model Context Protocol (MCP). MCP servers allow AI clients like ChatGPT and Claude to interact with external systems, such as databases, APIs, and other services. This post will show you how to create a Model Context Protocol (MCP) server that allows an AI client to interact with a MySQL database.

Apr 09, 2025
16 minutes
Doing a 'Incremental' Dump With MySQL Shell
Doing a 'Incremental' Dump With MySQL Shell

In previous posts, I discussed how to use MySQL Shell to dump and load data using a multithreaded process. When using util.dumpInstance(), we create a dump of all the data and schema changes, even those that have already been dumped previously. But what if we only want to dump the data and schema changes that have occurred since the last dump? In this post, we will demonstrate how to use MySQL Shell and util.dumpBinlogs() to achieve this.

Mar 27, 2025
4 minutes
Running Drupal using Always Free Resources in Oracle Cloud
Running Drupal using Always Free Resources in Oracle Cloud

Oracle Cloud Infrastructure (OCI) has a very robust always-free tier. Oracle recently announced that HeatWave MySQL will be part of that offering. This post will show how to set up a free Drupal site using Always Free resources in Oracle Cloud.

Dec 13, 2024
10 minutes
Running WordPress using Always Free Resources in Oracle Cloud
Running WordPress using Always Free Resources in Oracle Cloud

Oracle Cloud Infrastructure (OCI) has a very robust always-free tier. Oracle recently announced that HeatWave MySQL will be part of that offering. This post will show how you can set up a free WordPress site using Always Free resources in Oracle Cloud.

Dec 10, 2024
9 minutes
Creating and Connecting to A HeatWave MySQL Always Free Instance
Creating and Connecting to A HeatWave MySQL Always Free Instance

Oracle Cloud Infrastructure (OCI) has a very robust always-free tier. Oracle recently announced that HeatWave MySQL will now be part of that offering. As part of the always-free tier, we can set up one instance and a single-node HeatWave Cluster. In this post, we will show how to spin up that instance and connect to it using a Compute instance.

Sep 13, 2024
6 minutes
Extending MySQL Shell with Plugins
Extending MySQL Shell with Plugins

MySQL Shell offers a wide variety of tools to manage our MySQL instances. With all those tools, though, we may want functionality that would be helpful and pertain to just your situation. Thankfully, the MySQL Shell team made it possible to extend MySQL Shell and add functionality. In this post, we will explore the use of plugins.

Aug 29, 2024
10 minutes
Extending MySQL Shell with Startup Scripts
Extending MySQL Shell with Startup Scripts

MySQL Shell offers a wide variety of tools to manage our MySQL instances. With all those tools, though, we may want functionality that would be helpful and pertain to just your situation. Thankfully, the MySQL Shell team made it possible to extend MySQL Shell and add functionality. In this post, we will explore the use of startup scripts.

Aug 23, 2024
8 minutes
Customizing The MySQL Shell Prompt
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 when you are connected to a production database.

Aug 15, 2024
15 minutes