If you look into the key elements of replication, then the very basic element is Binary log or binlog. Over the period of time we have made efforts to improve the management of this quintessential element of replication. To keep up with our raising standards and requirements coming from the global MySQL community we have introduced two new features to help you manage your binary logs more efficiently.…
Group Replication support SAVEPOINT
Group Replication has been around as GA for some months now. Nonetheless, work continues and now we are happy to let you know that you can now use transaction savepoints when write-set extraction is enabled.
This enhancement was released as in MySQL 8.0.1.…
MySQL 8.0.1 Replication Performance Improvements
MySQL 8.0.1 introduces new features and improvements to replication. The next sections summarize some related to performance.
1. WL#9556 – Writeset-based dependency tracking on the master
Transaction writesets can now be used to evaluate which transactions are independent and can be executed in parallel on the binary log applier on the asynchronous slaves.…
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.…
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 very fast storage.…
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 using multi-source replication.…
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 build robuster replication and convert row data between types smoothly.
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 was improved.…
Replication Features in MySQL 8.0.1
MySQL 8.0.1 has just been released with a wonderful set of features across the board. Specifically in replication, there is plenty of new and exciting functionality as well as performance improvements. In this post I am going to summarize the replication features of this development milestone release.…
MySQL Cluster Manager 1.4.2 released!
In this blog post we will highlight some of the details of the MCM 1.4.2 release.
Progress reporting
First, some eye candy. With MCM 1.4.2 we added simple progress reporting.…