Planning a MySQL Protection Group
A MySQL database resource group can belong to only one protection group.
The MySQL geographic replication was developed with the script-based plug-in module of
Geographic Edition, so it must comply with all rules of the script-based plug-in. For each protection
group, you must provide a script-based plug-in configuration file on each node. In addition, the
MySQL geographic replication brings in its own configuration file, which is needed only at
registration.
The MySQL geographic replication creation is an automated process that takes the
MySQL geographic configuration file as input and performs the necessary actions. The essential
content of this file consists of key=value
pairs.
|
Key
|
Explanation of Value
|
|
PS
|
Name of the partnership.
|
|
PG
|
Name of the protection group to create.
|
|
REPCOMP
|
Name of the replicated component to create in this protection group.
|
|
REPRS
|
Name of the replication resource.
|
|
REPRG
|
Name of the replication resource group.
|
|
DESC
|
Description for the protection group.
|
|
CONFIGFILE
|
Absolute path for the script-based plug-in configuration file.
|
|
REALMYSRG
|
Resource group names that contain the MySQL database resource on the clusters. If the
resource group names on the clusters differ, provide a comma-separated list.
|
|
REALMYSRS
|
Resource names configured as the master and slave MySQL database resources. If the
resource names on the clusters differ, provide a comma-separated list.
|
|
READONLY
|
Switch for setting the read-only variable on the MySQL slave. If the read-only variable
should not be set, leave this value undefined. Any entry here triggers the read-only variable to be
set.
|
|
APPRG
|
Application resource group, which is unmanaged and contains at least the logical host for
client access.
|
|
LONGPING
|
Timeout for the extensive ping test. The default is 60 seconds if this
variable is unset. This timeout is used at check_takeover where it must be
verified as the remote site is unavailable.
|
|
SHORTPING
|
Timeout for the short ping test. The default is 10 seconds if this variable
is unset. The short ping timeout is used whenever a connection should succeed but
is not required to succeed.
|
|