Search Results
https://dev.mysql.com/doc/refman/8.4/en/error-log-configuration.html
Important When implementing an implicit configuration, set log_error_services first to load a component and expose its system variables, and then set component system variables afterward. Important When loading log components explicitly using ... In ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
In this example, the EVENT privilege on the schema myschema is removed from the jon@ghidora user account: REVOKE EVENT ON myschema.* FROM jon@ghidora; Important Revoking the EVENT privilege from a user does not delete or disable any events that may ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/8.4/en/fips-mode.html
Important In general, STRICT imposes more restrictions than ON, but MySQL itself has no FIPS-specific code other than to specify the FIPS mode value to OpenSSL. MySQL supports FIPS mode when a supported OpenSSL library and FIPS Object Module are ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-connection-security.html
It is especially important to make sure these requirements are all fulfilled when you switch from using the XCom communication stack to the MySQL communication stack for your group. It is important to note that because Group Replication cannot even ... MySQL 8.4 Group Replication can secure group communication connections between members by one of the following methods: Using its own implementation of the security protocols, including TLS/SSL and the use of an allowlist for incoming Group Communication System (GCS) ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-socket-layer-support-ssl.html
Important Support for the TLSv1 and TLSv1.1 connection protocols was removed in MySQL 8.0. Secure sockets can be used for group communication connections between members of a group. The Group Replication system variable group_replication_ssl_mode ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-user.html
Important When using the MySQL communication stack (group_replication_communication_stack=MYSQL) AND secure connections between members (group_replication_ssl_mode is not set to DISABLED), the recovery users must be properly set up, as they are also ... State transfer from the binary log requires a replication user with the correct permissions so that Group Replication can establish direct member-to-member replication ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-user-credentials.html
Important If distributed recovery connections for your group use SSL, the replication user must be created on each server before the joining member connects to the donor. For instructions to set up SSL for distributed recovery connections and create ... Group Replication uses a distributed recovery process to synchronize group members when joining them to the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
There is no change in semantics compared to “traditional” mode for any statement that uses auto-increment, with one important exception. The only circumstance in which InnoDB uses the equivalent of a SELECT MAX(ai_col) FROM table_name FOR UPDATE ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-syntax-warnings.html
The “non-strict” behavior lets you import a mysqldump file into a database that does not support compressed tables, even if the source database contained compressed tables. To import the dump file into a new database, and have the tables ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-per-table-tablespaces.html
You can import a table that resides in file-per-table tablespace from another MySQL instance. A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data file. File-per-table ...