(Alexey Stroganov) In this post, we’ll look at a scalability fix for issues the query rewrite plugin had on performance.

(Frederic Descamps) MySQL Group Replication is just one component of the upcoming MySQL HA Solution as Matt Lord explained it in his GR quick start guide. So while mysql-router is back to school to become smarter and learn how to take the right decision we can already use existing 3rd party solution

(Marco Tusa) All of us are very good in writing good queries, we know that 😉 but sometimes a bad query may escape our control and hit (badly) our database.

(Jean-François Gagné) Some time ago, feedback was requested on new replication default after MySQL 5.7. Some of the suggested default are:

(Marco Tusa) Recently a colleague of mine ask me to provide a simple example on how ProxySQL can perform sharding.

(Robert Golebiowski) With MySQL version 5.7.12 and up, Oracle continues to improve MySQL’s security features by adding MySQL Enterprise Transparent Data Encryption (TDE) for InnoDB tables stored in innodb_file_per_table tablespaces.

(Ulf Wendel) MySQL 5.7/8.0 does not allow creating a full-text index on a JSON column. Although a full-text index would be useful – unstructured data deserves unstructured search. I am unaware o any workaround of this limitation that does not require storing the JSON data twice.

(Geoff Montee) Sequences are objects defined by the SQL standard that are used to create monotonically increasing sequences of numeric values. Whenever nextval is called on a sequence object, it generates and returns the next number in the sequence.

This guide explains how to password-protect web directories (with users from a MySQL database) with mod_authn_dbd on Apache2 on a Debian 8 (Jessie) server. It is an alternative to the plain-text password files provided by mod_auth and allows you to use normal SQL syntax to create/modify delete users

(Ulf Wendel) Storing documents is convenient: no need to define a schema up-front, no downtime for schema changes, no normalization, no slow joins – true or not, you name it. But what about search if you do not know how your data is structured?