PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-usage.html
When many rows are affected, the set of changes is split into several events; when the statement commits, all of these events are written to the binary log. MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format logging.
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-installation.html
Semisynchronous replication is implemented using plugins, so the plugins must be installed into the server to make them available. After a plugin has been installed, you control it by means of the system variables associated with it. These system ...
https://dev.mysql.com/doc/refman/5.7/en/replication-snapshot-method.html
Once the data dump has been completed, import this data into the replica before starting the replication process. If the database on the source contains existing data it is necessary to copy this data to each replica. There are different ways to ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-performance.html
This prevents “dumb” replicas from also logging events they have executed into their own binary log. As the number of replicas connecting to a source increases, the load, although minimal, also increases, as each replica uses a client ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-scaleout.html
Most websites fit into this category, where users are browsing the website, reading articles, posts, or viewing products. You can use replication as a scale-out solution; that is, where you want to split up the load of database queries across ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions.html
For guidance on switching sources, or converting replicas into sources as part of an emergency failover solution, see Section 16.3.7, “Switching Sources During Failover”. Replication can be used in many different environments for a range of ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads.html
A replica uses two threads to separate reading updates from the source and executing them into independent tasks. MySQL replication capabilities are implemented using three main threads, one on the source server and two on the replica: Binary log ...
https://dev.mysql.com/doc/refman/5.7/en/replication-upgrade.html
When you upgrade servers that participate in a replication topology, you need to take into account each server's role in the topology and look out for issues specific to replication. For general information and instructions for upgrading a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
These cause the output of cat to be substituted into the kill command. If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as root. For instructions on assigning a password, see Section ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin.html
The query_rewrite database contains a stored procedure named flush_rewrite_rules() that loads the contents of the rules table into the plugin. MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by the ...