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:
- 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.
- 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.
- 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.
- DB Connection Object: It is a representation of a connection to Altibase DBMS.
Please refeter to "Understanding User Interface" for details.
- Replication Pairs Object: It is the root object of "Replication Pair" and
the entry point for "Replication Pairs" pane.
- 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
- Connect all: Connect all registered but not connected DB Connection
- Disconnect all: Disconnect all registerd and connected DB Connection
- Start all: Start all replication objects which are stopped.
- Stop all: Stop all replication objects which are started.
- Quick Start all: Quick Start all replication objects which are stopped. This operation may cause the loss of not yet delievered data.
Please refere to "Replication User's Manual" for details.
- New DB Connection: Create a new DB Connection.
DB Connection
- Connect: Connect to the database with the given properties.
- Disconnect: Disconnect from the connected database.
- Edit: Edit the properties of DB Connection
- Remove: Remove the selected DB Connection.
- Start all: Start all replication object which are stopped in the DB Connection.
- Stop all: Stop all replication objects which are started in the DB Connection.
- Quick Start all: Quick Start all replication objects which are stopped in the DB Connection. This operation may cause the loss of not yet delievered data.
Please refere to "Replication User's Manual" for details.
- Create Replication: Create a Replication Object at the DB Connection.
- Create Replication Pair: Create a pair of Replication Objects at two distinct DB Connections.
- Drop Replications: Drop all Replication Object at the DB Connection. All Replication Objects
should be stopped before using this function.
Replication Object
- Start: Start the selected Replication Object.
- Stop: Stop the selected Replication Object.
- Quick Start: Quick Start the selected Replication Object. This operation may cause the loss of not yet delievered data.
- Please refere to "Replication User's Manual" for details.
- Sync: Sync the selected Replication Object. It is equivalent to perform ALTER REPLICATION ... SYNC ... statement.
- Sync Only: Sync Only the selected Replication Object. It is equivalent to perform ALTER REPLICATION ... SYNC ONLY ... statement.
- Drop: Drop the selected Replication Object, which is stopped.
- Edit Table List: Add/Remove Replication Target Tables in the selected Replication Object, which is stopped.
- Monitor: Open a monitor dialog for the selected Replication Object and the corresponding Replication Object.
- Show DDL: Print the schema to generate the selected Replication Object and its related objects, such as table, index, and so on.
- Compare DDL: Print the difference of schema between the selected Replication Object and the corresponding Replication Object.
Replication Target Table
- Remove: Remove the selected table from its underlying Replication Object.
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
- Start all: Start all replication object which are stopped.
- Stop all: Stop all replication objects which are started.
- Quick Start all: Quick Start all replication objects which are stopped. This operation may cause the loss of not yet delievered data.
Please refere to "Replication User's Manual" for details.
- Create Replication Pair: Create a pair of Replication Objects at two distinct DB Connections.
Replication Pair
- Start all: Start all replication object which are stopped in the Replication Pair.
- Stop all: Stop all replication objects which are started in the Replication Pair.
- Quick Start all: Quick Start all replication objects which are stopped in the Replication Pair. This operation may cause the loss of not yet delievered data.
Please refere to "Replication User's Manual" for details.
- Drop: Drop Replication Objects in the selected Replication Pair. All Replication Objects
should be stopped before using this function.
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
- Connect: Connect to the database with the given properties.
- Disconnect: Disconnect from the connected database.
- Start all: Start all replication object which are stopped in the DB Connection.
- Stop all: Stop all replication objects which are started in the DB Connection.
- Quick Start all: Quick Start all replication objects which are stopped in the DB Connection. This operation may cause the loss of not yet delievered data.
Please refere to "Replication User's Manual" for details.
Replication Object
- Start: Start the selected Replication Object.
- Stop: Stop the selected Replication Object.
- Quick Start: Quick Start the selected Replication Object. This operation may cause the loss of not yet delievered data.
- Please refere to "Replication User's Manual" for details.
- Sync: Sync the selected Replication Object. It is equivalent to perform ALTER REPLICATION ... SYNC ... statement.
- Sync Only: Sync Only the selected Replication Object. It is equivalent to perform ALTER REPLICATION ... SYNC ONLY ... statement.
- Drop: Drop the selected Replication Object, which is stopped.
- Monitor: Open a monitor dialog for the selected Replication Object and the corresponding Replication Object.
- Show DDL: Print the schema to generate the selected Replication Object and its related objects, such as table, index, and so on.
- Compare DDL: Print the difference of schema between the selected Replication Object and the corresponding Replication Object.