Search Results
https://dev.mysql.com/doc/refman/8.4/en/plugin-loading.html
The --plugin-load and --plugin-load-add options load plugins after built-in plugins and storage engines have initialized during the server startup sequence. These can be identified as those that have a library name of NULL in the output from the ...
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-positions.html
When finished, note the binary log position up to which you have restored the server for later use, and restart the server. The last section, Section 9.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the ...
https://dev.mysql.com/doc/refman/8.4/en/query-attributes.html
To access query attributes within SQL statements for which attributes have been defined, install the query_attributes component as described in Prerequisites for Using Query Attributes. If multiple attributes are defined with the same name, attempts ... The most visible part of an SQL statement is the text of the ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
Although normally you should never have to run REPAIR TABLE, if disaster strikes, this statement is very likely to get back all your data from a MyISAM table. In the worst case, you might have a new clean index file without information about the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-shutdowns.html
However, be careful that the replica does not have temporary tables open; see Section 19.5.1.31, “Replication and Temporary Tables”. The fault tolerance of your system for these types of problems is greatly increased if you have a good ... It is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions-async-failover.html
The connection is also changed if the currently connected source does not have the highest weighted priority in the group. If multiple sources have the same priority, the replica orders them randomly. asynchronous_connection_failover_reset() can be ... The following functions enable you to add or remove replication source servers to or from the source list for a replication channel, as well as clear the source list for a given ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-restrictions.html
If you have enabled GTID assignment on a replication channel using the ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS option of the CHANGE REPLICATION SOURCE TO statement, sql_replica_skip_counter is available. IGNORE_SERVER_IDS cannot be used with CHANGE ... Because GTID-based replication is dependent on transactions, some features otherwise available in MySQL are not supported when using ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-masterstatus.html
You now have the information you need to enable the replica to start reading from the source's binary log in the correct place to start replication. The next step depends on whether you have existing data on the source. Choose one of the following ... To configure the replica to start the replication process at the correct point, you need to note the source's current coordinates within its binary ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto.html
There are a number of different methods for setting up replication, and the exact method to use depends on how you are setting up replication, and whether you already have data in the database on the source that you want to replicate. If you already ... This section describes how to set up a MySQL server to use binary log file position based ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-provision-replica.html
If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting replication. For example: mysql -u<user> -p<password> < dumpM1_nopurge.sql mysql -u<user> ...In a multi-source replication topology, cloning or copying of the data directory cannot be used to provision the replica with data from all of the sources, and you might also want to replicate only specific databases from each ...