(Mayank Prasad) In MySQL 8.0.0, the Performance Schema can now instrument server errors. There are 5 new summary tables introduced:
Tag: Open Source
Consul, ProxySQL and MySQL HA
(Nik Vyzas) When it comes to “decision time” about which type of MySQL HA (high-availability) solution to implement, and how to architect the solution, many questions come to mind. The most important questions are:
MySQL 8.0: Performance Schema, now with indexes!
(Marc Alff) In MySQL 8.0 we are improving the Performance Schema to support indexes. This increases the flexibility and ease of use of using performance_schema, as a number of monitoring queries will see a dramatic speed up in performance.
Roles on MySQL 8.0
(Gabriela D’Ávila) This is a feature that will make life the many DevOps and DBAs easier. Believe it or not, a lot of people control access to the database by sharing the same username and password. Which is completely insecure for a number of reasons:
MySQL 8.0: JSON Aggregation functions
(Johannes Schlüter) In MySQL 5.7 the new JSON support had been added. The JSON support consists out of three features:
MySQL 8.0: Persisting configuration variables
(Bharathy Satish) Starting with MySQL 8.0 we are introducing a new feature which will allow configuration variables to be persisted. This means that for a number of configuration settings, you will no longer need to manually edit a configuration file and can instead make modifications directly via a
MySQL Default Configuration Changes between 5.6 and 5.7
(bradley mickel) In this blog post, we’ll discuss the MySQL default configuration changes between 5.6 and 5.7.
Varchar fields on MySQL 5.7
(Gabriela D’Ávila) VARCHAR and CHAR are used to store strings. VARCHAR stores varying length and CHAR always use the same exact size no matter the size of the string. For example, CHAR(4) will always store 4 bytes, whereas VARCHAR(4) will store up to 5 bytes. See documentation.
MySql Connector NET for .NET Core 1.0
(Gabriel Valencia) It is exciting times! Recently Microsoft released .NET Core 1.0, a cross platform implementation of the .NET Framework. .NET Core works on Windows, Mac OS, and Linux and is fully open source!
Get MySQL Passwords in Plain Text from .mylogin.cnf
(Roman Vynar) This post will tell you how to get MySQL passwords in plain text using the .mylogin.cnf file.
