The MySQL 8.0.16 Release Notes are very
interesting and sadly not read enough. One thing that may have
escaped attention is that you no longer have to run
mysql_upgrade after updating the binaries.
Let me repeat: you no longer have to
run mysql_upgrade after updating the
binaries.
From the release notes:
Previously, after installation of a new version of MySQL, the
MySQL server automatically upgrades the data dictionary tables at
the next startup, after which the DBA is expected to invoke
mysql_upgrade manually to upgrade the system tables in the mysql
schema, as well as objects in other schemas such as the sys
schema and user schemas.
The server, starting 8.0.16, does the work previously done by
mysql_upgrade for itself. And mysql_upgrade
itself is …
The MySQL Development Team is very happy to announce a new 8.0 GA Maintenance Release of InnoDB Cluster – 8.0.16!
In addition to important bug fixes, 8.0.16 brings very useful new features!
This blog post will cover MySQL Shell and the AdminAPI, for detailed information of what’s new in MySQL Router stay tuned for an upcoming blog post!…
Facebook Twitter Google+ LinkedIn
Readers of my blog know that I like how MySQL Shell allows you to customize it and use it’s Python and JavaScript support to create custom libraries with tools that help with your daily tasks and even creating auto-refreshing reports. Lefred has even taken this a step further and started to port …
[Read more]This year we’re having a different concept for Percona Live conferences, which started at Percona Live Europe 2018 last fall. This is an approach practiced by many other organizations by having separate track for MySQL®, MongoDB®, MariaDB®, or PostgreSQL and more.
Having many tracks in this big Open Source Database Conference meant that one track steering committee could not be asked to handle all the talks for each track. So we formed several mini-committees to make sure that the submissions to each of the tracks received the right level of attention from the right kind …
[Read more]MySQL 8.0.16 introduces the SQL CHECK constraint feature. This is one of the most requested and long awaited features for MySQL. This post describes the details of the feature. Let’s get started!
Introduction
The CHECK constraint is a type of integrity constraint in SQL.…
Facebook Twitter Google+ LinkedIn
As you may have noticed, MySQL 8.0.16 has been released today !
One of the major long expected feature is the support of
CHECK contraints .
My colleague, Dave Stokes, already posted an article explaining how this works.
In this post, I wanted to show how we could take advantage of this new feature to validate JSON values.
Let’s take the following example:
So we have a collection of documents representing rates from a user on some episodes. Now, I expect that the value for the rating should be between 0 and …
[Read more]Dear MySQL users,
MySQL Shell 8.0.16 is a maintenance release of MySQL Shell 8.0
Series (a
component of the MySQL Server). The MySQL Shell is provided
under
Oracle’s dual-license.
MySQL Shell 8.0 is highly recommended for use with MySQL Server
8.0 and
5.7. Please upgrade to MySQL Shell 8.0.16.
MySQL Shell is an interactive JavaScript, Python and SQL
console
interface, supporting development and administration for the
MySQL
Server. It provides APIs implemented in JavaScript and Python
that
enable you to work with MySQL InnoDB cluster and use MySQL as a
document
store.
The AdminAPI enables you to work with MySQL InnoDB cluster,
providing an
integrated solution for high availability and scalability using
InnoDB
based MySQL databases, without requiring advanced MySQL
expertise. For
more information about how to configure and work with …
Dear MySQL users,
MySQL Connector/J Version 8.0.16 is the GA release of the
8.0
branch of MySQL Connector/J. It is suitable for use with MySQL
Server
versions 8.0, 5.7 and 5.6. It supports the Java Database
Connectivity (JDBC) 4.2 API, and implements the X DevAPI.
This release includes the following new features and changes,
also
described in more detail on
https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-16.html
As always, we recommend that you check the “CHANGES” file in
the
download archive to be aware of changes in behavior that might
affect
your application.
To download MySQL Connector/J 8.0.16 GA, see the “Generally
Available
(GA) Releases” tab at http://dev.mysql.com/downloads/connector/j/
Enjoy!
———————————————————————–
Changes in MySQL Connector/J …
[Read more]Dear MySQL users,
MySQL Connector/ODBC 8.0.16 is a new version in the MySQL
Connector/ODBC 8.0 series,
the ODBC driver for the MySQL Server.
The available downloads include both a Unicode driver and an ANSI
driver based on the
same modern codebase. Please select the driver type you need
based on the type of your
application – Unicode or ANSI. Server-side prepared statements
are enabled by default.
It is suitable for use with the latest MySQL server version 8.0.
This release of the MySQL ODBC driver is conforming to the ODBC
3.8 specification.
It contains implementations of key 3.8 features, including
self-identification
as a ODBC 3.8 driver, streaming of output parameters (supported
for binary types
only), and support of the SQL_ATTR_RESET_CONNECTION connection
attribute (for the
Unicode driver only).
The release is now available in source and binary form …
[Read more]
Before MySQL 8.0.16 you could put constraint checks into your
Data Definition Language (DDL) when creating tables but the
server ignored them. There was much gnashing of teeth as
taunts of "It is not a real database" from other databases
taunted the MySQL Community.
But with 8.0.16 this has all changed. You can now have your data
constraints checked by the server. Below is an example table with
two constraints.
mysql>CREATE TABLE parts
(id int, cost decimal(5,2) not null check (cost >
0),
price
decimal(5,2) not null check (price > 1.0)
);
Query OK, 0 rows affected (0.09 sec)
mysql> insert into parts (id,cost,price) values …