Search Results
https://dev.mysql.com/doc/refman/8.4/en/plugin-loading.html
Plugins normally are installed using either a plugin-loading option at startup or with INSTALL PLUGIN at runtime, but not both. Server plugins must be loaded into the server before they can be used. It is also possible to control the activation ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-numbers.html
Exact-value numeric literals have an integer part or fractional part, or both. The scope of precision math for exact-value operations includes the exact-value data types (integer and DECIMAL types) and exact-value numeric literals.
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
By proxied_user for itself: The value of USER() must exactly match CURRENT_USER() and proxied_user, for both the user name and host name parts of the account name. Both accounts have the same user part (''), which matches any user. The plugin that ...
https://dev.mysql.com/doc/refman/8.4/en/replication-encrypted-connections.html
To use an encrypted connection for the transfer of the binary log required during replication, both the source and the replica servers must support encrypted network connections. The connection procedure negotiates the use of the highest TLS ...If ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-errors.html
If a statement produces the same error (identical error code) on both the source and the replica, the error is logged, but replication continues. This includes the case that a statement produces an error on the source or the replica, but not both.
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-auto-positioning.html
Disabling the SOURCE_AUTO_POSITION option again causes the replica to revert to file-based replication; this means that, when GTID_ONLY=ON, some positions may be marked as invalid, in which case you must also specify both SOURCE_LOG_FILE and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-failover.html
The easiest way to reproduce all identifiers and transactions on a new server is to make the new server into the replica of a source that has the entire execution history, and enable global transaction identifiers on both servers. Alternatively, ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-functions.html
Having identical GTIDs present on both servers causes errors when copying database db2 to server1. In this scenario, source1 and source2 are both sources and replicas and replicate to each other. This section provides examples of stored functions ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
You can increase the security of a replication channel where privilege checks are applied by adding one or both of these options to the CHANGE REPLICATION SOURCE TO statement when you specify the PRIVILEGE_CHECKS_USER account for the channel: The ...
https://dev.mysql.com/doc/refman/8.4/en/replication-problems.html
Verify that the server_id system variable was set at startup on both the source and replica and that the ID value is unique on each server. Use SHOW REPLICA STATUS to check whether the Replica_IO_Running and Replica_SQL_Running values are both Yes.