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