Managing an Amazon Aurora global database

You perform most management operations on the individual clusters that make up an Aurora global database. When you choose Group related resources on the Databases page in the console, you see the primary cluster and secondary clusters grouped under the associated global database. To find the Amazon Web Services Regions where a global database's DB clusters are running, its Aurora DB engine and version, and its identifier, use its Configuration tab.

The cross-Region database failover processes are available to Aurora global databases only, not for a single Aurora DB cluster. To learn more, see Using switchover or failover in an Amazon Aurora global database.

To recover an Aurora global database from an unplanned outage in its primary Region, see Recovering an Amazon Aurora global database from an unplanned outage.

Modifying an Amazon Aurora global database

The Databases page in the Amazon Web Services Management Console lists all your Aurora global databases, showing the primary cluster and secondary clusters for each one. The Aurora global database has its own configuration settings. Specifically, it has Amazon Web Services Regions associated with its primary and secondary clusters, as shown in the screenshot following.

When you make changes to the Aurora global database, you have a chance to cancel changes, as shown in the following screenshot.

When you choose Continue, you confirm the changes.

Modifying parameters for an Aurora global database

You can configure the Aurora DB cluster parameter groups independently for each Aurora cluster within the Aurora global database. Most parameters work the same as for other kinds of Aurora clusters. We recommend that you keep settings consistent among all the clusters in a global database. Doing this helps to avoid unexpected behavior changes if you promote a secondary cluster to be the primary.

For example, use the same settings for time zones and character sets to avoid inconsistent behavior if a different cluster takes over as the primary cluster.

The aurora_enable_repl_bin_log_filtering and aurora_enable_replica_log_compression configuration settings have no effect.

Removing a cluster from an Amazon Aurora global database

You can remove Aurora DB clusters from your Aurora global database for several different reasons. For example, you might want to remove an Aurora DB cluster from an Aurora global database if the primary cluster becomes degraded or isolated. It then becomes a standalone provisioned Aurora DB cluster that could be used to create a new Aurora global database. To learn more, see Recovering an Amazon Aurora global database from an unplanned outage.

You also might want to remove Aurora DB clusters because you want to delete an Aurora global database that you no longer need. You can't delete the Aurora global database until after you remove (detach) all associated Aurora DB clusters, leaving the primary for last. For more information, see Deleting an Amazon Aurora global database.

When an Aurora DB cluster is detached from the Aurora global database, it's no longer synchronized with the primary. It becomes a standalone provisioned Aurora DB cluster with full read/write capabilities.

You can remove Aurora DB clusters from your Aurora global database using the Amazon Web Services Management Console, the Amazon CLI, or the RDS API.

To remove an Aurora cluster from an Aurora global database

1. Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/rds/.

2. Choose the cluster on the Databases page.

3. For Actions, choose Remove from Global.

   

   You see a prompt to confirm that you want to detach the secondary from the Aurora global database.

   

4. Choose Remove and promote to remove the cluster from the global database.

The Aurora DB cluster is no longer serving as a secondary in the Aurora global database, and is no longer synchronized with the primary DB cluster. It is a standalone Aurora DB cluster with full read/write capability.

After you remove or delete all secondary clusters, then you can remove the primary cluster the same way. You can't detach (remove) the primary Aurora DB cluster from an Aurora global database until after you remove all secondary clusters.

The Aurora global database might remain in the Databases list, with zero Regions and AZs. You can delete if you no longer want to use this Aurora global database. For more information, see Deleting an Amazon Aurora global database.

To remove an Aurora cluster from an Aurora global database, run the remove-from-global-cluster CLI command with the following parameters:

• --global-cluster-identifier – The name (identifier) of your Aurora global database.

• --db-cluster-identifier – The name of each Aurora DB cluster to remove from the Aurora global database. Remove all secondary Aurora DB clusters before removing the primary.

The following examples first remove a secondary cluster and then the primary cluster from an Aurora global database.

For Linux, macOS, or Unix:

aws rds --region secondary_region \
  remove-from-global-cluster \
    --db-cluster-identifier secondary_cluster_ARN \
    --global-cluster-identifier global_database_id

aws rds --region primary_region \
  remove-from-global-cluster \
    --db-cluster-identifier primary_cluster_ARN \
    --global-cluster-identifier global_database_id

Repeat the remove-from-global-cluster --db-cluster-identifier secondary_cluster_ARN command for each secondary Amazon Web Services Region in your Aurora global database.

For Windows:

aws rds --region secondary_region ^
  remove-from-global-cluster ^
    --db-cluster-identifier secondary_cluster_ARN ^
    --global-cluster-identifier global_database_id

aws rds --region primary_region ^
  remove-from-global-cluster ^
    --db-cluster-identifier primary_cluster_ARN ^
    --global-cluster-identifier global_database_id

Repeat the remove-from-global-cluster --db-cluster-identifier secondary_cluster_ARN command for each secondary Amazon Web Services Region in your Aurora global database.

To remove an Aurora cluster from an Aurora global database with the RDS API, run the RemoveFromGlobalCluster action.

Deleting an Amazon Aurora global database

Because an Aurora global database typically holds business-critical data, you can't delete the global database and its associated clusters in a single step. To delete an Aurora global database, do the following:

Deleting the writer instance from the newly standalone Aurora DB cluster also typically removes the Aurora DB cluster and the Aurora global database.

For more general information, see Deleting a DB instance from an Aurora DB cluster.

To delete an Aurora global database, you can use the Amazon Web Services Management Console, the Amazon CLI, or the RDS API.

aws rds --region primary_region delete-global-cluster \
   --global-cluster-identifier global_database_id

aws rds --region primary_region delete-global-cluster ^
   --global-cluster-identifier global_database_id