MySQL Engineering Blogs
MySQL at Oracle Open World London FEB 12-13
Planning to attend Oracle Open World 2020 in London? Make sure to: Visit our booth Join us at our evening reception Check out our MySQL sessions MySQL Booth: Located in Zone 4 , stop by to meet the MySQL EMEA team and learn the latest about MySQL from...
Preserving commit order on replicas with binary log disabled
MySQL 8.0.19 introduces Binlogless replicas with commit ordering which means you can deploy asynchronous replicas without binary logs enabled, and commit transactions in the same order they are replicated in. Yes, you can disable binlog (skip-log-bin) and the logging of changes done by the applier...
Automatic Schema Synchronization in NDB Cluster 8.0: Part 2
In part 1, we took a brief, high-level look at the various protocols and mechanisms used to keep the Data Dictionary (DD) of MySQL servers connected to a MySQL Cluster in synchronization with each other and with the NDB Dictionary.…
Faster restarts with local and partial checkpoints in MySQL NDB Cluster
The MySQL NDB Cluster team works on fundamental redesigns of core parts of NDB architecture. One of these changes is the partial checkpoint algorithm. You can now take full advantage of it when building much larger clusters: NDB 8.0 can use 16 TB data memory per data node for in-memory...
Automatic Schema Synchronization in NDB Cluster 8.0: Part 1
Data nodes are the distributed, sharded storage core of MySQL NDB Cluster. Its data is usually accessed by MySQL Servers (also called SQL nodes in NDB parlance). The MySQL servers each have their own transactional Data Dictionary (DD) where all the metadata describing tables, databases,...
Upgrading MySQL InnoDB Cluster Metadata
As on every release MySQL Shell 8.0.19 includes several bug fixes as well as new features. However, this release includes some significant changes: Fixes for bugs in the schema definition: Cascading keys in multi-primary mode. Introduction of InnoDB ReplicaSet. These changes required updates to...
A Tale of UDFs with Character Sets
If you are reading this blog post, you likely already know the purpose of user-defined functions (UDF) in MySQL. If you need a quick refresher on UDF’s take a look at the MySQL reference manual. You may have created your own UDFs as well.…
A new, simple way to figure out why your recursive CTE is running away
In MySQL 8.0.1, we introduced support for recursive common table expressions (CTE). There are quite a few blog entries showcasing the feature, starting from this one, and there is also a complete documentation. Today, I would like to present a solution to a problem which nearly everybody meets when...
MySQL Community Server
- MySQL Cluster 7.6
- MySQL Cluster 7.5
- MySQL Cluster 7.4
- MySQL Cluster 7.3
- Connector/C++ 8.0
Which backup features do you require for your MySQL database backups?
"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.