Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
Leave the value unset if you do not want the replica to register itself with the source. This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica Servers ...
https://dev.mysql.com/doc/refman/8.4/en/replication-snapshot-method.html
Employing this method with a table using a storage engine that has complex caching or logging algorithms requires extra steps to produce a perfect “point in time” snapshot: the initial copy command could leave out cache information and logging ... If the source database contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/8.4/en/replication-upgrade.html
If they have not applied all changes, leave their applier running so they can process the received transactions in the background. When you upgrade servers that participate in a replication topology, you need to take into account each server's role ...
https://dev.mysql.com/doc/refman/8.4/en/request-access.html
For other users, leave all privileges in the user table set to 'N' and grant privileges at more specific levels only (for particular databases, tables, columns, or routines). After the server accepts a connection, it enters Stage 2 of access ...
https://dev.mysql.com/doc/refman/8.4/en/reset-binary-logs-and-gtids.html
Note This statement takes the place of the old RESET MASTER statement, which is no longer supported. RESET BINARY LOGS AND GTIDS [TO binary_log_file_index_number] Warning Use this statement with caution to ensure you do not lose any wanted binary ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
On Linux platforms using systemd and kernel support for Ambient Capabilities (Linux 4.3 or newer), the recommended way to enable CAP_SYS_NICE capability is to modify the MySQL service file and leave the mysqld binary unmodified. MySQL supports ...
https://dev.mysql.com/doc/refman/8.4/en/return.html
The LEAVE statement can be used to exit a stored program of those types. RETURN expr The RETURN statement terminates execution of a stored function and returns the value expr to the function caller. There must be at least one RETURN statement in a ...
https://dev.mysql.com/doc/refman/8.4/en/server-shutdown.html
If a thread is updating a nontransactional table, an operation such as a multiple-row UPDATE or INSERT may leave the table partially updated because the operation can terminate before completion. The server shutdown process takes place as follows: ...
https://dev.mysql.com/doc/refman/8.4/en/sha256-pluggable-authentication.html
The latter name choice leaves room for future expansion of possible digest lengths without changing the plugin name. MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: ...
https://dev.mysql.com/doc/refman/8.4/en/stop-group-replication.html
This is because on a Group Replication group member, an additional transaction committed during the shutdown operation would leave the member inconsistent with the group and cause an issue with rejoining. This statement requires the ...