It's been a while since I've messed with this, but I'm pretty sure you can just run the add_slave_user.sh and create_slave.sh scripts to reset the values.
------------------------------
Jay MacDonald - Adoption Architect - Broadcom API Management (Layer 7)
------------------------------
Original Message:
Sent: 08-13-2020 07:11 AM
From: Sumeet Basu
Subject: Update MySQL Gateway Replication Database Process
If I start from scratch say from these scripts add_slave_user.sh and create_slave.sh then will it override first replication configuration ? host names are incorrect in both gatway configurations and we also don't know what else is missed.
Original Message:
Sent: 08-13-2020 06:57 AM
From: Ronald Dsouza
Subject: Update MySQL Gateway Replication Database Process
Best option is to use the Restart Replication option with the Secondary Node fails in the Techdocs.
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-api-management/api-gateway/9-4/install-configure-upgrade/configure-a-gateway-cluster/configuring-cluster-database-replication/restart-replication.html
You will have to provide the correct details there when you are running the sh for create slave user
------------------------------
Pre-Sales Consultant
CA Southern Africa
Original Message:
Sent: 08-13-2020 03:33 AM
From: Sumeet Basu
Subject: Update MySQL Gateway Replication Database Process
We have a gateway setup with 2 instances in a cluster say GW1 and GW2 are the gateways.
We have 2 MySQL gateway databases namely SSG1 and SSG2. We already setup a cluster and database replication. However the hostname we mentioned during slave permission and replication configuration are incorrect. How can I modify the correct hostname? Or else can I re-initiate add slave and database replication process so that it will override my existing configuration