Author: MySQL Release Engineering

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Shell 8.0.21 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.21. 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 ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Shell 8.0.20 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.20. 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 ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users,MySQL Connector/J 8.0.21 is the latest General Availability release ofthe MySQL Connector/J 8.0 series.  It is suitable for use with MySQLServer versions 8.0, 5.7, and 5.6.  It supports the Java DatabaseConnectivity (JDBC) 4.2 API, and implements the X DevAPI.In the documentation for MySQL 8.0.21, we have startedchanging the term “master” to “source”, the term “slave” to“replica”, the term “whitelist” to “allowlist”, and the term“blacklist” to “blocklist”. There are currently no changes tothe product’s syntax, so these terms are still present in thedocumentation where the current code requires their use. Seethe blog post MySQL ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/Node.js is a new Node.js driver for use with the XDevAPI. This release, v8.0.21, is a maintenance release of theMySQL Connector/Node.js 8.0 series. The X DevAPI enables application developers to write code that combinesthe strengths of the relational and document models using a modern,NoSQL-like syntax that does not assume previous experience writingtraditional SQL. MySQL Connector/Node.js can be downloaded through npm (seehttps://www.npmjs.com/package/@mysql/xdevapi for details) or fromhttps://dev.mysql.com/downloads/connector/nodejs/. To learn more about how to write applications using the X DevAPI, seehttp://dev.mysql.com/doc/x-devapi-userguide/en/.For more information about how the X DevAPI is implemented in MySQLConnector/Node.js, and its ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/C++ 8.0.21 is a new release version of the MySQL Connector/C++ 8.0 series. Connector/C++ 8.0 can be used to access MySQL implementing Document Store or in a traditional way, using SQL queries. It allows writing both C++ and plain C applications using X DevAPI and X DevAPI for C. It also supports the legacy API of Connector/C++ 1.1 based on JDBC4. To learn more about how to write applications using X DevAPI, see “X DevAPI User Guide” at https://dev.mysql.com/doc/x-devapi-userguide/en/See also “X DevAPI Reference” at https://dev.mysql.com/doc/dev/connector-cpp/devapi_ref.htmland “X DevAPI for C Reference” at https://dev.mysql.com/doc/dev/connector-cpp/xapi_ref.htmlFor generic information on using Connector/C++ 8.0, see https://dev.mysql.com/doc/dev/connector-cpp/For general documentation about how to get started using MySQL as a document store, see http://dev.mysql.com/doc/refman/8.0/en/document-store.htmlTo download MySQL Connector/C++ 8.0.21, see the “General Availability (GA) Releases” tab at https://dev.mysql.com/downloads/connector/cpp/Changes in MySQL Connector/C++ 8.0.21 (2020-07-13, General Availability) Configuration Notes      * The CMake configuration files were revised to work better        when Connector/C++ is used as a subproject of application        projects. Thanks to Lou Shuai for the contribution.        This revision does not change the fact that the intended        (and supported) usage scenario is to build the connector        in a separate project, install it somewhere and then use        it in application projects from that installed location        (for example, by defining the imported library target in        CMake). (Bug #31095993, Bug #99093) JSON Notes      * The rapidjson library included with Connector/C++ has        been upgraded to the GitHub snapshot of 16 January 2020. Security Notes      * For platforms on which OpenSSL libraries are bundled, the        linked OpenSSL library for Connector/C++ has been updated        to version 1.1.1g. Issues fixed in the new OpenSSL        version are described at https://www.openssl.org/news/cl111.txt and https://www.openssl.org/news/vulnerabilities.html. (Bug        #31296689) X DevAPI Notes      * For X DevAPI or X DevAPI for C applications, methods and        functions that create or modify collections now accept        options to enable validation of a JSON schema that        documents must adhere to before they are permitted to be        inserted or updated. Schema validation is performed by        the server, which returns an error message if a document        in a collection does not match the schema definition or        if the server does not support validation.        These new classes are implemented to support validation        options:           + CollectionOptions: The base class that has all             options. Contains an Option enumeration with             constants REUSE and VALIDATION.           + CollectionValidation: Handles only subkey             validation. Contains a Level enumeration with             constants STRICT and OFF, and an Option enumeration             with constants SCHEMA and LEVEL.        X DevAPI now has these signatures for createCollection()        (and modifyCollection()):        // Accepts the full document        createCollection(“name”, “JSON_Document”);        // DbDoc usage is also permitted        createCollection(“name”, DbDoc(“validation”, DbDoc(“level”,”off”,…)));        // List of pairs with Option enum constant and value        createCollection(CollectionOptions::REUSE, true,                  CollectionOptions::VALIDATION, CollectionValidation(…));        // Old REUSE way is also acceptable        createCollection(“name”, true);        createCollection(“name”, CollectionValidation(…));        // createCollection also allows a list of pairs of        // CollectionValidation Option enum constant and value        createCollection(“name”, CollectionOptions::VALIDATION,                          CollectionValidation::OFF,                          CollectionValidation::SCHEMA,                          “Object”);        X DevAPI for C examples:        These are the possible options for        mysqlx_collection_options_set():        OPT_COLLECTION_VALIDATION_LEVEL(VALIDATION_OFF)        OPT_COLLECTION_VALIDATION_SCHEMA(“Object”)        OPT_COLLECTION_REUSE(true)        Perform option operations like this:        mysqlx_collection_options_t *options = mysqlx_collection_options_new() //creates collection options object        mysqlx_free(options) //frees collection options        mysqlx_collection_options_set(options,…);        Creation and modification functions have these signatures:        mysqlx_collection_create_with_options(mysqlx_schema_t *schema, mysqlx_collection_options_t *options);        mysqlx_collection_create_with_json_options(mysqlx_schema_t *schema, const char* json_options);        mysqlx_collection_modify_with_options(mysqlx_schema_t *schema, mysqlx_collection_options_t *options);        mysqlx_collection_modify_with_json_options(mysqlx_schema_t *schema, const char* json_options);        For modifications, the REUSE option is not supported and        an error occurs if it is used. Functionality Added or Changed      * The MySQL_Connection_Options enumeration is no longer        sensitive to the order in which the underlying options        are declared in the C API source. (Bug #30799197) ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/NET 8.0.21 is the latest General Availability release of the MySQL Connector/NET 8.0 series. This version supports .NET Core 3.1 and the 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 project level ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/ODBC 8.0.21 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 ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/Python 8.0.21 is the latest GA release version of theMySQL Connector Python 8.0 series. The X DevAPI enables applicationdevelopers to write code that combines the strengths of the relationaland document models using a modern, NoSQL-like syntax that does notassume 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/ For more information about how the X DevAPI is implemented in MySQLConnector/Python, and its usage, see http://dev.mysql.com/doc/dev/connector-python Please note that the X DevAPI requires at least MySQL Server version 8.0or higher with the ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL Users, MySQL Connector/J 5.1.49, a maintenance release of the production 5.1 branch, has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. MySQL Connector/J is available in source and binary form from the Connector/J download pages at http://dev.mysql.com/downloads/connector/j/5.1.htmland mirror sites as well as Maven repositories. MySQL Connector/J (Commercial) is available for download on the My Oracle Support (MOS) website. This release will shortly be available on eDelivery (OSDC). As always, we recommend that you check the “CHANGES” file in the download archive to be aware of changes in behavior that might ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/Python 8.0.20 is the latest GA release version of the MySQL Connector Python 8.0 series. The X DevAPI 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/ For more information about how the X DevAPI is implemented in MySQL Connector/Python, and its usage, see   http://dev.mysql.com/doc/dev/connector-python Please note that the X DevAPI requires at least MySQL Server version 8.0 or higher with the X Plugin enabled. For general documentation about how to get started using MySQL as a document store, see   http://dev.mysql.com/doc/refman/8.0/en/document-store.html To download MySQL Connector/Python 8.0.20, see the “General Availability (GA) Releases” tab at   http://dev.mysql.com/downloads/connector/python/ Enjoy! ============================================================================== Changes in MySQL Connector/Python 8.0.20 (2020-04-27, General Availability) Functionality Added or Changed  * For X DevAPI applications, when creating a new    connection, if the connection data contains several    target hosts that have no explicit priority assigned, the    behavior of the failover logic now is the same as if all    those target hosts have the same priority. That is, the    next candidate for making a connection is chosen randomly    from the remaining available hosts. Alternatively, the    new priority attribute optionally sets the priority for    each host. If two hosts have the same priority then one    is chosen at random. Bugs Fixed  * The fetchmany() method failed to function properly when    the last fetch was not a full batch; and would hang.    Thanks to Bruce Feng for the patch.    (Bug#30608703, Bug#97830) On Behalf of Oracle/MySQL Engineering Team Kent Boortz ... Read More