What is Amazon RDS?
How to create and Restore RDS Snapshot in a specific time?
If you want to learn this thing in a more simple way
then you can refer to the video below๐๐
To create a DB instance
Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.
In the upper-right corner of the Amazon RDS console, choose the AWS Region in which you want to create the DB instance.
In the navigation pane, choose Databases.
Choose Create database.
In Choose a database creation method, select Standard Create.
In Engine options, choose the engine type: MariaDB, Microsoft SQL Server, MySQL, Oracle, or PostgreSQL. Microsoft SQL Server is shown here.
For Edition, if you're using Oracle or SQL Server choose the DB engine edition that you want to use.
MySQL has only one option for the edition, and MariaDB and PostgreSQL have none.
For Version, choose the engine version.
In Templates, choose the template that matches your use case. If you choose Production, the following are preselected in a later step:
Multi-AZ failover option
Provisioned IOPS storage option
Enable deletion protection option
We recommend these features for any production environment.
To enter your master password, do the following:
In the Settings section, open Credential Settings.
If you want to specify a password, clear the Auto-generate a password check box if it is selected.
(Optional) Change the Master username value.
Enter the same password in Master password and Confirm password.
For the remaining sections, specify your DB instance settings. For information about each setting, see Settings for DB instances.
Choose Create database.
If you chose to use an automatically generated password, the View credential details button appears on the Databases page.
To view the master user name and password for the DB instance, choose View credential details.
For Databases, choose the name of the new DB instance.
On the RDS console, the details for the new DB instance appear. The DB instance has a status of creating until the DB instance is created and ready for use. When the state changes to Available, you can connect to the DB instance. Depending on the DB instance class and storage allocated, it can take several minutes for the new instance to be available.
Restoring a DB instance to a specified time
You can restore a DB instance to a specific point in time, creating a new DB instance.
When you restore a DB instance to a point in time, you can choose the default VPC security group or apply a custom VPC security group to your DB instance.
To restore a DB instance to a specified time
Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.
In the navigation pane, choose Automated backups.
Choose the DB instance that you want to restore.
For Actions, choose to Restore to point in time.
The Restore to point in time window appears.
Choose the Latest restorable time to restore to the latest possible time, or choose Custom to choose a time.
If you chose Custom, enter the date and time to which you want to restore the instance.
For the DB instance identifier, enter the name of the target restored DB instance. The name must be unique.
Choose other options as needed, such as DB instance class, storage, and whether you want to use storage autoscaling.
Choose to Restore to point in time.
No comments:
Post a Comment