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/functions.html
This helps the MySQL parser distinguish between function calls and references to tables or columns that happen to have the same name as a function. Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING ...
https://dev.mysql.com/doc/refman/5.7/en/geometry-well-formedness-validity.html
Syntactic well-formedness is also checked for attempts to store geometries into tables. For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Spatial import functions that parse WKT or ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
If a transaction executes against a table that has foreign keys with cascading constraints, then the transaction fails to commit when synchronizing itself with the group. Group Replication operates in the following different modes: single-primary ...
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-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. Alternatively, you can disable binary logging using SET SQL_LOG_BIN=0; and ...