Chapter 5. Advanced Deployments

Table of Contents

5.1. Deploying the Replicator using the AWS Marketplace AMI
5.1.1. Prepare Source/Target database instances
5.1.2. Launch and Configure AMI
5.2. Deploying a Fan-In Topology
5.2.1. Management and Monitoring Fan-in Deployments
5.3. Deploying Multiple Replicators on a Single Host
5.3.1. Preparing Multiple Replicators
5.3.2. Install Multiple Replicators
5.3.3. Best Practices: Multiple Replicators
5.4. Replicating Data Into an Existing Dataservice
5.5. Deploying Parallel Replication
5.5.1. Application Prerequisites for Parallel Replication
5.5.2. Enabling Parallel Apply During Install
5.5.3. Channels
5.5.4. Parallel Replication and Offline Operation
5.5.5. Adjusting Parallel Replication After Installation
5.5.6. Monitoring Parallel Replication
5.5.7. Controlling Assignment of Shards to Channels
5.5.8. Disk vs. Memory Parallel Queues
5.6. Batch Loading for Data Warehouses
5.6.1. How It Works
5.6.2. Important Limitations
5.6.3. Batch Applier Setup
5.6.4. JavaScript Batchloader Scripts
5.6.5. Staging Tables
5.6.6. Character Sets
5.6.7. Supported CSV Formats
5.6.8. Columns in Generated CSV Files
5.6.9. Batchloading Opcodes
5.6.10. Time Zones
5.6.11. Batch Loading into MySQL
5.6.12. Data File Partitioning
5.7. Deployment Security
5.7.1. Enabling Security
5.7.2. Disabling Security
5.7.3. Creating Suitable Certificates
5.7.4. Installing from a Staging Host with Manually Generated Certificates
5.7.5. Installing via INI File with Manually Generated Certificates
5.7.6. Replacing the TLS Certificate from a Staging Directory
5.7.7. Removing TLS Encryption from a Staging Directory
5.7.8. Handling Database Level Security
5.7.9. Configuring Connector SSL
5.7.10. Creating the Truststore and Keystore
5.7.11. Enabling Database Level SSL with Amazon AWS Aurora