Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-features-drop-if-exists.html
The DROP DATABASE IF EXISTS, DROP TABLE IF EXISTS, and DROP VIEW IF EXISTS statements are always replicated, even if the database, table, or view to be dropped does not exist on the source. This is to ensure that the object to be dropped no longer ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-max-allowed-packet.html
This means that, when you are replicating large column values using row-based replication, you must take care to set max_allowed_packet large enough to accommodate the largest row in any table to be replicated, even if you are replicating updates ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-shutdowns.html
However, be careful that the replica does not have temporary tables open; see Section 19.5.1.32, “Replication and Temporary Tables”. It is safe to shut down a replication source server and restart it later. When a replica loses its connection ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-timeout.html
The Performance Schema table replication_applier_status shows the total number of transaction retries that took place on each replication channel, in the COUNT_TRANSACTIONS_RETRIES column. The Performance Schema table ... The global value of the ...
https://dev.mysql.com/doc/refman/9.7/en/replication-multi-source.html
Channel specific replication filters can be used when the same database or table is present on multiple sources, and you only need the replica to replicate it from one source. Multi-source replication in MySQL 9.7 enables a replica to receive ...
https://dev.mysql.com/doc/refman/9.7/en/replication-privilege-checks-recover.html
Details of the error and the last applied transaction are recorded in the Performance Schema replication_applier_status_by_worker table. If the PRIVILEGE_CHECKS_USER account should have been permitted to execute the transaction, but has been ... If ...
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-backups-rawdata.html
You can use any suitable copying or archive utility, including cp, tar or WinZip. Assuming tables have been used for the replica's connection metadata repository and applier metadata repository (see Section 19.2.4, “Relay Log and Replication ...
https://dev.mysql.com/doc/refman/9.7/en/reset-binary-logs-and-gtids.html
The value of the gtid_purged system variable is set to an empty string (''), the global value (but not the session value) of the gtid_executed system variable is set to an empty string, and the mysql.gtid_executed table is cleared (see ... RESET ...
https://dev.mysql.com/doc/refman/9.7/en/roles.html
If a role named in mandatory_roles is not present in the mysql.user system table, the role is not granted to users. You should keep in mind that this distinction is not immutable; a user with appropriate privileges can lock or unlock roles or ...
https://dev.mysql.com/doc/refman/9.7/en/security-guidelines.html
When running MySQL, follow these guidelines: Do not ever give anyone (except MySQL root accounts) access to the user table in the mysql system database! This is critical. To prevent password recovery using rainbow tables, do not use these functions ... Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security ...