Working with Replication

This section is intended to describe the detail usage of Replication Manager. It also describes the relationship between panes and objects.

Replication Manager takes care of a single base model, which simulates databases and replication-related objects, while providing a various ways of visualizing and manipulating the model through three editable panes. The model is consists of six types of objects as follows:

  1. Replication Object: It is an object created with the CREATE REPLICATION statement and the common object among panes at Replication Manager. Please refeter to "Understanding User Interface" for details.
  2. Replication Target Table Object: This is a table that is designated, using the CREATE REPLICATION or ALTER REPLICATION statement, to be replicated between corresponding replication nodes.
  3. DB Connections Object: It is the root object of "DB Connection" object to manage DB Connection. Also, it is the entry point for "DB Connections" pane.
  4. DB Connection Object: It is a representation of a connection to Altibase DBMS. Please refeter to "Understanding User Interface" for details.
  5. Replication Pairs Object: It is the root object of "Replication Pair" and the entry point for "Replication Pairs" pane.
  6. Replication Pair Object: It is a pair of corresponding replication objects having the same name, one residing on each of two different nodes. Please refeter to "Understanding User Interface" for details.

Some objects in the model are show up few panes for the ease use of Replication Manager.

Even though some objects shared by panes are the same ones, they may provide different functionalities according to the pane. For instance, Replication Object at DB Connections pane provides "Edit Table List" function, but Replication Object at Map pane doesn't. The reason of different functionalities on the same object according to the panes is to align functionalities to its context. At the previous example, editing replication target table list is quite intuitive at the database-centric view, DB Connections pane. On the while, the Map pane, which is intended to give brief overview, is not the right place to edit replication target table list. The following table summarizes user operations according to the object type(Y-axis) and accessible pane(X-axis).

¡¡ Object Operation Pane
DB Connections Replication Pairs Map
1 "DB Connections"
Object
Connect all O X X
2 Disconnect all O X X
3 Start all O X X
4 Stop all O X X
5 Quick Start all O X X
6 New DB Connection O X X
7 "DB Connection"
Object
Connect O X O
8 Disconnect O X O
9 Edit O X X
10 Remove O X X
11 Start all O X O
12 Stop all O X O
13 Quick Start all O X O
14 Create Replication O X X
15 Create Replication Pair O X X
16 Drop Replications O X X
17 "Replication"
Object
Start O O O
18 Stop O O O
19 Quick Start O O O
20 Sync O O O
21 Sync Only O O O
22 Drop O O O
23 Edit Table List O O X
24 Monitor O O O
25 Show DDL  O O O
26 Compare DDL  O O O
27 "Replication Target Table"
Object
Remove O O X
28 "Replication Pairs"
Object
Start all X O X
29 Stop all X O X
30 Quick Start X O X
31 Create Replication Pair O O X
32 "Replication Pair"
Object
Start all X O X
33 Stop all X O X
34 Quick Start X O X
35 Drop X O X
Table. Replication Manager Operations Summary

The rest part of this section discusses the detail functionalities of objects at each pane.

DB Connections pane

DB Connections pane is a database-centric view that represents the relationship between databases and replication objects in a tree structure. Therefore, it handles four types of objects: DB Connections, DB Connection, Replication Object, and Replication Target Tables.

DB Connections
DB Connection
Replication Object
Replication Target Table

Replication Pair pane

Replication Pair pane is a logical view to depicts replication objects in pairs. So, it takes care of four types of objects: Replication Pairs, Replication Pair, Replication Object, and Replication Target Table.

Replication Pairs
Replication Pair
Replication Object

The same at DB Connections pane.

Replication Target Table

The same at DB Connections pane.

Map pane

Map pane illustrates the physical layout and status of databases, replication objects, and the relationships therebetween. So, it carries only two types of objects: DB Connection and Replication Object.

DB Connection
Replication Object