PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery-fault.html
In MySQL 8.0.17 and later, for state transfer from the binary log, the joiner only selects a donor that is running a lower or equal patch version of MySQL Server compared to itself. Because this method of state transfer uses the existing MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-gtids.html
From MySQL 8.0.26, you can set the Group Replication system variable group_replication_view_change_uuid to use an alternative UUID in the GTIDs for view change events, so that they are easy to distinguish from transactions received by the group from ... Group Replication uses GTIDs (global transaction identifiers) to track exactly which transactions have been committed on every server ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-monitoring.html
You can use the MySQL Performance Schema to monitor Group Replication. Beginning with MySQL 8.0.21, messages relating to Group Replication lifecycle events other than errors are classified as system messages; these are always written to the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-offline-upgrade.html
See Section 20.8.3.2, “Upgrading a Group Replication Member” for how to remove members from a group and shutdown MySQL. See Chapter 3, Upgrading MySQL for how to perform an upgrade. If you have a requirement to allow members at earlier releases ... To perform an offline upgrade of a Group Replication group, you remove each member from the group, perform an upgrade of the member and then restart the group as ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-xcom-cache-reduce.html
The minimum setting for the XCom message cache size is 1 GB up to MySQL 8.0.20. From MySQL 8.0.21, the minimum setting is 134217728 bytes (128 MB), which enables deployment on a host that has a restricted amount of available memory. From MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-replication-group-member-stats.html
To use this table to monitor a Group Replication member, issue the following statement: mysql> SELECT * FROM performance_schema.replication_group_member_stats\G Beginning with MySQL 8.0.19, you can also use the following statement: mysql> TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-single-consensus-leader.html
From MySQL 8.0.27, the group communication engine can use a single leader to drive consensus when the group is in single-primary mode. The column value is 1 if the group was started with group_replication_paxos_single_leader set to ON, and its ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-columns-table.html
1 = VARCHAR, 2 = CHAR, 3 = FIXBINARY, 4 = BINARY, 5 = BLOB, 6 = INT, 7 = SYS_CHILD, 8 = SYS, 9 = FLOAT, 10 = DOUBLE, 11 = DECIMAL, 12 = VARMYSQL, 13 = MYSQL, 14 = GEOMETRY. PRTYPE The InnoDB “precise type”, a binary value with bits representing ...For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tables-table.html
This column is no longer used as of MySQL 8.0.29 but continues to show information for tables with columns that were added instantly prior to MySQL 8.0.29. Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE TABLE_ID = 214\G ...For ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-benchmarking.html
If InnoDB is not the default storage engine, you can determine if your database server and applications work correctly with InnoDB by restarting the server with --default-storage-engine=InnoDB defined on the command line or with ...Since changing ...