Required parameter settings for active-active clusters
Configuring parameters for active-active clusters in Amazon RDS for MySQL is essential for maintaining consistent performance and operational stability. This table details the key parameters that control replication, conflict resolution, and workload distribution. Correct configuration ensures efficient synchronization between nodes, minimizes replication lag, and optimizes resource utilization in distributed or high-traffic environments.
| Parameter | Description | Required setting |
|---|---|---|
|
|
Sets the binary logging format. The default value for RDS for MySQL
8.0 versions and lower is |
|
|
|
Enforces GTID consistency for statement execution. The default value for RDS for MySQL is |
|
|
|
Sets the Group Replication name to a UUID. The UUID format is
|
A MySQL UUID |
|
|
Controls GTID-based logging. The default value for RDS for MySQL 9.7 is |
|
|
|
Specifies whether to allow DNS resolution from the Amazon DNS
server in your VPC. DNS resolution must be enabled when Group
Replication is enabled with the
|
|
|
|
Specifies whether Group Replication is enabled for a DB instance. Group Replication must be enabled on a DB instance in an active-active cluster. |
|
|
|
Controls the order that transactions are committed on a replica.
The default value for RDS for MySQL is |
|
For RDS for MySQL 9.7, the default value of the group_replication_ssl_mode parameter is
REQUIRED, so connections between the DB instances in the active-active cluster use SSL by
default. For RDS for MySQL 8.4 and lower versions, the default value is DISABLED. The values of
the group_replication_ssl_mode and group_replication_recovery_use_ssl
parameters must be the same for all of the DB instances in the active-active cluster. If your cluster
has DB instances that run different major versions, set both parameters explicitly in each DB
parameter group.