Search Results
https://dev.mysql.com/doc/refman/8.4/en/resource-group-statements.html
MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group. This section describes the SQL ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrade-with-mysqlbackup.html
As part of a provisioning approach you can use MySQL Enterprise Backup to copy and restore the data from a group member to new members. This process consists of: Take a backup from a member of the older group using mysqlbackup. Then join the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-compatibility-communication.html
A replication group uses a Group Replication communication protocol version that differs from the MySQL Server version of the members. To check the group's communication protocol version, issue the following statement on any member: SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-launching.html
It is first necessary to ensure that the Group Replication plugin is installed on server s1. If you used plugin_load_add='group_replication.so' in the option file then the Group Replication plugin is already installed, and you can proceed to the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade.html
When you have a group running which you want to upgrade but you need to keep the group online to serve your application, you need to consider your approach to the upgrade. This section describes the different elements involved in an online upgrade, ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-throttling.html
Based on the metrics gathered across all servers in the group, a throttling mechanism kicks in and decides whether to limit the rate a member is able to execute/commit new transactions. The lowest capacity of all the members in the group determines ...Therefore, metrics acquired from all members are the basis for calculating the capacity of each member: if a member has a large queue (for certification or the applier thread), then the capacity to execute new transactions should be close to ones certified or applied in the last ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-options.html
The next two sections contain information about MySQL server system and server status variables which are specific to the Group Replication plugin.
https://dev.mysql.com/doc/refman/8.4/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 an IP address allowlist.
https://dev.mysql.com/doc/refman/8.4/en/example-maximum-column-group-row.html
Task: For each article, find the dealer or dealers with the most expensive price. Other possibilities for solving the problem are to use an uncorrelated subquery in the FROM clause, a LEFT JOIN, or a common table expression with a window function.
https://dev.mysql.com/doc/refman/8.4/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 | +---------+-------+ .