Search Results
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-replication.html
During the cloning operation, both the binary log position (filename, offset) and the gtid_executed GTID set are extracted and transferred from the donor MySQL server instance to the recipient. To clone for replication, perform the following steps: ...In addition to cloning data, a cloning operation extracts replication coordinates from the donor and transfers them to the recipient, which enables using the clone plugin for provisioning Group Replication members and ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-communication-protocol.html
Return value: The oldest MySQL Server version that can join this group and use the group's communication protocol. Note that the group_replication_get_communication_protocol() function returns the minimum MySQL version that the group supports, which ...If the protocol cannot be inspected because this server instance does not belong to a replication group, an error is returned as a ... The ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-partition.html
Setting a timeout means you do not need to pro-actively monitor for servers that are in a minority group after a network partition, and you can avoid the possibility of creating a split-brain situation (with two versions of the group membership) due ... By default, members that find themselves in a minority due to a network partition do not automatically leave the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrading-member.html
When an upgraded member joins a group which has any member running an earlier MySQL Server version, the upgraded member joins with super_read_only=on. How you upgrade the server instance, using either the in-place or provision approach, does not ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-local-connections.html
The following procedure shows how to configure MySQL to permit IPv6 connections by clients that connect to the local server using the ::1 local host address. Start the MySQL server with an appropriate bind_address setting to permit it to accept ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-start.html
Note If you do this, you should not access MyISAM tables from another program (such as from another MySQL server or with myisamchk) when the tables are in use. The following options to mysqld can be used to change the behavior of MyISAM tables.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-asynchronous-connection-failover-table.html
You set and manage source lists using the asynchronous_connection_failover_add_source and asynchronous_connection_failover_delete_source functions to add and remove replication source servers from the source list for a replication channel. To add ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-tables.html
Transaction Boundaries In MySQL Server, transactions start explicitly with these statements: START TRANSACTION | BEGIN | XA START | XA BEGIN Transactions also start implicitly. Subsequent statements are part of the transaction until it is committed.
https://dev.mysql.com/doc/refman/8.4/en/replication-encrypted-connections.html
For more information on setting up a server and client for encrypted connections, see Section 8.3.1, “Configuring MySQL to Use Encrypted Connections”. To use an encrypted connection for the transfer of the binary log required during ...You must ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-restrictions.html
Because GTID-based replication is dependent on transactions, some features otherwise available in MySQL are not supported when using it. If binlog_format is set to STATEMENT, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements cannot be used ...This section provides information about restrictions on and limitations of replication with ...