Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrading-member.html
To upgrade a member of a group: Connect a client to the group member and issue STOP GROUP_REPLICATION. Disable Group Replication from starting up automatically so that you can safely connect to the member after upgrading and configure it without it ... This section explains the steps required for upgrading a member of a ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-processlist-table.html
This is the same value displayed in the Id column of the SHOW PROCESSLIST statement, displayed in the PROCESSLIST_ID column of the Performance Schema threads table, and returned by the CONNECTION_ID() function within the thread. unauthenticated user ... Important INFORMATION_SCHEMA.PROCESSLIST is deprecated and subject to removal in a future MySQL ...