PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-rbr-usage.html
MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format logging. The type of binary log used impacts the size and efficiency of logging. Therefore the choice between row-based replication (RBR) or statement-based ...
https://dev.mysql.com/doc/refman/9.7/en/replication-semisync.html
In addition to the built-in asynchronous replication, MySQL 9.7 supports an interface to semisynchronous replication that is implemented by plugins. This section discusses what semisynchronous replication is and how it works. The following sections ...
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 6.5.4, “mysqldump — A Database Backup Program”). You should not ...
https://dev.mysql.com/doc/refman/9.7/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. For example, you may want to distribute different sales data to different departments to help spread the load during data ...
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-performance.html
As the number of replicas connecting to a source increases, the load, although minimal, also increases, as each replica uses a client connection to the source. Also, as each replica must receive a full copy of the source's binary log, the network ...
https://dev.mysql.com/doc/refman/9.7/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/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. This ...
https://dev.mysql.com/doc/refman/9.7/en/reset-binary-logs-and-gtids.html
RESET BINARY LOGS AND GTIDS [TO binary_log_file_index_number] Warning Use this statement with caution to ensure you do not lose any wanted binary log file data and GTID execution history. For a server where binary logging is enabled (log_bin is ...
https://dev.mysql.com/doc/refman/9.7/en/reset-replica.html
RESET REPLICA [ALL] [channel_option] channel_option: FOR CHANNEL channel RESET REPLICA makes the replica forget its position in the source's binary log. This statement is meant to be used for a clean start; it clears the replication metadata ...
https://dev.mysql.com/doc/refman/9.7/en/revoke.html
[IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], GRANT OPTION FROM user_or_role [, user_or_role] ... [IGNORE UNKNOWN USER] REVOKE [IF EXISTS] PROXY ON user_or_role FROM user_or_role [, user_or_role] ... [IGNORE UNKNOWN USER] REVOKE [IF ...