New! MySQL Cluster 7.5
Oracle MySQL Cloud Service
MySQL Document Store

MySQL Engineering Blogs

MySQL 8.0: Storing IPv6
In MySQL 8.0.0 we introduced many new features; among those, we extended the bit-wise operations to work with binary data. Because of these changes, storing and manipulating IPv6 addresses can be done in an easier manner. In this blog we will take a look at how can you do this for some of the most...

MySQL 8.0: MTR Configurations to Be Set to Server Defaults Where Possible
MySQL Test Run or MTR for short, is a MySQL test program. It was developed to ensure that the MySQL server’s operation is as expected whether it be in terms of testing the functionality of new features or integrity of the old.…

Making MySQL Better for Operations
In the MySQL team, one of our focuses over the last few releases has been improving the usability of the MySQL Server for operations teams.  The results can be seen in a number of areas: Our continued investment in Performance Schema.  …

MySQL Cluster Manager 1.4.1 released
MySQL Cluster Manager 1.4.1 is available for download from My Oracle Support. MCM 1.4.1 now ships with MySQL Cluster 7.5! More details are available in the the MCM 1.4.1 Release Notes. Updated documentation is available here……

MySQL 8.0: Refactoring and Improving the Parser
In 8.0 we have introduced another bunch of parser refactoring worklogs: WL#8067 (me): “Refactoring of the CREATE TABLE statement” with its subtasks: WL#8434: Refactoring of partitioning-related stuff. WL#8435: Cleanup and refactoring column definition stuff. WL#8433: Separate DD...

MySQL 8.0 Data Dictionary: Status in the 8.0.0 DMR
In a previous post, I explained the architecture and design for the transactional data dictionary in MySQL 8.0. In this post I intend to summarize the status of this work in the 8.0.0 Milestone Release. Storing all dictionary information in InnoDB tables The MySQL 8.0.0 now stores dictionary data...

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.…

"The Documents contained within this site may include statements about Oracle's product development plans. Many factors can materially affect Oracle's product development plans and the nature and timing of future product releases. Accordingly, this Information is provided to you solely for information only, is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle.

THIS INFORMATION MAY NOT BE INCORPORATED INTO ANY CONTRACTUAL AGREEMENT WITH ORACLE OR ITS SUBSIDIARIES OR AFFILIATES. ORACLE SPECIFICALLY DISCLAIMS ANY LIABILITY WITH RESPECT TO THIS INFORMATION. Refer to the LEGAL NOTICES AND TERMS OF USE for further information."