Jump toUpdate content

How to manage Read Replicas

Published on 21 September 2019
Requirements:

How to resync a Read Replica

When you resync a Read Replica, first it is reset, and then its data is resynchronized from the primary node. Your Read Replica will be unavailable during the resync process. The duration of this process is proportional to your Database Instance size. The configured endpoints will not change.

  1. Click PostgreSQL and MySQL under Managed Databases on the side menu. A list of your Database Instances displays.

  2. Click the database name or «See more Icon» > More info to access the Database Instance information page.

  3. Scroll down to the Read Replica section.

  4. Click «See more Icon» > Resync next to the name of the Read Replica you want to resync. A pop-up displays.

  5. Make sure you have selected the correct Read Replica and click Resync. The list of your Read Replicas displays.

Important:

Your Read Replica will be unavailable during the resync process. The duration of this process is proportional to your Database Instance size. The configured endpoints will not change.

How to manage Private Networks

You can attach your Read Replica to a Private Network even after its creation.

  1. Click PostgreSQL and MySQL under Managed Databases on the side menu. A list of your Database Instances displays.
  2. Click the database name or «See more Icon» > More info to access the Database Instance information page.
  3. Scroll down to the Read Replica section.
  4. Click «See more Icon» > Attach Private Network next to the name of your selected Read Replica. A pop-up displays.
  5. Select an existing Private Network to attach to your Read Replica.
  6. Configure your IP address and its corresponding mask.

If you already have an attached Private Network, you can detach it from your Read Replica.

  1. Click PostgreSQL and MySQL under Managed Databases on the side menu. A list of your Database Instances displays.
  2. Click the database name or «See more Icon» > More info to access the Database Instance information page.
  3. Scroll down to the Read Replica section.
  4. Click «See more Icon» > Detach Private Network next to the name of your selected Read Replica. A pop-up displays to ask if you are sure you want to detach the Private Network.
  5. Click Detach Private Network to proceed. The list of your Read Replicas displays. The private endpoint is removed.

How to delete Read Replicas

  1. Click PostgreSQL and MySQL under Managed Databases on the side menu. A list of your Database Instances displays.
  2. Click the database name or «See more Icon» > More info to access the Database Instance information page.
  3. Scroll down to the Read Replica section.
  4. Click «See more Icon» > Delete. A pop-up appears warning you that this will permanently delete your Read Replica and all associated endpoints. This action is irreversible.
  5. Click Delete Read Replica to do so. The list of your Read Replicas displays.
See Also