Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-binlog-encryption-scope.html
Data in motion in the replication event stream, which is sent to MySQL clients including mysqlbinlog, is decrypted for transmission, and should therefore be protected in transit by the use of connection encryption (see Section 8.3, “Using ...
https://dev.mysql.com/doc/refman/9.7/en/replication-howto-slaveinit.html
To set up the replica to communicate with the source for replication, configure the replica with the necessary connection information. You must be able to connect to the source MySQL server using TCP/IP. To do this, on the replica, execute the ...
https://dev.mysql.com/doc/refman/9.7/en/replication-howto.html
In addition, InnoDB Cluster interfaces seamlessly with MySQL Router, which enables your applications to connect to the cluster without writing your own failover process. On each replica that you want to connect to the source, you must configure a ...
https://dev.mysql.com/doc/refman/9.7/en/replication-multi-source-configuration.html
Replicas in a multi-source replication topology require TABLE repositories for the replica's connection metadata repository and applier metadata repository, which are the default in MySQL 9.7. Create a suitable user account on all the sources that ... A multi-source replication topology requires at least two sources and one replica ...
https://dev.mysql.com/doc/refman/9.7/en/replication-problems.html
If the replica is running, check whether it established a connection to the source. If the receiver thread state says Connecting to master, check the following: Verify the privileges for the replication user on the source. Check that the host name ... If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for ...
https://dev.mysql.com/doc/refman/9.7/en/replication-snapshot-method.html
In addition, InnoDB Cluster interfaces seamlessly with MySQL Router, which enables your applications to connect to the cluster without writing your own failover process. To import the data, either copy the dump file to the replica, or access the ...
https://dev.mysql.com/doc/refman/9.7/en/request-access.html
After the server accepts a connection, it enters Stage 2 of access control. For each request that you issue through the connection, the server determines what operation you want to perform, then checks whether your privileges are sufficient. The ...
https://dev.mysql.com/doc/refman/9.7/en/reserved-accounts.html
This account is locked so that it cannot be used for client connections. This account is locked so that it cannot be used for client connections. This account is locked so that it cannot be used for client connections. One part of the MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/restart.html
Note After executing a RESTART statement, the client can expect the current connection to be lost. If auto-reconnect is enabled, the connection is reestablished after the server restarts. One use for RESTART is when it is not possible or convenient ...
https://dev.mysql.com/doc/refman/9.7/en/server-status-variable-reference.html
The following table lists all status variables applicable within mysqld. The last column indicates whether the scope for each variable is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the ...