Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-concepts.html
Before setting the replication mode of an online server, it is important to understand some key concepts of replication. This section explains these concepts and is essential reading before attempting to modify the replication mode of an online ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-monitoring.html
This enables you to write complex queries based on Channel_Name as a key. To monitor the status of replication channels the following options exist: Using the replication Performance Schema tables. By default, if the FOR CHANNEL channel clause is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-sbr-rbr.html
SELECT INSERT statements with AUTO_INCREMENT UPDATE or DELETE statements with WHERE clauses that do not use keys or do not change most of the examined rows. For most users, the mixed replication format should provide the best combination of data ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-installation.html
For information on key system variables, see Section 19.4.10.2, “Configuring Semisynchronous Replication”. Semisynchronous replication is implemented using plugins, which must be installed on the source and on the replicas to make ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-interface.html
Some key system variables are: rpl_semi_sync_source_enabled Controls whether semisynchronous replication is enabled on the source server. When you install the source and replica plugins for semisynchronous replication (see Section 19.4.10.1, ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-unexpected-replica-halt.html
The innodb_flush_log_at_trx_commit=1 setting mentioned in the list below is a key setting for a replication setup that uses InnoDB with transactions. In order for replication to be resilient to unexpected halts of the server (sometimes described as ...
https://dev.mysql.com/doc/refman/8.4/en/reset-binary-logs-and-gtids.html
Note This statement takes the place of the old RESET MASTER statement, which is no longer supported. RESET BINARY LOGS AND GTIDS [TO binary_log_file_index_number] Warning Use this statement with caution to ensure you do not lose any wanted binary ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-reference.html
Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates information to users by setting the table's message column. Note The rules table is loaded into the plugin by the flush_rewrite_rules ...
https://dev.mysql.com/doc/refman/8.4/en/secure-client-programming.html
The information returned in a MySQL error is not gratuitous because that information is key in debugging MySQL using applications. Client applications that access MySQL should use the following guidelines to avoid interpreting external data ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
InnoDB tablespace encryption relies on the MySQL Keyring for encryption key management, and the keyring plugin to be used must be loaded prior to storage engine initialization to facilitate InnoDB recovery for encrypted tables. For example, ... When ...