MySQL Engineering Blogs
MySQL 8.0 Labs: The “Unified Data Dictionary” Lab Release
The recent “Unified Data Dictionary Lab Release” quietly delivered an important change to the MySQL server with InnoDB engine: the “InnoDB System Tables” are now officially “decommissioned”. And InnoDB is now deriving its metadata from the new...
No new options, no new commands… Just faster at full load, where it counts!
Starting on MySQL 8.0.1, a very updated replica server will be more efficient (and probably faster) than previous MySQL versions because of improvements in the relationship between the replication threads. Preliminary testing showed a benefit of up to 65% on Sysbench Update Index.…
MySQL 8.0 Collations: Migrating from older collations
From MySQL 8.0, utf8mb4 is the default character set, and the default collation for utf8mb4 is utf8mb4_0900_ai_ci. MySQL 8.0 is also coming with a whole new set of Unicode collations for the utf8mb4 character set. This will allow use of the complete Unicode 9.0.0 character set in MySQL, and for...
Improving the Parallel Applier with Writeset-based Dependency Tracking
MySQL 8.0.1 introduces a new mechanism to track the dependencies between transactions. This feature is used to optimize the binary log applier on asynchronous replication slaves, improving the throughput significantly on workloads where there is low-concurrency on the master and/or on systems with...
MySQL InnoDB Cluster in Oracle Public Cloud: A Tutorial
In this tutorial, we are going to guide you through the entire process of creating a 3 node InnoDB cluster in Oracle Public Cloud (OPC). We will address each of the steps, from the initial configuration and setup of the OPC IaaS resources to the InnoDB cluster creation and setup.…
The per-channel replication filters
In 8.0.1, we introduced per-channel replication filters. This allows user to specify different replication filter rules for different slave replication channels. Therefore, the slave will be able to filter out (or transform) the execution of selected replicated changes on a per-source basis when...
More Metadata Is Written Into Binary Log
In row based replication, the row data generated by DML is logged into binary log with some metadata. For example column type, type length etc. In the new release MySQL-8.0.1, more table metadata are written into binary log. All metadata together brings users and us below benefits: Allows us to...
New monitoring replication features and more!
The new release of MySQL is packed with exciting features that help detecting and analyzing replication lag. In this post, you will be able to learn all about the new replication timestamps, the new useful information that is now reported by performance schema tables, and how delayed replication...
MySQL Community Server
- MySQL Cluster 7.6
- MySQL for Visual Studio 2.0
- Connector/Python 2.1
- MySQL Router 2.1
- MySQL Shell 1.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.