add new DB inside aurora cluster

0

Hi Team,

I would like to know how can I add a second Database in my RDS aurora DB? each time I "create Database" it will create a new cluster, but I don't want a new aurora cluster I just want to have another DB inside the same cluster.

2 Antworten
0
Akzeptierte Antwort

You need to connect to your cluster using the master user and simply create a new DB using SQL. For example:

CREATE DATABASE mydatabase;
profile picture
beantwortet vor 3 Jahren
profile picture
EXPERTE
überprüft vor 7 Monaten
  • how can connect to my cluster using bastion host with a command line connect to it?

  • Please take a look at Karthikeyan answer, he explained how to connect to the RDS Cluster :) If you need to connect through a bastion host, remember about properly configuring SecurityGroups and enabling SSH Agent forwarding in your ssh client.

0

Hi AWS-User-5483303,

If you are trying to connect to the Aurora DB instance from you bastion, there are few pre checks that you might need to do before using the command line to connect to the aurora instance,

Prechecks:

  • Ensure that your bastion instance is able to reach to the aurora cluster(Assuming both Aurora DB instance and Bastion host are in same VPC).For this to happen, you have to ensure that Aurora Cluster Security Group allows bastion security group to connect over the Aurora DB instance over the desired port (Default -> MYSQL 3306; PSQL 5432). Meaning to say inbound rule of Aurora SG should allow Bastion SG on desired port number
  • You should have installed the desired driver for you to connect to aurora DB instance. Depending on the Aurora engne(MYSQL/PSQL), install the desired driver for you to connect to the instance.

Connectivity Steps:

Follow the below documentation once you are done with the prechecks:

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Connecting.html

Below are the commands to connect based on the engine:

  • MYSQL -> mysql -h <<db_writer/reader_endpoint>> -d <<database_name>> -u <<username>> -p
  • PSQL -> psql -h <<db_writer/reader_endpoint>> -d <<database_name>> -U <<username>> -W

Once you connect you should be able to create database using the command "CREATE DATABASE <<dbname>>;"

beantwortet vor 3 Jahren
profile picture
EXPERTE
überprüft vor 7 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen