mysql

MySQL Shell 8.0.17 – What’s New? 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 [ more… ]

The MySQL 8.0.17 Maintenance Release is Generally Available 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.… Facebook Twitter Google+ LinkedIn Source: The MySQL 8.0.17 Maintenance Release is Generally Available

Supporting all kinds of outer references in derived tables (lateral, or not) (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.… Facebook Twitter Google+ LinkedIn Source: Supporting all kinds of outer references in derived tables (lateral, or not)

How to validate server configuration settings. 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.… Facebook Twitter Google+ LinkedIn Source: How to validate server configuration settings.

MySQL Router 8.0.16: What’s new 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.… Facebook Twitter Google+ LinkedIn Source: MySQL Router 8.0.16: What’s new