Search Results
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-deploying-basic-routing.html
The Connection Routing plugin performs connection-based routing, meaning it forwards packets to the server without inspecting them. [logger] level = INFO [routing:secondary] bind_address = localhost bind_port = 7001 destinations = ...For additional ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/deploying-production-innodb-cluster.html
When working in a production environment, the MySQL server instances which make up an InnoDB Cluster run on multiple host machines as part of a network rather than on single machine as described in Section 6.9, “AdminAPI MySQL Sandboxes”. How ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-connection-using-parameters.html
Use the following connection related parameters: --user (-u) value --host (-h) value --port (-P) value --schema or --database (-D) value --socket (-S) The command options behave similarly to the options used with the mysql client described at ... In ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-pluggable-password-configuration-options.html
Valid values are: always - passwords are always stored, unless they are already available in the Secret Store or server URL matches credentialStore.excludeFilters value. prompt - in interactive mode, if the server URL does not match the value of ...
https://dev.mysql.com/doc/c-api/9.7/en/c-api-binary-log-data-structures.html
C API functions for processing a replication event stream from a server require a connection handler (a MYSQL * pointer) and a pointer to a MYSQL_RPL structure that describes the steam of replication events to read from the server binary log. int ...
https://dev.mysql.com/doc/c-api/9.7/en/c-api-multiple-queries.html
This capability is enabled by special options that are specified either when you connect to the server with mysql_real_connect() or after connecting by calling mysql_set_server_option(). Failure to process the result this way may result in a dropped ... By default, mysql_real_query() and mysql_query() interpret their statement string argument as a single statement to be executed, and you process the result according to whether the statement produces a result set (a set of rows, as for SELECT) or an affected-rows count (as for INSERT, UPDATE, and so ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-ssl-set.html
It is optional to call mysql_ssl_set() to obtain an encrypted connection because by default, MySQL programs attempt to connect using encryption if the server supports encrypted connections, falling back to an unencrypted connection if an encrypted ... bool mysql_ssl_set(MYSQL *mysql, const char *key, const char *cert, const char *ca, const char *capath, const char *cipher) Description Note As of MySQL 8.0.35, mysql_ssl_set() is deprecated and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-stmt-reset.html
bool mysql_stmt_reset(MYSQL_STMT *stmt) Description Resets a prepared statement on client and server to state after prepare. It resets the statement on the server, data sent using mysql_stmt_send_long_data(), unbuffered result sets and current ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-use-result.html
This reads the result of a query directly from the server without storing it in a temporary table or local buffer, which is somewhat faster and uses much less memory than mysql_store_result(). This ties up the server and prevent other threads from ... MYSQL_RES * mysql_use_result(MYSQL *mysql) Description After invoking mysql_real_query() or mysql_query(), you must call mysql_store_result() or mysql_use_result() for every statement that successfully produces a result set (SELECT, SHOW, DESCRIBE, EXPLAIN, CHECK TABLE, and so ...
https://dev.mysql.com/doc/ndb-operator/9.7/en/crd-ndbmanagementnodespec.html
NdbManagementNodeSpec specifies a management server node in an NDB Cluster. enableLoadBalancer (bool): (optional) Exposes the management servers externally using the Kubernetes cloud provider's load balancer. By default, the operator creates a ...