MySQL Fabric添加组报告用户(fabric)没有适当的权限，当用户有权限时

Question

组添加命令抛出错误

$ mysqlfabric group add group_id-1 127.0.0.1:70002
Fabric UUID:  5ca1ab1e-a007-feed-f00d-cab3fe13249e
Time-To-Live: 1

ServerError: User (fabric) does not have appropriate privileges (ALL PRIVILEGES) on server (127.0.0.1:70002, 33c14c02-4f 67-11e4-8df7-00ffb263a4ad).

为什么会发生这种情况？ Fabric 需要什么权限？

我在同一台机器上运行fabric和mysql服务器实例，状态存储使用localhost:70001 mysql实例。

用户fabric在MySQL实例上的权限localhost:70002

$ mysql -u root -P70002 -e "show grants for fabric"
+---------------------------------------------------------------+
| Grants for fabric@%                                           |
+---------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'fabric'@'%' WITH GRANT OPTION |
+---------------------------------------------------------------+
$ mysql -u root -P70002 -e "show grants for fabric@127.0.0.1"
+-----------------------------------------------------------------------+
| Grants for fabric@127.0.0.1                                           |
+-----------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'fabric'@'127.0.0.1' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `fabric`.* TO 'fabric'@'127.0.0.1'            |
+-----------------------------------------------------------------------+
$ mysql -u root -P70002 -e "show grants for fabric@localhost"
+-----------------------------------------------------------------------+
| Grants for fabric@localhost                                           |
+-----------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'fabric'@'localhost' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `fabric`.* TO 'fabric'@'localhost'            |
+-----------------------------------------------------------------------+

Answer 1

我将/etc/mysql/fabric.cfg 上的日志记录级别更改为 DEBUG

[logging]
level = DEBUG

从那里我可以看到我在端口 130001 上运行的从属 mysqld 没有在 gtid 打开和 log_bin 的情况下运行

我添加了这些参数并重新启动了从属实例。

[mysqld]
log_bin=/home/mysql/13001
gtid-mode=ON

然后我就可以将从属实例添加到结构组中。