Skip Navigation Links
Exit Print View
| Oracle Solaris Cluster Geographic Edition System Administration Guide

Search Scope:

- This Document
- Entire Library

## How to Delete a Data-Replicated Component From a MySQL Protection Group

You might need to delete a data-replicated component from a protection group if you previously added a data-replicated component to that protection group. Normally, after an application is configured to connect to the database, you would not change the database.

Before You Begin

Before you delete a data-replicated component, ensure that the following conditions are met:

- The protection group is defined on the local cluster.

- The protection group is offline on the local cluster and the partner cluster, if the partner cluster can be reached.

- The device group is managed by the protection group.

For information about deleting protection groups, refer to How to Delete a MySQL Protection Group.

1. Become superuser or assume a role that is assigned the Geo Management RBAC rights profile.

   For more information about RBAC, see Geographic Edition Software and RBAC.

   Note - If you use a role with Geo Management RBAC rights, ensure that the `/var/cluster/geo` ACLs are correct on each node of both partner clusters. If necessary, become superuser on the cluster node and set the correct ACLs.

       # chmod A+user:username:rwx:allow /var/cluster/geo

   The `/var/cluster/geo` directory must have the correct access control lists (ACL) applied for compatibility between the Geo Management RBAC rights profile and Oracle Data Guard.

2. Remove the replicated component.

       # geopg remove-replication-component MySQL-replicated-component protection-group

   In this syntax, `MySQL-replicated-component` specifies the name of the data-replicated component, and `protection-group` specifies the name of the protection group.

Example F-6 Deleting a Replicated Component From a MySQL Protection Group

In the following example, a data-replicated device group is deleted from a `MySQLprotection` group:

    # geopg remove-replication-component mysql-dg mysql-pg

Copyright © 2004, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices |