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/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]Dear MySQL users,
MySQL Connector/NET 8.0.16 is the fourth version to support
Entity Framework Core 2.1 and the sixth general availability
release
of MySQL Connector/NET to add support for the new X DevAPI,
which
enables application developers to write code that combines
the
strengths of the relational and document models using a
modern,
NoSQL-like syntax that does not assume previous experience
writing traditional SQL.
To learn more about how to write applications using the X DevAPI,
see
http://dev.mysql.com/doc/x-devapi-userguide/en/index.html.
For more
information about how the X DevAPI is implemented in
Connector/NET, see
http://dev.mysql.com/doc/dev/connector-net. NuGet
packages provide functionality at a …
Please join Percona’s Principal Support
Engineer Sveta Smirnova as she presents Billion Goods in Few Categories: How
Histograms Save a Life?
We store data with the intention to use it: search, retrieve, group, sort, etc. To perform these actions effectively, MySQL storage engines index data and communicate statistics with the Optimizer when it compiles a query execution plan. This approach works perfectly well unless your data distribution is uneven.
Last year I worked on several tickets where data followed …
[Read more]The MySQL Development team is very happy to announce that MySQL 8.0.16 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release. Please download 8.0.16 from dev.mysql.com or from the MySQL Yum, APT, or SUSE repositories.…
Facebook Twitter Google+ LinkedIn
