ALTER MULTIPLEX SERVER Statement

Syntax

Syntax 1:

ALTER MULTIPLEX SERVER server-name server-option

Syntax 2:

ALTER MULTIPLEX SERVER server-name PRIVATE NULL

Parameters

• server-option –

  { RENAME new-server-name
   |  DATABASE  'dbfile' 
   |  ROLE { WRITER | READER | COORDINATOR }
   |  STATUS { INCLUDED |  EXCLUDED }
   |  ASSIGN AS FAILOVER SERVER
   |  host-port-list }

• host-port-list –

   { HOST  '  hostname '  PORT  port number ...}
   { PRIVATE HOST ' hostname ' PORT port number ...}

  Note: Shut down the target server before you exclude it. If you do not, an excluded server automatically shuts down and requires ALTER MULTIPLEX SERVER server-name STATUS INCLUDED and a synchronize to rejoin the multiplex.

Applies to

Examples

• Example – excludes secondary server mpx_writer1:

  ALTER MULTIPLEX SERVER mpx_writer1 STATUS EXCLUDED

Usage

Changes the multiplex server, as follows:

• RENAME – changes the name of the given server. The server automatically shuts down and the next restart requires the new name.

• DATABASE – changes the catalog file path for the given server. The server automatically shuts down and the next restart requires the new catalog path. The user must relocate the catalog file.

• ROLE – changes the role of the given server. Users cannot change the role of coordinator or role to coordinator. If the role of the writer node changes to reader, the server shuts down.

• STATUS – changes the status of the given server. A failover node cannot be excluded unless it is the last node to be excluded. The server automatically shuts down after exclusion. After including a node, you synchronize and restart it.

• ASSIGN – designates the given server as the new failover server. The node should not be in the excluded state. The ASSIGN AS FAILOVER clause is a standalone clause that cannot be used with any other ALTER MULTIPLEX SERVER clause.

  The coordinator must be running, but you can run the ALTER MULTIPLEX SERVER command from any server in the multiplex. (Run all DDL statements on the coordinator.) In all cases except when altering role from reader to writer, the named server is automatically shut down.

Permissions

Requires the MANAGE MULTIPLEX system privilege.