Chapter 5. Heterogeneous MySQL Deployments

Table of Contents

5.1. Deploying MySQL to Oracle Replication
5.1.1. Prepare: MySQL to Oracle Replication
5.1.2. Install: MySQL to Oracle Replication
5.2. Deploying MySQL to MongoDB Replication
5.2.1. Preparing Hosts for MongoDB Replication
5.2.2. Installing MongoDB Replication
5.2.3. Management and Monitoring of MongoDB Deployments
5.3. Deploying MySQL to Hadoop Replication
5.3.1. Hadoop Replication Operation
5.3.2. Preparing Hosts for Hadoop Replication
5.3.3. Installing Hadoop Replication
5.3.4. Generating Materialized Views
5.3.5. Accessing Generated Tables in Hive
5.3.6. Management and Monitoring of Hadoop Deployments
5.4. Deploying MySQL to Amazon RDS Replication
5.4.1. Preparing Hosts for Amazon RDS Replication
5.4.2. Installing MySQL to Amazon RDS Replication
5.4.3. Management and Monitoring of Amazon RDS Deployments
5.4.4. Changing Amazon RDS Instance Configurations
5.5. Deploying Amazon RDS to MySQL Replication
5.5.1. Preparing Hosts for Replicating from Amazon RDS
5.5.2. Installing Amazon RDS to MySQL Replication
5.5.3. Management and Monitoring Deployment from Amazon RDS
5.5.4. Changing Amazon RDS Instance Configurations
5.6. Deploying MySQL to Amazon Redshift Replication
5.6.1. Redshift Replication Operation
5.6.2. Preparing Hosts for Amazon Redshift Deployments
5.6.3. Installing Amazon Redshift Replication
5.6.4. Verifying your Redshift Installation
5.6.5. Keeping CDC Information
5.6.6. Management and Monitoring of Amazon Redshift Deployments
5.6.7. Troubleshooting Amazon Redshift Installations
5.7. Deploying MySQL to Vertica Replication
5.7.1. Preparing Hosts for Vertica Deployments
5.7.2. Installing Vertica Replication
5.7.3. Management and Monitoring of Vertica Deployments
5.7.4. Troubleshooting Vertica Installations

Heterogeneous deployments cover installations where data is being replicated between two different database solutions. These include, but are not limited to:

The following sections provide more detail and information on the setup and configuration of these different solutions.