Download Replication Users` Manual - ALTIBASE Customer Support

Contents
Preface ............................................................................................................................................................................. i
About This Manual ....................................................................................................................................................................................ii
Target Users..................................................................................................................................................................................ii
Software environment..............................................................................................................................................................ii
Organization.................................................................................................................................................................................ii
Documentation Conventions ................................................................................................................................................ii
Related Documents ...................................................................................................................................................................v
Online Manual .............................................................................................................................................................................v
Altibase Welcomes Your Opinions.......................................................................................................................................v
1. Replication Overview.................................................................................................................................................1
Introduction ................................................................................................................................................................................................2
Concepts........................................................................................................................................................................................2
Terminology .................................................................................................................................................................................2
How to Perform Replication in Altibase .............................................................................................................................3
Choosing a Replication Server...............................................................................................................................................5
Choosing Replication Targets................................................................................................................................................5
Replication Mode .......................................................................................................................................................................5
Replication of Partitioned Tables..........................................................................................................................................5
Data Recovery Using Replication..........................................................................................................................................6
2. Managing Replication...............................................................................................................................................7
Replication Procedures............................................................................................................................................................................8
Troubleshooting .......................................................................................................................................................................................9
Abnormal shutdown of the local server.............................................................................................................................9
Interruption of communication between the local and remote servers............................................................. 10
Network Failure........................................................................................................................................................................ 11
Confilict Resolution................................................................................................................................................................................ 12
User-Oriented Scheme .......................................................................................................................................................... 12
Master-Slave Scheme............................................................................................................................................................. 13
Timestamp-Based Scheme................................................................................................................................................... 15
3. Deploying Replication ............................................................................................................................................17
Considerations......................................................................................................................................................................................... 18
Prerequisites.............................................................................................................................................................................. 18
Data Requirements ................................................................................................................................................................. 18
Connection Requirements ................................................................................................................................................... 18
Replication Target Column Constraints .......................................................................................................................... 18
Partitioned Table Constraints ............................................................................................................................................. 19
Restrictions on Using Replication for Data Recovery ................................................................................................. 19
Additional Considerations when Using Replication for Data Recovery .............................................................. 19
Conditional Clause Requirements..................................................................................................................................... 19
Allowable DDL Statements ................................................................................................................................................. 20
CREATE REPLICATION............................................................................................................................................................................ 21
Syntax .......................................................................................................................................................................................... 21
Description ................................................................................................................................................................................ 21
Error Codes ................................................................................................................................................................................ 22
Example ...................................................................................................................................................................................... 22
Starting, Stopping and Modifying Replication using “ALTER REPLICATION” .................................................................. 23
Syntax .......................................................................................................................................................................................... 23
Description ................................................................................................................................................................................ 23
Error Codes ................................................................................................................................................................................ 24
Example ...................................................................................................................................................................................... 25
DROP REPLICATION ............................................................................................................................................................................... 26
Syntax .......................................................................................................................................................................................... 26
Description ................................................................................................................................................................................ 26
Error Codes ................................................................................................................................................................................ 26
Example ...................................................................................................................................................................................... 26