Synchronizing secondary servers

The process that updates a secondary server with respect to the coordinator is called synchronization.

Synchronizing copies the coordinator's version of the database catalog to a single secondary server. The multiplex automatically makes committed changes, including global schema changes, changes to data in IQ tables visible on all servers in the multiplex. In general, Sybase IQ propagates DDL and DML changes to secondary servers, so you only need to synchronize a secondary server for these server management actions:

StepsSynchronizing individual secondary servers (Sybase Central)

  1. Make sure that the coordinator is running, and connect to it with Sybase Central.

  2. To synchronize a secondary server, right-click that server and choose Control > Synchronize. You can keep running queries on the other servers.

    Sybase Central stops the secondary server that you right-clicked, replaces its catalog store, then restarts the server. The coordinator continues running throughout the operation.

StepsSynchronizing multiple servers (Sybase Central)

To synchronize multiple servers:

  1. Right-click the Multiplex folder to launch the synchronization wizard.

  2. Select Control > Synchronize context menu item.

  3. In the wizard page, select the servers to synchronize.

StepsSynchronizing servers (command line)

Perform the following steps on the computer where the secondary server runs.

NoteIf you checked “Generate Admin Scripts” when creating the multiplex server in Sybase Central, you can run the sync_server script instead of dbbackup.

  1. Remove the .LOG transaction log file in the secondary server directory.

  2. Back up the catalog store to the directory where the secondary server runs:

    dbbackup -y -d -c "uid=dba;pwd=sql;links=tcpip{port=2763};eng=mpxnode_c" /host1/mpx/
    
  3. Set the log file path:

    dblog -r -t mpxtest.log mpxtest.db
    
  4. Start the secondary node using the start_iq command.

  5. Repeat the previous steps for each secondary server in the multiplex.