Questions tagged [amazon-rds]

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.

Amazon RDS (Relational Database Service) is an online storage web service offered by Amazon Web Services. Amazon RDS is a web service that makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks, freeing you up to focus on your applications and business.

References

Related tags:

6750 questions
2
votes
2 answers

AWS RDS Postgres: No space left on Device

does anyone know what this error is in relation to ? Is it in relation to the size of the RDS DB Instance or is it in relation to a temp tablespace ? ERROR: could not write to hash-join temporary file: No space left on device;
TheManBehindTheMan
  • 31
  • 1
  • 3
  • 10
2
votes
0 answers

AWS RDS SDK get instance type

I am trying to get the RDS instance role (reader or writer) using the AWS RDS Java SDK. I tried the following api methods: getReadReplicaSourceDBInstanceIdentifier() and getReadReplicaDBInstanceIdentifiers(), but none of them ever returned anything…
branko terzic
  • 654
  • 1
  • 8
  • 27
2
votes
3 answers

How to delete archive log files on AWS RDS Oracle instance

We have an AWS Oracle RDS instance that recently ran out of space with ORA-01653 and ORA-01654 (Unable to extend index X by 8 in tablespace X...) errors. On investigation by running query: select nvl(sum(BLOCKS * BLOCK_SIZE),0)/1024/1024/1024 GB…
ptha
  • 836
  • 1
  • 8
  • 22
2
votes
3 answers

Cannot establish connection with AWS RDS Oracle database instance from Oracle SQL Developer

I created an Oracle database in the AWS RDS console. I'm unable to connect to it from the Oracle SQL Developer program despite following all the instructions in the Amazon Developer Guides (see item #3 in this webpage in particular). I get this…
2
votes
0 answers

Do I need to import aws rds 2019 certificate to glassfish server

A Java EE 8 Production Application is running on Glassfish 5 (Jelastic cloud) and uses an AWS RDS Aurora (MySQL 5.6) database. I received this email from aws: As of September 19, 2019, Amazon RDS has published new Certificate Authority (CA)…
usertest
  • 2,140
  • 4
  • 32
  • 51
2
votes
1 answer

How can I confirm my AWS MySQL connection is secure?

I am connecting to a MySQL instance hosted on AWS from a seperate AWS EC2 server that is running NodeJS on Express. Here are my connection settings: var connection = mysql.createConnection({ host: '.rds.amazonaws.com', user:…
tim_d
  • 133
  • 2
  • 11
2
votes
1 answer

AWS RDS BatchExecuteStatementRequest

I am trying to update my RDS Aurora database with simple information. import * as AWS from 'aws-sdk'; import { BatchExecuteStatementRequest } from 'aws-sdk/clients/rdsdataservice'; const RDS = new AWS.RDSDataService(); export const create = async…
Johan Byrén
  • 890
  • 2
  • 13
  • 28
2
votes
2 answers

RDS Certificate Rotating

I received an email from AWS, which looks as follows: https://i.stack.imgur.com/BP9Zp.png This part is the most noteworthy: If your applications connect to those instances using the Secure Sockets Layer (SSL) or Transport Layer Security (TLS)…
onassar
  • 3,313
  • 7
  • 36
  • 58
2
votes
1 answer

Unable to run SQL query on AWS RDS using golang SDK

I am new to AWS and working on Relational Database Service(RDS) for the first time. I have created a database(MySQL) on RDS from the AWS console. Now I am trying to create some tables in the database and to simply insert and retrieve data from it…
Rahul Satal
  • 2,107
  • 3
  • 32
  • 53
2
votes
1 answer

Amazon RDS Instance type connection limits

I am trying to decide which AWS RDS instance type is to be used. I have the stats of the number of database connections required by the application. Is it possible to know which AWS RDS instance type supports how many database connections…
Dev1ce
  • 5,390
  • 17
  • 90
  • 150
2
votes
1 answer

mysqldump Doesn't Work with Full-Text Index?

I often export a mySql db on AWS RDS, via ssh using the command: mysqldump -u myUserName -h myDBname.randomcharacters.us-region.rds.amazonaws.com -p myDBname > myDBname.sql It creates 10 GB sql file, which I then zip and download to my dev…
VikR
  • 4,818
  • 8
  • 51
  • 96
2
votes
0 answers

AWSCLI: Can't specify db parameter group when creating mysql read replica

Using awscli, I'm trying to create a cross-region read replica, in us-west-1, of a mysql RDS in us-east-1. The db must have the lower_case_table_names parameter set to 1(default is 0). I have created a custom db parameter group with this setting.…
2
votes
2 answers

How to create AWS Elasticbeanstalk application with integrated RDS using CloudFormation?

I am trying to setup the AWS environment for my SpringBoot application which uses Postgres. I decided to use CloudFormation to configure all the AWS components needed for my application. Following is the cloud formation template app.json: { …
2
votes
2 answers

AWS RDS PostgreSQL Minor Update

I am a bit confused about how to perform a minor PostgreSQL version update on AWS RDS. I read multiple articles from AWS…
Rares R
  • 209
  • 1
  • 13
2
votes
0 answers

Pushing AWS RDS Microsoft SQL Server logs to cloudwatch

I want to check if there is way I can push AWS RDS Microsoft SQL Server logs to CloudWatch. I had a look at: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.html It has links for: MariaDB MySQL Oracle PostgreSQL But not…
1 2 3
99
100