Convert a partner server in a database mirroring system to a copy node in a read-only scale-out system without stopping the system.
You must have the MANAGE ANY MIRROR SERVER system privilege.
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.
Connect to the primary server.
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
(Optional) If you are dismantling the mirroring system, delete the arbiter server.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|