View maintenance events and windows for your database fleet

Database Center lets you view maintenance windows and maintenance events—including upcoming, in-progress, and completed events—for resources in your database fleet. You can also view maintenance window recommendations to help you maintain your database fleet. Database Center uses factors, such as a resource's environment (production or non-production) and traffic, to create suggested maintenance windows. Database Center also identifies resources without a set maintenance window and provides recommendations to help you set a maintenance window for every resource in your database fleet.

Database Center supports viewing and creating maintenance window recommendations for AlloyDB for PostgreSQL resources and resources for all Cloud SQL engines (MySQL, PostgreSQL, and SQL Server).

A maintenance window defines the preferred time, by hour-of-the-day and day-of-the-week, for your resources to begin maintenance events. For example, you can set a resource to have a maintenance window that begins at 11 AM on Sundays (UTC). By default, database resources don't have a maintenance window. For more information about maintenance windows, see the following:

• For AlloyDB for PostgreSQL resources, see Maintenance timing and maintenance preferences .

• For resources for Cloud SQL engines, see the following:

  • View and set maintenance windows in Cloud SQL for MySQL
  • View and set maintenance windows in Cloud SQL for PostgreSQL
  • View and set maintenance windows in Cloud SQL for SQL Server

Before you begin

• Ensure you set up Database Center for your organization .

• Make sure your instance is set up:

  • For AlloyDB for PostgreSQL, see Create and configure an AlloyDB for PostgreSQL cluster and instance .

  • For Cloud SQL, see one of the following quickstarts:

    • Create instances in Cloud SQL for MySQL
    • Create instances in Cloud SQL for PostgreSQL
    • Create a database in Cloud SQL for SQL Server

View database resource maintenance events and windows

To view information about database resource maintenance events and windows, go to the Maintenancepage in Database Center.

Go to Database Center

After the Maintenancepage opens, review the following information about maintenance events and windows in your database fleet.

The Summarycard shows you the following:

• How many of your database resources have a configured maintenance window.

• How many of your database resources have recommended maintenance windows created by Database Center.

• How many of your database resources have a deny maintenance period configured. During a deny maintenance period, updates aren't allowed.

The Managed maintenance updatescard has four tabs:

The Recommended maintenance windows by resourcecard shows you information for each resource, including the following:

• The name of the resource.

• The database product name and version.

• The most recent version of the product before the last update.

• The installed version of the product.

• The number of days since the last version update.

• The status of maintenance on the resource. This status indicates whether maintenance is scheduled, in progress, completed, or failed. Failure statuses include reasons such as a deny maintenance period or a stopped instance.

• The current maintenance window configured for the resource. If a resource has no configured maintenance window, Noneappears.

• A menu of maintenance windows that Database Center recommends. Learn how to set a recommended maintenance window .

Set a recommended maintenance window

To set a recommended maintenance window for a database resource, complete these steps:

1. Locate the resource for which you want to update the maintenance window by completing one of the following steps:

   • To locate a resource by product, click View maintenance planfor a product in the Managed maintenance updatescard. In the table that appears, find the resource you want to update.

   • Find the resource in the Recommended maintenance windows by resourcecard.

2. In the table row for the resource you want to update, click the Recommended windowsdrop-down menu. Then, find a recommended maintenance window you want to implement and make a note of its day and times. You need this information to set the maintenance window in the next step. Clicking a recommended maintenance window in the drop-down menu doesn't apply the maintenance window.

3. Click the resource name or Applyto navigate to a page in the Google Cloud console where you can specify the recommended maintenance window you chose in the previous step. For information about how to specify a maintenance window for an AlloyDB for PostgreSQL resource (cluster), see
   Set a maintenance window on a cluster .

What's next

• Learn more about Database Center .

• Learn how to customize your database fleet view .

• Learn how to analyze database fleet health using Gemini .