PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-locally.html
The instructions in this section are not suitable for production deployments because all MySQL server instances are running on the same single host. mysql-5.7/bin/mysqld --initialize-insecure --basedir=$PWD/mysql-5.7 --datadir=$PWD/data/s1 ... The ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-failure-detection.html
If a member does not receive messages from another member for 5 seconds, it suspects that the member has failed, and lists the status of that member as UNREACHABLE in its own Performance Schema table replication_group_members. Group Replication’s ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-fault-tolerance.html
MySQL Group Replication builds on an implementation of the Paxos distributed algorithm to provide distributed coordination between servers. As such, it requires a majority of servers to be active to reach quorum and thus make a decision. This has ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-frequently-asked-questions.html
This limit has been identified from testing and benchmarking as a safe boundary where the group performs reliably on a stable local area network. And you can likely scale-out a small fraction of your IO operations, since remote servers receive only ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-options.html
The next two sections contain information about MySQL server system and server status variables which are specific to the Group Replication plugin.
https://dev.mysql.com/doc/refman/5.7/en/group-replication-server-states.html
Table 17.1 Server State Field Description Group Synchronized ONLINE The member is ready to serve as a fully functional group member, meaning that the client can connect and start executing transactions. There are various states that a server ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-single-primary-mode.html
For example, changes to tables that have cascading foreign keys are allowed, whereas in multi-primary mode they are not. When a new primary is elected, it is only writable once it has processed all of the transactions that came from the old primary.
https://dev.mysql.com/doc/refman/5.7/en/group-replication-user-credentials.html
Therefore you need to set up a replication user with the correct permissions so that Group Replication can establish direct member-to-member recovery replication channels. When configuring your servers use a suitable user name and password. This ...
https://dev.mysql.com/doc/refman/5.7/en/gtid-functions.html
Table 12.24 GTID Functions Name Description GTID_SUBSET() Return true if all GTIDs in subset are also in set; otherwise false. The functions described in this section are used with GTID-based replication. It is important to keep in mind that all of ...
https://dev.mysql.com/doc/refman/5.7/en/hexadecimal-literals.html
Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, A..F). Lettercase of the digits and of any leading X does not matter. A leading 0x is case-sensitive and cannot be written as 0X.