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 ...
https://dev.mysql.com/scalar-subqueries.html
In its simplest form, a subquery is a scalar subquery that returns a single value. A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those ...
