Oracle^® Solaris Cluster Data Replication Guide for MySQL

Chapter 1

Replicating Data With MySQL

This chapter describes the Oracle MySQL (MySQL) data replication when used with the Oracle Solaris Cluster disaster recovery framework. It covers the following topics:

• Overview of MySQL Replication Resource Groups

• Initial Configuration of MySQL Replication

• Planning a MySQL Protection Group

• Creating and Validating a MySQL Protection Group

• Administering MySQL Application Resource Groups

• Administering MySQL Data-Replicated Components

• Replicating a MySQL Protection Group Configuration to a Partner Cluster

• Recovery Strategy After a Takeover of a MySQL Protection Group

Some procedures and examples in this guide use the example cluster names cluster-paris and cluster-newyork to identify the primary and secondary clusters, respectively, in the partnership. Also used are the example cluster node names phys-paris-N and phys-newyork-N.