We are pleased to announce the Call for Participation (CfP) for the FOSDEM 2025 MySQL Devroom. The Devroom will be held on February 2 (Sunday), 2025 in Brussels, Belgium. The submission deadline for talk proposals is December 1, 2024. FOSDEM is a free event for software developers to meet, share ideas, and collaborate. Every year, […]

We are pleased to announce the Call for Participation (CfP) for the FOSDEM 2025 MySQL Devroom. The Devroom will be held on February 2 (Sunday), 2025 in Brussels, Belgium. The submission deadline for talk proposals is December 1, 2024.

FOSDEM is a free event for software developers to meet, share ideas, and collaborate. Every year, thousands of developers of free and open source software from all over the world gather at the event in
Brussels.

The MySQL Devroom aims to provide a dedicated space for presentations covering the most popular open source database and celebrate the 30th anniversary of MySQL.

Key dates

• Proposals can be submitted by October the 30th, 2024
• Submission deadline: 1st December 2024 Brussels time
• Announcement of the selection …

We are pleased to announce the Call for Participation (CfP) for the FOSDEM 2025 MySQL Devroom. The Devroom will be held on February 2 (Sunday), 2025 in Brussels, Belgium. The submission deadline for talk proposals is December 1, 2024. FOSDEM is a free event for software developers to meet, share ideas, and collaborate. Every year, […]

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 …

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 […]

You can connect to MySQL Server using MySQL Client (the command-line utility) and GUI tools. This article will review each method in detail.

The post How to Connect to a MySQL Database appeared first on Devart Blog.

In this guide, we are going to walk you through the process of transferring a database from a local machine or a traditional server to AWS with the help of the command line as well as with a convenient GUI - dbForge Studio for MySQL.

The post How to Migrate MySQL Database to Amazon RDS or Aurora appeared first on Devart Blog.

Interpreting the results and exit codes of your upgrade tests is essential for assessing the process’s outcome. In this blog, we’ll explore the significance of pt-upgrade return codes and how…

The post Understanding Return Codes of pt-upgrade: A quick guide first appeared on Change Is Inevitable.