Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/ui-group-replication-advisors-ref.html
The configuration advisor analyzes the configuration of the servers, checking for misconfiguration which could lead to unstable or insecure installations, and the status advisor continuously monitors for servers which go offline, or fall out of sync ... The Group Replication advisors, Group Replication Configuration and Group Replication Status, provide continuous analysis of the condition of your group replication ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-data-encryption.html
After a keyring plugin is installed and configured, encryption can be enabled for: File-per-table tablespaces General tablespaces The mysql system tablespace Redo logs Undo logs For more information, see InnoDB Data-at-Rest Encryption. MySQL Server ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/boolean-expression-strings.html
Boolean expression strings can be used when filtering collections or tables using operations, such as find() and remove(). The following example of a boolean expression string uses find() to search for all documents with a “red” color attribute ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/connection-attributes-xdevapi.html
Connection attributes are key-value pairs that application programs can pass to the server during connection time to be stored in the PERFORMANCE_SCHEMA tables session_account_connect_attrs and session_connect_attrs. There are two different kinds ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/creating-documents.html
Once a collection has been created, it can store JSON documents. You store documents by passing a JSON data structure to the Collection.add() function. Some languages have direct support for JSON data, others have an equivalent syntax to represent ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/devapi-users-crud-operations.html
This section explains how to use the X DevAPI for Create Read, Update, and Delete (CRUD) operations. X DevAPI extends this domain by adding support for CRUD operations that can be run against collections of documents.
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/fetching-all-data-items-at-once.html
The following example assumes that the test schema exists and that the employee table exists in myTable. In addition to the pattern of using fetchOne() explained at Section 9.3, “Working with Data Sets”, which enables applications to consume ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/method-chaining.html
The example assumes that the test schema exists and an employee table exists. // New method chaining used for executing an SQL SELECT statement // Recommended way for executing queries var employees = db.getTable('employee'); var res = ... X DevAPI ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/using-sql.html
In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string. The following example uses a Session to call an SQL Stored Procedure on the specific node.
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-a-session-object.html
All previous examples used the getSchema() or getDefaultSchema() methods of the Session object, which return a Schema object. Most examples make use of the X DevAPI ability to chain all object constructions, enabling you to get to the Schema object ...