Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-sessions.html
In MySQL Shell, connections to MySQL Server instances are handled by a session object. The following types of session object are available: Session: Use this session object type for new application development to communicate with MySQL Server ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-sql-system-log.html
SQL statements that you issue in MySQL Shell’s SQL mode can be sent to the operating system’s system logging facility. On Unix, this is syslog; on Windows, it is the Windows Event Log. When you activate system logging for SQL statements, the ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-json-mysqlsh.html
With the mysqlsh command interface, you invoke the JSON import utility as follows: mysqlsh user@host:port/mydb -- util importJson <path> [options] or mysqlsh user@host:port/mydb -- util import-json <path> [options] For information on this syntax, ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-json-run.html
The JSON import utility requires an existing X Protocol connection to the server. In the MySQL Shell API, the JSON import utility is a function of the util global object, and has the following signature: importJSON (path, options) path is a string ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/rejoin-cluster.html
If an instance leaves the cluster, for example because it lost connection, and for some reason it could not automatically rejoin the cluster, it might be necessary to rejoin it to the cluster at a later stage. Tip If the instance has ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/replicasets-working-with-router.html
You can also use MySQL Router to bootstrap against an InnoDB ReplicaSet. The only difference in the generated MySQL Router configuration file is the addition of the cluster_type option. When MySQL Router is bootstrapped against a ReplicaSet, the ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/test-failover.html
There are various ways to simulate an instance leaving a cluster, for example you can forcibly stop the MySQL server on an instance, or use the AdminAPI dba.killSandboxInstance() if testing a sandbox deployment. In this example, there is a ... To ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-unload.html
You can use MySQL HeatWave Auto Unload to unload data automatically. This topic contains the following sections: Before You Begin Overview for Unloading Data Automatically Unload Specific Tables Unload All Data Auto Unload Examples What's Next ...
https://dev.mysql.com/doc/refman/8.4/en/create-spatial-reference-system.html
srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-table-select.html
You can use the select() method to query for and return records from a table in a database. The X DevAPI provides additional methods to use with the select() method to filter and sort the returned records. MySQL provides the following operators to ...