Search Results
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
These functions are connection-specific, so their return values are not affected by another connection which is also performing inserts. You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
Plan isn't ready yet (JSON property: none) This value occurs with EXPLAIN FOR CONNECTION when the optimizer has not finished creating the execution plan for the statement executing in the named connection. The EXPLAIN statement provides information ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-installation.html
It refers to Windows Firewall and controls whether Windows blocks the TCP/IP port on which the MySQL server listens for client connections.) To install MySQL Enterprise Firewall using MySQL Workbench, see MySQL Enterprise Firewall Interface. To ...
https://dev.mysql.com/doc/refman/8.4/en/gis-class-multipolygon.html
A MultiPolygon that has more than one Polygon has an interior that is not connected. The number of connected components of the interior of a MultiPolygon is equal to the number of Polygon values in the MultiPolygon. A MultiPolygon is a MultiSurface ...
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
If you do not want the credentials transferred to new joiners and recorded there, ensure that you unset them before remote cloning operations take place, as described in Section 20.6.3, “Securing Distributed Recovery Connections”, and use START ... If you want to use remote cloning operations for distributed recovery in a group, you must set up existing members and joining members beforehand to support this ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance-xcom-cache-reduce.html
Having a very low group_replication_message_cache_size setting is not recommended if the host is on an unstable network, because a smaller message cache makes it harder for group members to reconnect after a transient loss of connectivity. If a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-restarting-group.html
For each group member in turn, in any order: Connect a client to the group member. Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-understanding-consistency-guarantees.html
This ensures that in a situation as described previously, when client C1 is reconnected to the new primary it reads A=2. This means that a client C2 can write B=2 WHERE B=1 on the primary, immediately connect to a secondary and read B=1. Any ... In ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-use-cases.html
It is important to understand that although the database service is available, in the event of an unexpected server exit, those clients connected to it must be redirected, or failed over, to a different server. A connector, load balancer, router, or ... Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of ...