Overview

This document describes how to add or delete replication target tables in the replication object.

Version

Altibase version 4.3.9 or later

Adding replication target table

• This is the procedure for adding tables to be replicated in the replication object.

1. Stop the replication
   Execute in the server where the replication sending thread is running.
   With the statement below, the replication sender of the local server and the receive thread of the remote server are stopped.

2. Add the replication target table

3. SYNC the replication
   If the data on both servers do not match, TRUNCATE one server table and then perform a SYNC statement on the server where the data exists to match the data.
   If the data matches on both servers 4, start the replication.

4. Start the replication
   If the data on both servers match each other, execute the replication start statement.

Deleting replication target table

• This is the procedure for deleting tables to be replicated in the replication object.

1. Stop the replication
   Execute in the server where the replication sending thread is running.
   With the statement below, the replication sender of the local server and the receive thread of the remote server are stopped.

   
   

2. Delete the replication target table

   This is the statement for deleting the replication target table in the replication object in each of the replication target servers.

3. Start the replication

Reference documents

• For syntax explanation and additional options of the ALTER REPLICATION statement, refer to SQL Reference Manual -> 3. Data Definition Language -> ALTER REPLICATION.
• Manual download page: http://support.altibase.com/en/manual
• Github: https://github.com/ALTIBASE/Documents/tree/master/Manuals/