Table of Contents

Introduction >>

1. Introduction

1.1. What Is CSQL
1.2. CSQL Components
1.2.1. CSQL Main Memory Database
1.2.2. CSQL Cache
1.2.3. CSQL Replication
1.3. Information In This Manual
1.4. Types Of Users
1.5. Conventions
1.5.1. Typographic Rule
1.5.2. Syntax Annotation
1.6. Additional Documentation
1.6.1. On-Line Help
1.6.2. Documentation Notes, Release Notes
1.7. Compliance With Industry Standards
1.7.1. SQL-92
1.7.2. ODBC Level 2
1.7.3. JDBC 3.0
1.8. CSQL Selective Information References
1.8.1. Mailing lists
1.8.2. Forums

2. Introducing CSQL Replication

2.1. INTRODUCING REPLICATION CONCEPTS AND FEATURES
2.1.1. Data-Replication Types
2.1.1.1. Synchronous Data Replication
2.1.1.2. Asynchronous Data Replication
2.1.2. Data-Replication Capture Mechanism
2.1.2.1. Log-Based Data Capture
2.1.3. CSQL Replication Features
2.1.3.1. Replication Granularity
2.1.3.2. Transaction Propagation modes
2.1.3.3. High Performance
2.1.3.4. High Availability
2.1.3.5. Load Balancing
2.1.3.6. Recovery
2.1.3.7. Consistent Information Delivery
2.1.3.8. Well-Situated, Centralize Administration
2.1.3.9. Platform Supported
2.1.4. CSQL Replication Benefits
2.1.4.1. Performance and Consistency
2.1.4.2. Scalability

3. Overview Of Replication

3.1. HOW REPLICATION REPLICATES DATA
3.1.1. Catch Transactions
3.1.2. Circulate Data for Replication
3.1.3. Apply Replicated Data 16

4. Deployment Options

4.1. ACTIVE-STANDBY REPLICATION
4.2. ACTIVE-ACTIVE REPLICATION
4.3. LOAD BALANCING CLUSTER FOR READ
4.4. BALANCING CLUSTER FOR READ/WRITE
4.5. LOAD BALANCING CLUSTER WITH DISTRIBUTOR
4.6. LOAD BALANCING CLUSTER WITH DISTRIBUTED DATA

5. Setting Up Replication Environment

5.1. OPERATIONAL RESTRICTIONS
5.2. SQL STATEMENT USE
5.3. Configuration Parameter
5.3.1. Setting up parameters in csql.conf file
5.4. CONFIGURATION PARAMETER
5.4.1. Setting up parameters in csql.conf file

6. Administering And Monitoring Replication

6.1. ACTIVE – STANDBY
6.1.1. Synchronous Replication
6.1.2. Asynchronous Replication
6.2. ACTIVE – ACTIVE
6.2.1. Synchronous Replication
6.2.2. Asynchronous Replication

7. Tools For Replication

Introduction >>

Page last modified on October 13, 2009, at 10:34 AM