Using console to create a Global Active Table

You can create a Global Active table from the NoSQL console.

See Global Active tables in NDCS to get an overview of what a Global Active table is and when you need to create a Global Active table.

To create a Global Active table:
  1. First, create a singleton table withat least one JSON column. Access the NoSQL console from the Infrastructure Console. See Accessing the Service from the Infrastructure Console . Click Create Table. You can create the table using one of the following:
  2. Freeze the schema of the table created. Under Table information, you can view the details of the table after it is created. The schema state of the table is currently Mutable. Click Freeze to freeze the schema of the table. The Schema state changes to Frozen.
  3. A NoSQL Database table becomes a Global Active table only after you add a regional table replica of it. The regional table replica is created in another region.
  4. In the Table Details page, click Replicas under Resources. You get a list of replicas of the table. Click Add replica.
  5. In the Add replica page, the list of regions is listed in the drop-down for the Replication region. Choose the region where you want to create a regional replica. Choose the read capacity and write capacity of the table in the replica region. Storage capacity cannot be changed and remains the same as in the sender region table. Click Add replica.

    Note:

    You can choose to have the same read capacity and write capacity of the sender region table in the replicas. In that case, the values need not be changed or edited.

The singleton table is now changed to a Global Active table. The regional table replica will be initialized with the data of the table in the sender region. Soon after the regional table replica is created and all data is copied to the regional table replica, you see that the Local replica initialized completeness becomes 100%.

Creating a child table:

A child table can be created for a Global Active table. See Using the console to create a child table for the steps to create a child table.

To create the child table as a Global Active table, follow the steps described above to create a Global Active table. In the Add replica page, the regions (regional replicas of the parent table) are listed in the drop-down for the Replication region. Choose the region where you want to create a regional replica for the child table. The child table is now changed to a Global Active table.

Related Topics