MySQL virtualization process

The following material introduces you to the overall process of deploying the MySQL virtualization solution. A sequence of high-level steps is below; each step briefly describes the task and the expected result. Refer to the embedded links for more detailed information. 

1. Begin by reviewing the general Delphix Continuous Data Engine architecture diagrams. This will give a good understanding of the architectural strategy and confirm support. As a next step, identify existing or new MySQL source, staging and target environments, the underlying Operating Systems, and MySQL database versions. 

2. Review the MySQL Support Matrix. Confirm that your combination of  MySQL software, host operating system, Delphix Continuous Data Engine version, and MySQL connector version are supported for the various environments that will integrate into your MySQL deployment. Early validation will reduce unexpected issues later.

3. Deploy and configure Delphix Continuous Data Engine.

4. Install the MySQL connector. The MySQL connector extends Delphix Continuous Data Engine to MySQL datasets. It is recommended to stay current with the latest version of the connector.

5. Create staging and target environments. The staging environment will host a MySQL instance that Delphix Continuous Data Engine will ingest from. The target environment will host one or more MySQL instance(s) in which the virtual database copies will be created.

   1. Consult the source environment and staging/target environment requirements documentation for configuration details.

6. Add staging and target environments in the Delphix Continuous Data Engine. Use the Add Environment operation in Delphix Continuous Data Engine for each host, which causes Delphix Continuous Data Engine to register the specific host and catalog the MySQL software installation(s) on that host.

7. Link the MySQL source database. Configure and create a dSource which allows Delphix Continuous Data Engine to capture a copy of the source data. There are numerous ingestion methods available that can provide a variety of methods for capturing data to be virtualized by Delphix Continuous Data Engine. Therefore, we encourage you to identify the ingestion method that best suits your organization and infrastructure policies.

8. Provision virtual MySQL databases. Administrators and users can provision multiple copies of the source data as virtual databases.