Primary Server

enable_mix_replication

Parameter description: Specifies how WAL logs and data are replicated between primary, standby, and secondary nodes.

Type: INTERNAL (fixed parameter, which can be viewed but not modified)

Value range: Boolean

  • on indicates that the WAL log and data page mixed replication mode is enabled.
  • off indicates that the WAL log and data page mixed replication mode is disabled.

Default value: off

This parameter is an INTERNAL parameter and cannot be modified in normal service scenarios. That is, the WAL log and data page mixed replication mode is disabled.

enable_data_replicate

Parameter description: Specifies the data synchronization mode between the primary and standby servers when data is imported to row-store tables in a database.

Type: USERSET

Value range: Boolean

  • on indicates that data pages are used for the data synchronization between the primary and standby servers when data is imported to row-store tables in a database. This parameter cannot be set to on if replication_type is set to 1.
  • off indicates that the primary and standby servers synchronize data using Xlogs while the data is imported to a row-store table.

Default value: on