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

 

Converting a partner server to a copy node

Convert a partner server in a database mirroring system to a copy node in a read-only scale-out system without stopping the system.

Prerequisites

You must have the MANAGE ANY MIRROR SERVER system privilege.

 Task

  1. Connect to the partner server that you want to convert and ensure that it has the mirror role. You can only convert the partner with the mirror role. If the server you want to convert to a copy node is the primary server, you must initiate a failover so that the primary and mirror servers switch roles.

  2. Connect to the primary server.

  3. Change the mirror definitions:

    • Update the mirror definition of type PRIMARY to remove the connection information of the partner that is being converted.

    • Delete the mirror definition of type MIRROR.

    • Change the partner definition for the server being converted to a copy node.

    For example, execute the following statements:

    ALTER MIRROR SERVER mirror_demo_primary
connection_string='SERVER=mirror_demo_primary;HOST=localhost:6871';
  
DROP MIRROR SERVER mirror_demo_mirror; 
 
ALTER MIRROR SERVER mirror_server2 AS COPY FROM SERVER PRIMARY;

    Both the root server and the converted partner server restart the database as part of changing these configurations, but the server itself remains running. During the restart of the database, connections to the database are dropped

  4. (Optional) If you are dismantling the mirroring system, delete the arbiter server.

Results

The partner server is now a read-only scale-out copy node.

Next

Verify that the partner has been converted to a copy node by viewing the contents of the SYSMIRRORSERVER system view.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0