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
OpenSSL FIPS support in MySQL 8.0 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.… Facebook Twitter Google+ LinkedIn Source: OpenSSL FIPS support in MySQL 8.0
Partial Revokes from Database Objects Have you ever encountered situations where you want to grant a user access to all databases except a few databases ? If yes, then this article will interest you. Starting from MySQL 8.0.16, you can partially revoke database privileges from users, even if they are granted global privileges.… Facebook Twitter Google+ LinkedIn Source: Partial Revokes from Database Objects