Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-high-availability-and-clustering.html
Alternatively, as a last option, investigate setting the MySQL server variable 'wait_timeout' to a high value, rather than the default of 8 hours. Between cycles, the driver will pause for 250 ms if no servers are available. Setting this property to ... autoReconnect Should the driver try to re-establish stale and/or dead connections? If enabled the driver will throw an exception for queries issued on a stale or dead connection, which belong to the current transaction, but will attempt reconnect before the next query issued on the connection in a new ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html
Connection The isClosed() method does not ping the server to determine if it is available. PreparedStatement Two variants of prepared statements are implemented by Connector/J, the client-side and the server-side prepared statements. Server-side ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-destination-configuration.html
This section describes which server options configure the default error log destination, which can be the console or a named file. The server interprets options that determine the default error log destination somewhat differently for Windows and ...It also indicates which log sink components base their own output destination on the default ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-security.html
There is also the Secure Deployment Guide, which provides procedures for deploying a generic binary distribution of MySQL Enterprise Edition Server with features for managing the security of your MySQL installation. For information about the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-connections.html
When a joining member connects to an online existing member for state transfer during distributed recovery, the joining member acts as a client on the connection and the existing member acts as a server. Important Distributed recovery can fail if a ...When state transfer from the donor's binary log is in progress over this connection (using the asynchronous replication channel group_replication_recovery), the joining member acts as the replica and the existing member acts as the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-member-actions.html
The functions can also be used on a server that is not part of a group, as long as the Group Replication plugin is installed. In that case, the member actions configuration is not propagated to any other servers. The ... The following functions can ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-exit.html
With this setting, you therefore need to pro-actively monitor the servers for failures. This exit action prevents both updates and stale reads (with the exception of reads by client users with the stated privileges), and enables proxy tools such as ... The group_replication_exit_state_action system variable specifies what Group Replication does when the member leaves the group unintentionally due to an error or problem, and either fails to auto-rejoin or does not ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-user.html
There is no way to verify the identity of a server, therefore only set group_replication_recovery_get_public_key=ON when you are sure there is no risk of server identity being compromised, for example by a man-in-the-middle attack. 20.6.3.1.2 ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-user-credentials.html
Alternatively, you can disable binary logging before creating the replication user, and then create the user manually on each member, for example if you want to avoid the changes being propagated to other server instances. Important If distributed ... Group Replication uses a distributed recovery process to synchronize group members when joining them to the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication.html
Groups can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. Alternatively, groups can be deployed in multi-primary mode, where all servers can accept updates, even if they are issued ... This chapter explains Group Replication in MySQL 8.4, and how to install, configure and monitor ...