Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-transactions.html
The server uses these rules for binary logging: If the initial statements in a transaction are nontransactional, they are written to the binary log immediately. When this variable is ON, logging occurs immediately for nontransactional statements ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
The sets of GTIDs in the gtid_executed and gtid_purged system variables are initialized when the server starts. The result is the set of GTIDs that have been used on the server, but are not currently recorded in a binary log file on the server, and ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-additionalslaves.html
You can add another replica to an existing replication configuration without stopping the source server. To do this, you can set up the new replica by copying the data directory of an existing replica, and giving the new replica a different server ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
The recovery process creates a new relay log file, initializes the SQL (applier) thread position to this new relay log, and initializes the I/O (receiver) thread to the applier thread position. This section explains the server options and system ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-diffengines.html
Configuring different engines on the source and replica depends on how you set up the initial replication process: If you used mysqldump to create the database snapshot on your source, you could edit the dump file text to change the engine type used ... It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine ...
https://dev.mysql.com/doc/refman/8.4/en/reusing-ssl-sessions.html
Server-Side Runtime Configuration and Monitoring for SSL Session Reuse To create the initial TLS context, the server uses the values that the context-related system variables have at startup. To expose the context values, the server also initializes ... MySQL client programs may elect to resume a prior SSL session, provided that the server has the session in its runtime ...
https://dev.mysql.com/doc/refman/8.4/en/roles.html
Like user accounts, roles can have privileges granted to and revoked from them. A user account can be granted roles, which grants to the account the privileges associated with each role. This enables assignment of sets of privileges to accounts and ...
https://dev.mysql.com/doc/refman/8.4/en/select.html
When you use ORDER BY or GROUP BY to sort a column in a SELECT, the server sorts values using only the initial number of bytes indicated by the max_sort_length system variable. The offset of the initial row is 0 (not 1): SELECT * FROM tbl LIMIT ...
https://dev.mysql.com/doc/refman/8.4/en/server-configuration-validation.html
For additional checks to occur, correct the initial problem and run the server with --validate-config again. As such, the configuration check does not initialize storage engines and other plugins, components, and so forth, and does not validate ...
https://dev.mysql.com/doc/refman/8.4/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...