Search Results
https://dev.mysql.com/doc/connectors/en/connector-net-8-0-connection-options.html
Restricts the set of TLS protocol versions to use during the TLS handshake when both the client and server support the TLS versions indicated and the value of the SslMode connection-string option is not set to Disabled or None (deprecated in ...With ... This chapter describes the full set of MySQL Connector/NET 8.0 connection ...
https://dev.mysql.com/doc/connector-net/en/connector-net-8-0-connection-options.html
Restricts the set of TLS protocol versions to use during the TLS handshake when both the client and server support the TLS versions indicated and the value of the SslMode connection-string option is not set to Disabled or None (deprecated in ...With ... This chapter describes the full set of MySQL Connector/NET 8.0 connection ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-functions.html
(See Section 19.2.1, “Replication Formats”.) USER() and CURRENT_USER() are automatically replicated using row-based replication when using MIXED mode, and generate a warning in STATEMENT mode. In such cases, a warning is still issued by this ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
This permits passwords to be specified in a safer way than on the command line even when --no-defaults is used. --sql-mode=mode Command-Line Format --sql-mode=mode Type String Set the SQL mode for the client session. --ssl-fips-mode={OFF|ON|STRICT} ... mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysqlrouter.html
--ssl-mode mode Command-Line Format --ssl-mode mode Type String Default Value PREFERRED Valid Values PREFERRED DISABLED REQUIRED VERIFY_CA VERIFY_IDENTITY SSL connection mode for use during bootstrap and normal operation when connecting to the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-changing-group-mode.html
Changing to Single-Primary Mode Use the group_replication_switch_to_single_primary_mode() function to change a group running in multi-primary mode to single-primary mode by issuing: SELECT group_replication_switch_to_single_primary_mode() When you ... This section explains how to change the mode which a group is running in, either single or ...While the action runs, you can check its progress by issuing the following SELECT statement: SELECT event_name, work_completed, work_estimated FROM performance_schema.events_stages_current WHERE event_name LIKE "%stage/group_rpl%"; +----------------------------------------------------------------------+----------------+----------------+ | event_name | work_completed | work_estimated | +----------------------------------------------------------------------+----------------+----------------+ | stage/group_rpl/Multi-primary Switch: applying buffered transactions | 0 | 1 | ...
https://dev.mysql.com/doc/refman/8.4/en/using-encrypted-connections.html
To prevent use of encryption and override other --ssl-xxx options, invoke the client program with --ssl-mode=DISABLED: mysql --ssl-mode=DISABLED To determine whether the current connection with the server uses encryption, check the session value of ...Instead, a warning is generated and encryption is disabled for new connections on the interface to which the statement ... Several configuration ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-single-user-mode.html
Single user mode enables the database administrator to restrict access to the database system to a single API node, such as a MySQL server (SQL node) or an instance of ndb_restore. When entering single user mode, connections to all other API nodes ...You can also check the status column of the ndbinfo.nodes table (see Section 25.6.15.48, “The ndbinfo nodes Table”, for more ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-variables.html
For this reason, replication of such a statement may not be safe when STATEMENT mode is in use. sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes ...In addition, the enabling this variable has different effects with regard to temporary tables, table locking, and the SET PASSWORD statement in different MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-verify-transactions.html
This is helpful when changing the replication mode online as you can verify that it is safe to change to GTID transactions. This section explains how to monitor a replication topology and verify that all anonymous transactions have been replicated.