Description:
Please update manual for MySQL2.1.
There is typo in Privileges needed by the Router account.
https://dev.mysql.com/doc/mysql-router/2.1/en/mysql-router-conf-options.html#option_mysqlr...
Privileges needed by the Router account:
On Metadata Server:
SELECT ON mysql_innodb_cluster_metadata.*
On Target Replica Sets:
SELECT ON performance_schema.replication_group_members
SELECT ON performance_schema.replication_group_member_status
How to repeat:
mysql> select * from performance_schema.replication_group_member_status;
ERROR 1146 (42S02): Table 'performance_schema.replication_group_member_status' doesn't exist
mysql> show tables from performance_schema like 'replication%';
+---------------------------------------------+
| Tables_in_performance_schema (replication%) |
+---------------------------------------------+
| replication_applier_configuration |
| replication_applier_status |
| replication_applier_status_by_coordinator |
| replication_applier_status_by_worker |
| replication_connection_configuration |
| replication_connection_status |
| replication_group_member_stats |
| replication_group_members |
+---------------------------------------------+
8 rows in set (0.00 sec)
mysql> select * from performance_schema.replication_group_member_stats\G
*************************** 1. row ***************************
CHANNEL_NAME: group_replication_applier
VIEW_ID: 14969818808079747:3
MEMBER_ID: 1c008db5-4cca-11e7-be2d-080027d65c57
COUNT_TRANSACTIONS_IN_QUEUE: 0
COUNT_TRANSACTIONS_CHECKED: 15
COUNT_CONFLICTS_DETECTED: 0
COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
TRANSACTIONS_COMMITTED_ALL_MEMBERS: 1c008db5-4cca-11e7-be2d-080027d65c57:1-11,
9dff371c-4cca-11e7-846c-080027d65c57:1-18
LAST_CONFLICT_FREE_TRANSACTION: 9dff371c-4cca-11e7-846c-080027d65c57:18
1 row in set (0.00 sec)
mysql>
Suggested fix:
Current:
SELECT ON performance_schema.replication_group_member_status
FIX:
SELECT ON performance_schema.replication_group_member_stats
