MySQL 8.0.17 adds three new functions to the JSON
repertoire. All three can take advantage of the new
Multi-Value Index feature or can be used on JSON arrays.
JSON_CONTAINS(target, candiate[,
path])
This function indicates with a 1 or 0 if a candidate
document is contained in the target document. The optional
path argument lets you seek information in embedded
documents. And please note the 'haystack' is before the
'needle' for this function.
mysql> SELECT JSON_CONTAINS('{"Moe": 1, "Larry":
2}','{"Moe": 1}');
+------------------------------------------------------+
| JSON_CONTAINS('{"Moe": 1, "Larry": 2}','{"Moe": 1}') |
+------------------------------------------------------+
…
Jul
22
2019
Jul
22
2019
Create a MySQL InnoDB Cluster using MySQL 8.0 has always been very easy. Certainly thanks to MySQL Shell and server enhancements like SET PERSIST and RESTART statement (see this post).
The most complicated part to deal with was the existing and none existing data. In fact GTID sets must be compatible.
Let me explain that with some examples:
Example 1 – empty servers
If you have empty servers with GTID enabled, manually creating credentials to connect to each MySQL instances will generate GTIDs that will prevent nodes to …
[Read more]
Jul
22
2019
Dear MySQL users,
MySQL Connector/J 8.0.17 is the latest General Availability
release of the MySQL Connector/J 8.0 series. 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-17.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.17 GA, see the “Generally
Available
(GA) Releases” tab at …
Jul
22
2019
Dear MySQL Connector/NET community,
We are proud to announce that version 8.0.17 is introducing support for SSH tunneled connections through the classic MySQL protocol and X Protocol. SSH enables the creation of secure encrypted connections between the local and a remote computer allowing services or components to be accessed, MySQL Server in this case. With SSH tunneling, users can connect to a MySQL Server from behind a firewall when the server port is blocked. The server doesn’t require any additional configuration for this type of connection and continues to work as usual.
Users can also add an extra layer of security by making use of SSL over SSH connections, which brings us to the second announcement. Connector/NET previously included support for SSL connections via PFX certificates, which are exclusive to Windows. However, now the support for SSL …
[Read more]
Jul
22
2019
The MySQL Development Team is very excited and proud of what was achieved in this 8.0.17 GA release!
The spotlight is on… A game-changer feature – Automatic Node provisioning!
This has been an extremely desired and important feature, and it has been accomplished, once again, with tight integration and cooperation of MySQL Components:
- The new MySQL Clone Plugin: To take a physical snapshot of the database and transfer it over the network to provision a server, all integrated into the server, using regular MySQL connections.
… Tweet Google Plus Share
Jul
22
2019
MySQL 8.0.17 is out. In addition to fixing a few bugs here and there, we also have a couple of new replication features that I would like to present. Thence, allow me to give you a quick summary. As usual, there shall be follow-up blog posts providing details, so stay tuned.…
Tweet Google Plus Share
Jul
22
2019
The MySQL Development Team is very excited and proud to announce a new 8.0 Maintenance Release of InnoDB Cluster – 8.0.17!
In addition to important bug fixes and improvements, 8.0.17 brings a game-changer feature!
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 LinkedIn
Jul
22
2019
The MySQL Development team is proud to announce a new version of the MySQL Shell in which the following new features can be highlighted:
- MySQL Shell Plugins
- Parallel table import
- In InnoDB Cluster:
- Automatic instance provisioning through cloning
- Automatic server version compatibility handling
- Simplification of internal recovery accounts
The following enhancements were also introduced:
- On the X DevAPI area:
- Support for array indexes in collections
- Support for overlaps operator in expressions
- Uniform SQL execution API in classic and X protocol
- Support for connection attributes
- New utility functions:
- shell.unparseUri(…)
- shell.dumpRows(…)
…
Jul
22
2019
The MySQL Development team is very happy to announce that MySQL 8.0.17 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.17 from dev.mysql.com or from the MySQL Yum, APT, or SUSE repositories.…
Facebook Twitter LinkedIn
Jul
21
2019
Mydbops continues with its commitment to the open source community comprising of Database Administrators. After the successful conduct of three meet-ups in the past, we are now stepping ahead on to the 4th edition of Mydbops Database meet-up.
First time, we are going to the new venue, thanks to the kind people of Zenefits Technologies India Pvt.Ltd., It is a real pleasure to be hosted by the like-minded organisation in the city of Bangalore, scheduled on Saturday, 3rd of August, 2019 at Zenefits Office.
In the past three editions, the focus was on the latest and hands-on topics by the selected speakers from the DBA World. This focus gets sharper this time as well. The topics for the 4 th Mydbops Database Meetup are:
InnoDB scalability improvements in MySQL 8.0 – Mr. Karthik P R, Founder / CEO of Mydbops, a MIT Masters …
[Read more]