Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » High availability and read-only scale-out systems » SQL Anywhere read-only scale-out » Maintaining a read-only scale-out system

 

Dropping copy nodes from a read-only scale-out system

Remove a copy node database from a read-only scale-out system by deleting the mirror server definitions for the copy node.

Prerequisites

You must have the MANAGE ANY MIRROR SERVER system privilege.

 Task
  1. Connect to the primary (root) server.

  2. If the copy node to be deleted has any child copy nodes, then execute an ALTER MIRROR SERVER statement to re-assign any child copy nodes to a different parent.

    ALTER MIRROR SERVER "child-copy-server-name"
     FROM SERVER "new-parent-name";
  3. Execute a DROP MIRROR SERVER statement to drop the mirror server definitions from the copy node to be deleted.

    DROP MIRROR SERVER "copy-server-name"
      

    The mirror database stops. If the mirror database is the only database running on the server, then the server also stops.

Results

The copy node is removed from the read-only scale-out system.

Next

Delete the database files.

 See also