Skip Navigation Links | |
Exit Print View | |
Oracle Solaris Cluster Geographic Edition System Administration Guide Oracle Solaris Cluster 4.1 |
1. Introduction to Administering the Geographic Edition Software
3. Administering the Geographic Edition Infrastructure
4. Administering Access and Security
5. Administering Cluster Partnerships
7. Administering Protection Groups
8. Monitoring and Validating the Geographic Edition Software
9. Customizing Switchover and Takeover Actions
A. Standard Geographic Edition Properties
B. Legal Names and Values of Geographic Edition Entities
C. Disaster Recovery Administration Example
E. Troubleshooting Geographic Edition Software
F. Deployment Example: Replicating Data With MySQL
MySQL Replication Resource Group
MySQL Application Resource Group
Initial Configuration of MySQL Replication
Installing MySQL and Configuring the MySQL Database Resource Group
How to Configure the MySQL Replication
Configuring the MySQL Application Resource Group
Administering MySQL Protection Groups
Planning for Your MySQL Protection Group
Creating, Modifying, Validating, and Deleting a MySQL Protection Group
How to Create the MySQL Configuration
Modifying a MySQL Protection Group
Validating a MySQL Protection Group
How to Delete a MySQL Protection Group
Administering MySQL Application Resource Groups
How to Add an Application Resource Group to a MySQL Protection Group
How to Delete an Application Resource Group From a MySQL Protection Group
Administering MySQL Data-Replicated Components
How to Add a Data-Replicated Component to a MySQL Protection Group
Data Replication Subsystem Process for Verifying the Replicated Component
How to Modify a MySQL Data-Replicated Component
How to Delete a Data-Replicated Component From a MySQL Protection Group
Activating and Deactivating a MySQL Protection Group
Activating a MySQL Protection Group
Deactivating a MySQL Protection Group
Resynchronizing a MySQL Protection Group
Recovery Strategy After a Takeover of a MySQL Protection Group
How to Recover After a Takeover
Before you replicate the configuration of a MySQL protection group to a partner cluster, ensure that the following conditions are met:
The protection group is defined on the remote cluster, not on the local cluster.
The MySQL database resources in the protection group on the remote cluster exist on the local cluster.
The application resource groups in the protection group on the remote cluster exist on the local cluster.
The Auto_start_on_new_cluster property of the resource groups is set to false. You can view this property by using the clresourcegroup show command, as follows:
# clresourcegroup show -p auto_start_on_new_cluster apprg
Then, set the Auto_start_on_new_cluster property to false as follows:
# clresourcegroup set -p Auto_start_on_new_cluster=false apprg1
Setting this property to false prevents the Oracle Solaris Cluster resource group manager from automatically starting the resource groups in the protection group. Once the Geographic Edition software restarts and communicates with the remote cluster to ensure that the remote cluster is running and that the remote cluster is the secondary cluster for the resource group, the software does not automatically start the resource group on the primary cluster.
Application resource groups should be online only on the primary cluster when the protection group is activated.
Replicate the protection group configuration to the partner cluster.
Use the following command to retrieve the configuration information of the protection group from the remote cluster and creates the protection group on the local cluster.
# geopg get -s partnershipname MySQL-Protection-group
In this syntax, -s partnershipname specifies the name of the partnership from which the protection group configuration information is retrieved. In addition, MySQL-Protection-group specifies the name of the protection group.
Note - Resynchronizing a protection group updates only entities that are related to Geographic Edition. To update Oracle Solaris Cluster resource groups, resource types, and resources, use the cluster export -t rg,rt,rs command to generate an XML cluster configuration file, modify the XML file for the expected configuration on the secondary cluster, and run the clresource create command with the -a option to apply the configuration updates. For more information, see How to Configure Oracle Solaris Cluster Software on All Nodes (XML) in Oracle Solaris Cluster Software Installation Guide and the cluster(1CL)and clresource(1CL) man pages.
Example F-7 Replicating a MySQL Protection Group to a Partner Cluster
In the following example, the configuration of mysql-pg is replicated to cluster-sfo.
The configuration of the protection group is retrieved from the remote cluster (in this example, cluster-nyc) and then validated by the data replication subsystem on the local cluster, cluster-sfo.
If the validation is successful, the configuration status is set to OK, and the protection group is created on the local cluster. This protection group contains a replicated component and an application group that are configured almost identically to the replicated component and application group on the remote cluster. If the validation fails, the protection group is not created on the local cluster. Fix the cause of the error, and replicate it again.
# rlogin cl2-phys-1 -l root cl2-phys-1# geopg get -s nyc-sfo-ps mysql-pg