MySQL is not only a relational database, but can also be used as a sch
emaless/NOSQL document store, or a mix of both. This is realized by the JSON datatype, and is useful for any data that is hard to fit in the ”tabular” format of a traditional table.…
“Look: I/O thread is waiting for disk space!”
MySQL 8.0.1 introduced a work with replication threads mutexes in order to improve performance. In MySQL 8.0.2 the same work was extended, focusing in usability, and revamped how replication deals with disk-full conditions, improving the responsiveness of both monitoring commands and administrative commands such as KILL, as well as making status messages much more precise and helpful.…
MySQL Cluster Manager 1.4.4 released!
What’s new?
With MCM 1.4.4 we continue to improve on MySQL Cluster Manager, specifically around:
- the collect logs command
- process status reporting
- process command execution in specific scenarios
More details
More details are available in the MCM 1.4.4 Release Notes.…
Replication Features in MySQL 8.0.3
Great news! MySQL 8.0.3 is out and it is a release candidate. In the replication team we have been busy working on interesting new enhancements and also doing some clean up. Some of these new features are out in this release.…
Heads Up: The List of Replication Defaults That Have Changed in 8.0.2
In development milestone release (DMR) version 8.0.2 we are changing several replication options. The motivation behind this is simply that we want our users to enjoy default installations with the best efficient setup, configuration and performance. We also don’t want users to struggle getting them to work optimally.…
MySQL Cluster Manager 1.4.3 released!
You might already have seen the announcement earlier this summer – we made MCM 1.4.3 available for download from My Oracle Support.
What’s new?
The most notable changes to MCM 1.4.3 include
- Significant reduction in cpu consumption when idle.
- Added support for running your mysqlds with skip-networking enabled.
More house chores: Cleaning up the binary log
Historically, the MySQL binary log has gone through a few revisions resulting in different versions of how the log is formatted. The following shows the version of the binary log and the MySQL version in which it appears. As you can see, version 4 is the current version of the binary log found in the current releases of MySQL.…
Group Replication: Prioritise member for the Primary Member Election
In initial Group Replication release, 5.7.17, we included the Single-Primary Mode with automatic membership and fail-over features. The MySQL Server 8.0.2 release has brought further enhancement to Group Replication Single-Primary Mode that will allow users to influence primary member election using integer member weight value.…
Group Replication – Extending Group Replication performance_schema tables
In MySQL 8.0.2, users will see the additional columns in the existing Group Replication Performance Schema tables which will provide extended information about Group Replication. Now user can view role and MySQL version of each member of the group, which earlier required a complex set of query.…
Protecting your data! Fail-safe enhancements to Group Replication.
Group Replication has been around for some time now and the feedback from community is overwhelming. One of the suggestions (BUG#84795) received is related to deploying a mechanism to prevent a server from being updated after stopping group replication.…