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/gis-linestring-property-functions.html
(There is an existing SQL function Length() that calculates the length of string values.) GLength() is deprecated; expect it to be removed in a future MySQL release. You can extract particular points of a LineString, count the number of points that ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-functional-dependence.html
Assume that referential integrity has been accidentally broken and there exists a row of countrylanguage without a corresponding row in country. The following discussion provides several examples of the ways in which MySQL detects functional ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-adding-instances.html
At this point server s2 only needs to be added to the already existing group. At this point, the group has one member in it, server s1, which has some data in it. It is now time to expand the group by adding the other two servers configured ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-launching.html
Otherwise, you must install the plugin manually; to do this, connect to the server using the mysql client, and issue the SQL statement shown here: mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so'; Important The mysql.session ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-limitations.html
Note that the limitations and issues described for multi-primary mode groups can also apply in single-primary mode clusters during a failover event, while the newly elected primary flushes out its applier queue from the old primary. Tip Group ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-network-partitioning.html
mysql> SELECT @@group_replication_local_address; Once you know the group communication addresses of s1 (127.0.0.1:10000) and s2 (127.0.0.1:10001), you can use that on one of the two servers to inject a new membership configuration, thus overriding ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-plugin-architecture.html
MySQL Group Replication is a MySQL plugin and it builds on the existing MySQL replication infrastructure, taking advantage of features such as the binary log, row-based logging, and global transaction identifiers. It integrates with current MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements.html
Therefore, copies of each transaction need to exist on every server, even for those transactions that were not initiated on the server itself. Server instances that you want to use for Group Replication must satisfy the following requirements.
https://dev.mysql.com/doc/refman/5.7/en/group-replication-the-group.html
If a server joins the group, it automatically brings itself up to date by fetching the missing state from an existing server. In MySQL Group Replication, a set of servers forms a replication group. A group has a name, which takes the form of a UUID. The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any ...
https://dev.mysql.com/doc/refman/5.7/en/handler-scope.html
For example, a statement could generate multiple warnings with different error codes, for each of which an error-specific handler exists. However, SQLSTATE handlers take precedence over SQLEXCEPTION handlers, so if the table t is nonexistent, the ...