How to Remove Replication Between Servers With Command REVOKE in a Failover Setup

Asset ID:	1-71-2143187.1
Update Date:	2018-03-09
Keywords:

Solution Type Technical Instruction Sure

Solution 2143187.1 : How to Remove Replication Between Servers With Command REVOKE in a Failover Setup

Applies to:

Oracle Communications EAGLE (Software) - Version E5-MS 45.0 to E5-MS 46.2 [Release E5-MS 45.0 to E5-MS 46.0]
Tekelec

Goal

Cannot remove replication between the servers with the command REVOKE:

Reference to procedure 17 in the Install/Upgrade Guide:

R46.2 - E69119 Revision 5
F.2 In case of Upgrade - Procedure 17
REVOKE REPLICATION SLAVE ON *.* FROM '<primary replication user>'@'%';

Solution

Referring to document Install/Upgrade Guide - Release 46.2 - E69119 Revision 5
Procedure F2 Page 80 Step 16 to 18:
The commands are intended to be like this.
Step 17 is not intended to revoke replication for primary replication user at secondary host, but for other hosts defined by % sign. If this step gives error; that is normal. You should continue with the procedure.

REVOKE REPLICATION SLAVE ON *.* FROM ''@'%';

When the same command is run on the customer server, if no such entry is found where username and hostname matched the query; the error string is displayed. It is not an error, It is just an output that the query did not find anything

mysql> REVOKE REPLICATION SLAVE ON *.* FROM 'repl1'@'%';

ERROR 1141 (42000): There is no such grant defined for user 'repl1' on host '%'

In the latest documentation; the command has been changed:

R46.2 - E69119 Revision 6 - F.2 In case of Upgrade - Procedure 17

REVOKE REPLICATION SLAVE ON *.* FROM '<primary replication user>'@'<standby server hostname>';

Going forward; replication user revoke process will be changed to further improve the replication user entries in a failover setup.

The Bug is: Bug 23266331

The bug will ask to do following at step-15:
It will list down who all have Repl_slave_priv set to Y.
Then it will revoke that privilege for all, one by one (which was intended in Step 17)
Then grant the Repl_slave_priv previlege to the actual replication user and hostname.

References

<BUG:23266331> - SR: REVOKE UNUSED REPLICATION PRIVILEGES DURING UPGRADE PROCEDURE

Attachments

This solution has no attachment