I am standing up new Virtual Appliance gateways under Version 10.0.
I have networking all setup but I am having issues with the Database Replication scripts for the MySQL 8 DB. I have a 2 node cluster that I am setting up.
Primary node:
- I ran Create new Database using the 'localhost' value
Secondary Node:
- I ran Configure database option pointing to primary node
Primary node / Secondary node:
- ran the add_slave_user.sh on both. No apparent issues.
- ran the create_slave on primary. No apparent issues.
- running create_slave.sh on secondary. getting errors. (see below)
Warning: A partial dump from a server that has GTIDs will by default include the GTIDs of all transactions, even those that changed suppressed parts of the database. If you don't want to restore GTIDs, pass --set-gtid-purged=OFF. To make a complete dump, pass --all-databases --triggers --routines --events.
ERROR 3546 (HY000) at line 24: @@GLOBAL.GTID_PURGED cannot be changed: the added gtid set must not overlap with @@GLOBAL.GTID_EXECUTED
mysqldump: Got errno 32 on write
I have tried to change the script to pass the --set-gtid-purged=OFF which allows the SSG database and tables to be created but then I get the following error when slave starts up.
Error 'There is no such grant defined for user 'gateway' on host '%'' on query. Default database: 'mysql'. Query: 'revoke all privileges on ssg.* from gateway@'%''
Am I missing something new with version 10 / MySQL 8 that needs to be configured to get replication up and running?