PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-features-foreign-keys.html
If enable_cascade_triggers=ON and both servers use SQL-layer foreign key handling, cascade-induced triggers execute on both servers, regardless of the replica's local enable_cascade_triggers setting. For InnoDB tables, foreign keys can be handled ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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.
https://dev.mysql.com/doc/refman/9.7/en/replication-sbr-rbr.html
(Row-based replication, however, simply replicates the value returned by the function or stored program, so its effect on table rows and data is the same on both the source and replica.) See Section 19.5.1.16, “Replication of Invoked Features”, ...For most users, the mixed replication format should provide the best combination of data integrity and ...
https://dev.mysql.com/doc/refman/9.7/en/reset-persist.html
RESET PERSIST [[IF EXISTS] system_var_name] RESET PERSIST removes persisted global system variable settings from the mysqld-auto.cnf option file in the data directory. Removing a persisted system variable causes the variable no longer to be ...
https://dev.mysql.com/doc/refman/9.7/en/resignal.html
RESIGNAL makes it possible to both handle an error and return the error information. The RESIGNAL statement takes condition_value and SET clauses, both of which are optional. RESIGNAL may change some or all information before passing it on. RESIGNAL ...
https://dev.mysql.com/doc/refman/9.7/en/reusing-ssl-sessions.html
Server-Side Runtime Configuration and Monitoring for SSL Session Reuse Client-Side Configuration for SSL Session Reuse Each full TLS exchange can be costly both in terms of computation and network overhead, less costly if TLSv1.3 is used. SSL ...