Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-instances.html
The host name that the server is using for SQL client connections can be verified in the Member_host column of the Performance Schema table replication_group_members. Configuring group_replication_group_seeds sets the hostname and port of the group ... This section explains the configuration settings required for MySQL Server instances that you want to use for Group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-member-actions.html
The Performance Schema table replication_group_member_actions lists the member actions that are available in the configuration, the events that trigger them, and whether or not they are currently enabled. The ... Group Replication has the ability to ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-rejoin.html
While an auto-rejoin procedure is taking place, the Performance Schema table events_stages_current shows the event “Undergoing auto-rejoin procedure”, with the number of retries that have been attempted so far during this instance of the ... The ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-user.html
State transfer from the binary log requires a replication user with the correct permissions so that Group Replication can establish direct member-to-member replication channels. To secure the user credentials, you can require SSL for connections ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-single-consensus-leader.html
The Performance Schema table replication_group_communication_information shows the current preferred and actual consensus leader, with the preferred leader being Group Replication’s choice, and the actual leader being the one selected by the group ... By default, the group communication engine for Group Replication (XCom, a Paxos variant) operates using every member of the replication group as a ...
https://dev.mysql.com/doc/refman/8.4/en/index-preloading.html
Preloading enables you to put the table index blocks into a key cache buffer in the most efficient way: by reading the index blocks from disk sequentially. If there are enough blocks in a key cache to hold blocks of an entire index, or at least the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlocks.html
A deadlock can occur when transactions lock rows in multiple tables (through statements such as UPDATE or SELECT ... A deadlock is a situation in which multiple transactions are unable to proceed because each transaction holds a lock that is needed ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-compression-oltp.html
The rise of SSD storage devices, which are fast but relatively small and expensive, makes compression attractive also for OLTP workloads: high-traffic, interactive websites can reduce their storage requirements and their I/O operations per second ...
https://dev.mysql.com/doc/refman/8.4/en/installation-layouts.html
MySQL Installation Layout on Microsoft Windows Section 2.8.3, “MySQL Layout for Source Installation” Table 2.3, “MySQL Installation Layout for Generic Unix/Linux Binary Package” Table 2.13, “MySQL Installation Layout for Linux RPM Packages ... The installation layout differs for different installation types (for example, native packages, binary tarballs, and source tarballs), which can lead to confusion when managing different systems or using different installation ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-component-installation.html
For example, the InnoDB storage engine uses the keyring for tablespace encryption, so a keyring component or plugin must be loaded and available prior to InnoDB initialization. Keyring components loaded using that statement may be available too late ... Keyring service consumers require that a keyring component or plugin be installed: To use a keyring component, begin with the instructions ...