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-masterbaseconfig.html
It is recommended that you specify this option to give the binary log files a non-default base name, so that if the host name changes, you can easily continue to use the same binary log file names (see Section B.3.7, “Known Issues in MySQL”).
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-slavebaseconfig.html
If you are shutting down the replica server, you can edit the [mysqld] section of the configuration file to specify a unique server ID. For example: [mysqld] server-id=21 Binary logging is enabled by default on all servers. In addition to binary ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-monitoring.html
To monitor the connection status of all channels: mysql> SELECT * FROM replication_connection_status\G; *************************** 1. row *************************** CHANNEL_NAME: source_1 GROUP_NAME: SOURCE_UUID: ... To monitor the status of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-table-options.html
For example, a GRANT statement, which updates the mysql.user system table but does not mention that table, is not affected by a filter that specifies mysql.% as the wildcard pattern. The replica checks for and evaluates table options only if either ...
https://dev.mysql.com/doc/refman/8.0/en/replication-security.html
To protect against unauthorized access to data that is stored on and transferred between replication source servers and replicas, set up all the servers involved using the security measures that you would choose for any MySQL instance in your ...In ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-monitoring.html
To check the current values of the status variables, use SHOW STATUS: mysql> SHOW STATUS LIKE 'Rpl_semi_sync%'; Beginning with MySQL 8.0.26, new versions of the source and replica plugins are supplied, which replace the terms “master” and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-switch.html
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 TO. In this way, the replica is ready to become a source without restarting the replica mysqld. Each MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/reset-slave.html
From MySQL 8.0.22, RESET SLAVE is deprecated and the alias RESET REPLICA should be used instead. RESET {SLAVE | REPLICA} [ALL] [channel_option] channel_option: FOR CHANNEL channel Makes the replica forget its position in the source's binary log.
https://dev.mysql.com/doc/refman/8.0/en/restart.html
One use for RESTART is when it is not possible or convenient to gain command-line access to the MySQL server on the server host to restart it. For example, SET PERSIST_ONLY can be used at runtime to make configuration changes to system variables ...
https://dev.mysql.com/doc/refman/8.0/en/role-names.html
MySQL role names refer to roles, which are named collections of privileges. It is possible for a row in the mysql.user system table to serve as both an account and a role. Role names have syntax and semantics similar to account names; see Section ...