Thu Dec 5 07:11:06 2024
EVENTS
 FREE
SOFTWARE
INSTITUTE

POLITICS
JOBS
MEMBERS'
CORNER

MAILING
LIST

NYLXS Mailing Lists and Archives
NYLXS Members have a lot to say and share but we don't keep many secrets. Join the Hangout Mailing List and say your peice.

DATE 2017-07-01

HANGOUT

2024-12-05 | 2024-11-05 | 2024-10-05 | 2024-09-05 | 2024-08-05 | 2024-07-05 | 2024-06-05 | 2024-05-05 | 2024-04-05 | 2024-03-05 | 2024-02-05 | 2024-01-05 | 2023-12-05 | 2023-11-05 | 2023-10-05 | 2023-09-05 | 2023-08-05 | 2023-07-05 | 2023-06-05 | 2023-05-05 | 2023-04-05 | 2023-03-05 | 2023-02-05 | 2023-01-05 | 2022-12-05 | 2022-11-05 | 2022-10-05 | 2022-09-05 | 2022-08-05 | 2022-07-05 | 2022-06-05 | 2022-05-05 | 2022-04-05 | 2022-03-05 | 2022-02-05 | 2022-01-05 | 2021-12-05 | 2021-11-05 | 2021-10-05 | 2021-09-05 | 2021-08-05 | 2021-07-05 | 2021-06-05 | 2021-05-05 | 2021-04-05 | 2021-03-05 | 2021-02-05 | 2021-01-05 | 2020-12-05 | 2020-11-05 | 2020-10-05 | 2020-09-05 | 2020-08-05 | 2020-07-05 | 2020-06-05 | 2020-05-05 | 2020-04-05 | 2020-03-05 | 2020-02-05 | 2020-01-05 | 2019-12-05 | 2019-11-05 | 2019-10-05 | 2019-09-05 | 2019-08-05 | 2019-07-05 | 2019-06-05 | 2019-05-05 | 2019-04-05 | 2019-03-05 | 2019-02-05 | 2019-01-05 | 2018-12-05 | 2018-11-05 | 2018-10-05 | 2018-09-05 | 2018-08-05 | 2018-07-05 | 2018-06-05 | 2018-05-05 | 2018-04-05 | 2018-03-05 | 2018-02-05 | 2018-01-05 | 2017-12-05 | 2017-11-05 | 2017-10-05 | 2017-09-05 | 2017-08-05 | 2017-07-05 | 2017-06-05 | 2017-05-05 | 2017-04-05 | 2017-03-05 | 2017-02-05 | 2017-01-05 | 2016-12-05 | 2016-11-05 | 2016-10-05 | 2016-09-05 | 2016-08-05 | 2016-07-05 | 2016-06-05 | 2016-05-05 | 2016-04-05 | 2016-03-05 | 2016-02-05 | 2016-01-05 | 2015-12-05 | 2015-11-05 | 2015-10-05 | 2015-09-05 | 2015-08-05 | 2015-07-05 | 2015-06-05 | 2015-05-05 | 2015-04-05 | 2015-03-05 | 2015-02-05 | 2015-01-05 | 2014-12-05 | 2014-11-05 | 2014-10-05 | 2014-09-05 | 2014-08-05 | 2014-07-05 | 2014-06-05 | 2014-05-05 | 2014-04-05 | 2014-03-05 | 2014-02-05 | 2014-01-05 | 2013-12-05 | 2013-11-05 | 2013-10-05 | 2013-09-05 | 2013-08-05 | 2013-07-05 | 2013-06-05 | 2013-05-05 | 2013-04-05 | 2013-03-05 | 2013-02-05 | 2013-01-05 | 2012-12-05 | 2012-11-05 | 2012-10-05 | 2012-09-05 | 2012-08-05 | 2012-07-05 | 2012-06-05 | 2012-05-05 | 2012-04-05 | 2012-03-05 | 2012-02-05 | 2012-01-05 | 2011-12-05 | 2011-11-05 | 2011-10-05 | 2011-09-05 | 2011-08-05 | 2011-07-05 | 2011-06-05 | 2011-05-05 | 2011-04-05 | 2011-03-05 | 2011-02-05 | 2011-01-05 | 2010-12-05 | 2010-11-05 | 2010-10-05 | 2010-09-05 | 2010-08-05 | 2010-07-05 | 2010-06-05 | 2010-05-05 | 2010-04-05 | 2010-03-05 | 2010-02-05 | 2010-01-05 | 2009-12-05 | 2009-11-05 | 2009-10-05 | 2009-09-05 | 2009-08-05 | 2009-07-05 | 2009-06-05 | 2009-05-05 | 2009-04-05 | 2009-03-05 | 2009-02-05 | 2009-01-05 | 2008-12-05 | 2008-11-05 | 2008-10-05 | 2008-09-05 | 2008-08-05 | 2008-07-05 | 2008-06-05 | 2008-05-05 | 2008-04-05 | 2008-03-05 | 2008-02-05 | 2008-01-05 | 2007-12-05 | 2007-11-05 | 2007-10-05 | 2007-09-05 | 2007-08-05 | 2007-07-05 | 2007-06-05 | 2007-05-05 | 2007-04-05 | 2007-03-05 | 2007-02-05 | 2007-01-05 | 2006-12-05 | 2006-11-05 | 2006-10-05 | 2006-09-05 | 2006-08-05 | 2006-07-05 | 2006-06-05 | 2006-05-05 | 2006-04-05 | 2006-03-05 | 2006-02-05 | 2006-01-05 | 2005-12-05 | 2005-11-05 | 2005-10-05 | 2005-09-05 | 2005-08-05 | 2005-07-05 | 2005-06-05 | 2005-05-05 | 2005-04-05 | 2005-03-05 | 2005-02-05 | 2005-01-05 | 2004-12-05 | 2004-11-05 | 2004-10-05 | 2004-09-05 | 2004-08-05 | 2004-07-05 | 2004-06-05 | 2004-05-05 | 2004-04-05 | 2004-03-05 | 2004-02-05 | 2004-01-05 | 2003-12-05 | 2003-11-05 | 2003-10-05 | 2003-09-05 | 2003-08-05 | 2003-07-05 | 2003-06-05 | 2003-05-05 | 2003-04-05 | 2003-03-05 | 2003-02-05 | 2003-01-05 | 2002-12-05 | 2002-11-05 | 2002-10-05 | 2002-09-05 | 2002-08-05 | 2002-07-05 | 2002-06-05 | 2002-05-05 | 2002-04-05 | 2002-03-05 | 2002-02-05 | 2002-01-05 | 2001-12-05 | 2001-11-05 | 2001-10-05 | 2001-09-05 | 2001-08-05 | 2001-07-05 | 2001-06-05 | 2001-05-05 | 2001-04-05 | 2001-03-05 | 2001-02-05 | 2001-01-05 | 2000-12-05 | 2000-11-05 | 2000-10-05 | 2000-09-05 | 2000-08-05 | 2000-07-05 | 2000-06-05 | 2000-05-05 | 2000-04-05 | 2000-03-05 | 2000-02-05 | 2000-01-05 | 1999-12-05

Key: Value:

Key: Value:

MESSAGE
DATE 2017-07-28
FROM Balasubramanian Kandasamy
SUBJECT Subject: [Hangout - NYLXS] MySQL Shell 1.0.10 GA has been released
From hangout-bounces-at-nylxs.com Fri Jul 28 07:51:11 2017
Return-Path:
X-Original-To: archive-at-nylxs.com
Delivered-To: archive-at-nylxs.com
Received: from www.mrbrklyn.com (www.mrbrklyn.com [96.57.23.82])
by mrbrklyn.com (Postfix) with ESMTP id 3D724163F57;
Fri, 28 Jul 2017 07:51:09 -0400 (EDT)
X-Original-To: hangout-at-www.mrbrklyn.com
Delivered-To: hangout-at-www.mrbrklyn.com
Received: by mrbrklyn.com (Postfix, from userid 1000)
id 743F8163F56; Fri, 28 Jul 2017 07:51:06 -0400 (EDT)
Resent-From: Ruben Safir
Resent-Date: Fri, 28 Jul 2017 07:51:06 -0400
Resent-Message-ID: <20170728115106.GA24191-at-www.mrbrklyn.com>
Resent-To: hangout-at-mrbrklyn.com
X-Original-To: ruben-at-mrbrklyn.com
Delivered-To: ruben-at-mrbrklyn.com
Received: from acsinet41.oracle.com (acsinet41.oracle.com [141.146.126.229])
by mrbrklyn.com (Postfix) with ESMTP id C08E6160876
for ; Fri, 28 Jul 2017 07:21:22 -0400 (EDT)
Received: from lists.mysql.com (unknown [137.254.60.71]) by
acsinet41.oracle.com with smtp
id 5b9b_03d7_36d4797c_ea30_45a9_8592_4e3b10413de3;
Fri, 28 Jul 2017 11:21:21 +0000
Received: (qmail 4872 invoked by uid 209); 28 Jul 2017 11:21:13 -0000
Mailing-List: contact mysql-help-at-lists.mysql.com; run by ezmlm
Precedence: list
Auto-Submitted: auto-generated
List-Archive: http://lists.mysql.com/mysql/231912
Delivered-To: mailing list mysql-at-lists.mysql.com
Received: (qmail 4813 invoked by uid 208); 28 Jul 2017 11:21:13 -0000
From: Balasubramanian Kandasamy
To: announce-at-lists.mysql.com, mysql-at-lists.mysql.com, packagers-at-lists.mysql.com
Message-ID: <681c2375-5402-448c-1540-2d0ce1ce87c4-at-oracle.com>
Date: Fri, 28 Jul 2017 16:50:53 +0530
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
Thunderbird/45.7.0
MIME-Version: 1.0
X-Source-IP: userv0021.oracle.com [156.151.31.71]
Subject: [Hangout - NYLXS] MySQL Shell 1.0.10 GA has been released
X-BeenThere: hangout-at-nylxs.com
X-Mailman-Version: 2.1.17
List-Id: NYLXS Tech Talk and Politics
List-Unsubscribe: ,

List-Post:
List-Help:
List-Subscribe: ,

Content-Type: multipart/mixed; boundary="===============0293296712=="
Errors-To: hangout-bounces-at-nylxs.com
Sender: "Hangout"

--===============0293296712==
Content-Type: multipart/alternative;
boundary="------------271B4E8B3438DC17D54F7DB5"

--------------271B4E8B3438DC17D54F7DB5
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit


Dear MySQL Users,

A new GA (general availability) version of MySQL Shell
(a component of the MySQL Server) has been made
available: MySQL Shell 1.0.10 GA. The MySQL Shell is provided
under Oracle's dual-license.

MySQL Shell is an interactive JavaScript, Python and SQL console
interface, supporting development and administration for the MySQL
Server. It provides scriptable API that supports the creation and
management of MySQL InnoDB clusters, as well as a modern fluent CRUD
API for the MySQL Document Store.

The AdminAPI provides an integrated solution for high availability and
scalability using InnoDB based MySQL databases, without requiring
advanced MySQL expertise.

The Document Store DevAPI enables developers and DBAs to create
"schema-less" JSON document collections and perform Create, Update,
Read, Delete (CRUD) operations on those collections with little to
no knowledge of the SQL language.

Additionally, MySQL Shell provides partial compatibility with the
mysql command line client by supporting many of the same command line
options. As with the mysql command line, MySQL Shell can also be used
to connect to and send SQL commands to pre-5.7.12 versions of the
MySQL server using the standard MySQL network protocol.

For more information about how to configure and work with an InnoDB cluster
see https://dev.mysql.com/doc/refman/en/mysql-innodb-cluster-userguide.html

For more information about how to use MySQL Shell and the MySQL Document
Store support see https://dev.mysql.com/doc/refman/en/document-store.html

For full documentation on MySQL Server, MySQL Shell and related topics,
see http://dev.mysql.com/doc/refman/en/

If you want to write applications that use the the CRUD based X DevAPI
use the latest MySQL Connectors for your language of choice. You can
also find documentation about Connectors in the MySQL documentation
site.

For more information about how to download MySQL Shell, see
http://dev.mysql.com/downloads/shell/

We welcome and appreciate your feedback and bug reports, see
http://bugs.mysql.com/

Enjoy!

Changes in MySQL Shell 1.0.10 (2017-07-28, General Availability)


Security Notes

* Security Fix: The linked OpenSSL library for MySQL Shell
Commercial has been updated to version 1.0.2l. Issues
fixed in the new OpenSSL version are described at
http://www.openssl.org/news/vulnerabilities.html.
This change does not affect Oracle-produced MySQL
Community builds of MySQL Shell, which use the yaSSL
library instead. (Bug #26284262)

* Security Fix: Running queries on servers using MySQL 8
against a table with a text column caused an unexpected
halt.

Functionality Added or Changed

* The clusterAdminType option of the dba.createCluster()
was unused and has been removed. (Bug #25585027)

* The --help message now displays all short-form options.
The --help message now displays complete information for
the --json option.
shell.help('options') now returns usable information
about mysqlsh options.
cluster.help('checkInstanceState') now reports correct
information.
cluster.help('addInstance') and
cluster.help('rejoinInstance') now report complete
information.
help() now reports complete information for all AdminAPI
and Shell commands. (Bug #24841493, Bug #24910540, Bug
#24841749, Bug #25701345, Bug #24977542, Bug #25268410,
Bug #25266846)

* Calling the modify() or remove() function without a
parameter caused the function to be executed against the
whole collection, which could cause unexpected results
such as deleting all rows in a table. To avoid this and
make the behavior consistent with update() and delete(),
a client-side exception is now thrown if the modify() or
remove() function is called without a parameter. Now, to
execute the modify() or remove() function against a
collection call them with an expression that evaluates to
true, for example remove('true') or modify('true').

Bugs Fixed

* When making cluster topology or membership changes,
AdminAPI was not taking into consideration the value of
group_replication_group_name, which could lead to
incorrect, non-deterministic results in scenarios such as
split-brains. Now, the following commands validate the
InnoDB cluster Metadata and the corresponding instance's
group_replication_group_name value:

+ dba.getCluster()

+ Cluster.rejoinInstance()

+ Cluster.forceQuorumUsingPartitionOf()
If the values of group_replication_group_name do not
match, the commands abort with an error.
dba.rebootClusterFromCompleteOutage() was also updated to
ensure that the group_replication_group_name variable has
not been changed before rejoining the instance. (Bug
#26159339)

* AdminAPI now always uses the active user value for the
current mysqlsh session, whether the value was explicitly
specified by the user or is the result of an implicit
default used by mysqlsh. (Bug #26132527)

* The addInstance() function was failing when run against a
server using MySQL 8. (Bug #26085799)

* Executing AdminAPI commands on a server with a version of
Python lower than 2.7 was failing without the correct
error message. (Bug #25975317)

* The checks performed by the AdminAPI upon issuing
dba.rebootClusterFromCompleteOutage() were more strict
than those required by Group Replication. Now, the
AdminAPI considers tables with a Primary Key Equivalent
(such as a Non Null Unique Key) as compatible, matching
the current requirement for Group Replication. (Bug
#25974689)

* Executing dba.createCluster() on an instance with
sql_mode=ANSI_QUOTES failed with an error. (Bug
#25966057)
References: See also: Bug #25990172.

* The server version is now displayed as part of the
"Connected to" message. (Bug #25824753)

* When using MySQL Shell on Windows any files created or
opened, for example those used during
dba.createSandboxInstance(), could not be deleted. (Bug
#25789094)

* Queries that used an expression of the form
collection.find(identifier IN identifier) caused an
abnormal mysqlsh exit. (Bug #25754078)

* If AdminAPI functions were interrupted, for example with
control-C on Unix, the exit code returned by the process
was 1 instead of the expected one for terminated
processes, for example SIGINT. (Bug #25728759)

* The previous limitation of auto_increment_increment being
set according to the random 32-bit unsigned integers used
for the server-id system variable has been resolved. Now,
when operating in single-primary mode
auto_increment_increment is set to 1 and
auto_increment_offset is set to 2. In multi-primary mode
auto_increment_increment is set to 7 and
auto_increment_offset is set to 1 plus the server_id
modulo 7. (Bug #25724564)

* The randomly generated passwords used by internal users
were not compatible with instances running the Password
Validation plugin. (Bug #25714751)

* The help for dba.configureLocalInstance(instance[,
options]) has been improved to describe the returned JSON
object. (Bug #25703028)

* The options in the MySQL Shell options dictionary are now
fully documented. (Bug #25701345)

* Issuing configureLocalInstance() when using a URI that
contained a user without the correct privileges resulted
in an incorrect new user being created. Now, if the user
in configureLocalInstance() URI does not have enough
privileges to grant all the necessary privileges for the
new user chosen during the interactive wizard
configuration the user is not created. (Bug #25614855)

* Issuing Cluster.rescan() resulted in non-determinstic
behavior which could produce incorrect JSON output,
showing an instance that was already part of the cluster
as belonging to the newlyDiscoveredInstances[] list and
to the unavailableInstances[] list. This also resulted in
MySQL Shell prompting to add or remove the instance from
the cluster. (Bug #25534693)

* AdminAPI functions now accept the standard connection
parameters as used by shell.connect. New validations have
been added for when require_secure_transport is ON, now
it is not possible to to create a cluster with
memberSslMode:DISABLED or to add an instance with
require_secure_transport=ON to a cluster where
memberSslMode:DISABLED. (Bug #25532298)

* The parsing of account names, for example when passing
the clusterAdmin option to dba.configureLocalInstance()
has been improved. (Bug #25528695)

* Issuing configureLocalInstance() twice could fail. (Bug
#25519190)

* When passing the rejoinInstances[] option to
dba.rebootClusterFromCompleteOutage(), if no
rejoinInstances[] option was specified then members were
being incorrectly handled during the rebuild. Now,
instances that are eligible to be added to the
rejoinInstances[] list but that are specified in the
removeInstances[] list are skipped by the interactive
wizard that tries to automatically build a
rejoinInstances[] list if one was not provided. This fix
also ensures that both interactive and non interactive
use of MySQL Shell correctly verify the rejoinInstances[]
list does not contain a non reachable instance. (Bug
#25516390)

* When using dba.deploySandboxInstance() and passing in
sandboxDir, the specified path must not exceed 89
characters. (Bug #25485035)

* shell.connect() did not report an error if an invalid
argument was used. An ArgumentError is now issued for any
invalid argument.
The following mutually exclusive pairs of options are now
checked, and an error is issued if both are specified:

+ --password and --dbPassword

+ --user and --dbUser

+ --port and --socket
(Bug #25268670)
References: See also: Bug #24911173.

* Issuing removeInstance() on the last member of a cluster,
and particularly the seed member, was resulting in a
cluster that could not be dissolved. Now, issuing
removeInstance() on the last member of a cluster results
in an error, and you must use dissolve() on that instance
to ensure the cluster is correctly dissolved. (Bug
#25226130)

* removeInstance() resulted in unexpected behavior in some
cases, for example when an empty password was passed as
part of the URI to the instance. (Bug #25111911)

* The default for prompts has been made more consistent.
(Bug #25039886)

* A number of issues with the output of
shell.help("prompt") have been corrected. (Bug #25026855,
Bug #25242638, Bug #25676343, Bug #25176769)

* The usage of the terms global session and active session
have been made more consistent in the user interface.
(Bug #24954546)

* The removeInstance() was not working on stopped instances
and it was not possible to remove an unavailable instance
from the cluster. The fix adds a new option force to the
removeInstance() command to enable you to remove
instances from the metadata that are permanently not
available, avoiding obsolete data from being kept in the
metadata of the cluster. In addition the error message
provided when not using the force option has been
improved and the online help for the removeInstance() was
also updated accordingly. (Bug #24916064)

* Unsigned data could be incorrectly read from the
database. (Bug #24912358)

* MySQL Shell now displays an invalid year as 0000,
matching the behavior of the MySQL prompt, rather than as
0. (Bug #24912061)

* MySQL Shell did not display fractional seconds for values
in DATETIME columns. (Bug #24911885)

* The parsing of Unix sockets provided as part of a URI has
been improved. (Bug #24905066)

* Creating Classic sessions that connect using Unix sockets
now uses the correct defaults such as hostname. This
resolves the previous limitation of using Unix sockets to
connect to InnoDB cluster instances. See MySQL Shell Connections
(http://dev.mysql.com/doc/refman/5.7/en/mysql-shell-connections.html)
for information on how the defaults are
applied to socket connections. (Bug #24848763, Bug
#26036466)
References: See also: Bug #24911068.

* Some issues with the MySQL Shell command line help output
were fixed. (Bug #24841749, Bug #24841493, Bug #24910540)

* If an error occurs now both the error number and error
text are correctly displayed. (Bug #24816578)

* URIs were incorrectly parsed in MySQL Shell when
passwords were hidden. (Bug #24793956)

* The error messages generated by issuing
dba.deployLocalInstance() against an unsuitable or
incompatible instance have been improved. (Bug #24598272)

* The dba.createCluster(), dba.getCluster(), and
dba.rebootClusterFromCompleteOutage() functions have been
updated to validate the cluster name, using the following
rules:

+ Name must start with a letter or the _ character

+ Name can only contain alphanumeric characters and
the _ character

+ Cannot be longer than 40 characters

+ Cannot be empty
The Cluster.addInstance() function has been updated to
validate the label used on an instance in the cluster,
using the following rules:

+ Label can only contain alphanumerics or the _
character

+ Cannot be longer than 256 characters

+ Cannot be empty
(Bug #24565242)

* Using the --dba enableXProtocol option to install X
Plugin was failing. (Bug #23508428)

* mysqlsh stopped responding if the \source command was
given a directory (rather than file) argument. (Bug
#23097932, Bug #81060)

* When using cluster.rejoinInstance() any user specified in
the connection string passed in was being ignored and the
connection was using the root user. (Bug #85567, Bug
#25786495)

* On an instance configured as a multi-threaded slave, in
other words slave_parallel_workers set to greater than 0,
and with slave_parallel_type=DATABASE,
dba.checkInstanceConfiguration() was not detecting that
the instance was not correctly configured for InnoDB
cluster usage.

* If removeInstance() failed due to a connection error, an
error was reported but the instance was incorrectly
removed from the InnoDB cluster metadata, and remained
part of the replication group. The fix ensures the
metadata is correctly updated according to the result of
removeInstance().

* In a situation where a new primary instance was elected,
adding a new instance to the cluster resulted in an error
due to a failed connection to the previous primary
instance.

* The functions that modify server variables, such as
dba.createCluster() and dba.validateInstance() now
provide more information in interactive mode output and
log output about server variables which are changed when
executed.

* Deploying instances to paths with directories that
contained spaces was failing without error. Use double
backslash to specify such paths, for example
D:\\Cluster\\foo bar.

* The Cluster object obtained from functions such as
dba.createCluster() or dba.getCluster() became unusable
once the Shell session in which the object was created is
was connected to a different server. The fix modifies the
Cluster object so that:

+ The Cluster object holds an internal reference to
the Session from which it was created or retrieved.

+ AdminAPI functions that modify the Cluster are made
using the session referenced by the object.

On Behalf of the MySQL/ORACLE RE Team
Balasubramanian Kandasamy


--------------271B4E8B3438DC17D54F7DB5--

--===============0293296712==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Hangout mailing list
Hangout-at-nylxs.com
http://www.nylxs.com/mailman/listinfo/hangout

--===============0293296712==--

--===============0293296712==
Content-Type: multipart/alternative;
boundary="------------271B4E8B3438DC17D54F7DB5"

--------------271B4E8B3438DC17D54F7DB5
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit


Dear MySQL Users,

A new GA (general availability) version of MySQL Shell
(a component of the MySQL Server) has been made
available: MySQL Shell 1.0.10 GA. The MySQL Shell is provided
under Oracle's dual-license.

MySQL Shell is an interactive JavaScript, Python and SQL console
interface, supporting development and administration for the MySQL
Server. It provides scriptable API that supports the creation and
management of MySQL InnoDB clusters, as well as a modern fluent CRUD
API for the MySQL Document Store.

The AdminAPI provides an integrated solution for high availability and
scalability using InnoDB based MySQL databases, without requiring
advanced MySQL expertise.

The Document Store DevAPI enables developers and DBAs to create
"schema-less" JSON document collections and perform Create, Update,
Read, Delete (CRUD) operations on those collections with little to
no knowledge of the SQL language.

Additionally, MySQL Shell provides partial compatibility with the
mysql command line client by supporting many of the same command line
options. As with the mysql command line, MySQL Shell can also be used
to connect to and send SQL commands to pre-5.7.12 versions of the
MySQL server using the standard MySQL network protocol.

For more information about how to configure and work with an InnoDB cluster
see https://dev.mysql.com/doc/refman/en/mysql-innodb-cluster-userguide.html

For more information about how to use MySQL Shell and the MySQL Document
Store support see https://dev.mysql.com/doc/refman/en/document-store.html

For full documentation on MySQL Server, MySQL Shell and related topics,
see http://dev.mysql.com/doc/refman/en/

If you want to write applications that use the the CRUD based X DevAPI
use the latest MySQL Connectors for your language of choice. You can
also find documentation about Connectors in the MySQL documentation
site.

For more information about how to download MySQL Shell, see
http://dev.mysql.com/downloads/shell/

We welcome and appreciate your feedback and bug reports, see
http://bugs.mysql.com/

Enjoy!

Changes in MySQL Shell 1.0.10 (2017-07-28, General Availability)


Security Notes

* Security Fix: The linked OpenSSL library for MySQL Shell
Commercial has been updated to version 1.0.2l. Issues
fixed in the new OpenSSL version are described at
http://www.openssl.org/news/vulnerabilities.html.
This change does not affect Oracle-produced MySQL
Community builds of MySQL Shell, which use the yaSSL
library instead. (Bug #26284262)

* Security Fix: Running queries on servers using MySQL 8
against a table with a text column caused an unexpected
halt.

Functionality Added or Changed

* The clusterAdminType option of the dba.createCluster()
was unused and has been removed. (Bug #25585027)

* The --help message now displays all short-form options.
The --help message now displays complete information for
the --json option.
shell.help('options') now returns usable information
about mysqlsh options.
cluster.help('checkInstanceState') now reports correct
information.
cluster.help('addInstance') and
cluster.help('rejoinInstance') now report complete
information.
help() now reports complete information for all AdminAPI
and Shell commands. (Bug #24841493, Bug #24910540, Bug
#24841749, Bug #25701345, Bug #24977542, Bug #25268410,
Bug #25266846)

* Calling the modify() or remove() function without a
parameter caused the function to be executed against the
whole collection, which could cause unexpected results
such as deleting all rows in a table. To avoid this and
make the behavior consistent with update() and delete(),
a client-side exception is now thrown if the modify() or
remove() function is called without a parameter. Now, to
execute the modify() or remove() function against a
collection call them with an expression that evaluates to
true, for example remove('true') or modify('true').

Bugs Fixed

* When making cluster topology or membership changes,
AdminAPI was not taking into consideration the value of
group_replication_group_name, which could lead to
incorrect, non-deterministic results in scenarios such as
split-brains. Now, the following commands validate the
InnoDB cluster Metadata and the corresponding instance's
group_replication_group_name value:

+ dba.getCluster()

+ Cluster.rejoinInstance()

+ Cluster.forceQuorumUsingPartitionOf()
If the values of group_replication_group_name do not
match, the commands abort with an error.
dba.rebootClusterFromCompleteOutage() was also updated to
ensure that the group_replication_group_name variable has
not been changed before rejoining the instance. (Bug
#26159339)

* AdminAPI now always uses the active user value for the
current mysqlsh session, whether the value was explicitly
specified by the user or is the result of an implicit
default used by mysqlsh. (Bug #26132527)

* The addInstance() function was failing when run against a
server using MySQL 8. (Bug #26085799)

* Executing AdminAPI commands on a server with a version of
Python lower than 2.7 was failing without the correct
error message. (Bug #25975317)

* The checks performed by the AdminAPI upon issuing
dba.rebootClusterFromCompleteOutage() were more strict
than those required by Group Replication. Now, the
AdminAPI considers tables with a Primary Key Equivalent
(such as a Non Null Unique Key) as compatible, matching
the current requirement for Group Replication. (Bug
#25974689)

* Executing dba.createCluster() on an instance with
sql_mode=ANSI_QUOTES failed with an error. (Bug
#25966057)
References: See also: Bug #25990172.

* The server version is now displayed as part of the
"Connected to" message. (Bug #25824753)

* When using MySQL Shell on Windows any files created or
opened, for example those used during
dba.createSandboxInstance(), could not be deleted. (Bug
#25789094)

* Queries that used an expression of the form
collection.find(identifier IN identifier) caused an
abnormal mysqlsh exit. (Bug #25754078)

* If AdminAPI functions were interrupted, for example with
control-C on Unix, the exit code returned by the process
was 1 instead of the expected one for terminated
processes, for example SIGINT. (Bug #25728759)

* The previous limitation of auto_increment_increment being
set according to the random 32-bit unsigned integers used
for the server-id system variable has been resolved. Now,
when operating in single-primary mode
auto_increment_increment is set to 1 and
auto_increment_offset is set to 2. In multi-primary mode
auto_increment_increment is set to 7 and
auto_increment_offset is set to 1 plus the server_id
modulo 7. (Bug #25724564)

* The randomly generated passwords used by internal users
were not compatible with instances running the Password
Validation plugin. (Bug #25714751)

* The help for dba.configureLocalInstance(instance[,
options]) has been improved to describe the returned JSON
object. (Bug #25703028)

* The options in the MySQL Shell options dictionary are now
fully documented. (Bug #25701345)

* Issuing configureLocalInstance() when using a URI that
contained a user without the correct privileges resulted
in an incorrect new user being created. Now, if the user
in configureLocalInstance() URI does not have enough
privileges to grant all the necessary privileges for the
new user chosen during the interactive wizard
configuration the user is not created. (Bug #25614855)

* Issuing Cluster.rescan() resulted in non-determinstic
behavior which could produce incorrect JSON output,
showing an instance that was already part of the cluster
as belonging to the newlyDiscoveredInstances[] list and
to the unavailableInstances[] list. This also resulted in
MySQL Shell prompting to add or remove the instance from
the cluster. (Bug #25534693)

* AdminAPI functions now accept the standard connection
parameters as used by shell.connect. New validations have
been added for when require_secure_transport is ON, now
it is not possible to to create a cluster with
memberSslMode:DISABLED or to add an instance with
require_secure_transport=ON to a cluster where
memberSslMode:DISABLED. (Bug #25532298)

* The parsing of account names, for example when passing
the clusterAdmin option to dba.configureLocalInstance()
has been improved. (Bug #25528695)

* Issuing configureLocalInstance() twice could fail. (Bug
#25519190)

* When passing the rejoinInstances[] option to
dba.rebootClusterFromCompleteOutage(), if no
rejoinInstances[] option was specified then members were
being incorrectly handled during the rebuild. Now,
instances that are eligible to be added to the
rejoinInstances[] list but that are specified in the
removeInstances[] list are skipped by the interactive
wizard that tries to automatically build a
rejoinInstances[] list if one was not provided. This fix
also ensures that both interactive and non interactive
use of MySQL Shell correctly verify the rejoinInstances[]
list does not contain a non reachable instance. (Bug
#25516390)

* When using dba.deploySandboxInstance() and passing in
sandboxDir, the specified path must not exceed 89
characters. (Bug #25485035)

* shell.connect() did not report an error if an invalid
argument was used. An ArgumentError is now issued for any
invalid argument.
The following mutually exclusive pairs of options are now
checked, and an error is issued if both are specified:

+ --password and --dbPassword

+ --user and --dbUser

+ --port and --socket
(Bug #25268670)
References: See also: Bug #24911173.

* Issuing removeInstance() on the last member of a cluster,
and particularly the seed member, was resulting in a
cluster that could not be dissolved. Now, issuing
removeInstance() on the last member of a cluster results
in an error, and you must use dissolve() on that instance
to ensure the cluster is correctly dissolved. (Bug
#25226130)

* removeInstance() resulted in unexpected behavior in some
cases, for example when an empty password was passed as
part of the URI to the instance. (Bug #25111911)

* The default for prompts has been made more consistent.
(Bug #25039886)

* A number of issues with the output of
shell.help("prompt") have been corrected. (Bug #25026855,
Bug #25242638, Bug #25676343, Bug #25176769)

* The usage of the terms global session and active session
have been made more consistent in the user interface.
(Bug #24954546)

* The removeInstance() was not working on stopped instances
and it was not possible to remove an unavailable instance
from the cluster. The fix adds a new option force to the
removeInstance() command to enable you to remove
instances from the metadata that are permanently not
available, avoiding obsolete data from being kept in the
metadata of the cluster. In addition the error message
provided when not using the force option has been
improved and the online help for the removeInstance() was
also updated accordingly. (Bug #24916064)

* Unsigned data could be incorrectly read from the
database. (Bug #24912358)

* MySQL Shell now displays an invalid year as 0000,
matching the behavior of the MySQL prompt, rather than as
0. (Bug #24912061)

* MySQL Shell did not display fractional seconds for values
in DATETIME columns. (Bug #24911885)

* The parsing of Unix sockets provided as part of a URI has
been improved. (Bug #24905066)

* Creating Classic sessions that connect using Unix sockets
now uses the correct defaults such as hostname. This
resolves the previous limitation of using Unix sockets to
connect to InnoDB cluster instances. See MySQL Shell Connections
(http://dev.mysql.com/doc/refman/5.7/en/mysql-shell-connections.html)
for information on how the defaults are
applied to socket connections. (Bug #24848763, Bug
#26036466)
References: See also: Bug #24911068.

* Some issues with the MySQL Shell command line help output
were fixed. (Bug #24841749, Bug #24841493, Bug #24910540)

* If an error occurs now both the error number and error
text are correctly displayed. (Bug #24816578)

* URIs were incorrectly parsed in MySQL Shell when
passwords were hidden. (Bug #24793956)

* The error messages generated by issuing
dba.deployLocalInstance() against an unsuitable or
incompatible instance have been improved. (Bug #24598272)

* The dba.createCluster(), dba.getCluster(), and
dba.rebootClusterFromCompleteOutage() functions have been
updated to validate the cluster name, using the following
rules:

+ Name must start with a letter or the _ character

+ Name can only contain alphanumeric characters and
the _ character

+ Cannot be longer than 40 characters

+ Cannot be empty
The Cluster.addInstance() function has been updated to
validate the label used on an instance in the cluster,
using the following rules:

+ Label can only contain alphanumerics or the _
character

+ Cannot be longer than 256 characters

+ Cannot be empty
(Bug #24565242)

* Using the --dba enableXProtocol option to install X
Plugin was failing. (Bug #23508428)

* mysqlsh stopped responding if the \source command was
given a directory (rather than file) argument. (Bug
#23097932, Bug #81060)

* When using cluster.rejoinInstance() any user specified in
the connection string passed in was being ignored and the
connection was using the root user. (Bug #85567, Bug
#25786495)

* On an instance configured as a multi-threaded slave, in
other words slave_parallel_workers set to greater than 0,
and with slave_parallel_type=DATABASE,
dba.checkInstanceConfiguration() was not detecting that
the instance was not correctly configured for InnoDB
cluster usage.

* If removeInstance() failed due to a connection error, an
error was reported but the instance was incorrectly
removed from the InnoDB cluster metadata, and remained
part of the replication group. The fix ensures the
metadata is correctly updated according to the result of
removeInstance().

* In a situation where a new primary instance was elected,
adding a new instance to the cluster resulted in an error
due to a failed connection to the previous primary
instance.

* The functions that modify server variables, such as
dba.createCluster() and dba.validateInstance() now
provide more information in interactive mode output and
log output about server variables which are changed when
executed.

* Deploying instances to paths with directories that
contained spaces was failing without error. Use double
backslash to specify such paths, for example
D:\\Cluster\\foo bar.

* The Cluster object obtained from functions such as
dba.createCluster() or dba.getCluster() became unusable
once the Shell session in which the object was created is
was connected to a different server. The fix modifies the
Cluster object so that:

+ The Cluster object holds an internal reference to
the Session from which it was created or retrieved.

+ AdminAPI functions that modify the Cluster are made
using the session referenced by the object.

On Behalf of the MySQL/ORACLE RE Team
Balasubramanian Kandasamy


--------------271B4E8B3438DC17D54F7DB5--

--===============0293296712==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Hangout mailing list
Hangout-at-nylxs.com
http://www.nylxs.com/mailman/listinfo/hangout

--===============0293296712==--

  1. 2017-07-02 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] Major intel bug with Generation 7 and Xeon chips
  2. 2017-07-02 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] itel hyperthreading bug
  3. 2017-07-02 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] firefox is dead as a platform now
  4. 2017-07-02 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] dropping alsa support and forcing pulseaudio
  5. 2017-07-03 Gabor Szabo <gabor-at-szabgab.com> Subject: [Hangout - NYLXS] [Perlweekly] #310 - Half-way through 2017
  6. 2017-07-03 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] check this video out... I'm going to show you
  7. 2017-07-05 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] Big Data is ready to crush you
  8. 2017-07-05 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] Chaim Deutch on Facebook and Coney Island
  9. 2017-07-07 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] Movie of the week
  10. 2017-07-07 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] Fwd: [mothur] Upcoming R workshop for Microbial
  11. 2017-07-07 From: "Pat Schloss" <pschloss-at-umich.edu> Re: [Hangout - NYLXS] [mothur] Upcoming R workshop for Microbial
  12. 2017-07-06 Brooklyn Urban Anglers Association <comment-reply-at-wordpress.com> Subject: [Hangout - NYLXS] =?utf-8?q?=5BNew_post=5D_BROOKLYN_HISTORICAL_SO?=
  13. 2017-07-10 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] IT Jobs
  14. 2017-07-13 Brooklyn Cyclones <info-at-brooklyncyclones.com> Subject: [Hangout - NYLXS] Jersey Giveaway & Fireworks Friday Night at MCU
  15. 2017-07-16 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] Pluto
  16. 2017-07-16 From: "Ruben.Safir" <ruben.safir-at-my.liu.edu> Subject: [Hangout - NYLXS] Fwd: Updates to GitHub Terms of Service
  17. 2017-07-17 From: "Mancini, Sabin (DFS)" <Sabin.Mancini-at-dfs.ny.gov> Re: [Hangout - NYLXS] [Learn] Pluto [ What is it ? The planet,
  18. 2017-07-18 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] Recruiter
  19. 2017-07-18 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] Covers
  20. 2017-07-17 Gabor Szabo <gabor-at-szabgab.com> Subject: [Hangout - NYLXS] [Perlweekly] #312 - Last chance to support the
  21. 2017-07-19 einker <eminker-at-gmail.com> Re: [Hangout - NYLXS] Recruiter
  22. 2017-07-19 Nick Shockey <opencon-at-sparcopen.org> Subject: [Hangout - NYLXS] Less than two weeks left to apply for OpenCon
  23. 2017-07-19 Ruben Safir <ruben.safir-at-my.liu.edu> Subject: [Hangout - NYLXS] Fwd: Re: [mothur] Upcoming R workshop for
  24. 2017-07-20 ruben safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] Fwd: Job Opportunity | Unix Lead | Sydney,
  25. 2017-07-19 From: "IEEE Communications Society" <noreply-at-comsoc.org> Subject: [Hangout - NYLXS] [White Paper] Fundamentals of Vector Network
  26. 2017-07-25 Ruben Safir <mrbrklyn-at-panix.com> Subject: [Hangout - NYLXS] Fwd: Only 1 week left to apply to attend OpenCon
  27. 2017-07-24 Gabor Szabo <gabor-at-szabgab.com> Subject: [Hangout - NYLXS] [Perlweekly] #313 - 1000 days of CPAN releases.
  28. 2017-07-25 From: "Ladders" <jobs-at-theladders.com> Subject: [Hangout - NYLXS] Now Hiring!
  29. 2017-07-24 Pharmacist e-Link <communications-at-pharmacistelink.com> Subject: [Hangout - NYLXS] CBO Says ACA Repeal Would Add 32 Million
  30. 2017-07-27 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] NYC jobs news IT
  31. 2017-07-28 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] Fwd: [Accu-contacts] Software engineer vacancies
  32. 2017-07-28 Balasubramanian Kandasamy <balasubramanian.kandasamy-at-oracle.com> Subject: [Hangout - NYLXS] MySQL Shell 1.0.10 GA has been released
  33. 2017-07-28 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] uptime
  34. 2017-07-28 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] messaging and privacy
  35. 2017-07-29 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] Pitty the twitterer
  36. 2017-07-30 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] David Warner - Movie of the Week
  37. 2017-07-31 Ruben Safir <ruben-at-mrbrklyn.com> Subject: [Hangout - NYLXS] Fwd: [Perlweekly] #314 - TPCiA is a week away!
  38. 2017-07-31 From: "Jessica Keener" <employer-at-msg.monster.com> Subject: [Hangout - NYLXS] AmerisourceBergen Inside Sales Opportunity -

NYLXS are Do'ers and the first step of Doing is Joining! Join NYLXS and make a difference in your community today!