Search Results
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 ...For example, to start the two channels separately, use the mysql client to issue the following statements: mysql> START REPLICA FOR CHANNEL "source_1"; mysql> START REPLICA FOR CHANNEL "source_2"; For the full syntax of the START REPLICA statement and other available options, see Section 15.4.2.4, “START REPLICA ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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 ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/role-names.html
Role names have syntax and semantics similar to account names; see Section 8.2.4, “Specifying Account Names”. As stored in the grant tables, they have the same properties as account names, which are described in Grant Table Scope Column ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-status.html
To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a scope that ...