mysql

Proposal to Change the Behavior of JSON_MERGE In MySQL 5.7, one of the most popular new features is the introduction of JSON: The JSON data type A set of 20 functions to search, manipulate and create JSON documents Virtual Columns for JSON indexing In MySQL 8.0 we plan to extend this functionality (for example: with the addition of JSON aggregate functions), but we are also considering changing the behaviour of one of the existing functions.… Source: Proposal to Change the Behavior of JSON_MERGE

MySQL 8.0 Collations: The devil is in the details. One of the challenges of language specific collations, is making sure they are accurate in the edge-cases of sometimes lesser-used language features. Since I am Norwegian, let me use the Danish collation (which is identical to Norwegian collation) as an example: Most Scandinavian people know that in Danish (and Norwegian), we have three extra letters: ‘Æ’, ‘Ø’ and ‘Å’ and they follow after ‘Z’ in that order.… Source: MySQL 8.0 Collations: The devil is in the details.

MySQL InnoDB Cluster – Real-World Cluster Tutorial for OEL, Fedora, RHEL and CentOS In this tutorial, we are going to guide you through the process of preparing and configuring RPM based distributions, such as OEL, Fedora or CentOS, for InnoDB cluster usage. We will address the steps from the initial configurations, to the cluster creation, and finally the MySQL Router configuration to map the data traffic.… Source: MySQL InnoDB Cluster – Real-World Cluster Tutorial for OEL, Fedora, RHEL and CentOS

MySQL InnoDB Cluster – Real-World Cluster Tutorial for Ubuntu and Debian In this tutorial, we are going to guide you through the whole process of configuring Debian based distributions for InnoDB cluster usage; the most popular being Ubuntu. We will address the steps from the initial configurations, to the cluster creation, and finally the MySQL Router configuration to map the data traffic.… Source: MySQL InnoDB Cluster – Real-World Cluster Tutorial for Ubuntu and Debian

MySQL InnoDB Cluster – Preparing a Linux VM for a Real-World Cluster In this tutorial, we are going to guide you through the process of preparing and configuring an Ubuntu mini host for InnoDB cluster usage. To create a cluster with tolerance to one failure, we need three instances. So we’re going to create and configure a Virtual Machine and clone it two times.… Source: MySQL InnoDB Cluster – Preparing a Linux VM for a Real-World Cluster