mysql

Last weekend I had the pleasure to attend the excellent FOSDEM conference in Brussels, Belgium. I indulged aplenty in pancakes with Nutella, a Belgian beer or two, and some truly interesting presentations. MySQL had a lecture hall for itself the whole weekend, and the booth conveniently located outside.… Source: mysqlserverteam.com

Correctness of data comes in different forms. One is referential integrity, also known as foreign keys. Another is CHECK constraints. While MySQL supports foreign keys, it doesn’t support CHECK constraints. Today we will look at three ways to emulate them: triggers views generated columns (new in MySQL 5.7) This is also relevant to another SQL feature: DOMAIN, which, in short, is a user-defined type composed of a base type (INT, CHAR, …), a default value, and a constraint on acceptable values – the latter being some simple sort of CHECK constraint.… Source: mysqlserverteam.com

MySQL Cluster 7.4 (7.4.10 GA, published on Friday, 29 Jan 2016) Source: mysql-releases

MySQL 5.7 makes secure connections easier with streamlined key generation for both MySQL Community and MySQL Enterprise, improves security by expanding support for TLSv1.1 and TLSv1.2, and helps administrators assess whether clients are connecting securely or not with new visibility into connection types. … Source: mysqlserverteam.com