No Image

SSL/TLS Improvements in MySQL 5.7.10

2015-12-22 KENNETH 0

Secure communications is a core component of a robust security policy, and MySQL Server 5.7.10 – the first maintenance release of MySQL Server 5.7 – introduces needed improvements in this area.  Support for TLS has been expanded from TLSv1.0 to include TLSv1.1 and TLSv1.2, default ciphers have been updated, and controls have been implemented allowing both server and client-side configuration of acceptable TLS protocol versions.  … Source:

MySQL 5.8 Planning: C++11 and Native Partitioning

2015-12-17 KENNETH 0

In November we held our first MySQL 5.8 planning session in London. On behalf of the MySQL team, I would like to thank you for your feature requests and suggestions. We reviewed over 150 pieces of feedback in total, and are looking forward to prioritizing a number of suggestions: In MySQL 5.8, we are planning to make two important changes to modernize our code base.… Source:

No Image

Using the aggregate functions ANY, SOME, EVERY with MySQL

2015-12-15 KENNETH 0

If you have used SQL a bit, you are certainly familiar with so-called set functions or aggregate functions COUNT, SUM, AVG, described in the manual. For example, let’s say that I am the owner of a shop and I keep track of daily sales in this table: create table sales (month int, day int, amount int); The first column is the number of the month, between 1 and 12, the second column is the number of the day in the month, between 1 and 31, and the third column is how much we sold on that date.… Source: