Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids.html
A general procedure for setting up and starting GTID-based replication (see Section 19.1.3.4, “Setting Up Replication Using GTIDs”). This section explains transaction-based replication using global transaction identifiers (GTIDs). Because ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
For details of how stored programs (stored procedures and functions, triggers, and events) are handled when each binary logging format is set, see Section 27.7, “Stored Program Binary Logging”. Startup Options Used with Binary Logging System ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-recover.html
Follow this procedure to recover from the error: Identify the replicated event that caused the error and verify whether or not the event is expected and from a trusted source. If a privilege check against the PRIVILEGE_CHECKS_USER account fails, ...
https://dev.mysql.com/doc/refman/8.4/en/replication-problems.html
If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for messages. Many users have lost time by not doing this soon enough after encountering problems. If you cannot tell from ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions.html
For information on using replication in a backup environment, including notes on the setup, backup procedure, and files to back up, see Section 19.4.1, “Using Replication for Backups”. Replication can be used in many different environments for ...
https://dev.mysql.com/doc/refman/8.4/en/reproducible-test-case.html
For information about steps to take when encountering InnoDB table corruption, see Section 1.6, “How to Report Bugs or Problems”. If you encounter corrupted MyISAM tables or if mysqld always fails after some update statements, you can test ...
https://dev.mysql.com/doc/refman/8.4/en/return.html
This statement is not used in stored procedures, triggers, or events. RETURN expr The RETURN statement terminates execution of a stored function and returns the value expr to the function caller. There must be at least one RETURN statement in a ...
https://dev.mysql.com/doc/refman/8.4/en/security.html
Note Several topics in this chapter are also addressed in the Secure Deployment Guide, which provides procedures for deploying a generic binary distribution of MySQL Enterprise Edition Server with features for managing the security of your MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/select-into.html
For the INTO var_list variant: var_list names a list of one or more variables, each of which can be a user-defined variable, stored procedure or function parameter, or stored program local variable. INTO form of SELECT enables a query result to be ...
https://dev.mysql.com/doc/refman/8.4/en/show-binary-logs.html
This statement is used as part of the procedure described in Section 15.4.1.1, “PURGE BINARY LOGS Statement”, that shows how to determine which logs can be purged. SHOW BINARY LOGS Lists the binary log files on the server. SHOW BINARY LOGS ...