Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-encrypted-connections.html
To enable encrypted connections on the replica, use the CHANGE REPLICATION SOURCE TO statement. After the source information has been updated, start the replication process on the replica, like this: mysql> START REPLICA; You can use the SHOW ... To ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-optimizer.html
It is possible for the data on the source and replica to become different if a statement is written in such a way that the data modification is nondeterministic; that is, left up the query optimizer. (In general, this is not a good practice, even ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-partitioning.html
In the case where a table is partitioned on the source but not on the replica, any statements that operate on partitions on the source's copy of the replica fail on the replica. When the replica's copy of the table is partitioned but the source's ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-reserved-words.html
In any SQL statements using these database object names, write the names as quoted identifiers using backtick characters (`). You can encounter problems when you attempt to replicate from an older source to a newer replica and you make use of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions-synchronization.html
Use a SHOW REPLICA STATUS statement to check if the binary log file position has been marked as invalid. A warning is logged if you use this function when binlog_format is set to STATEMENT. The functions listed in this section are used for ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
No error is raised, and no statement in the transaction is executed. If the first attempt committed, all the concurrent sessions stop being blocked, and auto-skip all the statements of the transaction. A global transaction identifier (GTID) is a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-monitoring.html
By default, if the FOR CHANNEL channel clause is not used, this statement shows the replica status for all channels with one row per channel. Note The SHOW VARIABLES statement does not work with multiple replication channels. Using a SHOW VARIABLES ... To monitor the status of replication channels the following options exist: Using the replication Performance Schema ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-installation.html
The INSTALL PLUGIN, SET GLOBAL, STOP REPLICA, and START REPLICA statements mentioned here require the REPLICATION_SLAVE_ADMIN privilege (or the deprecated SUPER privilege). To load the plugins, use the INSTALL PLUGIN statement on the source and on ... Semisynchronous replication is implemented using plugins, which must be installed on the source and on the replicas to make semisynchronous replication available on the ...
https://dev.mysql.com/doc/refman/8.4/en/reproducible-test-case.html
If you encounter corrupted MyISAM tables or if mysqld always fails after some update statements, you can test whether the issue is reproducible by doing the following: Stop the MySQL daemon with mysqladmin shutdown. If you want to find a statement ...For information about steps to take when encountering InnoDB table corruption, see Section 1.6, “How to Report Bugs or ...
https://dev.mysql.com/doc/refman/8.4/en/security-guidelines.html
Use the GRANT and REVOKE statements to control access to MySQL. Use the SHOW GRANTS statement to check which accounts have access to what. Then use the REVOKE statement to remove those privileges that are not necessary. Anyone using MySQL on a ...