Configuring Database Instances
Use
You configure the database instances that you want to synchronize.
Prerequisites
● You use MaxDB software version 7.6 or higher.
● You have created the database instance that will assume the role of master instance. See
○ Database Manager GUI, Creating a Database Instance
○ Database Manager CLI, db_create
● You have created the database instances that will assume the role of client instances.
● You have created the synchronization user in all the database instances.
See Database Manager GUI, Creating/Changing/Deleting a Synchronization User
● You have designed a data model.
See Data Model.
All tables to be synchronized must have a primary key. You may not execute UPDATES for data in the primary key columns in tables that are participating in the synchronization.
Procedure
...
1. In the master instance, define the master tables, database users, and so on in accordance with your data model.
See
SQL Reference
Manual,
Data
Definition
SQL
Tutorial,
Data
Definition
2. Insert the data into the master table.
See
SQL Reference
Manual,
Data
Manipulation
SQL
Tutorial,
Data
Manipulation
Loader, Importing: Commands
3. In the client instances, define the client tables, database users, and so on in accordance with your data model.
Do not fill the client tables with data. Before you start the synchronization, initialize the client tables; the Synchronization Manager then copies all necessary data from the master tables to the client tables.
4.
The synchronization
user must be able to access all tables involved in the synchronization. Thus
the database users who created the tables have to grant the synchronization
user all privileges for these tables using the GRANT statement. See the
Reference
Manual,
GRANT statement
(grant_statement)
See also: