> Software > Databases > Amazon Web Services > Amazon RDS > Amazon RDS Using Export > MySQL > Getting Started

Complete the Databases Guided Setup for Amazon RDS for MySQL

The Databases guided setup takes you through creating a backup plan and adding a Amazon RDS for MySQL database server.

To complete the guided setup, you need the following information:

  • The server name

  • The host name

  • The credentials that you use to access the server

  • The packages that you want to install, such as Oracle

    Note

    If you are configuring a database that uses a pseudoclient, you must manually install the packages on the physical servers before you use the guided setup. For more information, see Adding a New Server.

Go to the Databases Guided Setup

  1. From the navigation pane, go to Guided setup.

    The Welcome page appears.

  2. On the Protect tab, in the Databases tile, click Configure.

    The Configure Database Server page appears.

  3. Click Database running in the cloud (PaaS).

  4. Select Amazon Web Services and click NEXT.

    The Configure Amazon database page appears.

  5. Select RDS (Export), and then click NEXT.

    The Configure Amazon Database - RDS (Export) page appears.

  6. From the Database list, select MySQL.

    The Select A Plan page appears.

Create a Backup Plan for Amazon RDS for MySQL

If you already have a backup plan that you can use, you can skip this step.

Note

To create a backup plan, you must have the Plan Creator Role assigned to your user account.

To create a new plan, complete the following steps:

  1. On the Select A Plan page, click +.

    The Create server backup plan page appears.

  2. Scroll to the bottom of the page, click the For advanced options click here link, and then specify the settings for a backup plan that you can use for the Amazon RDS for MySQL instance.

  3. Settings

    Steps

    Plan name

    1. Enter the following information:

      1. Choose whether to create a new backup plan or use a base plan.

      2. If you selected Create a new plan, in the Plan name, enter a name for the backup plan.

      3. If you selected Use existing base plan, specify the backup plan name and select a base plan.

    Storage policies

    1. Click ADD COPY.

      The Add copy dialog box appears.

    2. In Name, enter a name for the backup destination.

    3. From the Storage list, select the storage to use for the backups.

      You can use the Air Gap Protect cool storage class for creating secondary copies, but not for creating primary copies.

    4. To specify the start time for backups on a specific date and later, move the Backups On and After toggle key to the right.

    5. For Retention rules, enter the amount of time to retain the backups.

    6. To specify additional backups, such as weekly full backups, move the Extended retention rules toggle key to the right, and then add rules.

    7. Click SAVE.

    8. To add additional regions to the backup destination, move the Multi-region toggle key to the right, and then select the regions.

      You can also add more regions and associate the storage copy to the region.

    RPO

    1. For Backup frequency, click ADD.

      The Add backup frequency dialog box appears.

      1. From the Backup type list, select the backup type, and from the for list, select All agents or Databases.

      2. Specify the frequency of the backup.

      3. To specify the client time zone, full backup database frequency, or to add exceptions, move the Advanced toggle key to the right, and do the following:

        • From the time zone list, select the time zone according to which the backups must run.

        • If you select incremental or differential backup type for all agents or databases, to modify the full backup frequency of the database, specify a value for Run full backup on databases every option.

        • To add exceptions when the backups must not run, click Exceptions, and then add exceptions for any day of a month or week or schedule an exception for any week of the month.

          Exceptions repeat every week or month according to the selected exception.

    2. For Backup window (if incremental and differential backups are supported for the workload), specify when you want incremental and differential backups to run.

    3. For Full backup window, specify when you want full backups to run.

  4. Click SAVE.

  5. On the Select A Plan page, click NEXT.

    The Cloud Account page appears.

Add Database Server

  1. From the Cloud Account list, select an Amazon RDS cloud account or configure a new cloud account, and then click NEXT.

    The Backup content page appears.

  2. From the Instance name list, select an instance.

  3. In the Database user box, type the user name to access the RDS for MySQL application.

  4. In the Password box, type the password to access the RDS for MySQL application.

  5. In the Endpoint box, type the name of the endpoint to connect to the database instance.

    Note

    For Multi-AZ DB cluster, enter the endpoint name of the cluster with writer access.

  6. If SSL is enabled on the cloud, move the Use SSL options toggle key to the right, and then in the SSL CA file box, enter the SSL CA file path in the proxy computer.

    Note

    For a Windows client computer, if the instance creation with SSL certificate fails, you can select only the Use SSL options check box, and leave the SSL CA file box blank. For more information, go to "Connecting to server using the MySQL CLI over SSL" on the Microsoft documentation website.

  7. Click NEXT.

    A summary page is displayed to show the instance information.

  8. Click FINISH.

×

Loading...