The Stroz

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
Copy Data Directly To A MySQL Instance With MySQL Shell
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.

Aug 01, 2024
10 minutes
Using Lookahead & Lookbehind in MySQL Regular Expressions
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.

Jul 30, 2024
4 minutes
MySQL Shell Table Export Utility
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.

Jul 25, 2024
5 minutes