Listing Read Replicas

You can retrieve a list of read replicas.

Use the Console, a command-line interface, or the REST API to list read replicas.

Using the Console

Use the Console to list read replicas.

  1. On the DB systems list page, select the DB system that contains the read replicas that you want to work with. If you need help finding the list page or the DB system, see Listing DB Systems.
  2. On the details page, select Read replicas tab or resource.
    All read replicas in the DB system are displayed in a table.
  3. Filtering List Results: Use filters to limit the read replicas in the list. Perform one of the following actions depending on the options that you see:
    • From the Search and Filter box above the list table, select one or more filters and specify the values that you want to use to narrow the list. In general, the filters correspond to the columns shown in the list table, although some filters represent attributes that aren't shown in the table. The Compartment filter is always displayed next to Applied filters.
    • On the left side of the list page, select a value from one of the available filters, such as compartment, state, or tags.
    Change the order of the items in the list table by using the sort icons next to the column names.
  4. Actions: In the list table, select the name of a read replica to open its details page, where you can view its status and perform other tasks. To perform an action on a read replica directly from the list table, select any of the following options from the Actions menu in the row for that read replica:
    • View details: Open the details page for the read replica.
    • Copy OCID: Copy the OCID of the configuration to the clipboard.
    • Delete: Delete the read replica.
    To create a read replica, select Create read replica.

Using the CLI

Use the command-line interface to list read replicas.

This task requires the following:
  • The Oracle Cloud Identifier (OCID) of your compartment.
  • A policy that permits you to list read replicas in the compartment or tenancy.
  • A properly configured CLI installation and the requisite SSH keys. See Command Line Interface.
List all read replicas in a compartment using the CLI:
  1. Open a command prompt and run the following command:
    oci mysql replica list 
         --compartment-id <CompartmentOCID>
    • compartment-id: Specify the OCID of the compartment.
If the command validates and runs successfully, you get a response which list all the read replicas found in the specified compartment.