Showing entries 1 to 10 of 43543
10 Older Entries »
Did MyDumper LIKE Triggers?

Yes, but now it likes them more, and here is why.IntroUsing the LIKE clause to filter triggers or views from a specific table is common. However, it can play a trick on you, especially if you don’t get to see the output (i.e., in a non-interactive session). Let’s take a look at a simple example […]

MySQL NDB Cluster replication: Single-channel replication

This is the second article in our blog series about MySQL NDB Cluster replication, it describes the basic concept and functional parts of a single-channel replication which is used for replicating data between clusters.

How to Add, Show, and Drop MySQL Foreign Keys

A key is typically defined as a column or a group of columns that are used to uniquely locate table records in relational databases (including MySQL, of course). And now that we've covered MySQL primary keys on our blog, it's time to give you a similarly handy guide on foreign keys.

The post How to Add, Show, and Drop MySQL Foreign Keys appeared first on Devart Blog.

Creating a MySQL HeatWave Configuration with the OCI CLI

The Oracle Cloud Infrastructure (OCI) command line interface (CLI) allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to create a MySQL HeatWave configuration that can be specified when creating a new instance.

When COMMIT Is the Slowest Query

When COMMIT is the slowest query, it means your storage is slow. Let’s look at an example.

MySQL Shorts - Episode #60 is Released

Episode #60 of MySQL Shorts in now available!

A Guide to Better Understanding MySQL Charset Levels

We usually receive and see some questions regarding the charset levels in MySQL, especially after the deprecation of utf8mb3 and the new default uf8mb4. If you understand how the charset works on MySQL but have some questions regarding this change, please check out Migrating to utf8mb4: Things to Consider by Sveta Smirnova.Some of the questions […]

EMEA MySQL Meetups in April & May 2024! - UPDATED!

MySQL Meetups EMEA in April

Creating a MySQL HeatWave Read Replica with the OCI CLI

The Oracle Cloud Infrastructure (OCI) command line interface (CLI) allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to create a read replica of a MySQL HeatWave instance.

Backing up and Restoring a MySQL HeatWave Instance with the OCI CLI

The Oracle Cloud Infrastructure (OCI) command line interface (CLI) allows users to manage OCI resources. In this post, we will discuss how to use the OCI CLI to create a backup of a MySQl HeatWave instance and then restore that back up to a new HeatWave instance.

Showing entries 1 to 10 of 43543
10 Older Entries »