Open main menu

CDOT Wiki β

Changes

OPS345 Lab 4

467 bytes added, 01:24, 4 January 2022
AWS RDS
RDS supports many backends including most of popular SQL database engines (RDBMSs). We're going to create a MariaDB DB instance.
* In the AWS Management Console go to '''RDS'''.* Under Databases click "'''Create database"'''.* Pick '''Standard create''', '''MariaDB''', leave the default version* Pick '''Free tier''' from Templates.* Call the database '''ops345db'''* Put in a long password, make sure it's a password that's only used for the database.  {{Admon/important|Database passwords|Database passwords are a breed of their own. While they are used to protect highly valuable data - unlike other passwords they are often written in plain text on the command-line, in shell scripts, and web service configuration files. Therefore to avoid having your entire account compromised: don't use the same password in a database that you use for other systems in AWS.}}
* In the AWS console go to RDS. Create ops345db, with a long password that's different from other passwords. Put it in ops345sgprivate. This one will be used/seen in plain text sometimes.
** It will complain about not having two subnets in different availability zones.
* In VPC/Subnets, create a new one in vpc-ops345 named subnet2-ops345, in us-east-1b instead of 1a. 10.3.45.128/25