JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Oracle Solaris Cluster Geographic Edition System Administration Guide
search filter icon
search icon

Document Information

Preface

1.  Introduction to Administering the Geographic Edition Software

2.  Before You Begin

3.  Administering the Geographic Edition Infrastructure

4.  Administering Access and Security

5.  Administering Cluster Partnerships

6.  Administering Heartbeats

7.  Administering Protection Groups

8.  Monitoring and Validating the Geographic Edition Software

9.  Customizing Switchover and Takeover Actions

10.  Script-Based Plug-Ins

A.  Standard Geographic Edition Properties

B.  Legal Names and Values of Geographic Edition Entities

C.  Disaster Recovery Administration Example

D.  Takeover Postconditions

E.  Troubleshooting Geographic Edition Software

F.  Deployment Example: Replicating Data With MySQL

Overview of MySQL Replication

MySQL Database Resource Group

MySQL Replication Resource Group

MySQL Application Resource Group

Initial Configuration of MySQL Replication

Installing MySQL and Configuring the MySQL Database Resource Group

How to Configure the MySQL Replication

Configuring the MySQL Application Resource Group

Administering MySQL Protection Groups

Planning for Your MySQL Protection Group

Creating, Modifying, Validating, and Deleting a MySQL Protection Group

How to Create the MySQL Configuration

Modifying a MySQL Protection Group

Validating a MySQL Protection Group

Data Replication Layer Process for Validating the Application Resource Groups and Data Replication Entities

How to Delete a MySQL Protection Group

Administering MySQL Application Resource Groups

How to Add an Application Resource Group to a MySQL Protection Group

How to Delete an Application Resource Group From a MySQL Protection Group

Administering MySQL Data-Replicated Components

How to Add a Data-Replicated Component to a MySQL Protection Group

Data Replication Subsystem Process for Verifying the Replicated Component

How to Modify a MySQL Data-Replicated Component

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

Replicating a MySQL Protection Group Configuration to a Partner Cluster

Activating and Deactivating a MySQL Protection Group

Activating a MySQL Protection Group

Deactivating a MySQL Protection Group

Resynchronizing a MySQL Protection Group

Recovery Strategy After a Takeover of a MySQL Protection Group

How to Recover After a Takeover

G.  Error Return Codes for Script-Based Plug-Ins

Index

How to Delete a MySQL Protection Group

Perform this procedure from a node on the cluster where you want to delete the protection group, for example, cluster-nyc. The cluster-nyc cluster is the primary cluster. For a sample cluster configuration, see Example Geographic Edition Cluster Configuration.

To delete a protection group on all clusters, run the geopg delete command on each cluster where the protection group exists.

Before You Begin

Before deleting a protection group, ensure that the following conditions are met:


Note - To keep the application resource groups online while deleting a protection group, you must remove the application resource groups from the 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. Delete the protection group.

    The following command deletes the configuration of the protection group from the local cluster. The command also removes the replication resource group for each device group in the protection group.

     # geopg delete protection-group

    In this syntax, protection-group specifies the name of the protection group.

    If the deletion is unsuccessful, the configuration status is set to Error. Fix the cause of the error, and rerun the geopg delete command.

Example F-2 Deleting a Protection Group

In the following example, a protection group is deleted from both partner clusters:

 # rlogin cluster-nyc -l root
cluster-nyc# geopg delete mysql-pg

 # rlogin cluster-sfo -l root
cluster-sfo# geopg delete mysql-pg

Example F-3 Deleting a Protection Group While Keeping Application Resource Groups Online

In the following example, two application resource groups (apprg1 and apprg2) are kept online while the protection group that they share, mysql-pg, is deleted. First, the application resource groups are removed from the protection group. Then, the protection group is deleted.

 # geopg remove-resource-group apprg1,apprg2 mysql-pg
 # geopg stop -e global mysql-pg
 # geopg delete mysql-pg