PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-connection-security.html
From MySQL 8.0.27, 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 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-syntax.html
This is not visible to the NDB kernel, which views these two rows as being the same, and thus has no way of knowing that this update should be cascaded. Keys and indexes on NDB Cluster tables are subject to the following limitations: Column width.
https://dev.mysql.com/doc/refman/8.0/en/mysql-ssl-rsa-setup.html
Instead, consider using MySQL server to generate missing SSL and RSA files automatically at startup (see Automatic SSL and RSA File Generation). This program creates the SSL certificate and key files and RSA key-pair files required to support secure ...mysql_ssl_rsa_setup can also be used to create new SSL files if the existing ones have ...
https://dev.mysql.com/doc/refman/8.0/en/plugin-loading.html
It is also possible to control the activation state of loaded plugins at startup, and to unload them at runtime. In the descriptions, plugin_name stands for a plugin name such as innodb, csv, or validate_password. --plugin-load, --plugin-load-add, ...Installing Plugins Controlling Plugin Activation State Uninstalling Plugins Plugins and Loadable Functions Installing Plugins Before a server plugin can be used, it must be installed using one of the following ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transaction-inconsistencies.html
Up to and including MySQL 8.0.18, preserving the commit order requires that binary logging (log_bin) and replica update logging (log_replica_updates or log_slave_updates) are also enabled, which are the default settings from MySQL 8.0. From MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-usage.html
This means that it is possible that updates are not applied on the replica, so that the source and replica are no longer synchronized. Another method to filter out changes on some replicas is to use a WHERE clause that includes the relation ...The ... MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-functions.html
To avoid unexpected results when replicating between MySQL servers in different time zones, set the time zone on both source and replica. To explain the potential problems when replicating between servers which are in different time zones, suppose ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
Killed Someone has sent a KILL statement to the thread and it should abort next time it checks the kill flag. System lock The thread has called mysql_lock_tables() and the thread state has not been updated since. Updating The thread is searching for ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-added-deprecated-removed.html
AutomaticThreadConfig: Use automatic thread configuration; overrides any settings for ThreadConfig and MaxNoOfExecutionThreads, and disables ClassicFragmentation. KeepAliveSendInterval: Time between keep-alive signals on links between data nodes, in ...Parameters Introduced in NDB 8.0 The following node configuration parameters have been added in NDB ...
https://dev.mysql.com/doc/refman/8.0/en/create-view.html
The view definition is “frozen” at creation time and is not affected by subsequent changes to the definitions of the underlying tables. The DEFINER and SQL SECURITY clauses specify the security context to be used when checking access privileges ...For example, if a view is defined as SELECT * on a table, new columns added to the table later do not become part of the view, and columns dropped from the table result in an error when selecting from the ...