The Stroz

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
Using MySQL Shell to Get MySQL Diagnostic Information
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.

Aug 09, 2024
13 minutes
Create an InnoDB Replica Set With MySQL Shell
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.

Aug 06, 2024
9 minutes