1,576
edits
Changes
m
# Read through the Week 8 slides, and have them handy as a reference for concepts
Chris.johnson moved page OPS705 Lab 8 to OPS705 Lab 8 (2207) without leaving a redirect: Old version, archived.
Before beginning, you must have:
# Working knowledge of databases and MySQL commands
# A MySQL client on your host machine
# Successfully completed [[OPS705_Lab_7 | Lab 7]]
# Watched the Week 8 video lecture
# Your AWS Educate login credentials
#* '''Username:''' admin
#* '''Password:''' Saved password from Lab 7
# If you need a MySQL database client, this cross-platform open-source client is a good choice: https://mariadb.com/downloads/#mariadb_platform
== Part 4: Adding a Secondary Author User To Your Blog ==
= INVESTIGATION 2: Create A Second Database Instance =
In this investigation, you will create a new MySQL instance in AWS RDS, and create the same tables and parameters as the ''ebdb'' database from Investigation 1write down its information.
== Part 1: Create A Second MySQL Instance ==
#* '''Enable automatic backups''': Unchecked
# Create the database.
# Once complete, add a second ''Inbound rule'' entry to your new security group (''lab8'') as you did in Investigation 1, Part 2. ('''Note:''' If the proper inbound rule already exists, you don't have to create it again.)# To finish, connect to your '''new''' database.
== Part 2: Recreate Record the ebdb Database Connection Info ==This investigation will rely on your previous MySQL knowledge. Using the ''ebdb'' database from the '''first''' database instance as a template, create the necessary tables and table structure in Write down the ''ebdb'' database in your '''connector information for this second''' database instance (i.e. You''wordpress-db2''). It is advisable to connect to both database instances to compare as you create the second set of tables in the new instancell need it for Lab 9.
= Lab Submission =
# The RDS database info page for the database from Investigation 1.
# The RDS database info page for the second database created in Investigation 2.
# The new tables for the second Connection to secondary database describedinstance. (CLI or GUI)
'''In the ''Comments'' text box for your submission on Blackboard, include the URL of your blog post.'''