Search Results
https://dev.mysql.com/doc/refman/9.7/en/group-replication-view-changes.html
They do not help marking a specific point in time to which the server joining the group must catch up, nor do they convey certification information. Begin: Stable Group All servers are online and processing incoming transactions from the group. Some ... When Group Replication's distributed recovery process is carrying out state transfer from the binary log, to synchronize the joining member with the donor up to a specific point in time, the joining member and donor make use of GTIDs (see Section 19.1.3, “Replication with Global Transaction ...
https://dev.mysql.com/doc/refman/9.7/en/request-access.html
After the server accepts a connection, it enters Stage 2 of access control. For each request that you issue through the connection, the server determines what operation you want to perform, then checks whether your privileges are sufficient. For ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-resource-manager-component.html
You can set an upper limit for this by setting the group_replication_resource_manager.applier_channel_lag server system variable; if the lag exceeds this value 10 times or more in succession, this server is expelled from the group. Resource (Memory) ...Recovery channel: The time by which this server's recovery channel lags behind that of the primary can be obtained by checking the value of the Gr_resource_manager_recovery_channel_lag server status ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-data-encryption.html
Defining an Encryption Default for Schemas and General Tablespaces default_table_encryption system variable defines the default encryption setting for schemas and general tablespaces. InnoDB supports data-at-rest encryption for file-per-table ...
https://dev.mysql.com/doc/refman/9.7/en/extensions-to-ansi.html
Consequently, database and table names are case-sensitive in MySQL Server on operating systems that have case-sensitive file names (such as most Unix systems). (In MySQL Server, these functions can take a variable number of arguments.) The ... MySQL ...If you add a version number after the ! character, the syntax within the comment is executed only if the MySQL version is greater than or equal to the specified version ...
https://dev.mysql.com/doc/refman/9.7/en/memory-storage-engine.html
Loading Data To populate a MEMORY table when the MySQL server starts, you can use the init_file system variable. See Section 7.1.8, “Server System Variables”, and Section 15.2.9, “LOAD DATA Statement”. As mentioned earlier, the ...When the ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/9.7/en/binary-log-transaction-compression.html
You can enable binary log transaction compression on a MySQL server instance using the binlog_transaction_compression system variable, which defaults to OFF. You can also use the binlog_transaction_compression_level_zstd system variable to set the ... MySQL supports binary log transaction compression; when this is enabled, transaction payloads are compressed using the zstd algorithm, and then written to the server's binary log file as a single event (a ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-connection-security.html
The choice is made by setting the system variable group_replication_communication_stack to XCOM to use Group Replication's own implementation (this is the default choice), or to MYSQL to use MySQL Server's connection security. Group Replication ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-file-formats.html
This is the same as the value of the server_id system variable. For the bytes_sent and bytes_received fields to be populated, the system variable log_slow_extra must be set to ON. Example: "time" : 1618498687 The time field occurs in files only if ... The MySQL server calls the audit log component to write an audit record to its log file whenever an auditable event ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-functions.html
On server2, extract that statement from the mysqldump output, and store the GTID set into a local variable, such as $gtid_purged_set. To check, on server1, extract and store gtid_purged from the output into a local variable as done previously, then ...The UUID is the identifier used by the server where the transaction originated, which is normally the value of ... This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by ...