Rechercher dans le manuel MySQL
Search Results
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 master-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 master waits on a commit for acknowledgment from a slave before timing out and reverting to asynchronous replication. It is 0 if the plugin is not enabled or the master ... The administrative interface to semisynchronous replication has several components: Two plugins implement semisynchronous ...
https://dev.mysql.com/replication-snapshot-method.html
Employing this method with a table using a storage engine that has complex caching or logging algorithms requires extra steps to produce a perfect “point in time” snapshot: the initial copy command could leave out cache information and logging ... If the master database contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/replication-solutions-backups-mysqldump.html
If you use this approach, make sure you monitor the slave replication process to ensure that the time taken to run the backup does not affect the slave's ability to keep up with events from the master. Using mysqldump to create a copy of a database ...
https://dev.mysql.com/replication-solutions-unexpected-slave-halt.html
In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the slave to recover its state before halting. Also note that when relay_log_recovery=0, the next time the slave ...This section describes the impact of an unexpected halt of a slave during replication and how to configure a slave for the best chance of recovery to continue ...
https://dev.mysql.com/replication-upgrade.html
When you upgrade servers that participate in a replication setup, the procedure for upgrading depends on the current server versions and the version to which you are upgrading. For general information about upgrading MySQL, see Section 2.11, ...
https://dev.mysql.com/replication.html
MySQL 8.0 also supports delayed replication such that a slave server deliberately lags behind the master by at least a specified amount of time; see Section 17.4.10, “Delayed Replication”. Replication enables data from one MySQL database server ...
https://dev.mysql.com/request-access.html
A '%' or blank Host value means “any host.” A '%' or blank Db value means “any database.” The server reads the db table into memory and sorts it at the same time that it reads the user table. After you establish a connection, the server ...
https://dev.mysql.com/rewriter-query-rewrite-plugin-usage.html
Prepared statements are rewritten at parse time (that is, when they are prepared), not when they are executed later. To enable or disable the plugin, enable or disable the rewriter_enabled system variable. By default, the Rewriter plugin is enabled ...
https://dev.mysql.com/savepoint.html
In this case, the row lock is released in the undo.) Savepoints that were set at a later time than the named savepoint are deleted. SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB supports the SQL ...
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-80.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.
