PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. Note The syntax of the CASE operator described here differs ...
https://dev.mysql.com/doc/refman/8.0/en/functions.html
Note By default, there must be no whitespace between a function name and the parenthesis following it. Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING clauses of SELECT statements, in the WHERE clause ...Expressions can be written using values from several sources, such as literal values, column values, NULL, variables, built-in functions and operators, loadable functions, and stored functions (a type of stored ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-geometrycollection.html
All the elements in a geometry collection must be in the same spatial reference system (that is, in the same coordinate system). GeomCollection and GeometryCollection are synonymous, with GeomCollection the preferred type name. There are no other ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-instances.html
The Group Replication plugin is provided with MySQL Server 8.0; no additional software is required, although the plugin must be installed in the running MySQL server. The first step is to deploy at least three instances of MySQL Server, this ...It ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-failure-detection.html
If a member is not participating in these decisions, the group must remove it to increase the chance that the group contains a majority of correctly working members, and can therefore continue to process transactions. Group Replication’s failure ...It is possible, though less likely, that member A suspects member B of having failed but member B does not suspect member A of having failed - perhaps due to a routing or firewall ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-fault-tolerance.html
In practice this means that to tolerate one failure the group must have three servers in it. MySQL Group Replication builds on an implementation of the Paxos distributed algorithm to provide distributed coordination between servers. This has direct ...As such, it requires a majority of servers to be active to reach quorum and thus make a ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-online-upgrade-combining-versions.html
In an upgrade scenario, each server must leave the group, be upgraded, and rejoin the group with its new server version. Group Replication is versioned according to the MySQL Server version that the Group Replication plugin was bundled with. For ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-xcom-cache-reduce.html
If a reconnecting member cannot retrieve all the messages it needs from the XCom message cache, the member must leave the group and rejoin it, in order to retrieve the missing transactions from another member's binary log using distributed recovery.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-replication-group-members.html
At that point, servers exchange some of their metadata to synchronize themselves and continue to cooperate together. The performance_schema.replication_group_members table is used for monitoring the status of the different server instances that are ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-triggers-table.html
To see information about a table's triggers, you must have the TRIGGER privilege for the table. TRIGGER_SCHEMA The name of the schema (database) to which the trigger belongs. These columns indicate the catalog and schema (database) in which this ...