Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/replication-features-differing-tables.html
A column's default value is determined by a number of factors, including its type, whether it is defined with a DEFAULT option, whether it is declared as NULL, and the server SQL mode in effect at the time of its creation; for more information, see ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/replication-features-memory.html
To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the table must be emptied by writing a DELETE or (from MySQL 8.0.22) TRUNCATE TABLE statement ... When a replication source server shuts down and restarts, its MEMORY tables become ...
https://dev.mysql.com/replication-features-transaction-inconsistencies.html
When using a multithreaded replica, workers which have not received an error complete their queues, so it may take time to stop all threads. After this timeout, the coordinator gives up and aborts the transaction. After this timeout, it aborts the ... Inconsistencies in the sequence of transactions that have been executed from the relay log can occur depending on your replication ...
https://dev.mysql.com/replication-gtids-functions.html
WAIT_FOR_EXECUTED_GTID_SET(gtid_set[, timeout]) Wait until the server has applied all of the transactions whose global transaction identifiers are contained in gtid_set. The optional timeout stops the function from waiting after the specified number ... MySQL includes some built-in (native) functions for use with GTID-based ...
https://dev.mysql.com/replication-mode-change-online-concepts.html
The valid values for gtid_mode are as follows and in this order: OFF OFF_PERMISSIVE ON_PERMISSIVE ON It is important to note that the state of gtid_mode can only be changed by one step at a time based on the above order. To be able to safely ...
https://dev.mysql.com/replication-mode-change-online-disable-gtids.html
If you use binary logs for anything else than replication, for example to do point in time backup or restore: wait until you do not need the old binary logs having GTID transactions. This section describes how to disable GTID transactions on ...
https://dev.mysql.com/replication-problems.html
Many users have lost time by not doing this soon enough after encountering problems. 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. If you cannot tell from ...
https://dev.mysql.com/replication-rbr-usage.html
You can switch from statement-based to row-based binary logging format at runtime even when temporary tables have been created. However, in MySQL 8.0, you cannot switch from row-based or mixed format for binary logging to statement-based format at ... MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format ...
https://dev.mysql.com/replication-semisync-installation.html
You can set these variables at runtime using SET GLOBAL, or at server startup on the command line or in an option file. At runtime, these source-side system variables are available: SET GLOBAL rpl_semi_sync_master_enabled = {0|1}; SET GLOBAL ...
https://dev.mysql.com/replication-semisync-interface.html
rpl_semi_sync_master_timeout A value in milliseconds that controls how long the source waits on a commit for acknowledgment from a replica before timing out and reverting to asynchronous replication. It is 0 if the plugin is not enabled or the ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-time-p-78.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
