Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [amazon-rds]

Amazon RDS (Relational Database Service)

Amazon RDS (Relational Database Service) is a distributed relational database service based on popular variants, running in the cloud. Currently supported are:

  • MySQL
  • Oracle
  • SQL Server
  • PostgreSQL

Additional Documentation:

549 questions
3
votes
1 answer

How do I specify an option group when upgrading RDS database?

I have a Postgres database in AWS RDS currently running version 9.6.11, and I'm trying to perform a major upgrade to version 10.7. I've followed the Upgrade Guide to create a new version-compatible parameter group, and also created a new…
Nic
  • 13,425
  • 17
  • 61
  • 104
3
votes
1 answer

Schedule the reboot of an AWS RDS (Postgres) instance at a certain time?

Is there a way to schedule the reboot of an RDS instance to a certain time? I know how to manually reboot it but I didn't see any UI or documentation on how to trigger a reboot at, for example, two minutes to midnight.
ThinkBonobo
  • 131
  • 3
3
votes
1 answer

How to Solve unknown_ca error on WSO2IS-5.7 when using MySQL RDS as backstore?

I've tried to install an instance on AWS using aws RDS as my datasource through the mysql-connector-java-5.1.45-bin.jar with jdbc url jdbc:mysql://< instance>.< zone>.rds.amazonaws.com:3306/carbon_db I've got an…
Gennady A.
  • 31
  • 1
3
votes
1 answer

AWS RDS instance 100% CPU utilisation for PostgreSQL for normal usage

am using aws rds Postgres 9.4. I am facing an issue of very high CPU utilization. Instance type is t2.xlarge (16 gb ram). All the time I can see very low ram usage i.e. 14 gb free, 15 gb free. But in comparison cpu utilization is 100%, with 100…
Mihir Shah
  • 31
  • 1
  • 1
  • 3
3
votes
2 answers

Options for giving remote access to private AWS RDS Aurora cluster

We have a production database server which at the moment is not publicly accessible, has no public IP address, and sits in a private VPC subnet. At the moment it is only accessible from applications we have running on EC2's in the same VPC. We now…
user1751825
  • 365
  • 6
  • 13
3
votes
1 answer

AWS EB and RDS: Invalid storage size for engine name mysql and storage type gp2

I'm trying to deploy my (python/django) application to AWS Elastic Beanstalk, but I am getting the error. Deployments have been working fine for the last few months, so I'm confused what could be the cause. Here's the error: ERROR: Updating RDS…
Deven
  • 133
  • 1
  • 1
  • 4
3
votes
1 answer

Does Amazon RDS support multiple oracle databases per instance?

As you can see the AWS FAQ mentions that we can create only one database per instance for Oracle.
Mahesh Wagh
  • 39
  • 1
  • 2
3
votes
2 answers

AWS restore_db_cluster_from_snapshot yet no instances

I'm writing an AWS lambda function to take my most recent snapshot of our production database and restore it as a new DB. This worked fine as a RDS instance but we recently switched our main DB to Aurora and its a cluster not an instance. I looked…
Ryan Grush
  • 181
  • 9
3
votes
2 answers

How to refer to AWS RDS host name

I started an Amazon RDS instance (with Multi-Az enabled) and was provided with a host name like instance.abc123.us-west-1.rds.amazonaws.com. Will this instance's hostname ever change? Can I use this hostname directly in my applications, or should I…
simpleuser
  • 274
  • 1
  • 4
  • 14
3
votes
1 answer

Is a single RDS instance acceptable for multi-geo locations?

I am looking to create a multi-geographic infrastructure. Essentially, I need to serve a website to US, EU and AU users. The challenge is that this website is ecommerce in nature, so needs read & write access on the database. To my knowledge there…
mikemike
  • 131
  • 4
3
votes
1 answer

Can you setup LDAP / AD Authenticaton to a Postgres DB on AWS RDS

AWS does not allow you to modify the pg_hba.conf file which is unfortunate to say the least. Does anyone know of a way that we can setup external user authentication for a RDS Postgres instance? The driving factor of this is compliance due to the…
CogitoErgoSum
  • 522
  • 5
  • 13
3
votes
1 answer

Improving connection to amazon RDS from EC2

Connecting to a local database on the same EC2 instance has a low latency, but to RDS things get really high. See results below. time mysql -u root -proot -h localhost -e 'show databases' +--------------------+ | Database …
Phil
  • 143
  • 1
  • 8
3
votes
2 answers

Connecting to an RDS from an EC2 on the same VPC

I have an RDS instance running on one subnet without NAT, and an EC2 instance running on another subnet with an Internet Gateway configured, both located in the same VPC. I have configured the RDS instance to not be publicly accessible. I am using…
Theodore
  • 133
  • 1
  • 1
  • 5
3
votes
1 answer

Diagnosing low disk space error from PostgreSQL despite low disk usage

I have a Django web application using a PostgreSQL 9.3 database, which occassionally throws the error: File "/usr/local/my_site/.env/lib/python2.7/site-packages/django/db/utils.py", line 94, in __exit__ six.reraise(dj_exc_type, dj_exc_value,…
Cerin
  • 3,600
  • 19
  • 61
  • 79
3
votes
1 answer

AWS Security Group for RDS - Outbound rules

I have a security group assigned to an RDS instance which allows port 5432 traffic from our EC2 instances. However, this security group has all outbound traffic enabled for all traffic for all IP's. Is this a security risk? What should be the ideal…
user384002
  • 31
  • 1
  • 2
1 2 3
…
36 37