Investigated further today, and comparing successful and failed deployments, I see the following differences on the 4th unit:
mysql-py []> \sql SHOW GLOBAL VARIABLES LIKE '%replication%'
the above command shows very diffirent results from both deployments, then:
mysql-py []> \sql START GROUP_REPLICATION
ERROR: 3093: The START GROUP_REPLICATION command failed since the group is already running.
on the successful deployment ^.
mysql-py []> \sql START GROUP_REPLICATION
ERROR: 3092: The server is not configured properly to be an active member of the group. Please see more details on error log.
on the failed deployment ^. Looking at the logs:
[ERROR] [MY-010381] [Repl] Group Replication plugin is not installed.
mysql-py []> \sql SHOW PLUGINS
group_replication | ACTIVE | GROUP REPLICATION | group_replication.so | GPL
the line ^ is present on the successful deployment but not on the failed one
Looking at juju logs with TRACE debug level I don't see any difference in output grepping -i for the word "group".
Another interesting fact is that when the 4th unit is being added it automatically becomes a coordinator, invoking the coordinator layer and relation [1]
Investigated further today, and comparing successful and failed deployments, I see the following differences on the 4th unit:
mysql-py []> \sql SHOW GLOBAL VARIABLES LIKE '%replication%'
the above command shows very diffirent results from both deployments, then:
mysql-py []> \sql START GROUP_REPLICATION
ERROR: 3093: The START GROUP_REPLICATION command failed since the group is already running.
on the successful deployment ^.
mysql-py []> \sql START GROUP_REPLICATION
ERROR: 3092: The server is not configured properly to be an active member of the group. Please see more details on error log.
on the failed deployment ^. Looking at the logs:
[ERROR] [MY-010381] [Repl] Group Replication plugin is not installed.
mysql-py []> \sql SHOW PLUGINS
group_replication | ACTIVE | GROUP REPLICATION | group_replicati on.so | GPL
the line ^ is present on the successful deployment but not on the failed one
Looking at juju logs with TRACE debug level I don't see any difference in output grepping -i for the word "group".
Another interesting fact is that when the 4th unit is being added it automatically becomes a coordinator, invoking the coordinator layer and relation [1]
[1] https:/ /github. com/juju/ layer-index/ blob/master/ layers/ coordinator. json