Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/customize-your-cluster.html
The default values are recommended for most deployments, but advanced users can override the defaults by passing the following options to the dba.createCluster() and Cluster.addInstance() commands: Pass the groupName option to the ... When you ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-batch-code-execution.html
Executable Scripts On Linux you can create executable scripts that run with MySQL Shell by including a #! line as the first line of the script. If you need to create a MySQL Shell script that is independent of the protocol used for connecting to the ... As well as interactive code execution, MySQL Shell provides batch code execution from: A file loaded for ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-encrypted-connections.html
For example: mysql-js> var session=mysqlx.getSession({host: 'localhost', user: 'root', password: 'password', ssl_ca: "path_to_ca_file", ssl_cert: "path_to_cert_file", ssl_key: "path_to_key_file"}); Sessions created using mysqlx.getSession(), ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-debug-diagnostics.html
If you omit it, the utility creates a file named Temp.zip in the named path. For example: {"customShell": ["command1", "command2", "command3"]} Important These commands run with the privileges of the user running MySQL Shell and should be used with ... The debugging and diagnostics utility util.debug.collectDiagnostics() enables you to collect diagnostic data on your MySQL ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-load-binlogs.html
If the location specified exists and contains a dump created by this utility, the snapshot information in that dump is used as the starting point for the binary log dump. Requirements and Restrictions The following must be true: The directory must ...This utility enables you to load a binary log dump from local or cloud ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/specifying-instances.html
For example, to connect as the user myuser to the MySQL server instance at www.example.com, on port 3306 use the connection string: myuser@www.example.com:3306 To use this connection string with an AdminAPI operation such as dba.configureInstance(), ... MySQL Shell enables you to work with various APIs, and supports specifying connections as explained in Connecting to the Server Using URI-Like Strings or Key-Value ...
https://dev.mysql.com/doc/connectors/en/connector-net-connections-pooling.html
See Section 4.4.1, “Creating a Connector/NET Connection String” for further information. Subsequently, if a new MySqlConnection object is opened, it is created from the connection pool, rather than creating a new native connection. Do not create ... The MySQL Connector/NET supports connection pooling for better performance and scalability with database-intensive ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-programming-net.html
5.6.7.2.1 Using Connector/ODBC with ODBC.NET and C# (C sharp) The following sample creates a table my_odbc_net and demonstrates its use in C#. This section contains simple examples that demonstrate the use of Connector/ODBC drivers with ODBC.NET.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor.html
To create a cursor, use the cursor() method of a connection object: import mysql.connector cnx = mysql.connector.connect(database='world') cursor = cnx.cursor() Several related classes inherit from MySQLCursor. To create a cursor of one of these ...
https://dev.mysql.com/doc/connector-net/en/connector-net-connections-pooling.html
See Section 4.1, “Creating a Connector/NET Connection String” for further information. Subsequently, if a new MySqlConnection object is opened, it is created from the connection pool, rather than creating a new native connection. Do not create a ... The MySQL Connector/NET supports connection pooling for better performance and scalability with database-intensive ...