Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-functions.html
To avoid unexpected results when replicating between MySQL servers in different time zones, set the time zone on both source and replica. To explain the potential problems when replicating between servers which are in different time zones, suppose ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-monitoring.html
To check the current values of the status variables, use SHOW STATUS: mysql> SHOW STATUS LIKE 'Rpl_semi_sync%'; All Rpl_semi_sync_xxx status variables are described at Section 7.1.10, “Server Status Variables”. Some examples are: ... The plugins ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups.html
There are therefore two choices: If you are using replication as a solution to enable you to back up the data on the source, and the size of your database is not too large, the mysqldump tool may be suitable. For larger databases, where mysqldump ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-performance.html
If you are using a large number of replicas connected to one source, and that source is also busy processing requests (for example, as part of a scale-out solution), then you may want to improve the performance of the replication process. Figure ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-switch.html
In a failover situation, all the servers in the group are typically executing the same events from the same binary log file, so changing the source of the events should not affect the structure or integrity of the database, provided that you ... You ...
https://dev.mysql.com/doc/refman/8.4/en/reproducible-test-case.html
If you want to find a statement that crashes mysqld, you should start the server with the general query log enabled as well. When you have gotten a crashed table, stop the mysqld server. If you encounter corrupted MyISAM tables or if mysqld always ...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/reset-persist.html
Removing a persisted system variable causes the variable no longer to be initialized from mysqld-auto.cnf at server startup. RESET PERSIST [[IF EXISTS] system_var_name] RESET PERSIST removes persisted global system variable settings from the ...The ...
https://dev.mysql.com/doc/refman/8.4/en/set-statement.html
Descriptions for those forms that are not associated with a specific server capability appear in subsections of this section: SET var_name = value enables you to assign values to variables that affect the operation of the server or clients. SET ...
https://dev.mysql.com/doc/refman/8.4/en/show-binary-log-status.html
SHOW BINARY LOG STATUS This statement provides status information about binary log files on the source server, and requires the REPLICATION CLIENT privilege (or the deprecated SUPER privilege). row *************************** File: ...
https://dev.mysql.com/doc/refman/8.4/en/show-binary-logs.html
SHOW BINARY LOGS Lists the binary log files on the server. Binary log encryption is active if binlog_encryption=ON is set for the server. Existing binary log files are not encrypted or decrypted if binary log encryption is activated or deactivated ...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 ...