2-Phase Commit in NDBCluster
This is a description of the simplest case of 2-phase commit (2PC) in NDBCluster: one transaction, containing a single insert, update or delete operation on a single row. The PREPARE phase of the 2PC is initiated by the API node (which is a mysqld or a NoSQL client) sending a TCKEYREQ to the...

MySQL Server bootstrapping and dictionary initialization
In MySQL 8.0, we are making large changes to the way the MySQL server stores meta data with the introduction of our native data dictionary. As part of these improvements, we have also made changes to the way the server bootstraps.…

fail-check-testcases: A new MTR option to enforce strict cleanup
Test cases that do not perform a proper cleanup turn out to be a nightmare for test engineers or anyone who is tasked with the job of monitoring regression test results. It leads to test failures that are difficult to analyse and fix.…

MySQL 8.0: Retiring support for libmysqld
Starting with MySQL 8.0, we will drop libmysqld (aka “embedded server”). This change will affect only a handful of users, but for context let me start with an introduction. Introduction libmysqld (also referred to as “the embedded server”) is a way of using MySQL without...

MySQL 8.0 Labs: [Recursive] Common Table Expressions in MySQL (CTEs), Part Three – hierarchies
Here is the third in a series of posts about CTEs, a new feature of MySQL 8.0, available in this Labs release. In the first post we had explored the new SQL syntax, and in the second we had applied it to generating series.…

MySQL Workbench 6.3.8 GA has been released
The MySQL developer tools team announces 6.3.8 as our GA release for MySQL Workbench 6.3.For the full list of changes in this revision, visithttp://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html For discussion, join the MySQL Workbench...

MySQL 8.0: Data Dictionary Architecture and Design
This blog post elaborates on the architecture and design of the transactional data dictionary that will be part of MySQL 8.0. Some descriptions of architecture will be implemented in later versions. See  MySQL 8.0 Data Dictionary:  Background and motivation. The MySQL Data Dictionary Schema The...

MySQL 8.0 Labs: [Recursive] Common Table Expressions in MySQL (CTEs), Part Two – how to generate series
Here is the second in a series of posts about CTEs, a new feature of MySQL 8.0, available in this Labs release. The first post ended with: Inside the recursive CTE definition (the part in AS (…)), some syntax constraints must be respected […] a recursive SELECT mustn’t contain GROUP BY,...