PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/en/replication-multi-source-start-replica.html
Once you have added channels for all of the replication sources, issue a START REPLICA (or before MySQL 8.0.22, START SLAVE) statement to start replication. When you have enabled multiple channels on a replica, you can choose to either start all ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-gr.html
This action causes the relay log files for the channel to be purged, which might cause the loss of transactions that have been received and queued in the relay log, but not yet applied. Group Replication requires every table that is to be replicated ... From MySQL 8.0.19, as well as securing asynchronous and semi-synchronous replication, you may choose to use a PRIVILEGE_CHECKS_USER account to secure the two replication applier threads used by Group ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-read-only.html
You should not attempt to use these instructions to make a binary backup by copying files directly because the server may still have modified data cached in memory and not flushed to disk. Note The instructions in this section place the server to be ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-partitioning.html
There may be situations where you have a single source server and want to replicate different databases to different replicas. If you have data that must be synchronized to the replicas before replication starts, you have a number of choices: ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-switch.html
Assume that you have the structure shown in Figure 19.4, “Redundancy Using Replication, Initial Structure”. Make sure that all replicas have processed any statements in their relay log. One way to keep applications informed about the location of ... You can tell a replica to change to a new source using the CHANGE REPLICATION SOURCE TO statement (prior to MySQL 8.0.23: CHANGE MASTER ...
https://dev.mysql.com/doc/refman/8.0/en/reproducible-test-case.html
When you have gotten a crashed table, stop the mysqld server. If the tables are corrupted again or you can get mysqld to die with the above command, you have found a reproducible bug. If you are a support customer, you can use the MySQL Customer ...
https://dev.mysql.com/doc/refman/8.0/en/request-access.html
These have the same meaning as for pattern-matching operations performed with the LIKE operator. These have the same meaning as for pattern-matching operations performed with the LIKE operator. In this case, you have the necessary privileges to ...
https://dev.mysql.com/doc/refman/8.0/en/reset-replica.html
Note All relay log files are deleted, even if they have not been completely executed by the replication SQL thread. (This is a condition likely to exist on a replica if you have issued a STOP REPLICA statement or if the replica is highly loaded.) ...
https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html
If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as root. If you assigned a root password previously but have forgotten it, you can assign a new password. To have server output to ...