How to set up table replicas?
This tutorial explains to users how to set up various types of Asynchronous Table Replication (ATR) in SAP HANA. It explains with details each and every command needed to replicate various types of tables.
Asynchronous Table Replication (ATR)
Below are the commands which are used implement table replicas:
| Replication type | Command | Details |
| ATR, OSTR | CREATE ... TABLE ... [A]SYNCHRONOUS REPLICA AT '<host>:<port>' | Creation of a table with an (a)synchronous replica on node <host> and port <port> |
| ATR, OSTR | ALTER TABLE ... ADD [A]SYNCHRONOUS REPLICA AT '<host>:<port>' | Adding an (a)synchronous replica to an existing table on node <host> and port <port> |
| ATR, OSTR | ALTER TABLE ... ENABLE [A]SYNCHRONOUS REPLICA | Activation of (a)synchronous table replication for a specific table |
| ATR, OSTR | ALTER TABLE ... DISABLE [A]SYNCHRONOUS REPLICA | Deactivation of (a)synchronous table replication for a specific table |
| ATR, OSTR | ALTER SYSTEM DISABLE ALL [A]SYNCHRONOUS TABLE REPLICAS | Global deactivation of (a)synchronous table replication |
| ATR, OSTR | ALTER TABLE ... DROP REPLICA AT ALL LOCATIONS | Drop of all replicas for a specific table |
| ATR, OSTR | ALTER TABLE ... DROP REPLICA AT '<host>:<port>' | Drop replica at node <host> and port <port> for a specific table |
| ATR, OSTR | ALTER SYSTEM ENABLE ALL [A]SYNCHRONOUS TABLE REPLICAS | Global activation of (a)synchronous table replication ATR:
OSTR: Activated per default
|