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-options-reference.html
The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary log. Replication Options and Variables The command-line options and system variables in the ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-source.html
This section describes the server options and system variables that you can use on replication source servers. You can specify the options either on the command line or in an option file. On the source and each replica, you must set the server_id ...
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 ...