AWS Certified Solutions Architect - Professional 2020

Sign Up Free or Log In to participate!

DB Instances

Hi, A DB instance can host multiple databases. How do I configure that using the console and how is the pricing: 1 instance + storage costs for all DBs? How does that work with the C Name which is linked to the instance? Each DB must have a unique name but how to connect to the correct DB if you only have one C Name (endpoint)?

I find it confusing. 

Also if I check the AWS  pricing tool e.g. it mentions for Aurora: Quantity Enter the number of DB instances that you need including read replicas.

So like number of nodes. If I want a Master and 3 Read Replica’s its 4 I assume but its one DB instance Aurora PostegreSQL with one endpoint.

1 Answers

Hello Jeroen,

I would normally expect to do it though the DB Command line or a DB admin console.  The AWS Console is there to provide control of the Instance (virtual server) and the DB engine.  Not the Database tables.
For instance if you were working with PostgreSQL you might use the pgAdmin utility. –  https://www.pgadmin.org/

Or for MySQL – https://www.mysql.com/

etc.


AWS does do you a courtesy of allowing you the option to create an initial  ‘default’ table set to work against.  What you propose may be possible, but I have never come across it, and it sort of flies in the face of the shared responsibility model.  Plus it is unnecessary as your management of the DB will be done though the DB tools not the RDS console.

– https://aws.amazon.com/getting-started/tutorials/create-mysql-db/

Best of skill

Rusty

Moderator & Coach

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?