Search Results
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-deploying-sandbox.html
In this case, Router acts as an intermediate node redirecting client connections to a list of servers. If one server fails, clients are redirected to the next available server in the list. Set Up a MySQL Server Sandbox Begin by starting three MySQL ... Test a MySQL Router installation by setting up a Router sandbox with InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-attribute-tables.html
Connection attributes are key-value pairs that application programs can pass to the server at connect time. FEDERATED storage engine connections: program_name: mysqld _client_role: federated_storage Connection Attribute Limits There are limits on ...Attribute names that begin with an underscore (_) are reserved for internal use and should not be created by application ...For applications based on the C API implemented ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-simple-dual.html
The source code for this program may be found in the NDB Cluster source tree, in the file storage/ndb/ndbapi-examples/ndbapi_simple_dual/main.cpp. This example demonstrates synchronous transactions and connecting to multiple clusters in a single ...
https://dev.mysql.com/doc/refman/8.4/en/creating-accounts.html
Account-management statements cause the server to make appropriate modifications to the underlying grant tables, which are discussed in Section 8.2.3, “Grant Tables”. The server is free to ignore rows that become malformed as a result of such ...
https://dev.mysql.com/doc/refman/8.4/en/cleartext-pluggable-authentication.html
A client-side authentication plugin is available that enables clients to send passwords to the server as cleartext, without hashing or encryption. Table 8.17 Plugin and Library Names for Cleartext Authentication Plugin or File Plugin or File Name ...(Examples are the PAM and simple LDAP authentication plugins; see Section 8.4.1.5, “PAM Pluggable Authentication”, and Section 8.4.1.7, “LDAP Pluggable Authentication”.) The following discussion provides usage information specific to cleartext pluggable ...
https://dev.mysql.com/doc/internals/en/x-protocol-implementation-implementation-notes.html
Topics in this section: Client Server Client and Server implementations of the protocol should make use of the following: vectorized IO pipelining to reduce the latency and CPU usage. Client Out-of-Band Messages The client should decode the ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndb-cluster-connection.html
This section provides information about the Ndb_cluster_connection class, which models a connection by a management server (ndb_mgmd) to a set of data nodes. The application connects to a cluster management server when this object's connect() ...By ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
The outcome of attempting to change the storage engine of a table is affected by whether the desired storage engine is available and the setting of the NO_ENGINE_SUBSTITUTION SQL mode, as described in Section 7.1.11, “Server SQL Modes”. These ...
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
The operation is either committed, with applicable changes persisted to the data dictionary, storage engine, and binary log, or is rolled back, even if the server halts during the operation. Supported non-table DDL statements include: CREATE and ...
https://dev.mysql.com/doc/refman/8.4/en/backup-and-recovery.html
Backups are also essential as a safeguard before upgrading a MySQL installation, and they can be used to transfer a MySQL installation to another system or to set up replica servers. Details for mysqldump can be found in Chapter 6, MySQL Programs.