Clone: Create MySQL instance replica

July 23, 2019InnoDB, MySQL, ReplicationDebarun Banejee

Cloning MySQL instance data reliably and efficiently is required in many scenarios. This includes MySQL HA solutions where one needs to provision an instance before joining it to a Group Replication cluster or adding it as Slave in classic the replication model.…

MySQL InnoDB Cluster – What’s new in Shell AdminAPI 8.0.17 release

July 22, 2019DevOps, High Availability, MySQL, ShellMiguel Araújo

The MySQL Development Team is very excited and proud to announce a new 8.0 Maintenance Release of InnoDB Cluster – 8.0.17!

In addition to important bug fixes and improvements, 8.0.17 brings a game-changer feature!

This blog post will cover MySQL Shell and the AdminAPI, for detailed information of what’s new in MySQL Router stay tuned for an upcoming blog post!…

MySQL Shell 8.0.17 – What’s New?

July 22, 2019MySQLRene Ramirez

The MySQL Development team is proud to announce a new version of the MySQL Shell in which the following new features can be highlighted:

MySQL Shell Plugins
Parallel table import
In InnoDB Cluster:
- Automatic instance provisioning through cloning
- Automatic server version compatibility handling
- Simplification of internal recovery accounts

The following enhancements were also introduced:

On the X DevAPI area:
- Support for array indexes in collections
- Support for overlaps operator in expressions
Uniform SQL execution API in classic and X protocol
Support for connection attributes
New utility functions:
- shell.unparseUri(…)
- shell.dumpRows(…)
Support for –verbose output
Upgrade Checker: Addition of checks for variables on the configuration files

MySQL Shell Plugins

The MySQL Shell now supports user extensions through MySQL Shell Plugins, which includes User Defined Reports (Introduced in 8.0.16) as well as the new Extension Objects introduced in 8.0.17.…

The MySQL 8.0.17 Maintenance Release is Generally Available

July 22, 2019MySQLGeir Hoydalsvik

The MySQL Development team is very happy to announce that MySQL 8.0.17 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release. Please download 8.0.17 from dev.mysql.com or from the MySQL Yum, APT, or SUSE repositories.…

Supporting all kinds of outer references in derived tables (lateral, or not)

July 12, 2019MySQLmysql, optimizerGuilhem Bichot

(Image credit: Pixabay).

In my earlier post, I showed how MySQL, since version 8.0.14, has support for LATERAL derived tables. With LATERAL, a JOIN can have a second table – a subquery-based derived table – be defined based on values from columns of the first table, and thus be re-calculated for each row of the first table.…

How to validate server configuration settings.

June 19, 2019Configuration, HowTo, MySQL, UpgradesNisha Gopalakrishnan

After upgrading the server many users start it with an unchanged config file only to find some deprecated options that they were using are no longer supported by the later server version, which causes the upgraded server to shutdown. In other cases modifying the server configuration file results in the server refusing to start when an invalid name is mistakenly entered in the configuration file.…

MySQL Router 8.0.16: What’s new

May 16, 2019RouterJan Kneschke

MySQL Router 8.0.16

Key features

log-rotation via SIGHUP
HTTP server plugin
flexible support for single/multi-PRIMARY Group Replication

Logrotation via SIGHUP

Sending a SIGHUP signal to the router process will now close and reopen the logfile.

It allows the integration with the logrotate to rotate and compress the Router’s logfiles.…

OpenSSL FIPS support in MySQL 8.0

May 9, 2019MySQLYashwant Sahu

Many products use OpenSSL, but for the most part, without choosing to incorporate the OpenSSL FIPS (US Federal Information Processing Standards) module. However it may be that running OpenSSL and using FIPs mode is something you should seriously consider and implement.…