- Replication objects are created with the CREATE REPLICATION statement and define information related to replication such as replication mode, replication server information, and replication target table.
- Two servers to be replicated are paired.
Replication objects must each be created with the same object name on the paired replication server.
Code Block title For creating replicaiton object theme DJango language sql
CREATE REPLICATION replication_name -- Define the name of the replication object. WITH remote_host_ip, remote_replication_port_no -- In the WITH clause, specify the IP and PORT of the remote server to be paired with. FROM user_name.table_name TO user_name.table_name, -- List the tables to be duplicated in the FROM ~ TO clause. FROM ... ;
- Refer to Replication Manual -> 3. Using Replication -> Create Replication (CREATE REPLICATION) for additional options of the replication object creation syntax.
- Manual page: http://support.altibase.com/en/manual
This is an example of creating a replication object when the conditions for creating a replication object are as follows.