{"id":598,"date":"2021-07-23T12:33:42","date_gmt":"2021-07-23T12:33:42","guid":{"rendered":"https:\/\/ssdsunucum.com\/blog\/create-an-amazon-rds-instance\/"},"modified":"2021-07-23T12:33:42","modified_gmt":"2021-07-23T12:33:42","slug":"create-an-amazon-rds-instance","status":"publish","type":"post","link":"https:\/\/ssdsunucum.com\/blog\/create-an-amazon-rds-instance\/","title":{"rendered":"Create an Amazon\u00ae RDS\u2122 Instance"},"content":{"rendered":"<\/p>\n
\n
<\/div>\n
\n

Overview<\/h2>\n

This document explains how to create an Amazon\u00ae RDS\u2122 instance.<\/p>\n

Create an Amazon RDS instance<\/h2>\n

Log in to the Amazon Web Services Management Console<\/h3>\n
\n

Click to view a screenshot…<\/p>\n

\n
\n
\n
\n<\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n

Log in to the AWS\u2122 Management Console with your Amazon AWS account.<\/p>\n

The AWS Management Console<\/em> page will appear.<\/p>\n

Select your region<\/h3>\n
\n

Click to view a screenshot…<\/p>\n

\n
\n
\n
\n<\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n

To select the region in which to create the database, perform the following steps:<\/p>\n

    \n
  1. \n

    Click the Region<\/em> setting in the upper-right corner of the page.<\/p>\n<\/li>\n

  2. \n

    Select the region in which you wish to create the RDS instance.<\/p>\n<\/li>\n<\/ol>\n

    \n
    Important:<\/div>\n
    \n We strongly<\/strong> recommend that you select the region in which you host your cPanel & WHM servers at Amazon.\n <\/div>\n<\/div>\n

    Open the RDS Console<\/h3>\n
    \n

    Click to view a screenshot…<\/p>\n

    \n
    \n
    \n
    \n<\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n

    To open the RDS Console, perform the following steps:<\/p>\n

      \n
    1. \n

      Click the Services<\/em> setting in the upper-left corner of the page.<\/p>\n<\/li>\n

    2. \n

      Click RDS<\/em>. The RDS Console<\/em> will appear.<\/p>\n<\/li>\n<\/ol>\n

      Create a parameter group<\/h3>\n
      \n

      Click to view a screenshot…<\/p>\n

      \n
      \n
      \n
      \n<\/figure>\n
      \n
      \n<\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n

      You must<\/strong> create a parameter group so that cPanel & WHM can properly connect to the database.<\/p>\n

      To create a DB parameter group, perform the following actions:<\/p>\n

        \n
      1. \n

        In the left sidebar, click Parameter<\/em> groups. A new interface will appear.<\/p>\n<\/li>\n

      2. \n

        Click Create parameter group<\/em>. A new interface will appear.<\/p>\n<\/li>\n

      3. \n

        From the Parameter group family<\/em> menu, select the version of MySQL\u00ae that you wish to use. <\/p>\n

        \n
        Note:<\/div>\n
        \n
          \n
        • \n

          cPanel & WHM versions 86 and earlier only<\/strong> support connections to MySQL 5.7.<\/p>\n<\/li>\n

        • \n

          cPanel & WHM versions 88 and later on CentOS 7 and 8, CloudLinux\u2122 7 and 8, and Red Hat\u00ae Enterprise Linux\u00ae 7 support connections to MySQL 5.7 and 8.0.<\/p>\n<\/li>\n

        • \n

          cPanel & WHM versions 94 and later on AlmaLinux 8 support connections to MySQL 5.7 and 8.0.<\/p>\n<\/li>\n<\/ul><\/div>\n<\/div>\n<\/li>\n

        • \n

          Enter a Group name<\/em> for the parameter group. We recommend that you use the cpanel-whm<\/code> name.<\/p>\n<\/li>\n

        • \n

          Enter a Description<\/em> of the parameter group.<\/p>\n<\/li>\n

        • \n

          Click Create<\/em>. The Parameter group<\/em> interface will reappear.<\/p>\n<\/li>\n

        • \n

          Click the cpanel-whm<\/code> parameter group. A new interface will appear.<\/p>\n<\/li>\n

        • \n

          In the Filter parameters<\/em> text box, enter log_bin_trust_function_creators<\/code>.<\/p>\n<\/li>\n

        • \n

          Click Edit parameters<\/em>.<\/p>\n<\/li>\n

        • \n

          In the Values<\/em> menu, select 1.<\/p>\n<\/li>\n

        • \n

          Click Save<\/em> changes.<\/p>\n<\/li>\n

        • \n

          In the left sidebar, click Dashboard<\/em>.<\/p>\n<\/li>\n<\/ol>\n

          Create the database<\/h3>\n
          \n

          Click to view a screenshot…<\/p>\n

          \n
          \n
          \n
          \n<\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n

          Click Create the Database<\/em>. A new interface will appear.<\/p>\n

          Select the database engine<\/h3>\n
          \n

          Click to view a screenshot…<\/p>\n

          \n
          \n
          \n
          \n<\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n

          Select the MySQL<\/em> database engine, and then click Next<\/em>. A new interface will appear.<\/p>\n

          \n
          Remember:<\/div>\n
          \n
            \n
          • \n

            cPanel & WHM versions 86 and earlier only<\/strong> support connections to MySQL 5.7.<\/p>\n<\/li>\n

          • \n

            cPanel & WHM versions 88 and later on CentOS 7 and 8, CloudLinux 7 and 8, and Red Hat Enterprise Linux 7 support connections to MySQL 5.7 and 8.0.<\/p>\n<\/li>\n

          • \n

            cPanel & WHM versions 94 and later on AlmaLinux 8 support connections to MySQL 5.7 and 8.0.<\/p>\n<\/li>\n<\/ul><\/div>\n<\/div>\n

            Select your use case<\/h3>\n
            \n

            Click to view a screenshot…<\/p>\n

            \n
            \n
            \n
            \n<\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n

            Select the use case for your database and click Next<\/em>. A new interface will appear.<\/p>\n

            Specify the database details<\/h3>\n
            \n

            Click to view a screenshot…<\/p>\n

            \n
            \n
            \n
            \n<\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n

            To specify the details for your database, perform the following actions:<\/p>\n

              \n
            1. \n

              Select the default License model<\/em>.<\/p>\n<\/li>\n

            2. \n

              Select the DB engine version<\/em> that you wish to use. <\/p>\n

              \n
              Remember:<\/div>\n
              \n
                \n
              • \n

                cPanel & WHM versions 86 and earlier only<\/strong> support connections to MySQL 5.7.<\/p>\n<\/li>\n

              • \n

                cPanel & WHM versions 88 and later on CentOS 7 and 8, CloudLinux 7 and 8, and Red Hat Enterprise Linux 7 support connections to MySQL 5.7 and 8.0.<\/p>\n<\/li>\n

              • \n

                cPanel & WHM versions 94 and later on AlmaLinux 8 support connections to MySQL 5.7 and 8.0.<\/p>\n<\/li>\n<\/ul><\/div>\n<\/div>\n<\/li>\n

              • \n

                Select the DB instance class. Your instance type determines the rate at which AWS bills you. Make certain that you select an instance type that includes appropriate resources for the type of system that you wish to run.<\/p>\n<\/li>\n

              • \n

                Select whether to deploy the database in Multiple Affinity Zones (Multi-MZ)<\/em>.<\/p>\n<\/li>\n

              • \n

                Select the Storage<\/em> type.<\/p>\n<\/li>\n

              • \n

                Select the amount of storage space.<\/p>\n<\/li>\n

              • \n

                For MySQL servers, select the Provisioned IOPS<\/em> rate. This value determines the number of I\/O operations per second that the database can support.<\/p>\n<\/li>\n<\/ol>\n

                Configure the database settings<\/h3>\n
                \n

                Click to view a screenshot…<\/p>\n

                \n
                \n
                \n
                \n<\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n

                To configure the database settings, perform the following actions:<\/p>\n

                  \n
                1. \n

                  Scroll down to the Database Settings<\/em> section.<\/p>\n<\/li>\n

                2. \n

                  Enter a name for the database.<\/p>\n<\/li>\n

                3. \n

                  Enter root<\/code> as the username. If you do not<\/strong> enter root<\/code> as the username, some functions in cPanel & WHM will not<\/strong> function properly.<\/p>\n<\/li>\n

                4. \n

                  Enter the password and then confirm it.<\/p>\n<\/li>\n

                5. \n

                  Click Next<\/em>. A new interface will appear.<\/p>\n<\/li>\n<\/ol>\n

                  Configure the advanced settings<\/h3>\n
                  \n

                  Click to view a screenshot…<\/p>\n

                  \n
                  \n
                  \n
                  \n<\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n

                  To configure the advanced settings for the database, perform the following actions:<\/p>\n

                    \n
                  1. \n

                    Select the desired Virtual Private Cloud (VPC)<\/em> for the database instance. If you host servers with AWS, we recommend that yo use the same VPC for each server.<\/p>\n<\/li>\n

                  2. \n

                    Select the desired Subnet group for the database. We suggest that you select the default<\/em> value.<\/p>\n<\/li>\n

                  3. \n

                    Select whether the public will have access to the database. If you select No<\/em>, only cPanel & WHM servers that you host at Amazon will be able to access the database.<\/p>\n<\/li>\n

                  4. \n

                    Select the desired Availability Zone<\/em> for the database instance. We recommend that you select the No preference<\/em> value.<\/p>\n<\/li>\n

                  5. \n

                    Select the desired VPC security groups<\/em> for the database instance. If you host servers with AWS, we recommend that you use the same security groups for each server.<\/p>\n<\/li>\n

                  6. \n

                    Select the desired Port<\/em> for database connections. We recommend that you use the current value.<\/p>\n<\/li>\n

                  7. \n

                    From the DB parameter group<\/em> menu, select the cpanel-whm<\/code> DB parameter group.<\/p>\n<\/li>\n

                  8. \n

                    Select your desired Option<\/em> group. We recommend that you use the current value.<\/p>\n<\/li>\n

                  9. \n

                    Select whether to enable or disable IAM DB authentication<\/em> for MySQL.<\/p>\n<\/li>\n

                  10. \n

                    Select the desired Encryption<\/em> settings.<\/p>\n<\/li>\n

                  11. \n

                    Select the desired Failover<\/em> settings.<\/p>\n<\/li>\n

                  12. \n

                    Configure your Backup settings<\/em> for the amount of days to retain backups, the time window in which to run backups, and whether to copy tags to snapshots.<\/p>\n<\/li>\n

                  13. \n

                    Configure your Monitoring settings<\/em>. We recommend that you select the Default monitoring role and retain a 60 second granularity.<\/p>\n<\/li>\n

                  14. \n

                    Select whether to post log files to Amazon CloudWatch\u2122.<\/p>\n<\/li>\n

                  15. \n

                    Select whether you wish to allow automatic updates of the database engine for minor versions.<\/p>\n<\/li>\n

                  16. \n

                    Select whether you wish to disable deletion of the database. This will prevent accidental deletion of the database.<\/p>\n<\/li>\n

                  17. \n

                    Click Create database<\/em>.<\/p>\n<\/li>\n<\/ol>\n

                    View the details<\/h3>\n
                    \n

                    Click to view a screenshot…<\/p>\n

                    \n
                    \n
                    \n
                    \n<\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n

                    Click View DB instance details<\/em>. The database console page will appear.<\/p>\n

                    Obtain the endpoint<\/h3>\n
                    \n

                    Click to view a screenshot…<\/p>\n

                    \n
                    \n
                    \n
                    \n<\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n

                    Wait for the Info value to change to Available<\/em>. Then, scroll down to the Connectivity & security<\/em> section.<\/p>\n

                    The Endpoint<\/em> value represents the hostname to which you will connect in WHM\u2019s Manage MySQL Profiles<\/em> interface (WHM >> Home >> SQL Services >> Manage MySQL Profiles<\/em>).<\/p>\n

                    \n
                    Note:<\/div>\n
                    \n When you suspend a cPanel account, the system will not<\/strong> suspend any of the account\u2019s Amazon RDS remote databases.\n <\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

                    Overview This document explains how to create an Amazon\u00ae RDS\u2122 instance. Create an Amazon RDS instance Log in to the Amazon Web Services Management Console Click to view a screenshot… Log in to the AWS\u2122 Management Console with your Amazon AWS account. The AWS Management Console page will appear. Select your region Click to view …<\/p>\n","protected":false},"author":1,"featured_media":599,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/598"}],"collection":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/comments?post=598"}],"version-history":[{"count":0,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/598\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media\/599"}],"wp:attachment":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media?parent=598"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/categories?post=598"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/tags?post=598"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}