PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/example-maximum-column-group.html
SELECT article, MAX(price) AS price FROM shop GROUP BY article ORDER BY article; +---------+-------+ | article | price | +---------+-------+ | 0001 | 3.99 | | 0002 | 10.99 | | 0003 | 1.69 | | 0004 | 19.95 | +---------+-------+ .
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-locally.html
The most common way to deploy Group Replication is using multiple server instances, to provide high availability. It is also possible to deploy Group Replication locally, for example for testing purposes. Important Group Replication is usually ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-monitoring.html
You can use the MySQL Performance Schema to monitor Group Replication. These Performance Schema tables display information specific to Group Replication: replication_group_member_stats: See Section 17.4.3, “The replication_group_member_stats ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-replication-group-member-stats.html
Each member in a replication group certifies and applies transactions received by the group. The performance_schema.replication_group_member_stats table provides group-level information related to the certification process, and also statistics for ...Statistics regarding the certifier and applier procedures are useful to understand how the applier queue is growing, how many conflicts have been found, how many transactions were checked, which transactions are committed everywhere, and so ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. The bootstrap should only be done by a single server, the one that starts the group and only once. This is why the value of the group_replication_bootstrap_group option was ...The same reasoning applies to stopping and restarting the plugin with this option set to ...
https://dev.mysql.com/doc/refman/5.7/en/alter-logfile-group.html
ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement adds an UNDO file named 'file_name' to an existing log file group logfile_group. An ALTER LOGFILE GROUP statement has ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-instances.html
The Group Replication plugin is provided with MySQL Server 5.7.17 and later; no additional software is required, although the plugin must be installed in the running MySQL server. See Section 17.2.1.1, “Deploying Instances for Group ... The first ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-security.html
This section explains how to secure a group, securing the connections between members of a group, or by establishing a security perimeter using IP address allowlisting.
https://dev.mysql.com/doc/refman/5.7/en/drop-logfile-group.html
DROP LOGFILE GROUP logfile_group ENGINE [=] engine_name This statement drops the log file group named logfile_group. The log file group must already exist or an error results. (For information on creating log file groups, see Section 13.1.15, ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-in-single-primary-mode.html
Each of the MySQL server instances in a group can run on an independent physical host machine, which is the recommended way to deploy Group Replication. This section explains how to create a replication group with three MySQL Server instances, each ...