PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-usage-advice-and-limitations-of-distributed-recovery.html
It is based on classic asynchronous replication and as such it may be slow if the server joining the group is not provisioned at all or is provisioned with a very old backup image. As such, the recommendation is that before adding a server to the ...
https://dev.mysql.com/doc/refman/5.7/en/start-group-replication.html
If super_read_only=ON and the member should join as a primary, super_read_only is set to OFF once Group Replication successfully starts. A server that participates in a group in single-primary mode should use skip_replica_start=ON. Otherwise, the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-primary-secondary-replication.html
Traditional MySQL Replication provides a simple Primary-Secondary approach to replication. There is a primary (source) and there are one or more secondaries (replicas). The primary executes transactions, commits them and then they are later (thus ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-replication-technologies.html
Before getting into the details of MySQL Group Replication, this section introduces some background concepts and an overview of how things work. This provides some context to help understand what is required for Group Replication and what the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-multi-primary-mode.html
Figure 17.6 Client Failover All servers are set to read-write mode when joining the group. In multi-primary mode, there is no notion of a single primary. There is no need to engage an election procedure because there is no server playing any ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements-and-limitations.html
This section lists and explains the requirements and limitations of Group Replication.
https://dev.mysql.com/doc/refman/5.7/en/group-replication-find-primary.html
The following example shows how to find out which server is currently the primary when deployed in single-primary mode.
https://dev.mysql.com/doc/refman/5.7/en/proxy-users.html
The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking purposes. This enables the external user to be a proxy for the second user; that is, to assume the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
For example, the following query retrieves index sizes for partitions of table t1: mysql> SELECT SUM(stat_value) pages, index_name, SUM(stat_value)*@@innodb_page_size size FROM mysql.innodb_index_stats WHERE table_name like 't1#P%' AND stat_name = ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...