Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-verify-transactions.html
This section explains how to monitor a replication topology and verify that all anonymous transactions have been replicated. This is helpful when changing the replication mode online as you can verify that it is safe to change to GTID transactions.
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-start-replica.html
When you have enabled multiple channels on a replica, you can choose to either start all channels, or select a specific channel to start. Once you have added channels for all of the replication sources, issue a START REPLICA statement to start ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-channel-based-filters.html
You cannot set up multiple replication channels from a single replica to a single source, even if you use replication filters to select different data to replicate on each channel. This section explains how to work with replication filters when ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-installation.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%semi%'; +----------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +----------------------+---------------+ | ...
https://dev.mysql.com/doc/refman/8.4/en/replication-snapshot-method.html
To select the appropriate method of dumping the database, choose between these options: Use the mysqldump tool to create a dump of all the databases you want to replicate. If the source database contains existing data it is necessary to copy this ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-mysqldump.html
You may either dump all databases or select databases to be dumped. Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance ...
https://dev.mysql.com/doc/refman/8.4/en/replication-threads-monitor-main.html
You can also retrieve information on the source's Binlog Dump threads with the following: SELECT * FROM performance_schema.threads WHERE PROCESSLIST_COMMAND LIKE "Binlog Dump%" Binlog Dump% is used to retrieve either Binlog Dump or Binlog Dump GTID, ... The SHOW PROCESSLIST statement provides information that tells you what is happening on the source and on the replica regarding ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin.html
These statements are subject to rewriting: SELECT, INSERT, REPLACE, UPDATE, and DELETE. MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by the server before the server executes them. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/security-guidelines.html
A passphrase containing multiple words is easy to create, remember, and reproduce, and is much more secure than a typical user-selected password consisting of a single modified word or a predictable sequence of characters. Anyone using MySQL on a ...
https://dev.mysql.com/doc/refman/8.4/en/selinux-file-context.html
The /var/lib/mysql-files/ directory is intended to be used for operations such as SELECT ... The MySQL Server reads from and writes to many files. If the SELinux context is not set correctly for these files, access to the files could be denied. The ...