Restoring MySQL Data from a GTID-Enabled Standby Server

To perform a redirect restore operation or a clone restore operation from a standby server that has GTID (Global Transaction Identifiers) enabled, to the destination client, add the sAdvancedStartServerOptions additional setting as shown in the following table.

Note

To perform a full instance restore operation on a GTID-enabled standby server, you do not need to add the sAdvancedStartServerOptions additional settings.

For instructions about adding additional settings from the CommCell Console, see Adding or Modifying Additional Settings from the CommCell Console.

Property

Value

Name

sAdvancedStartServerOptions

Category

MySQL

Type

String

Values

  • --gtid_mode=ON

  • --enforce_gtid_consistency

×

Loading...