Learn how to enable TLS in MySQL NDB Cluster 8.4 with MySQL NDB Cluster Manager 8.4

With MySQL 9.1 we introduce support for OpenID Connect, making secure authentication easier for developers and enterprises alike.

In today’s fast-paced financial landscape, organizations must embrace digital transformation to stay competitive. MySQL Enterprise Edition has empowered over 700 financial services firms to navigate this shift effectively. With its proven performance and scalability, MySQL is uniquely positioned to support demanding applications while ensuring data protection and regulatory compliance.   Overview MySQL Enterprise Edition offers […]

One of the standout features of dbForge Studio is its ability to import data from various sources, including ODBC data. This significantly expands your capabilities, both for direct conversion of data stored on different platforms and for the convenient development of database-related objects such as ETL procedures, reports, and more.

The post How to Migrate From SQL Server to MySQL appeared first on Devart Blog.

MySQL 8.0 and newer change and improve how we measure and monitor replication lag. Even though multi-threaded replication (MTR) has been on by default for the last three years (since v8.0.27 released October 2021), the industry has been steeped in single-threaded replication for nearly 30 years. As a result, replication lag with MTR is a complicated topic because it depends on version, configuration, and more. This three-part series provides a detailed understanding, starting from what was originally an unrelated feature: binary log group commit.

It’s very difficult explaining to students new to relational databases how SQL works. There are many parts that seem intuitive and then there are others that confuse and confound.

For beginners, the idea that a SQL statement is simply a text string that you must dispatch to a SQL statement processing engine is new. That’s because they use an Integrated Development Environment (IDE) that hides, or abstracts the complexity, of how SQL executes.

I start my core SQL class by demonstrating how to run a text literal query without a FROM clause in MySQL Workbench, like this:

SELECT 'Hello World!' AS "Output";

After writing the query, I highlight everything except the semicolon and click the lightening bolt that dispatches the static string to the SQL statement engine. They see this result:

Then, I launch a mysql Monitor session and write the query with a semicolon to dispatch the SQL …

Installing Example Databases on HeatWave Using Cloud Shell and MySQL Shell

Recently I was asked by one of our HeatWave users about using Airbyte to synchronize data to HeatWave in Oracle Cloud Infrastructure (OCI), specifically I was asked to provide guidance to build a test environment to test out moving data from one source to a target in HeatWave on OCI.  Based on my research on Airbyte, I chose to use the […]

Now that you have a new HeatWave DB system and want to experiment with it, but there is no data, and you’re not ready to upload your production data, you may want to install one of the example databases available on the MySQL Documentation site. But where do you begin, and how do you get […]

A new feature to MySQL NDB Cluster replication allows the NDB data nodes to skip sending unnecessary updates to subscribing MySQL Server nodes. These updates reflect changes that occurred in the NDB cluster, and some subscribing MySQL Servers are configured to discard changes applied by a replica or that are not to be written to binary log at all. Instead of having MySQL Servers discarding changes, the NDB data nodes do such work for them saving computing resources for the whole cluster.