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

Search Scope:

- This Document
- Entire Library

## How to Recover After a Takeover

1. Allow the MySQL slave threads to be started if the database resource performs a restart or similar action.

   Remove the `skip-slave-start` keyword from the appropriate `my.cnf` file.

2. Log in to MySQL as the `root` role, then start the slave.

       mysql> start slave;

3. Verify that the slave is running, and wait until it is synchronized with the master.

       mysql> show slave status\G

   If the slave status shows that at least one slave thread is not running, fix the root cause, and retry the operation. As a last resort, you could take a backup from the current master and perform a fresh slave setup.

   Connect to a node of the old primary cluster and update the protection group to change the role from a deactivated primary cluster to a secondary cluster.

4. Log in to a cluster node.

   You must be assigned the Geo Management RBAC rights profile to complete this procedure. For more information, see Geographic Edition Software and RBAC.

5. Resynchronize the protection group.

        # geopg update protection-group

6. Start the protection group locally.

       # geopg start -scope local protection-group

   For more information, see Resynchronizing a MySQL Protection Group and Activating and Deactivating a MySQL Protection Group.

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