Adding multiplex servers

The coordinator must be running in order to add secondary servers. See “Checking server status”.

StepsAdding multiplex servers (Sybase Central)

  1. Right-click the server name in the Multiplexes folder.

  2. Choose Add Server from the popup.

  3. Follow the instructions in the Create Server Wizard.

StepsAdding multiplex servers (Interactive SQL)

  1. In Interactive SQL, run the CREATE MULTIPLEX SERVER command, for example:

    CREATE MULTIPLEX SERVER mpxnode_w2 DATABASE 'host1/mpx/mpxtest.db' HOST 'host1' PORT 2957 ROLE WRITER STATUS INCLUDED
    

    For command reference details, see “CREATE MULTIPLEX SERVER statement”.

    This command creates the definition for a secondary writer server mpxnode_w2.

  2. Follow steps 7 through 10 in “Converting databases to multiplex (Interactive SQL)”.