Cluster failover

Help
1

I have two machines:
host-a running master aggregator and 2 leaves
host-b running child aggregator and 2 leaves

I killed host-a and then made the child aggregator on host-b master.
The clients tried reconnecting but kept on getting ‘permission denied’. Somehow none of the privileges present on the master aggregator were available on the child aggregator. I had to manually recreate the grants,

How do we ensure the privileges are available on both aggregators?

2

Hi,

You can enable sync_permissions. This will keep the permissions synchronized between all aggregators.

Note that enabling it requires removing all grants that currently exist on the cluster (its best to enable on a fresh cluster).