MySQL Shell offer many features to make life easier for DBAs and developers. In this post we talk about how to execute system commands inside MySQL Shell.

MySQL NDB Cluster Manager 8.4, or MCM 8.4, was recently released as part of the 8.4 LTS (Long Term Support) release series by the MySQL team. If you are unfamiliar with MCM, it is a commercial addition, available with the commercial version of MySQL NDB Cluster. MCM simplifies the creation and management of your MySQL […]

This is the fifth article in our series about MySQL NDB Cluster replication. In many cases, it’s enough to replicate between two clusters located in different data centers or cloud regions to achieve the desired availability level and disaster protection. However, for some use cases, there is a need to replicate data between even more […]

Over the last few years, I have become quite smitten with MySQL Shell. For those who may not be familiar with MySQL Shell, it is a new(ish) command line interface (CLI) for connecting to and managing MySQL instances. During a recent episode of Inside MySQL: Sakila Speaks, Fred and I talked to Miguel Araujo about many of the helpful […]

MySQl Shell offer many features to make life easier for DBAs and developers. In this post we talk about how to execute external JavaScript, Python, or SQL files indie MySQL Shell.

Over the last few years, I have become quite smitten with MySQL Shell. For those who may not be familiar with MySQL Shell, it is a new(ish) command line interface (CLI) for connecting to and managing MySQL instances. During a recent episode of Inside MySQL: Sakila Speaks, Fred and I talked to Miguel Araujo about many of the helpful […]

It’s a time to announce a list of conferences and events where you can find the MySQL Community and the MySQL team during June – August 2024 plus one conference at the end of May. See the list below. May 2024: June 2024: July 2024: August 2024:  

Where is MySQL, 6-9, 2024

TL;DR: Make sure to run “SET persist_only disabled_storage_engines=’MyISAM’, persist sql_generate_invisible_primary_key=ON;” on all instances and restart each one in your MySQL InnoDB Cluster.

Ok, what does “safe from naughtiness” mean?:
– Anyone creating tables that aren’t InnoDB, as this doesn’t make sense, after all, it is an “InnoDB” cluster.
– Making sure all tables have a Primary Key (invisible or not).
– Making sure that my (invisible) primary keys are visible to the cluster as it will rightfully complain if they aren’t!

This basically means that once you’ve got it all up and running you won’t run into those horrible situations whereby someone, somewhere, creates a MyISAM table that didn’t have a Primary Key and thus leave you with a broken cluster.

Eg.

MySQL rtnode-01:3306 ssl JS > vlc.status()
{
 "clusterName": "VLC",
 "clusterRole": "PRIMARY", …

MySQL HeatWave is the MySQL DBaaS provided by Oracle in OCI and some other clouds. Compared to the vanilla MySQL, one of the key features of the service is that it allows you to run analytics queries (aka OLAP) very quickly using the HeatWave cluster. You can also run such queries on files using LakeHouse. […]