Search Results
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.4/en/crashing.html
The problem may be that all connections are in use, or there may be some internal lock problem. mysqladmin -u root processlist usually is able to make a connection even in these cases, and can provide useful information about the current number of ... Each MySQL version is tested on many platforms before it is ...
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-rsa-files.html
SSL certificate and key files enable MySQL to support encrypted connections using SSL. RSA key files enable MySQL to support secure password exchange over unencrypted connections for accounts authenticated by the sha256_password (deprecated) or ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-priority-based-filtering.html
If the value is 3, the server logs aborted connections and access-denied errors for new connection attempts. If you use replication, a log_error_verbosity value of 2 or greater is recommended, to obtain more information about what is happening, such ... The log_filter_internal log filter component implements a simple form of log filtering based on error event priority and error ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
Must the replica be connected to the source all the time? A.14.2. Must the replica be connected to the source all the time? No, it does not. The replica can go down or stay disconnected for hours or even days, and then reconnect and catch up on ...
https://dev.mysql.com/doc/refman/8.4/en/gis-class-polygon.html
A Polygon has an interior that is a connected point set. A Polygon is a planar Surface representing a multisided geometry. It is defined by a single exterior boundary and zero or more interior boundaries, where each interior boundary defines a hole ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
If you are relying on distributed recovery to configure the user on all members, when s2 connects to the seed s1 the replication user is replicated or cloned to s1. [mysqld] # # Disable other storage engines # ... At this point, the group has one ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-locally.html
For example: [mysqld] # server configuration datadir=<full_path_to_data>/data/s1 basedir=<full_path_to_bin>/mysql-8.4/ port=24801 socket=<full_path_to_sock_dir>/s1.sock These settings configure MySQL server to use the data directory created earlier ... The most common way to deploy Group Replication is using multiple server instances, to provide high ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-failure-detection.html
In a replication group, each member has a point-to-point communication channel to each other member, creating a fully connected graph. These connections are managed by the group communication engine (XCom, a Paxos variant) and use TCP/IP sockets. In ... Group Replication’s failure detection mechanism is a distributed service which is able to identify that a server in the group is not communicating with the others, and is therefore suspected of being out of ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-member-actions.html
In this state, it does not accept updates from any clients, even users who have the CONNECTION_ADMIN or SUPER privilege. When this member action is enabled, asynchronous connection failover for replicas is active for a replication channel on a Group ... The following functions can be used to enable and disable actions for members of a group to take in specified situations, and to reset the configuration to the default setting for all member ...