(Frederic Descamps) You may already know that MySQL 8.0 is coming with a nice requested feature : ROLES
Tag: Open Source
ProxySQL Query Cache: What It Is, How It Works
(Ananias Tsalouchidis) In this blog post, I’ll present the ProxySQL query cache functionality. This is a query caching mechanism on top of ProxySQL. As there are already many how-tos regarding the ProxySQL prerequisites and installation process, we are going to skip these steps.
MySQL Shell 8.0.4: Introducing ‘Upgrade checker’ utility
(Konrad Olesinski) MySQL 8.0 brings a lot of exciting new features and improvements. To make sure that your 5.7 system is ready for an upgrade there are certain steps you should take, described in our documentation: upgrade prerequisites.
How caching_sha2_password leaks passwords
(Daniël van Eeden) Oracle recently announced a new authentication plugin: caching_sha2_password. This was added in 8.0.4, the second release candidate for MySQL 8.0. The new plugin is also made the default (can be configured by changing default_authentication_plugin.
About READ UNCOMMITTED
(Federico Razzoli) Transaction isolation levels are the least understood feature of relational databases. Most developers don’t know them and just use the default one. Actually, a relevant part of them even believe they use MySQL without transactions.
MySQL Cluster 7.6 includes new Cluster Configurator
(Tonci Grgin) After dealing with Windows performance, I switched to MySQL Cluster Configurator (MCC for short) project. This was quite a change for me having to deal with Python back-end and JavaScript front-end, languages I was not so familiar with.
More P_S Instrumentation for Group Replication
(Filipe Campos) In order to improve observability and manageability of MySQL Group Replication (GR), we enhanced its instrumentation in MySQL 8.0.4.
MyRocks Engine: Things to Know Before You Start
(Vadim Tkachenko) Percona recently released Percona Server with MyRocks as GA. You can see how Facebook explains wins they see in production with MyRocks. Now if you use Percona repositories, you can simply install MyRocks plugin and enable it with ps-admin –enable-rocksdb.
Going to Oracle MySQL Cloud via Enterprise Backup.
(Keith Hollman) First of all, if you want a guide on how to deploy MySQL in Oracle Cloud, then the best place to start is here.
Aurora Hash Join Optimization (with a Gentle Reminder on Lab Features)
(Jervin Real) The Aurora hash join feature for relational databases has been around for a while now. But unlike MySQL Block Nested Loop algorithm, an Aurora hash join only caters to a specific number of use cases.
