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
Once you have added channels for all of the replication sources, issue a START REPLICA statement to start replication. When you have enabled multiple channels on a replica, you can choose to either start all channels, or select a specific channel ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-channel-based-filters.html
This section explains how to work with replication filters when multiple replication channels exist, for example in a multi-source replication topology. Replication filters can be global or specific to a channel, enabling you to configure ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-installation.html
Semisynchronous replication is implemented using plugins, which must be installed on the source and on the replicas to make semisynchronous replication available on the instances. There are different plugins for a source and for a replica. After a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-snapshot-method.html
If the source database contains existing data it is necessary to copy this data to each replica. There are different ways to dump the data from the source database. To select the appropriate method of dumping the database, choose between these ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-mysqldump.html
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 of MySQL Server (see Section 6.5.4, “mysqldump — A Database ...
https://dev.mysql.com/doc/refman/8.4/en/replication-threads-monitor-main.html
The SHOW PROCESSLIST statement provides information that tells you what is happening on the source and on the replica regarding replication. For information on source states, see Section 10.14.4, “Replication Source Thread States”. For replica ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin.html
MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by the server before the server executes them. MySQL distributions include a postparse query rewrite plugin named Rewriter and scripts for installing ...
https://dev.mysql.com/doc/refman/8.4/en/security-guidelines.html
Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security mistakes. In discussing security, it is necessary to consider fully protecting the entire server host (not just the MySQL server) ...
https://dev.mysql.com/doc/refman/8.4/en/selinux-file-context.html
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 instructions that follow use the semanage binary to manage file context; on RHEL, it's part ...