Search Results
https://dev.mysql.com/doc/refman/8.4/en/gis-geometrycollection-property-functions.html
mysql> SET @gc = 'GeometryCollection(Point(1 1),LineString(2 2, 3 3))'; mysql> SELECT ST_AsText(ST_GeometryN(ST_GeomFromText(@gc),1)); +-------------------------------------------------+ | ST_AsText(ST_GeometryN(ST_GeomFromText(@gc),1)) | ...Unless ...
https://dev.mysql.com/doc/refman/8.4/en/gis-wkt-functions.html
mysql> SET @g = "MULTILINESTRING((10 10, 11 11), (9 9, 10 10))"; mysql> SELECT ST_AsText(ST_GeomCollFromText(@g)); +--------------------------------------------+ | ST_AsText(ST_GeomCollFromText(@g)) | +--------------------------------------------+ | ... These functions take as arguments a Well-Known Text (WKT) representation and, optionally, a spatial reference system identifier ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. The bootstrap should only be done by a single server, the one that starts the group and only once. This is why the value of the group_replication_bootstrap_group option was ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-cloning.html
Group Replication configures this setting automatically for you after it selects a donor from the existing group members. To enable Group Replication to select a remote cloning operation for state transfer where this is more appropriate, set the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-frequently-asked-questions.html
One of the members listed in that table is selected as the donor of the missing data from the group to the joining member. These settings avoid the selection of duplicate auto-increment values for writes on group members, which causes rollback of ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-communication-protocol.html
Example: SELECT group_replication_get_communication_protocol(); +------------------------------------------------+ | group_replication_get_communication_protocol() | +------------------------------------------------+ | 8.4.6 | ... The following ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-maximum-consensus.html
Example: SELECT group_replication_get_write_concurrency() For more information, see Section 20.5.1.3, “Using Group Replication Group Write Consensus”. Example: SELECT group_replication_set_write_concurrency(instances); For more information, see ... The following functions enable you to inspect and configure the maximum number of consensus instances that a group can execute in ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-mode.html
Example: SELECT group_replication_switch_to_multi_primary_mode() All members which belong to the group become primaries. Example: SELECT group_replication_switch_to_single_primary_mode(member_uuid); For more information, see Section 20.5.1.2, ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-group-write-consensus.html
This section explains how to inspect and configure the maximum number of consensus instances at any time for a group. This maximum is referred to as the event horizon for a group, and is the maximum number of consensus instances that the group can ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-limitations.html
group_replication_recovery_tls_version and group_replication_recovery_tls_ciphersuites can be used to configure client support for any selection of ciphersuites, including only non-default ciphersuites if desired. Limit on Group Size Limits on ...